Search results

Don't kick yourself! We have all made those types of mistakes along the way. I'm glad you got it worked out.

Is tblCodesAddEdit.MMDBID a numeric datatype? What is the bound field of the list box? You can push the SQL text to a variable and display it in the VBA immediate window to see what is actually being used as the row source for the list box. If needed, you could copy and paste the SQL text...

You're welcome!

I would bring these three fields into the combo box: Currency, GBP, USD. You would set the bound field of the combo box to Currency. You can hide the GBP & USD field from the user by setting the column widths property to zero for each. For your calculations, you can reference the GBP & USD...

The form control referenced in your SQL statement is a variable and thus cannot be enclosed in the double quotes List174.RowSource = "SELECT tblCodesAddEdit.Auto, tblCodesAddEdit.[IOE Code], tblCodesAddEdit.[Uptix Code], tblCodesAddEdit.MMDBID FROM tblCodesAddEdit WHERE...

You're welcome. Glad we could help out.

You can add other criteria for the dates. I usually switch from the design grid view to SQL view and add the criteria there. You will need to utilize the dateadd() function 1.Where [Complaint Closed] is between "Start Date" and End Date" but is also less than or equal to [Recieved Date] + 28...

In order to help you use the DLookup function, we will need to see the fields in the orderdetails table as well as the fields in the unrelated tables. You will also have to tell us which fields in the orderdetails table have matching info in the unrelated table. (BTW, if a field in one table...

If there is no relationship between the order detail table and the product table then how can you create an order with any products? There would need to be some relationship; something like this perhaps: tblOrderDetails -pkOrderDetailID primary key, autonumber -fkOrderID foreign key to...

Actually based on your example, the value of 1.2345 is a constant throughout and it is the other numbers (4.75 & 3.25) that actually determine the value since you are doing multiplication. The following would yield the same values in the scenario you presented. 25 1.2345 24 1.2345*4.75 23...

I'm not sure what you mean by "...calculate the same field in the next record". Can you provide an example of what you expect the query output to look like for 3 records or so? This will allow us to see what calculations you are doing.

If you haven't done so already, you just need to alter the query I provided slightly. You will have to make sure you order the records appropriately in the main query SELECT yourtable.recordnumber, yourtable.somefield, (SELECT Q1.somefield FROM yourtable as Q1 where...

Typically you would use a subquery to pull in the value from the previous record. You mention that your records are in order by record number. Do you control the record number or is that value the result of an autonumber field? I ask because if records are deleted over time, the previous...

I would include the distances in the second combo box and then reference that in the code I provided. So instead of referencing a textbox (me.distance) with the distance, reference the column of the combo box that contains the distance value. me.combobox2name.column(x) where x=the column...

Re: Find posts wich it between two fieldvalues Since the results might include multiple companies, I would recommend using a subform based on a query that filters the data from the second table. The key would be the filtering of course. You did not provide any example data for table two, but...

Glad you got it worked out.

Sorry, I missed that. I do not have an explanation for the error message. Did you try to put the file in your my documents folder? Is that folder set up as a trusted location for Access?

I did not see an attachment.

I did not have any trouble downloading and opening the file. Here it is again but unzipped.

The reason you could not link the main and subreports via fkDisciplineID is because you had the subreport in the footer of the main report. It has to be in the detail section. I moved it and did the linking, but whether it gives you what you want, I'll leave that to you. BTW, I got several...