How to: Intrsting

[rush8080]

Hi Guys!


I hope you guys can help me here.... (I'm new to access)

I need to design a database to solve a problem.

Problem: I have a small paper shop. We get paper delivered from 2 different suppliers, at the end of the night we return the left over papers to the suppliers which will be credited to my account in 2 to 3 days time. I need to input the amount i recived and the amount I return everyday. Then when i get the credit note in 3 days time I want to recall the amount i returned and check if every thing alright.

I want something like this:
1st screen calender. When I click on a date it should take me to

2. supplier list. which will have a drop down menu of suppliers. then

3. paper list according to the supplier eg: if i choose '1' on the supplier menu i should be presented with paper a,b,c,d,e,f,g ext if i choose '2' i should have x,y,z with columns of Delivered,Return,Credited,Difference. on the bottom I should have a button says SAVE.

4.when i press save it should save the details under that supplier for that day, so i can go back to that data in later days.

now,
I have created the tables and forms, I don't know how to link them together and run it as a programme, also i need to know how to make it save the data when i press save.

any help welcome

even though i'm new to access i'm fairly good with excell/word/php/html etc if that helps

thnx in advance

[Robeen]

I have created the tables and forms, I don't know how to link them together and run it as a programme

Usually, you would create a 'Main' form that automatically opens when you open your Database.
On the Main form - you can have command buttons that allow you to open other forms - depending what you want to do next.
When you put a button on your Main Form - do you get the Button Wizard come up and ask you what you want the button to do? If so - choose 'Form Operations' and follow the steps . . ..

also i need to know how to make it save the data when i press save.

The same thing applies for creating a button to save records. You can use the button wizard to create this button.

But - remember that Access automatically saves records when you move to a new record - so you can save yourself time by just clicking on a button to go to a new record. You don't HAVE to have a 'Save' button. You CAN if you want - but it will also work without specifically clicking a Save button.

I hope this helps!

[rush8080]

Thnx Robeen, I will try it now and let you know the results in few mins.

[rush8080]

it didn't work. any more ideas?

[rush8080]

I have uploaded this image, hope this will help