Go Back   Access World Forums > Microsoft Access Discussion > Queries

Thread Tools Rate Thread Display Modes
Old 12-19-2017, 03:12 AM   #16
Newly Registered User
Join Date: Apr 2013
Posts: 287
Thanks: 50
Thanked 1 Time in 1 Post
exaccess is on a distinguished road
Re: sql query with variable field names

currentdb.execute "UPDATE [" & dest & "] SET SOMESTRINGFIELD = " & myval
Yes Static this was the solution I was looking for. It works like charm.

Galaxion I did not want to rebuke anyone, nor did I use inappropriate language. Do not worry I put much more time to research on finding new and shorter ways to do things then to just accept what is written in the forum. This solution saved me a lot of coding in VBA.

Thanks a lot Static.

exaccess is offline   Reply With Quote

field , names , sql query , variable

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Append records with different field names or change field names maw230 Queries 7 06-29-2016 02:06 PM
Dlookup with variable field names thescottsman Modules & VBA 2 09-03-2015 11:48 PM
Populate List Box with variable table field names sammylou Modules & VBA 5 04-25-2014 11:12 AM
VBA to query with variable field names? MinnDarwin Modules & VBA 1 10-02-2006 11:37 AM
Field Names from form in Query Field titles samonwalkabout Queries 5 01-12-2004 09:41 AM

All times are GMT -8. The time now is 05:54 AM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World