I have a table [tblROPError] that I want to update one field in. I created an Update query that uses a SQL Passthrough query [qryROPTracking] as my data source. I get error: Operation Must Use Updateable Query.
Do I have to write the records from [qryROPTracking] to a table before I can update my table [tblROPError]? Isn't there a better way without having to store records that are already being stored in SQL?
Here is the Update Query:
UPDATE qryROPTracking INNER JOIN tblROPError ON qryROPTracking.adid = tblROPError.AdID SET tblROPError.DEUsername = qryROPTracking!username;
Please help. I want to avoid having to write the records to a table so I don't have a delayed response that the users will feel.
The Windows Phone Theme Colours is a tight, powerful, and well balanced palette.
This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder.
But why not let Windows retr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …
With just a little bit of SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form. If you have never written code or looked at an SQL statement before, no problem! ... give i…