Access Development

4 answers

Eorris when Using Chinese characters in sql queries in ACCESS Database.

Hi, from June, the access sql will pop up error as below, when referencing any Chinese character as the screen shot. The exact same codes worked well in May.

asked

Xiaoyu Wang 0

commented

Dora-T 925 Microsoft External Staff Moderator

2 answers

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…

asked

George Dimitrov 0

answered

Hamish HFL 0

1 answer

Lost linked Authenticator accounts

I got a new phone and when transferring all my data over my linked accounts to the Authenticator app didn’t transfer over. Since now I can’t access the app I can’t get the codes, how can I get my accounts back onto my Authenticator app?

asked

David Lindley 20

accepted

David Lindley 20

2 answers

Access Report Prints Form Instead — Seeking Insights from the Community

Hi everyone, I'm hoping someone here can shed light on a frustrating issue we've been facing with Microsoft Access. We have a database where users click a button on a form (labelled “Delivery Sheet”) to open a report in Print Preview mode. The report…

asked

Phillip Bridgeman 0

answered

Albert Kallal 5,586

0 answers

Access Report Prints Form Instead — Seeking Insights from the Community

Hi everyone, I'm hoping someone here can shed light on a frustrating issue we've been facing with Microsoft Access. We have a database where users click a button on a form (labeled “Delivery Sheet”) to open a report in Print Preview mode. The report…

asked

Phillip Bridgeman 0

3 answers

Using Access, what is wrong with this query, UPDATE family SET F17 = CDate(bday);

UPDATE family SET F17 = CDate(bday) Where id = 1;

asked

Thomas Pape 0

commented

Luis Angel Ñañez Llanos 431

2 answers

Microsoft Access - My report is only showing up as a half page vertical

Every time I go to run my report, it shows up as a half page vertical. Can anyone provide me with step by step instructions on how to correct this? I cannot figure out how to get the report to show up and save as a full page.

asked

JM2025 0

commented

Karl Donaubauer 2,061 MVP

2 answers

How to fix an expression newstu(x).Value = stu(x).Value

We use access for our student records, we have a student that wrote the wrong SSN in and we used to be able to transfer the student entire record by clicking on the tab Correct Student ID Numbers but it now throws an error code 64224: Invalid Argument…

asked

Sarah Eskew 5

commented

Sarah Eskew 5

1 answer

How to find my data base access password?

I need to know how to find my data base access password

asked

Cheryl Shaver 0

answered

George Hepworth 10

3 answers

CopyFromRecordset Automation Error

ExcelSheetPopulate.txtI had been running Office 2016 MSO (16.0.12624.20278) 32-bit for several years. I've been using the attached code in MS Access for the past 5 years without any issue. Suddenly, getting Error 430, 'Class does not support Automation…

asked

AlphonseG 236

commented

AlphonseG 236

0 answers

MS Access Automation Error on updating to Version 2108

Some copies of MS Access at my organisation have updated to; Microsoft® Access® for Microsoft 365 MSO (16.0.14326.20384) 64-bit. Subsequently they are experiencing; Automation error -2146232576 (80131700) when setting references to some libraries e.g. …

asked

Malcolm Weller 11

commented

George Hepworth 10

1 answer

How do I fix my access form display

I can open a form in design mode and all the fields look great. When I switch to form mode I get a dark green overlaid and I do not see any of the fields

asked

Francis Phelan 0

answered

DBG 2,376

0 answers

How to work with Attachment data type in VBA

Is it possible to view the size of an attached file in a field of an Access table? For example, using <field>.FileName or <field>.FileType I can view the name or extension of the attached file. Is there a similar feature for file size?

asked

Sidnei Botelho 0

4 answers

ACEOLEDB.DLL from Microsoft 365 Apps crash with Exception code 0xc0000005

ACEOLEDB.DLL from Microsoft 365 Apps (at least versions 16.0.14228.20248, 16.0.14430.20006, 16.0.14701.20040 in "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\") appear to cause an application crash…

asked

Jmenninkainen 31

commented

Jmenninkainen 31

2 answers

I CANNOT CREATE CALCULATED FIELD BECAUSE OF PROBLEM WITH MaxLocksPerFile

N° Fields I have a database in Access with about 130 fields. ACCESS and LOCATION The Access file is in a shared folder, just because it really is, but only I use it, no one else goes in. PROBLEM When I want to create a calculated field the following…

asked

Luis Angel Ñañez Llanos 431

answered

Karl Donaubauer 2,061 MVP

1 answer

Use VBA to delete all appointments in a day of Outlook

From MS Access 365 I need to use VBA to automatically delete all appointments for a specific day in the Calendar of Outlook. I can access the specific Calendar using the following command Set nsCalendar = nsMAPI.Folders("Specific Outlook…

asked

John Papaioannou 21

commented

George Hepworth 10

1 answer

How to fix Automation error Object is not connected to server

I have an MS Access database with a table that has an OLE Object type field. The field stores a PowerPoint slide associated with the rest of the data in the record. I have a form with a bound object frame for the OLE Object field. There is a Button on…

asked

William Sessums 0

answered

Courtney Owen 0 Microsoft Employee

2 answers

How to program with Edge navigateur object?

How can we use the Edge Navigator control to send a message to copilote and save the information?

asked

NGUYEN Alain FG/DACRG 0

answered

George Hepworth 10

2 answers

how to fix "Failed to load microsoft.date.sqlclient version = 5.0.0.0 file or assembly..."

I tried to recreate projects, installed the access engine, added microsoft.data.sqlclient through nuGet, installed various database extensions, watched a lot on the Internet, nothing helped. I need to add an access database. What should I do?

asked

Efrem 20

commented

Efrem 20

4 answers

Microsoft Access - Sytax Error in JOIN operation

I am struggling with an access database. I cannot figure this out. I keep getting a "Syntax error in JOIN operation" error. Can someone please help me? Below is the SQL data. SELECT Courses.course_name ,Venues.venue_name …

asked

Harley Kronikxz 0

edited a comment

Ken Sheridan 2,851

Filter

Content

908 questions with Access Development tags

Eorris when Using Chinese characters in sql queries in ACCESS Database.

Enabling user authentication to connect Access front end to Azure SQL Database

Lost linked Authenticator accounts

Access Report Prints Form Instead — Seeking Insights from the Community

Access Report Prints Form Instead — Seeking Insights from the Community

Using Access, what is wrong with this query, UPDATE family SET F17 = CDate(bday);

Microsoft Access - My report is only showing up as a half page vertical

How to fix an expression newstu(x).Value = stu(x).Value

How to find my data base access password?

CopyFromRecordset Automation Error

MS Access Automation Error on updating to Version 2108

How do I fix my access form display

How to work with Attachment data type in VBA

ACEOLEDB.DLL from Microsoft 365 Apps crash with Exception code 0xc0000005

I CANNOT CREATE CALCULATED FIELD BECAUSE OF PROBLEM WITH MaxLocksPerFile

Use VBA to delete all appointments in a day of Outlook

How to fix Automation error Object is not connected to server

How to program with Edge navigateur object?

how to fix "Failed to load microsoft.date.sqlclient version = 5.0.0.0 file or assembly..."

Microsoft Access - Sytax Error in JOIN operation