Compact & Repair throws error saying file is in use
When trying to compact and repair any database created on my computer i get an error saying file is already in use. I have tried every possible way to fix this - reinstalled Office 365 tried multiple file locations to save a database and no matter what i get the same error message when trying to compact and repair.
New Access feature released: Code signing for ACCDB/ACCDE
Hi, FYI, since Microsoft hasn't published a blog article about it here yet: With the new version 2012 of Access 365 from January 4, the digital signature for the modern Access file formats is finally available. More about this can be found in our AccessForever article. Servus Karl **************** Access Bug Trackers Access News Access DevCon
Sharepoint 365 - Access Database
Hi All, We recently moved one of our databases to be a Linked Microsoft SharePoint database in Access, so changes made in Access are sync'd to Sharepoint and visa-versa. We also use this database for an IIS Website internally, since the change I am getting an error when running a query: 500 - Internal server error. There is a problem with the resource you are looking for, and it cannot be displayed. From the IIS Log: 2020-12-07 00:04:51 10.0.0.117 POST /xref.asp |41|80040e37|The_Microsoft_Office_Access_database_engine_could_not_find_the_object_'Cross_Reference_1-1'.__Make_sure_the_object_exists_and_that_you_spell_its_name_and_the_path_name_correctly. 80 - 10.0.0.9 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/86.0.4240.198+Safari/537.36 http://10.0.0.117/xref.asp 500 0 0 431 Any help would be great. Cheers Jono
365 Access won't open reports on one computer
After a computer "crash" I upgraded to 365 Subscription and installed it on two PCs using Windows 10. The Access files I use are menu driven within the database. The Access database was originally prepared on 2013 version or maybe earlier. On the desktop computer, everything works fine. One the laptop, the main menu displays, but none of the buttons that connect to the reports are active. Tried the online 365 repair on the laptop, but no results. Is there a setting that I missed? Any suggestions?Print Report/Label VBA Based On Control Box Value
Hey All, I am currently running a program to print pathology labels for work based on a simple form and table that refreshes, opens form, and auto prints to the label maker based on the specifications in the report. Private Sub BtnPrintVial_Click() D = Now() T = Now() Form.Refresh DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "62VIAL" End Sub The first part of the VBA ensures that the Date and Time is refreshed to the current time, and the form is refreshed so that the report picks up the label in the query. Rather than clicking "BtnPrintVial" 3 or 4 times if I have multiple vials of blood / samples, I am hoping to have a Number Value in a Text Box with a default value of 1 (easy) and if I need additional labels I can change the number to what I need. (e.g. 3 vials of blood, change it to 3, click the button, 3 labels will print). I know that there is software out there to do this, but this allows full customisation to my needs, and is lower cost. I have searched for the better part of two days for an answer, but no luck. Any tips? Would it maybe be better building it outside of VBA? Thanks All!
Checking if a record exists from a form button on update
Hi I have a bit of a problem. I have a form with a date dropdown combo, "WeekCommCombo". After update I am trying to check in the table to see if there is a record with the date already in the table. if there is then display one message and if there isn't display the message "Run Query". However, when I run it it does nothing. Not even an error message. (Code below) Any ideas what I can get this to work? Thanks Aaron
