Microsoft Access: Entering Data into Forms

[brethser]

Currently i have a database which I use to keep control of stock. I have a form for inputting data via a barcode scanner. It inputs the shipping number, Asset number and Status. Is it possible to only prompt for the shipping number once and then I scan the rest of the data in and then when i reopen the form scan another shipping number in etc. At the moment I am Scanning in the shipping number each time.

Cheers for any help,
Brethser

[NeoPa]

You could have a process (in a form if you like) which scans in the shipping number.

Once this is accomplished the next code could open the form, passing across the Shipping Number in the form's OpenArgs parameter.

In the Form's Open event procedure set the .DefaultValue of the Shipping Number control to that value.

[brethser]

Thank you for your help but i'm afraid i'm only at the beginner stage and i don't understand what you mean when you say have a process that opens a form. Any examples would be appreciated. Thanks again for any hep.
Cheers
Brethser

[NeoPa]

I didn't say that. Please reread the post and explain if/where you get stuck.

I will know when an example might be appropriate thank you.

[brethser]

Sorry about all the confusion but i figured out the problem using subforms. I am now trying to make my database more user friendly and was wondering if there is a way you can have a form which opens when the database is opened and you can scan in a number which will direct you to another form.

For example if number 010 was for receiving products. can i scan that into a "main form" and it'll open up the form used for receiving products and maybe 999 will Exit back to the "main form"

Cheers
Brethser

[NeoPa]

See Tools / Startup... for setting a form to start automatically on opening of the database.

The rest is already answered in my post #2. If you need further clarification on any point, please explain clearly what you need.

[NeoPa]

BTW please don't assume that because I seem unco-operative that therefore I'm unwilling to help. I don't intend to be lead down the road of doing it for you, as that is no real help. I can however, explain what you need explaining, but you will need to be involved in the process. Spoonfeeding will get you nowhere.

[brethser]

Hows it going. I have already explored the Start up option but as far as i understand it does not suit my purpose. It only allows me to automatically open a form i have created. For this to work i would need to create a form that links all my forms together. But I don't understand how you would link all the forms together in one form that just contains the original forms names.

At the moment i have 4 forms.[ 010 Receive from factory, 110 Build Unit, 210 Ship to customer, 310 Recieve from customer] in my case what would be ideal would be that when i open access a form appears and when i scan/type in 010 or 110 or 210 or 310 it would open one of these forms.

Sorry if i seems like i'm pressing you to do the work for me that was not my intention. Any help would be appreciated.

Regards Brethser

[NeoPa]

... I am now trying to make my database more user friendly and was wondering if there is a way you can have a form which opens when the database is opened and ...

I will need more time (later) for a fuller answer, but I can say that the Startup option is simply in response to the quoted part of your earlier post.

If you can handle the scanning part (it seems you can do that already) then it shoul be perfectly practicable to handle the rest - if you can wait for further posting later.

[NeoPa]

Right, when you manage to scan an item in, does it set the value of the ComboBox for you? Or does it present some other way?

I need to know how that is reflected before I can really advise where to go from there.

Clearly, the first step is to set up the form where you do the scanning as your Startup form.

[NeoPa]

Actually, I've just reread post #8 and realise I misunderstood it somewhat earlier.

To create a form of the type that would allow you to branch of to the other specified forms, what you need is to create a form which is NOT bound to any record source.

Add to this form a ComboBox which lists all the other forms you want to link to, and a Command Button.

This is the basic form that you need to point to in the Startup Options.

[brethser]

Actually, I've just reread post #8 and realise I misunderstood it somewhat earlier.

To create a form of the type that would allow you to branch of to the other specified forms, what you need is to create a form which is NOT bound to any record source.

Add to this form a ComboBox which lists all the other forms you want to link to, and a Command Button.

This is the basic form that you need to point to in the Startup Options.

************************************************** *******************************************
Yea that worked for me, I used the command buttons to accomplish the task. Thanks very much for all your help and i'm sure you'll be hearing from me again.

Regards Brethser

[NeoPa]

Can I take that to mean you have worked out the whole problem then? Triggering the other forms as well?