ACCESS FEED

Rabu, 15 Oktober 2025

Re: [MSAccessProfessionals] Runtime Error '3075' Syntax error in query expression

I think the number of "(" and ")" aren't equal. All of them are unnecessary and should be removed.

Is UPDATED_58 actually a text field rather than a yes/no field?

Also, since there is only the single table, you can remove all of the [Work General Ledger]."s. The table name is only needed following the UPDATE.

Duane

On Oct 15, 2025, at 7:19 AM, Doyce Winberry via groups.io <doyce.winberry=xpo.com@groups.io> wrote:

Hello friends,

I need help with syntax on an SQL statement. It is pulling criteria from a combo box. I want it up update a field, UPDATED_58 from "N" to "Y" for records with a batch number (text field) that comes from a combo box. I'm getting a runtime error 3075, syntax error in query expression and can't figure out what is wrong. Here is the SQL from VBA:

strSQL = "UPDATE [Work General Ledger] SET [Work General Ledger].UPDATED_58 = ""Y""" & _

" WHERE ((([Work General Ledger].UPDATED_58)=""N"") AND (([Work General Ledger].BATCH_58)= '" & [Forms]![frmOracleGLUpload]![cboBatch] & "' AND (([Work General Ledger].FROM_58)=""GL""));"

000006532 is the text field with the batch number for this example. Here is what I get with debug.print:

UPDATE [Work General Ledger] SET [Work General Ledger].UPDATED_58 = "Y" WHERE ((([Work General Ledger].UPDATED_58)="N") AND (([Work General Ledger].BATCH_58)= '000006532' AND (([Work General Ledger].FROM_58)="GL"));

Thanks

Re: [MSAccessProfessionals] Runtime Error '3075' Syntax error in query expression

Never mind. I just figured out the problem was with the parenthesis. Too many in some places and they weren’t balanced.

Doyce Winberry

Manufacturing

Manager Systems

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973 M: +1 501-207-2269

From: MSAccessProfessionals@groups.io <MSAccessProfessionals@groups.io> On Behalf Of Doyce Winberry via groups.io
Sent: Wednesday, October 15, 2025 7:19 AM
To: MSAccessProfessionals@groups.io
Subject: [MSAccessProfessionals] Runtime Error '3075' Syntax error in query expression

Hello friends, I need help with syntax on an SQL statement. It is pulling criteria from a combo box. I want it up update a field, UPDATED_58 from “N” to “Y” for records with a batch number (text field) that comes from

ZjQcmQRYFpfptBannerStart

This Message Is From an External Sender

This message came from outside your organization.

ZjQcmQRYFpfptBannerEnd

Hello friends,

I need help with syntax on an SQL statement. It is pulling criteria from a combo box. I want it up update a field, UPDATED_58 from “N” to “Y” for records with a batch number (text field) that comes from a combo box. I’m getting a runtime error 3075, syntax error in query expression and can’t figure out what is wrong. Here is the SQL from VBA:

strSQL = "UPDATE [Work General Ledger] SET [Work General Ledger].UPDATED_58 = ""Y""" & _

" WHERE ((([Work General Ledger].UPDATED_58)=""N"") AND (([Work General Ledger].BATCH_58)= '" & [Forms]![frmOracleGLUpload]![cboBatch] & "' AND (([Work General Ledger].FROM_58)=""GL""));"

000006532 is the text field with the batch number for this example. Here is what I get with debug.print:

UPDATE [Work General Ledger] SET [Work General Ledger].UPDATED_58 = "Y" WHERE ((([Work General Ledger].UPDATED_58)="N") AND (([Work General Ledger].BATCH_58)= '000006532' AND (([Work General Ledger].FROM_58)="GL"));

Thanks in advance.

Doyce Winberry

Manufacturing

Manager Systems

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973 M: +1 501-207-2269

[MSAccessProfessionals] Runtime Error '3075' Syntax error in query expression

Hello friends,

strSQL = "UPDATE [Work General Ledger] SET [Work General Ledger].UPDATED_58 = ""Y""" & _

" WHERE ((([Work General Ledger].UPDATED_58)=""N"") AND (([Work General Ledger].BATCH_58)= '" & [Forms]![frmOracleGLUpload]![cboBatch] & "' AND (([Work General Ledger].FROM_58)=""GL""));"

000006532 is the text field with the batch number for this example. Here is what I get with debug.print:

Thanks in advance.

Doyce Winberry

Manufacturing

Manager Systems

XPO

2001 Benton Street

Searcy, AR 72143 USA

O: +1 501-207-5973 M: +1 501-207-2269

Minggu, 20 Juli 2025

Re: [MSAccessProfessionals] Update tables from second DB

Hi Mike,

Your plan makes good sense and is a practical workflow, especially for managing job data between the office and field. Since you're already using Microsoft Access, a great improvement would be to integrate it with a SharePoint List. This setup allows real-time updates without needing to email files back and forth.

Recommended Workflow Using Access + SharePoint:

Create your Work Order table in Access.
Publish the table to a SharePoint List – Access supports this directly.
From the office, create a new work order in the SharePoint-linked table.
The service tech can open the same SharePoint List using an Access frontend, or via a browser or Power Apps on a mobile device.
Update job info in the field, which syncs instantly with the main database.
From the office, you can generate the PDF and email it to the client using Access automation.

Benefits:

No need to copy or email files.
Live, centralized data.
Minimal manual work — Access + SharePoint handle syncing.
Scalable as your jobs or team grow.

If you'd like, I can walk you through setting up the SharePoint integration or provide a basic example.

Best regards,

On Mon, Jul 21, 2025 at 4:03 AM michael simpson via groups.io <saccity101=yahoo.com@groups.io> wrote:

I work as a plumber, current procedure is to text the client with details, then copy and past to my database when home, followed by my software creating a PDF and generating an email to send to the client...

I'm an old Plumber not a programmer.

What I would like to do is send a file from the office, update in the field and email to client and office.
My thought is to have a base template WorderOderdb create a copy, update with call/job info... Then email to service tech...
At completion of task, update file and email back to office... and or client...

From there read updated fields back into base database..

Does this sound like a reasonable path, any better ideas, starting pointers...

Take care,
Mike the Plumber

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[MSAccessProfessionals] Update tables from second DB

I work as a plumber, current procedure is to text the client with details, then copy and past to my database when home, followed by my software creating a PDF and generating an email to send to the client...

I'm an old Plumber not a programmer.

What I would like to do is send a file from the office, update in the field and email to client and office.

My thought is to have a base template WorderOderdb create a copy, update with call/job info... Then email to service tech...

At completion of task, update file and email back to office... and or client...

From there read updated fields back into base database..

Does this sound like a reasonable path, any better ideas, starting pointers...

Take care,

Mike the Plumber

Sabtu, 19 Juli 2025

Re: [MSAccessProfessionals] ALPHABETIZATION

Access doesn't simply follow the raw ASCII values of characters; instead, it uses the collation order defined by your computer's regional and language settings.

In a default "General" sort order, values beginning with a space come first, followed by those enclosed in quotation marks, and then items starting with a minus sign (which sort before those starting with a plus sign); for any other symbol (like "#"), while its ASCII code would normally place it before letters, the regional collation often treats letters as more significant so that, for example, "AC Adapter" (starting with A) comes before "#10", and since text is compared character‐by‐character, a string beginning with "9" sorts before one starting with "a" (as in "adapter audio TV") .

On Sun, Jul 20, 2025, 2:58 AM Phil, WF3W via groups.io <WF3W=JUNO.COM@groups.io> wrote:

Gday all,

I know you're keeping hydrated...

A simple look-up, in Access, had me stumped for many, long minutes, as to not being in alphabetical order, in a table.

Online was not helpful, so, I ask:

when ACCESS alphabetizes, what is the hierarchy/order, e.g., spaces, punctuation marks, e.g., #, numbers, etc.

Some brain-busters:

AC Adapter appears before #10; adapter audio TV is after 9v batt

Thanks for your help.

Phil, WF3W

_._,_._,_

Groups.io Links:

You receive all messages sent to this group.

_._,_._,_

[MSAccessProfessionals] ALPHABETIZATION

Gday all,

I know you're keeping hydrated...

A simple look-up, in Access, had me stumped for many, long minutes, as to not being in alphabetical order, in a table.

Online was not helpful, so, I ask:

when ACCESS alphabetizes, what is the hierarchy/order, e.g., spaces, punctuation marks, e.g., #, numbers, etc.

Some brain-busters:

AC Adapter appears before #10; adapter audio TV is after 9v batt

Thanks for your help.

Phil, WF3W