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 Grade: C 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 Grade: A 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 Grade: A 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 Grade: A 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 Grade: A 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 Grade: A 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 Grade: A Views: 0
Here's what's going on...
I have a table with 9000+ records in it, all having names etc. What I need to have is a reference number containing 4 letters and 2 numbers.
Example:
John Smith ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20922968.html
Zones:
MS AccessDate Answered: 03/29/2004 Grade: B Views: 0
I am simply trying to make an update to an access backend database.
This is the code so far:
<%
Dim Conn 'Holds the Database Connection Object
Dim rs 'Holds the recordset for...
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_21241831.htm...
Zones:
ASPDate Answered: 12/14/2004 Grade: A Views: 0
I am no DBA by any means. I have been successful at setting up SQL Server, but now I think I need some help on a query.
I have two tables. "TL_Tooling" and "TL_Events"
Here is how they are ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_21304763.html
