| Thread | Last Post | Replies |
|
| Update Record from record in other table | 05 Oct 2005 19:15 GMT | 1 |
Can you assist, I have two tables, one called Stock, listing material code & available quantity, the 2nd called Order, listing order no's, material code, and qty required for that order.
|
| Acess 97--Print Multiple Reports using same parameter | 05 Oct 2005 15:02 GMT | 3 |
I have several databases all running on Access 97. In two of them there are 4 reports that all require an [Enter Date] parameter. None of them use be 'between [Enter Start Date] and [Enter End Date]. I would like to create a macro that will prompt me for the date once, then
|
| Opening popup form with NotInList Event | 05 Oct 2005 04:24 GMT | 1 |
I think this is a macro issue, but it could be the combobox in question. I have a combo box that looks up a list of vendors. I want the user to be able to enter a new one, get a popup that allows them to enter the details and then proceed back to the original form and continue on ...
|
| Return the value of Count(*) as a condition in a macro | 05 Oct 2005 04:19 GMT | 1 |
I have a macro that opens a form bound to a query. If the query is empty, I have a msgbox that says "No records to view", which would open if the query is empty. How do I write the condition in my macro to make that happen. And it has to be a macro.
|
| Access Deletes the SQL Code in Query after running output macro | 04 Oct 2005 19:54 GMT | 4 |
I have a button setup to run a macro that does a OutputTo command on a query to Excel 97-2003. The macro runs fine, but after it is done for some reason the SQL code in the query is deleted and it only does it some of the time. I'm not quiet sure what is causing it because if I
|
| Open Web Page | 03 Oct 2005 22:06 GMT | 4 |
Is there anyway to create a macro that opens a web page? I have the url stored in a field expression. Thanks,
|
| Halt Macro on Error | 03 Oct 2005 22:03 GMT | 7 |
I have an autoexec macro that calls multiple public functions. The first function requires the user to select excel files which become the basic tables via transferspreadsheet. If they select the wrong files, the function bombs. I added error handling for the GetData function to ...
|
| Set Menu Options | 03 Oct 2005 20:27 GMT | 2 |
Good morning. I am working an existing DB. I am trying to add the FILE | EXPORT command to the menu. I have changed the existing menu marco to included RunCommand Export. When I execute the macro the current settings never change, Export
|
| Exporting multiple reports via macro | 03 Oct 2005 16:35 GMT | 2 |
I'm trying to create a macro that will automatcally export and save multiple reports from a macro. I have a query that generates a list of names that I would like to 'step through' to generate each report (something easily done in Excel, but apparently not so much in Access).
|
| My saved AutoTexts have disappeared. | 01 Oct 2005 22:07 GMT | 1 |
Over the past 3 days, I have saved multiple AutoTexts. They were working last night but when I pulled in MS Word today, they are all gone. Also, the font size had changed from 12 to 10. Does anyone known how I can get the AT's back without retyping them and why they might have ...
|
| SendObject HOW CAN I SEND TWO REPORTS IN THE SAME MAIL WITH | 01 Oct 2005 22:05 GMT | 1 |
SendObject : HOW CAN I SEND TWO REPORTS IN THE SAME MAIL WITH SENDOBJECT COMMAND IN ACCESS 2000
|
| macro go to a new subform record | 01 Oct 2005 22:01 GMT | 1 |
I have a subform which allows user data entry. I'm trying to add a record to the subform, but it always goes into the first record, even if data has already been entered. When I try to use the Go To Record command in the macro, I get an error message that the form is not open. ...
|