Where would it go in this structure?
If intReply = vbYes Then
DoCmd.OpenForm "PackManuf", , , , acFormAdd, acDialog, NewData
Response = acDataErrAdded
Else
MsgBox "Please Select a Pack Manufacturer from the List!", vbExclamation, "Error"...
Ok, so I got the combo box I was working on to accept new values. When the user types in an entry not in the original table, I can prompt the user to see if he/she wants to add this entry to the list, and if he/she says yes, a box pops up and asks them to enter the entry again. Now, I was...
OK, I can update my form, through a user interface now. But the updated form entries don't appear on my combo box as a choice. Also, the user has to type the word in again, is there any way to make it so that program knows what the user typed in previously and automatically adds that entry...
still working on the same problem from last week. I need to be able to add a user entry into a combo box. The combo box comes with a default number of options, so supposed the user looks at those options and decides that his/her desired entry is not there, so he/she needs to be able to add...
From the microsoft webpage... God help me if this works:
Microsoft Office 2000 Service Release 1/1a
Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) includes updated Visual Database Tools for Access projects. Office 2000 SR-1/SR-1a addresses most of the issues described in the...
A2k is what i'm using...ok, so I got that open exclusive thing to work, but it says that either someone else has the file open (i'm going to go look into that) or I don't have permissions, which is weird since I've been working on this same one for three days now. Anyway, also, the shift-enter...
TEXT BOX MESSAGE:
When I try and open up any tables or forms in Design View, I get the following box that pops up:
You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.
Also, when I open up a table to...
I'm trying to add information onto a table via a macro, but everytime I get the macro to pop up the table in my form, I get an error message saying that the table cannot be updated, either the database or the object is read-only. Like the subject of this thread states, I know the files aren't...
OK, i'm just learning how to use this software...so i'm playing around with thornmastr's suggestions and while creating my macro, I ask the computer to perform the following commands: CopyObject, Save, Requery, and Close. When I try and place a new item into my guide box, I get the following...
Say you have a database set-up. You have combo boxes setup which drop down choices. Now the user looks through the choices and doesn't see his option, so he types in his option. How do i accept that option and add it to the list of drop down choices?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.