Best way to sort and reduce data in an Access MDB table
Looking for some advice on handling a table. I’ve got an Access mdb database. The VB program that drives it puts data into two columns of a table, and for each row it puts a numeric reason code in the third column. The data pairs in the first two…
whitespace query mystery
I am trying to identify ‘mismatches’ between a table of valid email addresses, and an employees table with an email address field. I’ve just been using the standard ‘find unmatched query wizard’ in Microsoft Access which has identified several…
Why doesnt the checkbox result in a value of -1?
I am checking the boxes of these fields but for whatever reason the the value doesnt result in -1. Every single box i check returns a value of 0. What can I do so that I get the -1 value of a checked box. One thing to note is that the table from which…
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…
The operation failed because of a registry or installation problem. Restart Outlook and try again.
I got an error "The operation failed because of a registry or installation problem. Restart Outlook and try again." on the last line of this simple procedure trying to execute .GetSharedDefaultFolder method: Public Sub xxx(Email As String,…
How to create a MS Word mail merge using an MS Access query with a criteria of Username
I have an MS Word document that I would like to populate with username details, namely; FirstName, LastName, PhoneNo, MobileNo & EmailAddress. I have an MS Access database that has a table called tblUsers with these fields plus a UserName field…
Will Microsoft Access have an End-of-Life? If so, when?
I am inquiring about the End of life for Microsoft Access in Office 365 products suite. Please provide dates as to end of life and end of support. Thank you!
How do I access my account if My Authenticator was deleted and reinstalled and now requires me to do the same two-step verification process, when I'm unable to get on either device??.
I deleted and reinstalled my Authenticator app and it is still asking me to login, but it didn't save my account on the Authenticator app. Now the issue arouse that I can't verify on the app nor access my work account. How am I supposed to access my…
Issue involving sum within query returning null values, and then 0 with the addition of Nz() even though there is a quantity (MS Access)
In MS Access, I have a query summing a quantities from one table, a union query summing hours from three different tables, and finally a third query joining these two queries through alike part numbers and part descriptions. When I do this, the summed…
Visual Studio 2022 unable to connect to excel
Hi Folks, I wish to connect to Excel sheet from my Visual studio 2022 however when I create a connection and ran it the following error was produced. I am running Win10 64bit. ERROR Exception from HRESULT: 0xC020801C Error at Package [Connection manager…
If we are changing from Office 2016 Access runtime to Office 365 Access runtime, do we need to change the database.mdb file to the newer version of microsoft access ?
In MS Access 2016, we created a database , with the file called App1.accbd. Users run this using access runtime. i.e. they have a shortcut to MSAccess.exe ( the access runtime version), so that it opens App1.accdb. If we swap the access runtime version…
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…
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…
where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit
hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards
Your account has been locked
Your account has been locked. Contact your support person to unlock it, then try again
Error 3101 in Access 2013
I have an error 3101 message in my desktop database (Access2013). I do have a one to many relationship, but the "many" side does have a corresponding record on the "one" side, but I get the 3101 error anyway. How can that…
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…
I lost my access to Minecraft
I bought Minecraft years ago from a gift card. I migrated my Mojang account to my Microsoft account and I could play with no problems for the time being. I played the last time like 2-3 days ago, and now I wanted to play Minecraft again. I can't.…
Device management could not be enabled
Your account was not set up because device management could not be enabled. This device might not be able to access some resources such as wifi vpn or email
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…