Search results

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...

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...

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

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...

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...

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...

Hi, i am trying to update a loginout table with the date/time out but i am getting an item not found in this collection message - here is the code. Dim MyDB As DAO.Database Dim rsLogout As DAO.Recordset Dim MyQuery0 As DAO.QueryDef Dim strSQL As String Dim stDocName As String...

Hi Everyone, I am from Edmonton, AB Canada current temp is -20C I took Computer Programming at NAIT but that was 12 years ago I am just getting back into doing some work with Access 2010 A lot of new stuff compared to what i learned. Hope to meet a lot of great people here (or at least...