Search results

I have a form that on open checks whether an Excel file on the server is open or not, be fore certain other functions occur. If the file is open I get a message, if the file is not open then the queries run. What I would like is to know who has the Excel file open. Can this be written into the...

Hi All, I have a linked table to an Excel file held on the company server. When I open a specific form, I have a delete query that deletes the contents of my table kmnow_tbl and then I use an Apppend query to update the table kmnow_tbl. The kmnow_tbl stores the current mileage for each train in...

Thanks for help, without I will be back, if not about this then something else!

ok, thanks again, will work on it, thanks

Thanks Minty, Forgive me, do I now use DLookup in the reports to look at this second query and I will need another 31 similar queries for all 32 axle positions on a train

May have been me confusing the descriptions; axle and wheel are the same thing. I will refer to them as axles in future. 4 axles fitted to a carriage, 16 axles fitted to an odd or even unit and 32 axles fitted to a train. 4 axles belong to a carriage, the position never changes, only the serial...

Thanks for your time Minty, As wheels get too small to machine they are removed and sent away to have a new tyre fitted, much like a car tyre. In its place a another wheel is fitted which has a different serial number. The wheel that was sent away, will in the future be fitted to another train...

Thanks for your time Minty, I work for a train company where we turn the train wheels on a lathe. As part of the turning process, I need to create a number of reports / forms, that when printed off lathe operators can see wheel serial numbers and last turn wheel sizes for every wheel on the...

Sorry for taking a while to get back, but work has been manic! I have attached a slimmed down version of my bd. On front page2 info is entered, a number of queries are then used so in the end text boxes in the 2 reports can be populated. The problem is using the DLookup method, it takes a long...

sorry, trying to do 10 things at once at work! Have played about a bit using a different field, shortno" in the query, this now gives what I'm after in a query, just need to make it work using a dlookup SELECT record_sheet3_qry.carid, record_sheet3_qry.wheelposition, record_sheet3_qry.shortno...

when I added the criteria got an error message, please see attachment

done as requested thanks

thanks Minty, have just tried as you suggested, blurt: DLookUp("axleserial","record_sheet3_qry","[carid]='110' AND [wheelposition]='1' AND [EvenOddunits]=1") but still get the data type mismatch error

carid and wheelposition are justified to the left and EvenOddunits to the right. Have created a query as you said and it returns a data type mismatch in criteria expression

the 3 fields you stated are all expressions. wheelsetposition is an expression in record_sheet3_qry carid and EvenOddunits are expressions in record_sheet2_qry, which record_sheet3_qry is based on. Not sure I understand your suggestion. Have created a new query with a field of axleserial and...

Thanks Minty, I have rearranged the criteria to the same order as seen in query record_sheets3_qry but I am now getting #ERROR. =DLookUp("axelserial","record_sheet3_qry","[carid]=110 AND [wheelposition]=1 AND [EvenOddunits]=1") Does it make any difference the report has no control source? Thanks

Hi All, I have a text box in a report that uses DLOOKUP to select a record from a query but I have no idea how this should look, so would like a bit of help. I created below using the expression builder, but not surprisingly it doesn't work and returns #NAME...

Plog, at the moment only user at any one time will be using the DB, so that shouldn't be a problem. Will get onto creating that table

Uncle Gizmo, you are absolutely correct, I am monitoring the condition of train wheels and planning when the wheels need turning. After turning a number of times, the wheels are then too small to turn anymore and are sent away to be re-wheeled, much the same as having a new tyre put on a car...

plog, thanks for this. As it is not possible to alter the source data, what I need is to create a table and update it with Insert and Append queries then. I will give this a go, but not used Insert, Append and Update queries, so might take a while. I assume this update of the created table can...