kiask2343
Last Activity: Sep 30 '06, 05:36 PM
Joined: Sep 18 '06
Location:
-
when I run the query it tells me that it can't append becuase of a data format error. I have done everything I can think of to clear everything and make the two fields the same but it still says it. -
Move data from one table to another with query
Ok here is what I've got.
I have a table called (EQUIP REG)
It contains all the information to the equipment in the hospitol.
next i have a table called (WO REG)
It contains all the information for the workorders for the equipment.
In the EQUIP REG table I have field titled (PM) this is the date that the equipment is due for PM's. Now I could just run a query for all the equipment on a given date called... -
Problem solved I need to use an update query.
Thanks for the helpLeave a comment:
-
I get this error when I run the append query:
What I am trying to do is insert the date into a field in the table using a form. I have it set as an append query that is run by a command button....Leave a comment:
-
Need help to insert date
Ok I need a little help here. I need the code to insert todays date into a specific field.
This is what I think I need but I don't know how to make it work.
This is how I wrote it.Code:INSERT INTO target [(field1[, field2[, ...]])] VALUES (value1[, value2[, ...])
VBA:
WO REG is the table and CLOSEDATE...Code:INSERT INTO WO REG.CLOSEDATE VALUES (DATE());
-
Double check that the field is set to text, becuase that is the only thing I can think of that would cuase that.Leave a comment:
-
I am looking for something very simular, have one person helping me, but I am the newest of newbs to VBA and access. If it is ok I would like to monitor this thread as well as mine.Leave a comment:
-
I really am grateful for your help, but when I say I know very little I mean it. I have no idea how to write code or even where to write, I opened up the query in sql view and put in what you suggetsted and access beeped at me. So I tried using the help feature and this is what it gave me.
...Code:INSERT INTO [CLOSED WO'S] ( WO, MMCN, TECH, NOMIN, FUALTS, TYPE, [SECTION], CLOSEDATE, OPENDATE ) SELECT [WO REG].WO, [WO REG].MMCN, [WO
Leave a comment:
-
When I run this query what are my parameters? No matter what I type it does nothing. Access takes the code but either I'm doing it wrong or it doesn't work.
in the feild areaIn the criteria area this is what it says.Code:Expr1: "Append query: qMove2ClosedWorkOrder INSERT INTO Closed WO's SELECT * FROM WO REG where WO REG.id"
then when I run the code it askes...Code:[forms].[New Workorder].[id]
Leave a comment:
-
Need to close Data in Table "A" and export it to table "B"
Ok before I get started let it be known I am the definition of a newbie when it comes to access and VBA. I know very little about access and nothing about VBA. I am in the Army and am tasked with making a maintenance program for medical equipment. I have the database, the query, the forms, and the reports. I was able to figure those out, but there is one thing that is beyond me.
Ok I have three tables call them table "A"...
No activity results to display
Leave a comment: