Can Access do this..?

[Brian]

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

[Larry Linson]

Re: Can Access do this..?

No, you cannot use VB Forms in Access, nor import, nor convert them. Despite
the resemblance, they are different.

In VB, Forms are often unbound so it may be more convenient to work the way
you describe. In Access, bound forms work well and are the preferred
method... they update as soon as you move from a form to a subform or back,
or to the next record, or close the form.

Larry Linson
Microsoft Access MVP


"Brian" <brian_polli@ho tmail.com> wrote in message
news:30df8968.0 406072318.47fbe 7d6@posting.goo gle.com...[color=blue]
> 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[/color]

[Alan Webb]

Re: Can Access do this..?

Brian,
Get thee to a software store and buy a decent inventory module for your
accounting software. And stop listening to your bosses claptrap about how
his inventory problem is special. But . . . if you insist on reinventing
materials management software . . . Access has a continuous form view which
will do all of what you ask without writing a lick of code.

"Brian" <brian_polli@ho tmail.com> wrote in message
news:30df8968.0 406072318.47fbe 7d6@posting.goo gle.com...[color=blue]
> 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
>[/color]