Jump to content
By fans, for fans. By fans, for fans. By fans, for fans.

access date query question


SkippyjonJones

Recommended Posts

I’m designing a database to be run by someone who has little knowledge of access – and less interest in learning it. No problem with that – I’m running everything through a macro so that they have very limited input into the process.

 

What they will have to do is pull data from several table and use it to produce some spreadsheets.

 

However the first 4 queries will require them to put in the 1st and last date of the month they are querying in order to return the correct info. Now I could make it a popup box each time but the more times you do it the better the chance of them screwing it up.

 

What I want to do is have them only put the dates in once only.

 

I’ve tried creating a table with just the start and end date in and using the names in that in the query – same for a for and same for a query based on the table like this “>=[datequery]![start date] And

However everything I do leads to a popup box asking for the date even though its in the table/query/form.

 

How the hell do I do this so they enter it once instead of once for the four data generation queries.

 

Also – at the end I’m producing a spreadsheet to send out – no problem with that but I have 4 spreadsheets. Now if I export them manually I can get them into one spreadsheet with one tab each. Is there an option to do this via the export function in the macro – I can’t seems to get that working without overwriting the first export.

Link to comment
Share on other sites

 

Also – at the end I’m producing a spreadsheet to send out – no problem with that but I have 4 spreadsheets. Now if I export them manually I can get them into one spreadsheet with one tab each. Is there an option to do this via the export function in the macro – I can’t seems to get that working without overwriting the first export.

 

 

never mind - got it.

 

except for the last bit - I think I can do it if the output area remains static - but if it changes each month I'm screwed. I thinkk.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...