Hi everyone I have problem with crosstab reports please help me. I have created 2 cross CTab queries and from that query I made 3rd query which is select...
Hi I want to create one table from the followin 2 trables please letme know what is the good way for this one. I want all the records from my both tables will...
Wahab- You can find the code to create a dynamic crosstab at: http://groups.yahoo.com/group/ms_access/message/14978 An alternative is to include an IN clause...
Ah, this is a different problem altogether! First, it looks like RVNo, DebitAcct, and CreditAcct are integers. You should not be using Double if that's the...
Hi, I'm trying to save a report to an excel file & I want it to be saved in the folder specified by the Windows environment variable %TEMP% for portability. I...
You need to pass Environ a string or a number. Unless TEMP is a string variable initialized to "TEMP", you'll get an error. ?Environ("Temp") .. in the...
Hey everyone, I am a newbie at Access and have playing around with the Northwind database. Is there a place online that will show how certain parts of the...
Gerry- There are only two places in Northwind that use filters. One is on the Suppliers form when you click the Review Products button. The code is as ...
... integers. You ... should be ... terrible ... when you do ... Currency data ... CreditAmt ... DebitAcct, 0 ... use it as ... letme ... from ... CreditAmt ...
Dear John, I've tried the method you mention earlier, but my knowlodge is pretty much limited. I hope you can show me a clearer picture, what are the steps I...
Arnold- Please tell me your table name and the relevant field names you're displaying on the form. I can't construct a correct DCount without that info. John...
Hello all, I'm having a brain fart this morning. In order to sort a column, then apply another sort to the next column must I create a query on my original...
David- Yes, a query is the way to go - unless the result must go into a report. If you need a report, simply specify the sort sequence you want in the Sorting...
Can someone please help? Private Sub Combo63_NotInList(NewData As String, Response As Integer) ' Ask the user whether to add a value to the list. Dim...
David- Sounds like you're missing a reference to the DAO library. You should probably also delete the reference to ADO. Choose Tools / References when you're...
Hi Everyone, I am hoping somebody knows how to do this, how can I get a column that checks the records horizontally for a maximum. I know how to do Max...
i have a page that will always display whatever i put in my database! but when i delete all the data inside my database, there is an error that tell me that i...
... Sorry, I couldn't understand what you are doing and what you would like to do. It may just be that you are using the term "database" when you don't really...
sorry about that... ok.. i have a database(customer.mdb)..inside them, i have created 5 tables (tb1.mdb , tb2.mdb ,tb3.mdb ,tb4.mdb ,tb5.mdb), each tables will...
Hi John Viescas Thank you very much for your quick reply and tips about the properties and format. I convert the double to integer and currency format and it...
Dear John, The table uses to hold the data is: SalesTransactionSub; fields are: ReceiptNo, Item, Quantity, Amount, TotalAppearance. But John, I reckon could it...
Wahab- Currency has four decimal places, so that should handle the money in Kuwait. Note that the default Decimal Places is 2 (this affects the display only), ...
Yes, use DSum. You need to filter each one on the current row value of Item, like this: =DSum("[Quantity]","SalesTransactionSub","[Item]='" & [Item] & "'") ...
Dear John, OoooYes! I'm so happy, finally I can put it to work! Thanks John! One more question relates to this; you see, the =DSum....... only sum up each Item...
Simply add to the predicate in the third parameter. Is ReceiptNo text or a number? If it's text, do: =DSum("[Quantity]","SalesTransactionSub","[Item]='" &...
Dear John, OooooooYes! You are so wonderful! Thousands thanks!!!!!!!!!!!!! Good day mate! ~Arnold~ John Viescas <JohnV@...> wrote: Simply add to the...
Hi all, I have a treeview in a form when I click in one node all input box´s became locked, this only happens when I click in one tree node , before that all...
John, Thank you so much but I am still lost. Do I have to add some extra library or ActiveX? Thanks again, David ... From: "John Viescas" <JohnV@...> ...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
