Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 12-19-2017, 03:12 AM   #16
exaccess
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

[QUOTE=static;1559470]
Code:
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
Reply

Tags
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
General
Tables
Queries
Forms
Reports
Macros
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