Greetings,
I am trying to create a database program so that I can keep a record
of the stock adjustments I do here at work.
How should it work?
I often have to do adjustments for 3-4 products at a time. I would
like to be able to do each lot of 3-4 as a batch all of which have the
same "Adjustment Number". The idea is that I enter the details for the
first product, then click on "Save Line Details" which will bring up a
box with the message "Add another line?" User clicks yes then goes on
to lines 2, 3, 4 and so on. When all products are entered, I click on
"Generate Preview of Adjustments" to bring up a report of all that
I've entered so that I can confirm that it's all correct. Assuming all
is ok, I click on the "Finished" button which appends all the info to
the database for interrogation at a later stage.
So far I have designed the data entry form in VB. You can see it here:
http://www.geocities.com/brian_polli/adjust.html
Can I import this front end into Access so that this is the form that
I use to enter my data? I've tried to do this through the "Forms"
section of Access but I can't seem to bring it up let alone see if I
can connect it to a DB. I've tried designing a form from scratch in
Access using form design but I can't get the same functionality (can't
see how to include drop down menus as per image).
On the whole does this seem like a difficult program to put together?
Thanks in advance...
Brian