Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. nerd19

    SELECT statement

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

    SELECT statement

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

    SELECT statement

    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
  4. nerd19

    Highlighting textfields of a subform

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

    Highlighting textfields of a subform

    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...
  6. nerd19

    why wont this work...

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

    why wont this work...

    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...
  8. nerd19

    TargetInvocationException

    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...
  9. nerd19

    Importing from excel

    I got it .. thanks for the help
  10. nerd19

    Importing from excel

    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...
  11. nerd19

    Importing from excel

    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"...
  12. nerd19

    Importing from excel

    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.
  13. nerd19

    Importing from excel

    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?
  14. nerd19

    Importing from excel

    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]...
  15. nerd19

    Importing from excel

    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...
  16. nerd19

    importing data from excel

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

    importing data from excel

    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)...
  18. nerd19

    determining if record exists

    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.
  19. nerd19

    determining if record exists

    oh and the stDocName is an update query while the stDocName1 is an append query
  20. nerd19

    determining if record exists

    -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...

Part and Inventory Search

Back
Top