Search results
-
B
Help needed with UPDATE and SELECT code
Hi all, I am trying to run an update query based on the top x records of a table. I have got the update function to work, but it updates all records as opposed to the top x. Please see below code: Dim strSQL As String strSQL = "UPDATE SectionStatus SET Position01=2 WHERE EXISTS "...- bpatrick
- Thread
- Replies: 3
- Forum: Modules & VBA
-
B
Blank records being inserted into database
Form/Subform corrupt data Hey all, Hoping someone can help me with a problem I am having with a database I have constructed. I have a form and a subform that is used to collect information about what time and jobs people have worked on. The collected information is saved in one table. On...