Microsoft Access Database Help?

crackafaza · Nov 28th, 2007, 13:06

Hi Everyone!

I have been given this project in work, but I have become stuck! could anyone try and help me through this, as I am still a newbie to this access lark!
Right...

I will give you an insight to what my project is:
I have to create a database that helps him to sort and organise his invoices for stock! (which is easy enough) but he then when he has selected the status of the item as invoiced, he wants a report creating for that, so he can print it off, and see! but he then wants some kind of trigger that deletes/moves on from that invoice, to the next by the same company! You still follow?

Soo...
I have created this database, with relationships, and the boss is happy enough with that! But that is the easy part, But i am just having great difficulty getting my head around where to begin the challenging bit that i stated above, I dont know where to begin, whether to use queries/forms/macros, i am simply stuck!

So any help on this matter would be greatly appreciated
Let us Know!

Thanks
Cracka

Monie · Nov 29th, 2007, 01:04

If I am not mistaken, this is not done through access. You need scripting language to do that for you (the report, deletion part, etc..)

crackafaza · Nov 29th, 2007, 08:54

Hi!
Thanks for your help! could you please help me how to do this in micrsoft access!?

Thanks
Cracka

alexgeek · Dec 2nd, 2007, 13:28

Nope this is done via Access. But it's very confusing.
What version have you got?

crackafaza · Dec 3rd, 2007, 14:27

I Have got version 2003!

alexgeek · Dec 3rd, 2007, 15:29

I'm sorry I have 2008. Controls are completely different.

Monie · Dec 4th, 2007, 07:58

Access 2008 is out? I must be sleeping.. lol

alexgeek · Dec 4th, 2007, 08:42

Part of office 2008, shiny!

Monie · Dec 4th, 2007, 23:51

wow.. I am not finish with my office 2007. I will check them now!

crackafaza · Dec 6th, 2007, 09:47

Anyway! Back onto subject!
I have done most of the above now, used vbscript for the most parts, but now i am in search for help on the next part, as i don't know what to do!
Right... At the moment my database has a form 'main' and on this form you can search for all the a certain date and define if you want it to show you monthly, quarterly or annually of when the next renewal for paying is, and you can also filter it by seeing the invoiced items and the not invoiced items.

Soo... seperately on this form i have a between dates function, and on this you can put in to different dates for the range, and then it has a 'preview' button, which i want when clicked to create a report for just the dates that is in the range! And that is what i need help on.

How can i create a report that will only show the between dates that has been inputted on the form when pressed the button to view the report?
Can anybody help? or if you are unsure i can say it again, but i really need help, my boss is on my back to get this completed, so any help will be muchly appreciated!

Thanks
Cracka

Monie · Dec 7th, 2007, 04:04

Its is just a simple SQL statement like this:

HTML: Select all

Dim date
date = Request.Form("date") 'date is your date text field in the form!

your database connection here...
...
...
Set recordset = conn.Execute("SELECT * FROM yourDatabase WHERE reportDate BETWEEN '"& dateFrom &"' AND '"& dateTo &"'")

Check this out?