Search results for query: *

got it, had to do a distcode = replace.... Thanks tho

I have tried that but i recieve that 'no column was specified for column 1 of DistCode'

I have a table with a bunch of districts where the fieldname is DistCode. I have a select statement as follows: SELECT distcode = 'sta' from tableDistCode What i want to do is replace 'sta' in the results with 'state', how can i do this. Thanks

thanks that worked, i didnt know it had such an option

hi, I have a form that allows a sort of dynamic filtering of a subforms recordset. On the main form i have various options to filter results that are displayed on the subform these options are things like part numbers, dates, employees, etc. What happens when options are selected off the main...

cool, that works. Thanks a ton. Leaves me with anoth question, whats the difference with the two as a concatenation operator?

i have a form that has several options (cmboboxes, text, date and time picker) and depending on what options are select a make a sql string to query a table. my problem is when i add a between dates criteria to the string it breaks. here is an example of a string that wont work, it states...

I'm have made an asynchronous client/server program using sockets. I am trying to update a listbox when i receive a message but i keep getting an TargetInvocationException on it. I have the method i am using for this on other controls and they work just fine, its just this listbox. What...

I got it .. thanks for the help

So here i what i have going for now: I populate my temporary table with the values: SQL = "INSERT INTO TempTbl ([Tool_Serial],Size) SELECT [Bulk Import update].[Tool Serial], [Bulk Import update].[Size] FROM [Bulk Import update]" 'DoCmd.RunSQL SQL1 Then i update the table with the new values...

This is what i have found to do but i keep getting a message saying that temporaryTbl is already created. Is this right? Dim temp As TableDef Set tempTbl = Db.CreateTableDef("temporaryTbl") With temp .Fields.Append .CreateField("Tool Serial", dbText) .Fields.Append .CreateField("Size"...

Is using the temporary table from the query just a matter of using a make table query and then deleting that table once you are done or is their a better way make one? Sry, might be basic but i have never done it before.

Does it have to do with the type of join, because if i take out the join it will update the table but the user has to enter it, but it rids the error. Are there any other ways to do this?

thanks that helps ... do you know why i would be getting a 'runtime error 3073 operation must use an updateable query'? code for the update query: UPDATE [Tools v3] RIGHT JOIN [Bulk Import] ON [Tools v3].Serial = [Bulk Import].[Tool Serial] SET [Tools v3].Serial = [Bulk Import].[Tool Serial]...

Im trying to update a table from three different excel tables, so what i have done is a union query to get the information i need from the three tables into one query table, Bulk Import. What I'm trying to do with the information in Bulk Import is to update/add to another table Tools v3. I want...

how would i make the table temporary? also if i wanted to iterate through the records would i use the bookmark feature? thanks

im try to create a automated batch update feature to one of my tables. What i have is a table, Tools, that consists of: serial, size, date_serviced, status, employee. The excel file i need to import can be called xlTable, but it contains too many fields; tool serial, serviceID, size (inches)...

sweet, thanks i got it working. although i had to use, If Not IsNull(DLookup....), not sure why but it works. thanks for the help.

oh and the stDocName is an update query while the stDocName1 is an append query

-MS Access 2002- Im trying to create a form called 'update tool' that will take the values, Employee (number), Serial (text), Size (number), and compare the serial field of the form 'update tool' to a table that holds all of the serials, 'Tools'. So what i have for the 'on click' property of a...