Search results for query: *

I've got two forms - one to locate a record in a table and another to show all of the fields in that record (they are two separate forms and not parent/sub-form). Rather than adding an 'AutoNumber' field and running a 'Seek' or 'Find', it there a way to store the bookmark from the first form...

Why not just set the 'Visible' property of the form to "false" when the form loads?

Here's a possible solution: Open the "Assets" table as a recordset and load the contents into an array. When someone enters a value in the 'Assets' field of the "Devices" table, check to see if this value is contained in the array (I'd try keying this check on the...

Do you have the checkboxes bound to a recordsource? Are they bound to the same recordsource?

Just to make sure, I tried creating a second connection and opening the second recordset under that connection - as you can imagine, same problem. I'm still at a loss to explain why it won't work. I've got another DB running seven recordsets under a single connection with multiple 'AddNew's...

Thanks for the updated suggestions.... I just tried the suggestion to open a static cursor and open the recordset 'Static'. Same problem. I've also tried working down my list one-at-a-time to see if I've simply got a mis-spelling somewhere. I started at the top of the list (and commented out...

Thanks for the suggestion to specify that the target of the 'Open' command is a table. I tried the change, but I'm still getting the same error message.

I've got a DB with information on problem resolution as it relates to computer workstations. I've got two tables - one with details on the problems for a given day and one summarizing all of the problems by type. I'm trying to code a loop to run through the data and add summary entries as...