Forms layout

[klafert]

I am creating an invoice. I have several serial numbers that will be listed
on the invoices. I will I have two scenario on how I will get the data.
Either I will pull the information from an accounting program. In that I
will actually entered the invoice in the accounting system. Then I will
import the data into an Access Database, which will have the invoice number,
inventory Id, serial number and amount date etc. The problem with using the
invoice in the accounting program is that it does track the information but
it list the serial number for each item id in one column. I could have
50-100 serial numbers. Which means before it list the second item purchased
it could be pages before I get to that item. It is possible that I only have
4 or 5 serial number for the same inventory ID. So I want to control the
layout in Access so that I can have it list 8 on a row and 5 in a column or
the other way around. Not locked into 8 across and 5 down. The other way is
I process the invoice in the Access database and I have a program that will
write the information back. Either way I need to be able to control how the
invoice layout. Writing back is not a problem because the program imports
..csv file format. Sorry posted this in the General. Some how missed the
forms section.

 

[Al Campagna]

klafert,
Please don't place the same question on more than one newsgroup. Fred
G. has responded to this question in microsoft.public.access newsgroup.
If you must "multi" post, include the newsgroup name/s in the TO: of
your post.
That way whatever someone responds in one group will be seen by both
groups.
Thanks...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[klafert]

Sorry for some reason I didn't notice the Forms section until after I posted
in General Question. Then I thought I would get more response if it was in
the appropriate section - won't do it again.