access to the folder has disappeared, a database has been created that is stored on onedrive. it opens through the browser. and the microsoft access gives an error. What should I do about it?
access to the folder has disappeared, a database has been created that is stored on onedrive. it opens through the browser. and the microsoft access gives an error. What should I do about it?
LOST Office 365 Developer license
I LOST Office 365 Developer license! My office 365 developer license expired in May, I reapplied for a office 365 developer license last week, but I haven't gotten a office 365 developer license yet, I don't see any information on the "My…
The expression On Open you entered as the event property setting produces the following error : Duplicate definition
Hello all I am Fouad from Baghdad I have an Access database that works on all versions of Office from version 2010 to the latest version in Arabic, and it works on Windows 10 and Windows 11 systems, but there is a laptop on which my database did not…
Invalid procedure call or argument error
When pressing a command button the code below is executed, and it results in an error as seen in the picture. In addition, I seem to be the only user with this issue. My coworkers don't mention having this issue. I never had this issue until about a…
Access Europe User Group Meeting - Wed 3 July
The next Access Europe User Group meeting will be on Wednesday 3 July 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). We are pleased to welcome two presenters from Germany: Olaf Nöhring and André Minhorst. Olaf will…
How to create with Visual studio a deployment for an Access project
Good morning, I have an Access 365 project and I would like to create an installation project of it using visual studio 2022. I would like some information on how to do it. It's possible? Thank you Marco Dell'Oca
Compile error on 64bit Office - Declare statements need to be updated
When I opened Endonte Manuscript Templates, I received an error, "The code in this project must be updated for use on 64 bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute". What should I…
How to set up client permissions on secure shared database
Hi. I am building a database for a person who audits hospitals and so the database is shared, between her and another lady, on a very secure site. The problem we are having is when I program it to do something, like show P1 from a checkbox to say P1 or…
Object variable or With Block variable not set
I have this code that is executed upon pushing a button. After going through most of the code i get an error saying 'Object variable or With Block variable not set'. Private Sub CancelJob_Click() On Error GoTo Err_Close_Jobs Dim BOM As String Dim i…
Jet compact utility
Hello Any idea why this download is not signed with a code signing certificate by Microsoft? https://learn.microsoft.com/en-us/office/troubleshoot/access/jet-compact-utility-download And, there's a password protected mdb database that I need to compact,…
Limit the rows in Access table
Hello Is it possible to limit the number of rows in each Access mdb database table? Will need to apply the limitation via VB.NET OLEDB and using Access database engine. Thanks.
Access Europe meeting on Wed 5 June - Extended File Properties / Manage Import/Export Data Tasks
The next Access Europe meeting will be on Wednesday 5 June 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by about 19:30 (7.30PM). The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST . Please note that the UK…
Open form of still open database from another access
Good morning, I have a Ms Access form from which I would like to open another form which is located in another database already open. I can do this if the second database is closed, but not when it is already open. How to do? Thanks to everyone who…
How to insert a new reference in an excel projet
Good morning, I have a Ms Access project that creates a new Ms Excel project and inserts data into a sheet. I need to insert a new reference in the created Excel project. I want to insert a reference to Ms Access to be able to invoke a Ms Access form.…
access copy and paste issue
We have a strange intermittent issue in an Access 2016 database application (classic architecture with individual front end per user with links to a central backend database), that prevents users copying text from emails, word docs, xlsx spreadsheets etc…
Query is too complex.
Hello To delete many selected records at once: In a loop I populate question marks: QuestionMarks = QuestionMarks + "?, " Then: "DELETE FROM table WHERE theID = ? AND fld IN (" + QuestionMarks + ")" And: For Each MyRow As…
ActiveX control not working
I have a form “InvoicesForm” with a subform “AttachedPDFForm” that displays PDF names. The subform displays the names of PDFs in a text control named PDFName and has a button to View PDF with the following code: Dim filepath As String filepath =…
In Access, an ActiveX control is not working
I have a form “InvoicesForm” with a subform “AttachedPDFForm” that displays PDF names. The subform displays the names of PDFs in a text control named PDFName and has a button to View PDF with the following code: Dim filepath As String filepath =…
Integer equivalent in Access
Hello I work with Access mdb with OleDbRader (Access Database Engine) in vb.net and need to set the data type to Integer (NOT Long Integer) so: Dim cmd As New OleDbCommand("ALTER TABLE Blah ALTER Column colm ???",…