========= QUESTION --------- When trying to run an Access Sync operation, I get the following error: --- Microsoft Visual Basic Run-time error '-2147023080 (80070718)': Method 'CopyFile' of object 'IFileSystem3' failed [Continue] [End] [Debug] [Help]--- ========= ANSWER --------- Believe it or not the best we have found on this error has to do with disk [...]
========= QUESTION --------- When synchronizing in Microsoft Access, I get the following error: ERROR: -2147467259 - File sharing lock count exceeded. Increase MaxLocksPerFile registry Entry. ========= ANSWER --------- Adjust the registry entry MaxLocksPerFile to increase the maximum number - see: http://support.microsoft.com/kb/815281 (Method 1) Start button, Run Type: RegEditClick OK--- For Access 2000, Access 2002, [...]
========= QUESTION --------- I have a table with one record per entity, and a field with the number drawing entries they have. How do I take this and create a table with one record for each of those drawing entries? ========= ANSWER --------- Use the code in EXAMPLES below to open each record in [...]
========= QUESTION --------- When I right-click a field cell in a query and select Zoom I get the following error in a pop up dialog box with an OK button: Microsoft Access can't open the Zoom box. The Microsoft Access Utility add-in is missing or was modified. Rerun Microsoft Access or Microsoft Office Setup to [...]
========= QUESTION ---------When running a query in Microsoft Access, I receive the following error in a pop up dialog box with an OK button: 'QUERY NAME HERE' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. ========= ANSWER --------- This [...]
========= QUESTION --------- Can I create directories from within my VBA code? ========= ANSWER --------- see EXAMPLES ========= EXAMPLES --------- MkDir "c:TOTNExamples" --------- If Len(Dir("c:TOTNExamples", vbDirectory)) = 0 Then MkDir "c:TOTNExamples"End If ========= APPLIES TO / KEY WORDS --------- VBA Directory Directories md MakeDirectory Make Directory ========= REF --------- http://www.techonthenet.com/access/functions/file/mkdir.php [...]
========= QUESTION --------- All of a sudden when I am running a query that includes the standard Microsoft Access function Right(), it is erroring out on me with the error: "Undefined function "Right" in expression" ========= ANSWER --------- Apparently functions like this can go missing from time to time for varying reasons. To get [...]
========= QUESTION --------- Every time I open an Access Database from the network using Access 2010, I can't work in it until I click the [Enable Content] button. Is there a setting somewhere I can change to avoid this? ========= ANSWER --------- Access 2010Select File, Options Select Trust Center, Trust Center Settings… --Macro Settings: [...]
========= QUESTION --------- I need to change the color of an object from within my VBA code. ========= ANSWER --------- See EXAMPLES ========= EXAMPLES --------- Private Sub ReLinkTables_Click() Me.ReLinkTables.BackColor = RGB(186, 20, 25) Me.ReLinkTables.ForeColor = Hex(FFF200) Me.CurrentStatusLabel.Caption = "Clicked: ReLink Tables" Me.CurrentStatusLabel.BackColor = Me.CurrentStatusLabel.ForeColor = vbWhite Me.CurrentStatus = _ "Opening Linked Table Manager" & [...]
========= QUESTION --------- Can you call or open the Linked Table Manager in Microsoft Access from your VBA code? ========= ANSWER --------- See EXAMPLES --------- Another interesting way of doing this would be to simply execute a query in your VBA code against each linked table in your database, thereby causing the logon prompt [...]