Access HELP NEEDED: MS ACCESS OPTION GROUP

Joined
Aug 24, 2011
Messages
1
Reaction score
0
Hi I appriciate this forum very much. Its helping newbies like me. I am creating an application for recording input from 2D Barcode and I need help very badly.

I am using MS ACCESS 2007. The input can come from 2 sources - Manual data entry (Default) or through Barcode Scanner. The data entered should go to the following fields.

1. Letter No.
2. Letter Date
3. Sender's Address
4. Location
5. Subject
6. Reference.

I have created a form to input this data. I am thinking of using an option group so that user can select either manual or barcode input. For manual input, user can straight away enter the data in relevant fields. For Barcode input..it will be a MEMO data type containing a delimited text which has to be separated using Split() function. The data should be stored in a table containing above 6 fields. It should take input from only one source though...direct input if manual or parsed input using Split() function through barcode. Kindly help me in achieving this.

Is using a option group a good idea or is there any other way doing this. Also If I use option group...it will result in two options Manual or Barcode. If Manual is selected how do I specify the 6 fields where data needs to be stored ( in the option group wizard)?.
I am have basic idea about access. I am badly in need of help. Hope u guyz will help me out.

Thanks in anticipation.

Prashanth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top