I have created a new Access database and need a few additional things that I would like to add. I created a database for inventory within my company. Only a few people will have access to it so security will not be an issue. However, I have a couple questions. Is their a way to have a popup when you open the database to insert let's say the serial number of the computer (already in my forms) and then it will automatically bring up that information. Also, I do not want any of my forms edited. I want this done strictly through the tables. So this leads to my next question. Is their a way once you have a form up that you can enter a different serial number and the information will automatically populate. If not, can you add a search query or option or what needs to be done. Thanks in advance for your help.
I am a beginner, please help.
- Thread starter kslezak
- Start date
jeremie_ingram
Registered User.
- Local time
- Today, 12:48
- Joined
- Jan 30, 2003
- Messages
- 437
First off, base your form off of a query, even if it is from a single table. Now in the criteria row beneath the "serial number" field, place
[Please enter Serial Number]
Include the brackets. Then when you open your form you will be presented with a pop up asking for the serial number. On the form place a button and cancel the wizard when it launches. Change the button display to "Reselect" and in On Click under the events tab use the dropdown to select Event Procedure then click on the ellipsis button (...). Enter the code me.requery and presto, when the button is clicked the pop up appears again.
Now go to Tools - Startup and set the form as the Display Form/Page
[Please enter Serial Number]
Include the brackets. Then when you open your form you will be presented with a pop up asking for the serial number. On the form place a button and cancel the wizard when it launches. Change the button display to "Reselect" and in On Click under the events tab use the dropdown to select Event Procedure then click on the ellipsis button (...). Enter the code me.requery and presto, when the button is clicked the pop up appears again.
Now go to Tools - Startup and set the form as the Display Form/Page
Thanks for your help, but I am still a little confused. I am not sure how to do this. I am new to Access and I do not know exactly how to create the specific query that I want and also how to add buttons or anything. I simply want that when you click to open my database that a popup or even a main search screen would appear. You could then enter the serial number or product number and that form would appear will all the user information and so forth. However, any changes would need to take place in the tables. Would you like to see a copy of my database?
jeremie_ingram
Registered User.
- Local time
- Today, 12:48
- Joined
- Jan 30, 2003
- Messages
- 437
Not trying to sound callous, but you do have to bring something to the table. If you have absolutely no knowledge of access and don’t understand how to create or use a query, you should look more to using an application that you are more familiar with. If you are developing something, you need to at least get the fundamentals down before jumping in and starting a project.
I can take a look at the database for you; I have no problems with that. I can offer suggestions and give guidance, but you still have to at least read up on Access or get a beginners course or two in. If you want to develop access database systems, you need to be familiar with the application itself and the tools available to you.
Post your database here and I (as well as others) can review it and offer up our advice.
I can take a look at the database for you; I have no problems with that. I can offer suggestions and give guidance, but you still have to at least read up on Access or get a beginners course or two in. If you want to develop access database systems, you need to be familiar with the application itself and the tools available to you.
Post your database here and I (as well as others) can review it and offer up our advice.
kslezak said:
I think what you want is a search combobox. The combobox wizard will walk you thru creating a combobox that will allow you to select a record and then bring up that record on the form.
But jeremie has some valid points here. Before jumping in to a new program you really should spend some time familiarizing yourself. Check the sample files, get a good tutorial book, take a course.
One other point that leapt out at me was this is allegedly an inventory app. Inventory apps have some special design considerations that most people new to database design miss. You might want to do some research here on inventory apps.
