Search results

hi again, i need help... why doesn't this work? if the SQL (following) can't work, is there another way of trying to count certain records in a table and store the value in a variable? strSomeString = DoCmd.RunSQL ("SELECT COUNT(*) from tbl_booking where Staff_ID=""" & [Staff_ID] & """")...

hi, I'm doing a login thing for my database and i need to store whether a user is logged in or not. at the moment im using UPDATE in VBA on my login form. the problem is when i login i get a message box saying im about to update a field, am i sure. Is there a way to stop the message from...