Thank you, Stewart. It didn't seem like a good idea to have the linked tables open by more than one user if changes were being made to them - even if they weren't to the same records.
Carol
cmcsween
Last Activity: May 10 '10, 10:10 PM
Joined: Apr 26 '10
Location:
-
Opening a database with linked tables exclusively
Is there a way in Access 2007 to open a database with linked tables exclusively when the other database containing the tables is also open? I was told by the user that this could be done in Access 2000, but I think it is a security restriction in Access 2007. Thank you.
Carol McSween-Brooks -
Select query deleting records!
I had an Access 2007 database with 75,000+ records and 60 fields in a table created from data imported from Excel spreadsheets. When a select query was run which counted the totals for each entry in the Manufacturer field, an error message - "Record is deleted" and the option to click on OK or HELP - was received. Of course clicking OK was really the only option and when this was done records, not a single record but several, were gone... -
I am working with 27+ Access 2000 databases that are part of processes that run in the HR department. We have migrated to Office 2007 and some of the macro code in these Access 2000 databases would not be supported. I researched and found that converting the macros to VBA code would resolve the problem in the near term. Some of the databases have forms with macros associated with command buttons. However, in most of the files, the users go directly...Leave a comment:
-
Hi Pat,
Thanks again for the code. I actually can't forget about the macro because it will be used to run the code and the users are looking for the process to be the same in Access 2007 as with the Access 2000 macro. Also, I keep mentioning the need for the report caption because it is used as the file name so that the users don't have to remember a file name for all of the files they output to PDFs (the file name is not the same...Leave a comment:
-
Using Access 2007 Runtime Version
Will the Access 2007 runtime version run on machines with Windows 95, 98, and/or 2000 as the OS?
Carol -
Pat,
The following is the (extensive) vba code from the converted macro that prints several reports as PDFs; the old 2000 macro prompted the user for a folder location, entered the report caption in the file name box, and allowed the user to change it when necessary. The VBA code just opens the report and the user has to go to the Office Button to save the file as a PDF where the user can enter location and file name parameters. There...Leave a comment:
-
Pat,
Following is the code. It includes yours added to the code generated from converting the macro in Access 2007.
'------------------------------------------------------------
' mac_1_StaffingT able_Update_and _Print_to_PDF_M T
'
'------------------------------------------------------------
Function mac_1_StaffingT able_Update_and _Print_to_PDF_M T()
On Error GoTo mac_1_StaffingT able_Update_and _Print_to_PDF_M T_Err...Leave a comment:
-
Pat,
The variable to capture the report caption gave me a syntax error (expected end of statement) until I changed it to this
strFolder & "\" & Report.[1 rptStaffingTabl e].Caption & ".PDF"
Also I have to have Exit Function instead of Exit Sub in the If ... Else clause.
But the main issue now is that the code halts with the error "Object required"...Leave a comment:
-
Pat,
I tried the solution you proposed and it doesn't work in this environment with all of the other processes the macro is doing. I did put together another command in VBA that will bring up the dialog box where the user can change the folder to save the specified report. The save name, though, is the same as the object name.
DoCmd.OutputTo acOutputReport, "1 rptStaffingTabl e", acFormatPDF, , , , , acExportQuality Print...Leave a comment:
-
Thank you, Pat, for the code. I think this is just what I was looking for. I do have a question about the If...Else statement. Does the If..Else statement determine whether or not the file dialog box displays and also does it only have to be stated once?
I will try to write the loop for the DoCmd; however, since I am still new to this I may take the repetitive but easy way out and write the DoCmd statement for each report. Is there an...Leave a comment:
-
Output a report to PDF format to save or send as email
I am in the process of converting macros in Access 2000 databases to VBA code for use in Access 2007. The macros open reports which are formatted to go to the Adobe PDF printer using the print command. The converted macro VBA code only opens the report in normal view and the user has to go to the Office Button and save the file as a PDF file. The original macro automated this process for 45 consecutive reports. I need to modify or add to the new...
No activity results to display
Leave a comment: