ACCESS FEED

Rabu, 15 Oktober 2025

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

Thanks Mark. I'll have to test that. I tried it earlier and it wouldn't compile but then again it was while I had unmatched parenthesis.

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 Mark Burns via groups.io
Sent: Wednesday, October 15, 2025 9:29 AM
To: MSAccessProfessionals@groups.io; Doyce Winberry via groups.io <doyce.winberry=xpo.com@groups.io>
Subject: Re: [MSAccessProfessionals] Runtime Error '3075' Syntax error in query expression

Also, you were mixing both ""s and ''s (double quotes and apostrophes) in the same query test - which is another potential source of confusion. SQL Server/T-SQL prefers single quotes (apostrophes). So it's better to be consistent in that regard.

ZjQcmQRYFpfptBannerStart

This Message Is From an Untrusted Sender

You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd

On 10/15/2025 8:34 AM EDT Doyce Winberry via groups.io <doyce.winberry=xpo.com@groups.io> wrote:

Thanks Duane. You are correct the number of "(" and ")" aren't equal. Evening them out fixed the 3075 error. Thanks for the other syntax advice also. I'll try it. And yes, UPDATED_58 actually a text field. It's from an SQL table for a program I didn't write. Not sure why they chose to add zeros to the front.

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 Duane Hookom via groups.io
Sent: Wednesday, October 15, 2025 7:30 AM
To: MSAccessProfessionals@groups.io
Subject: 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

ZjQcmQRYFpfptBannerStart

This Message Is From an Untrusted Sender

You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd

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

On 10/15/2025 8:34 AM EDT Doyce Winberry via groups.io <doyce.winberry=xpo.com@groups.io> wrote:

Thanks Duane. You are correct the number of "(" and ")" aren't equal. Evening them out fixed the 3075 error. Thanks for the other syntax advice also. I'll try it. And yes, UPDATED_58 actually a text field. It's from an SQL table for a program I didn't write. Not sure why they chose to add zeros to the front.

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 Duane Hookom via groups.io
Sent: Wednesday, October 15, 2025 7:30 AM
To: MSAccessProfessionals@groups.io
Subject: 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

ZjQcmQRYFpfptBannerStart

This Message Is From an Untrusted Sender

You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd

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

Thanks Duane. You are correct the number of "(" and ")" aren't equal. Evening them out fixed the 3075 error. Thanks for the other syntax advice also. I'll try it. And yes, UPDATED_58 actually a text field. It's from an SQL table for a program I didn't write. Not sure why they chose to add zeros to the front.

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 Duane Hookom via groups.io
Sent: Wednesday, October 15, 2025 7:30 AM
To: MSAccessProfessionals@groups.io
Subject: 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

ZjQcmQRYFpfptBannerStart

This Message Is From an Untrusted Sender

You have not previously corresponded with this sender.

ZjQcmQRYFpfptBannerEnd

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

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.

_._,_._,_