Access help

Soldato
Joined
4 Mar 2008
Posts
2,567
Location
Guildford
hello all :)

i am currently doing my AS level ICT and we are oing a database for our coursework, now my teacher is terrible and has no idea about my question so i though i would come here :) so here goes....

it is a fairly basic database consisting of 3 tables: Stock, Customers, and Customer Orders.

I also have 4 forms: New Customer entry form, New stock entry form, New order entry form and Front page form.

I have created queries that calculate the totals and VAT etc etc, i have the correct data to create an invoice.

So i have created a report called 'Invoice' which points to the Query 'Total'

this invoice brings up the data of total order cost, total quantity bought, product name, customer name, sales date etc

At the moment, the invoice brings up all the records, so it brings up the orders for every person on one report.

What i want to do is to be able to only bring up an invoice for one customer, so under the query i have put "[ Please Enter Surname Of Customer ]" (without quotes) into the 'criteria' box under the 'surname' record.

this worked perfectly, because everytime i ran the query or the report it brough up a paramter value request for the surname and then this worked with bringing up the right invoice :)

However i would also like to be able to only do an invoice for a purchase on a certain date, for a certain customer.

For example, if smith bought 4 microphones on 24/6/2010 and then bought 2 mixers on 27/6/2010 how would i be able to display the order for the 27th for the customer smith?

I am a complete noob at databases because we have been taught NOTHING about them, so i am trying to work it out for myself :S

i hope the above makes sense

thanks

ali
 
also, when i open either the customer entry form or the stock entry form, it opens with the previous record displayed, and if you change the record it overwrites it in the table. however if i press the submit button to add it to the table, it then clears the form and i can add a new record normally. Is there a way to automatically clear the form when it opens?

ta
 
hello all :)
I have created queries that calculate the totals and VAT etc etc, i have the correct data to create an invoice.

So i have created a report called 'Invoice' which points to the Query 'Total'

this invoice brings up the data of total order cost, total quantity bought, product name, customer name, sales date etc

At the moment, the invoice brings up all the records, so it brings up the orders for every person on one report.

What i want to do is to be able to only bring up an invoice for one customer, so under the query i have put "[ Please Enter Surname Of Customer ]" (without quotes) into the 'criteria' box under the 'surname' record.

this worked perfectly, because everytime i ran the query or the report it brough up a paramter value request for the surname and then this worked with bringing up the right invoice :)

However i would also like to be able to only do an invoice for a purchase on a certain date, for a certain customer.

For example, if smith bought 4 microphones on 24/6/2010 and then bought 2 mixers on 27/6/2010 how would i be able to display the order for the 27th for the customer smith?

If the syntax you have stated above works fine, you will only need another parameter in the date field with something like ["Please enter the specified date in the DD/MM/YYYY format"] that should allow you to find all the records sold on that day and then the second parameter will appear after to narrow the results down further based on the "surname"
 
also, when i open either the customer entry form or the stock entry form, it opens with the previous record displayed, and if you change the record it overwrites it in the table. however if i press the submit button to add it to the table, it then clears the form and i can add a new record normally. Is there a way to automatically clear the form when it opens?

ta

If you have a version of MS Access older than 2010 you can create a switchboard that will open the form in "Add mode" which will have all the values cleared and allow you to submit it afterwards :)
 
excellent the second parameter request works like a charm :D in regards to your second point, how do i create a switchboard?! sorry if this is really easy :p


EDIT: worked out to do it :p works really well

cheers!
 
Last edited:
excellent the second parameter request works like a charm :D in regards to your second point, how do i create a switchboard?! sorry if this is really easy :p


EDIT: worked out to do it :p works really well

cheers!

Not at all a problem :) But If your still stuck with it, just simply give it a google and I'm sure you'll find some guides on how to do it :) Plus if its for a project the switchboard sounds like something you'd have to do at some point, because am I right in thinking its for an end client that will be using the system?
 
yeh pretty much, but its stupid you dont even hand the database in, just screenshots of how you made it? and its in for next wednesday!!!! :eek: :eek: :eek: :eek: :eek: :eek:
 
Back
Top Bottom