My problem comes from an update query. What I am wanting to do is basically move several fields of data from one table say PMTable to another table say HistoryTable before I have a query make chan...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10067639.html
Zones:
MS AccessDate Answered: 09/04/1998 Rating: 7.0 Views: 0
I have an mdb which contains my parameterized update-query.
I want to run that query through ADO-code. How do I do this?
Thanks
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10312665.html
Zones:
Visual BasicDate Answered: 03/17/2000 Rating: 7.4 Views: 0
Objective: Use a query to figure a total claim overlimit amount.
I have four tables as follows (using pertinent fields only):
CLAIMTABLE
claimnumber
overlimittotal
LINEITEMS
claimno
m...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20003637.html
Zones:
MS AccessDate Answered: 09/25/2001 Rating: 7.4 Views: 0
How do I do this:
The table I want to update:
UID(number) Red(checkbox) Blue(checkbox)
1 not checked not checked
2 not checked not checked
3 not checked ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20478141.html
Zones:
MS AccessDate Answered: 01/28/2003 Rating: 7.8 Views: 0
Hi:
I have a table that has two main fields: Date and Amount. Some of the dates do not have any amounts. I would like to write an update query that would update any records where the amount fi...
http://www.experts-exchange.com/Database/Miscellaneous/Q_20590046.html
Zones:
DatabasesDate Answered: 04/21/2003 Rating: 7.0 Views: 0
I have a form, collecting daily stats. On this is a subform - collecting no. of queries per course. I have a calculated field on the form, summing total daily queries from the subform. I would like...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20677357.html
Zones:
MS AccessDate Answered: 07/16/2003 Rating: 7.6 Views: 0
How do you create and Update Query to update the same field with different text depending on the criteria.
If field 1 is "Black" then field 2 should be updated to "Open"
If field 1 is "White" t...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20700548.html
Zones:
MS AccessDate Answered: 08/05/2003 Rating: 8.2 Views: 0
I have the following code to update a field called Task (number) based on the value of a public variable "Task Number ID". When I try to run the code, it gives me syntax errors. Please help.
...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20727596.html
Zones:
MS AccessDate Answered: 09/04/2003 Rating: 9.2 Views: 0
I would like to create a query based on CFLOOP. I need to update a undetermined number of numerically-named fields. After the loop is processed, I am looking for the following example to be what ...
http://www.experts-exchange.com/Software/Server_Software/Web_Servers/ColdFusion/Q_20801647...
Zones:
Cold...Date Answered: 11/18/2003 Rating: 9.2 Views: 0
I have a database that I have created for my company to track everything from Tardy's to Vacation time. I have created subforms to allow me to use the various data sources, however when new inform...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20875843.html
Zones:
MS AccessDate Answered: 02/06/2004 Rating: 7.4 Views: 0
