Search results

Thank you :)

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.

I'm happy with using Dlookup. I'm not spending another 10 hours trying to get something else to work. I just need to display an error message if the id I am entering in as the criteria of the Dlookup doesn't exist.

...I finally cracked it after a billion years by using a Dlookup. Now I have a new question: How would I incorporate a dlookup into an if statement and return an error message if the id does not exist?

Ok, I have had just about enough with VBA and SQL and I'm looking for an easier route to do this, probably simple, task. What I have is a text box in which an ID is entered. A button is clicked and then I want to find the name that corresponds to the ID in a table and return it as a label...

ghudson's worked... thanks a lot :)

hmm... didn't work. The null method spawned an error, and the like method just went to the else bit of the statement. :confused: I'm not having a very good day with Access am I? :)

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

Thanks for your help Tess :) I'll give it a go in a while and see what I can come up with. If I have any problems I'll post back.

Just treat this as seperate from the other post I made, I'm trying out something else. All I want to do is assign the result of an SQL Select query to the variable 'name'. My actual query will work, won't it?

Pretty hard to explain, but I assume it isn't as complex as it sounds: I have a form for adding records to a database. I want to show a foreign key (names) on the form in the form of a combo box (i.e. I want to list all the names so one can be selected for insertion into a different table).

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

Please could you please elaborate futher? I'm lost already. :confused: For anyone else who is reading the thread, and can't be bothered to read or doesn't understand my explanation, here is a short version: How do I populate a combo box on a form with all the values from a field?

Cheers for that :)

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