Go to the navigation button by clicking
Hi, I have a navigation form and I want it to go to the navigation button when I click on a button in another form. But I don't know how to address
populate a list box based on user input
Hello, I am not a programmer, I need to populate a list box based on user input. I have Access form that has 5 Entry fields, that user enter proper information in one field and selecting “Search” icon. Created 5 different queries that runs according to…
One of your parameters invalid
When I create 2 tables in access and make a relationship between them. When I press plus sign in the first table it shows me a ( One of your parameters invalid )
Need assistant with Access VBA coding. Thanks
Hello, I am not a programmer, I have Access form that has 5 Entry fields, also created 5 different queries that runs according to the user selection by entering information on proper field and selecting “Search” icon. Those work well and can pull correct…
Run-time error -2147221164 (80040154) Class not registered
Hi, I applied this tutorial for using .Net in Micrsoft Office, I used Visual Studio 2022 Current and .Net Framework 4.7.2 and Microsoft Access 2016 I didn't see Intellisense when writing code, and when I execute I get the error: Class not…
Enabling user authentication to connect Access front end to Azure SQL Database
I need to connect/link the tables in Access to an Azure SQL database using ODBC Driver 18 for SQL Server. I am trying to use New Data Source->From Database->From Azure Database to authenticate with either Azure AD Password or Interactive…
Why do I get the following error in MS Access?
Cannot open database <name>. It may not be a database that your application recognizes, or the file may be corrupt. (Error 3049)
I can't use SSMA for Access because the DAO component is missing. What should I do?
I can't use SSMA for Access. When I installed it, I got an error message that the DAO component was missing. What should I do? (It seems as though the Microsoft download page is still not working.)
How can I have this code run faster?
I have this code that is executed only when I open a form. I press a button that runs a macro and that macro simply opens the form. Once this form is opened, the code in the "On Load" event is triggered, this code can be seen below. This code…
Need help on reactivaing my microsoft 365 developer Sandbox
Hi All, Last year in November i signed up for 365 developer community and i was given the E5 Instance Sandbox for development due to some issues i have left the program after developing the powerapp and integrated it with teams. After completion of my…
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…
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…
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,…