Search results

I think that has it. took a while to tweek the query to what I want but I agree that the condition part needed to be done at run time. THank you very much

No that doesn't work - still says too few parameters expected 4

I tried changing the openrecordset line to this Set rst = CurrentDb.OpenRecordset("qryBell1", , , dbReadOnly) the error says invalid argument now!

I have researched on here how to print the results of a query to a text file I put the code in and I get an error on the openrecordset line the error says "too few parameters, expected 4" I tried the query in another report I export to excel and the query works I tried printing the whole...

thanks guys - looking into it you two nailed it the Dlookup is working perfectly Thanks to you both for a quick reply .

All of a sudden, my mind has gone blank, under fire here too :confused: Access 2010 I have a table in the db_be called tbl_Version in it is one field with one text value - CurrentVersion if I want to retrieve it to compare it to lbl_Version.caption from my main login screen how do I code it...

If you have CustomerID in Table2 and that is what you want to look up the address for then Table1 doesn't matter. Just search Table2 for the CustomerID and Address.

Thanks Pat, I will look into that.

This forum was very helpful in getting my program to a FE/BE state where I link to the tables with a share like \\ad\mydata_be.addb Can I also setup the link to point to a url eg 207.229.44.18\mydata_be.addb??? thanks for your input Mark

Got it that worked. Thanks

I have a fe that has 5 tables linked to a backend db on the server. I want to add a new table to the fe that is linked to a second db on the server?? What I have tried. I have created the tbl_called in the fe. when I right click on it and go to Linked Table Manager I do not see it on the...

I think the problem is that I don't actually do a .edit until the user hits the Save button. The screen and data have been open for minutes before (I assume in read mode) since multiple users are viewing the same data. When the save button and .edit are executed that is when the record is...

Thanks for the response CJ when you say you do this in the query design for your recordsource. the query for ? the original list or for the record to load on the details screen? when I go from the list to the details screen I use this code DocName = "frmCallDetails" LinkCriteria =...

Gemma - by the time optimistic record locking takes effect - it is too late. I have 10 sales agents calling numbers from a list. If two agents click on the same number at the same time (happens multiple times per 8 hour shift) the same call details screen opens on each of their pcs. fe/be...

I was running multiple users from the one Access file on the server. Now I have split fe and be and still have the same issue. two users can select the same record from a list screen and open the details screen. the first user to click Save on the details screen will get their changes saved...

In the post by rickyfong about multi user access gemma-the-husky states that ricky should use record locking to ensure users don't modify the same record at the same time. He doesn't explain how this is done. I have a sales call tracking program. a list of available numbers are displayed to...

then you have to prefice VATMonth with the table name otherwise it isn't defined. also maybe to check if the select statement is working remove the whole WHERE clause and step(f8) through the code to see if the recordset is created and has records.

how about this SELECT tbl_Staff.Staff_Name, tbl_Trip.Trip_Title FROM tbl_Staff RIGHT JOIN tbl_Trip ON tbl_Staff.Staff_ID = tbl_Trip.Trip_Leader;

After the suggested statement Set rst=Currentdb.OpenRecordset(name:="SELECT * FROM tblVAT WHERE VATMONTH='" & varMonth & "'", Type:=dbOPenDynaset wouldn't something like this work If rst.BOF and rst.EOF then 'add your new record else 'edit the other fields end if .

I have a table displayed on a form in the details section (not in a subform) and one of the columns is CallBackDate which is stored as a date field and displayed as "dd/mm/yyyy" when i do conditional formating on it so that fieldvalue of CallBackDate < or= todays date it compares the...