Search results

If you have data in your tables then you can use queries and calculate in the queries, the data you modify is saved in the tables and the calculations you create in the queries will be maintained. You can use forms that look like datasheets if that is your preference.

Is the word template a mail merge document? Have you considered using a report for your mail merge document and then print individual letters from there so everything stays in the database. Take a look at this link it may help...

From the ComboBox you can add the following code to the After Update Event. Make sure you adjust the names to what you are using.

Welcome to the Forum, I have adjusted the code for you and it is now working, I have also made Login form display when the database is opened. This is the extra code

Re: Pop up a "Process Running" MsgBox and Close Automatically on Process Execution Rather than a message box, place a label on the form where the button is and add some text to like Query is running and then name the label lblMessage and then make the property visible to false. Then with the...

Cross post on another forum http://www.mrexcel.com/forum/microsoft-access/722008-access-2003-database-save-access-2000-running-windows-7-a.html

Pleased to read you resolved your issue Alec

Alec can you upload a sample of the database to something like dropbox and place the link into your thread that way I can take a look

This can be achieved via VBA, sample code that you will need to adjust is shown below:

You just missed the / between ampm so it should be mmm dd", "yyyy", "hh:nn am/pm

Eli I was hoping you would have sent a link to download a sample of the database, it would be better that just showing the query as I don't know the structure of the tables and what the data looks like. Now that you have 10 threads perhaps zip and extract of the database into your thread.

You need to adjust a few things in the code. Attached is a working copy, I have tested it several times.

You might need to have sent at least 10 threads (I think), but you should be able to use another option as I have mentioned then just copy the URL from Dropbox or who every you upload it into your thread that is permitted.

Upload an extract of your database via another source like dropbox and place a link in you thread it will be easier to take a look from there.

Can you attach an extract of the spreadsheet I can take a look and post a solution.

Sorry this can't be done, make a copy of the report how its laid out etc into a form then they can use a text box and based on its contents it can then print the report.

This would need to be linked to the orders table so you would need a id field to do the calculation on in a query.

Can you upload an extract of the database with the report on it. State which version of Access and the report name and the source name

Using a macro in 2003 you would add the condition to match the selected option from your frame and in the actions of the macro look at the OutPutTo or TransferSpreadsheet, that should give you a solution you could then convert the macro to VBA if you want some Error Handling added.

Can you attach a sample of your data and show what you have and also show what you need, your example in your thread doesn't give a clear definition.