Microsoft Access - Assistance

[Sid]

Was wondering if there are any Microsoft Access Gurus out there

I have a bit of a problem for a small little project i wish to finish and i am stuck on a minor detail.

Basically this little project has to keep track of receipts

Company Name
Vat Number
Date of Receipt
Amount of Transaction

the easy way of doing it of course is just straight input it into the table (either directly or via the use of a form to mask the entry into the table in a pretty way)

I have gone the form route and well i have discovered that i have several receipts from the same company which means i have to enter the company name and Vat number over and over again.

which is time consuming as you can imagine

i could create a companies table and have the form pull the info from this table. BUT if there is a new company i have to go to the company table input it there and then go to the form to fill out the rest

is there a way (im sure there is.. i just cant get my head around it right now)

to have the form pull up the company and vat data from a table, if that particular data does not exist allow you to input it on the spot and then, let you fill in the rest date and amount of transaction ?

thanks in advance..

Sid


Almost forgot i am using access 2007 but im sure the process is the same for all versions

[drcrippen324]

the easy way of doing it is with one of those good old fashioned things called a book !!! if you have to use a rinky dinky new fangled computer type things then use it to print lined paper for the book

You would be better using xcell and using a data base that will fill out the spread sheet for you and you can fill out the database as you go

7 is lookig for you now

[Sid]

yes Excel is a solution, but its a last resort..

[mcknli7]

If you get desperate or feel you want to throw the computer out the window give me a week and i will have the database set up for you and i will email it over

you will have to tell me what fields you need / want in it