Search results

Yes, it happens when I save the new record. Its supposed to calculate at that time. Sometimes it does not, especially when I am pulling data from another record with DLookup.

I have a form with code behind a command button does a few calculations. Sometimes it needs to pull data from another record before it does this. All the calculations I have are correct, but sometimes the code does not work until I close the form and go back to that record again. I have added a...

I have looked through the message board, and cannot find an answer for this question. I would like to send 2 different reports to the same person, in the same e-mail. Is this possible?

I think he saves the zip file and then extracts the MDB file into another directory.

I send a zipped Access file daily to a few guys. Everyone of them can retrieve the file and everything is fine. Except one guy. Everything he tries to open the file after unzipping, its read only. The read only check box is not clicked though. Any ideas whats happening here?

Help Here is my query: SELECT [Inventory Transactions].DealID, [Inventory Transactions].BuyerId, Suppliers.SupplierName, [Inventory Transactions].Supplier FROM Suppliers INNER JOIN [Inventory Transactions] ON Suppliers.SupplierID = [Inventory Transactions].BuyerId WHERE ((([Inventory...

Works perfectly. Cheers.

I have a start date that gets automatically figure out when a combo box with Terms is selected. I want to have one of two option boxes get filled depending on the StartDate. I tried this and it didn't work: If Market = "2" and StartDate > "1/1/2004" then opt2004 = -1 If Market = "2" and...

I have a large report that is generated off of several other subreports. Everytime I run this report, the system hangs for a bit ( I would guess because of the size of the report), and then everything works well. However, when I close out of the system. I notice that the size of the database...

I cannot get this to work. =DLookUp("[Price]","tblPrice","[LocationID] = " & [Location] & " And [PriceType] =" & [PriceLookup] And "[Month]=#" & [Month] & "#") Is there something wrong with the syntax. It just seems to give me the same result all the time. Thanks.

I have a report that is generated based on several subforms and subqueries. If there is no data for one of the queries, all the text boxes that relate to that query give me a #error. Is there a way to change these to zero? I tried the code below, and it did not work. Function nnz(testvalue As...

Works perfectly, thanks for your help.

Is there a way to do a DLookup with 3 criteria, I have tried this with no luck... =DLookUp("[Price]","tblPrice","[LocationID] = " & [Location] & " And [Date]=#" & [TodaysDate] & "#" And "[MonthForward] = #01/01/2004#") HELP!

I am trying to create a DLookup with 2 criteria. This is what I have so far. DLookUp("[PriceAmount]","tblPrice","Market=" & [Market] And "[PriceDate]=#" & #01/01/2004# & "#") Its not working, so far it seems to pull out only the first record in the table. What am I doing wrong? Thanks.

I have two seperate cross tabs now for each amount. How do I join them together? I am getting weird numbers when I try. Thanks.

Please see my attached file. Any help would be appreciated. Thanks.

I wanted to keep the results in the same table as the other form, which just has: PriceID Price PriceDate Also, if I did it the way you suggested, how do I show a query between the two dates where the price shows up daily: example: 1/11/2003 3.45 1/12/2003 3.45 1/13/2003 3.45.....

I have a form where users can enter a price for a specific date. Sometimes this price doesn't change for months, so instead of entering the same price 60 times for 2 months. I would like another form that gives you a start date and an end date to enter and the price, and it will automatically...

I have a query where it lists the months within a certain period of time inputted by the user. What I need to do, because of information in another table, is put a numbering system in. Lets say the Start Date is 4/1/2003 and the End Date is 8/31/2003 The qry needs to look like this: Month 1...

I'll give it a shot, stupid question though, what is FK?