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 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…
How do I use an Access query to update a field in a SharePoint calendar?
I have a SharePoint 2016 calendar with 3 multi-value lookup fields (Org L1, Org L2 and Org L3) which need to be set based on a value in a multi-value choice field (Project). I'm trying to use Microsoft Access 2021 to do what I thought would be easy…
How can I create a label in Microsoft Access that ignores empty fields and moves the remaining fields up?
I have a form that is a label and I need to have this as a sort of "general purpose" label so there may be a field missing from time to time (Company Name) that when the label prints, it ignores that field and moves the rest of the fields up so…
How to Nest Select Case statements in SQL
I seem to have problems when I try to Nest "Select Case(s)" in Access/SQL... Can it be done; is there a specific syntax to do it? This is what I am trying to accomplish...Select Case Me.[RecordSource] Case 0 Case 1 Case 2 Select Case…
[Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 15 (63µm)
I am unable to refresh an excel spreadsheet pulling the data from Access Database. [Microsoft][ODBC Microsoft Access Driver]Invalid character value for cast specification on column number 15 (63µm) I can refresh other spreadsheets from the same access…
Can I change Azure SQL Server port 1433 to a different port (Connecting externally using MS Access ODBC)
Hi, Our IT has flagged port 1433 as being high risk and has requested that we change the way we connect our Access DB to our Azure SQL server. Currently we are connecting using the standard ODBC connection string. Any ideas or information would be…
This Recordset is not updatable. (Error 3326)
I migrated access tables to SQL and use the linked tables in a series of forms. Once option in the Main Form updates fields from a table in a sub-form when I get the This Recordset is not updatable. (Error 3326) error. I checked and the tables all have a…
Microsoft Access Error After April 2024 Microsoft Update: Too many client tasks
I am getting the error "Too many client tasks" when querying an Access database using ODBC after an April 2024 Microsoft update was applied, which was the update for Office 2016 KB5002340. When I uninstalled that update, it's working well…
Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine.
Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine. But in my machine Microsoft Access Database Engine 2010 was installed.
Trying to access old account from almost 10 years ago!
Hi, I am trying to regain access to my old account that I stopped using due to trying to escape domestic violence and safety concerns around 2017/18. I am now safe to access my account, but cannot pass the generic application to do so, as I don't…
My authenticator app has lost all apps data and I'm unable to login to apps like twitter
My twitter account is connected to authenticator but after changing my device and restoring dat via smart switch ,all Microsoft authenticator data is missing and I cannot reconnect my twitter account with out the authenticator code
I am having trouble unlinking my GitHub account from Microsoft App Center
Hi there, Is it possible to unlink my github account from Microsoft App Center? I wish to download software onto my mobile via the Microsoft "personal, company or school' option here. https://appcenter.ms/create-account. Currently I am unable to do…
I am making a report in Microsoft access and I need help.
I am making a database for school. It consists of a query and a report. I am making the report and having trouble. I inserted a page break on my report to make a new page, however in print preview it doesn't show my data on the second page on my report.…
I need to share my subscription benefits with an employee
I paid for a subscription it says I can share with a few people. I have 4 employees I'd like to share with so they can open spreadsheets etc. How do I do this?
ODBC Connection DSN and Linked Table Manager Giving Different Results: The link table manager in access database only gives the master tables
I am setting up a DSN and a Linked Table Manager link all on the same Access database on the same computer with the same database Login and associated User (and of course the same database). The DSN gives me the tables I need, but the Linked Table…
I cannot see any tables when Connecting the Azure via MS Access Linked Table Manager, what am I missing?
I have installed AdventureWorksLT as well as my own tables in a new Azure database that I am trying to connect to via "Linked Table Manager" in MS Access but all I see are the sys tables. If I use DoCmd.TransferDatabase acLink it works fine…
#Func! Error I can’t get around
I have a column of data ([Premium Hdr].[Rev]) that contains blanks, letters and strings containing letters+numbers. I need to do a Nz on the blanks, trim the + and numbers if they are there, and if there are just letters, return that in a calculated…
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