Recent content by TheHub

Thank you. Will try these and respond

I am stuck trying to query a table for entries in a date field that are 21 days earlier than the current date. I thought I could use the built in 'Now()' but am struggling. Any pointers would be helpful :banghead:

Thanks for the quick reply, but unfortunately, I have to work with what I have got

I am in the process of revamping an old database, and I would like a little help. I have a main table that currently has two fields "Name" and "Job" but will have more. I have another table with the same fields. I want to use as a lookup to populate the main table with a user form from the...

@TJPoorman. Thanks for the information. I will have to look at all recommendations, as the requirements have now changed.

I probably have not explained my self properly. What I have is a form, with a button. the button runs a query that ask for the user to input the Fisrt Date and Last Date. It is these two parameters that i need to include into the spreadsheet name. This is the only way I am allowed to do this, as...

@pr2-eugin. Tried your first suggestion, and many thanks for that, but it results in an error message: Compile error: Method or data member not found. Have not tried your second your second method as it will need a rewrite of the form.

Thanks. I'll give that a try.

Almost, when the button is clicked, the query runs and requests the First Date and the Last Date. Don't know if that makes a difference.

Hi all. I am running an Access 2003 report that outputs to an Excel Spreadsheet The parameter query has two paramerters First Date and Last Date. The report runs from an Button OnClick event. I need to include the two dates in the 'name' of the spreadsheet as below Private Sub...

a small penguin

Don't shout at me if I'm wrong here but I think your email body text should have the file type as part of the text "email body text.rtf"

having no fingers

wearing boxing gloves

Brilliant !! Worked 1st time. Many thanks