Search results

Is there any way to remove these alerts that say something like "You are about to update 1 record"? I have no need for them because I implemented my own alert.

Here's another simple one for you all; I need to check if a text box is empty and pop up a message if it is. I have tried: personID = Forms!Add!personID If personID Is Nothing Then MsgBox ("You must enter an ID number") Else... and personID = Forms!Add!personID If...

I have no idea what I am doing here, as I have never used SQL with VBA before: namelookup = "SELECT people.name FROM people WHERE people.name='personID';" name = DoCmd.OpenQuery "namelookup" What do I have to do in order to get the name from the query and assign it to the name variable...

I have created a form in design view and assigned all of the fields in a table to textboxes. However, my problem is this: how do I make it so that not all records are shown in the form, and it is just left blank to add a record into the table with?

Hi, I'm new here and consider myself as a complete Access newbie. I have a problem with a form that I created in design view with getting all the values in a field into a combo box for selection. I have no idea what I am doing at all, so this is just all trial and error. I apologise if this has...