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 Chriss Miller 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. chris9

    Should be a very easy question

    I want my form to look up a columns value and if the column is empty insert a character(example: "n"). I've tried to alter the table with a sql statement but that doesn't seem to be working. I know this should be fairly simple but I'm not having any luck. Thanks so much
  2. chris9

    Sort some by ascending and some by descending

    Thanks you. I tried it with the () and [] but never tired it without them.
  3. chris9

    Sort some by ascending and some by descending

    I have the following code that sorts the table in ascending order by MakeName, ModelName, and VIN rst.Open "Select * From " & tnm & " Order By MakeName, ModelName, VIN", CurrentProject.Connection, adOpenStatic, adCmdText 'tnm is my table name I want to now add two more...
  4. chris9

    Not changing the values during UPDATE

    These aren't traditional line breaks. If you go to file/get external data/import/ select a text file then select fixed width and next you will see how the line breaks are actually created. They are really fields breaks so I miss lead you with the terms that I used.
  5. chris9

    Application error closing Access

    ...If Not CurrentDb(tnm) Then MsgBox "This table already exists in the Database." DoCmd.RunSQL "DELETE * FROM " & [Forms]![Form1]![Text0] & "" DoCmd.RunSQL "ALTER TABLE " & [Forms]![Form1]![Text0] & " DROP COLUMN MakeName" Else End If The...
  6. chris9

    Not changing the values during UPDATE

    Here is the statement that is creating my table: DoCmd.TransferText acImportFixed, "Price Symbol Import Specification", Forms!Form1!Text0, Forms!Form1!Text2, False, "" The "Price Symbol Import Specification" was created when I manually imported one of the txt...
  7. chris9

    Table in Database

    I have a form that is creating a table and I want to check and make sure the table name that is entered into [Form]![Form1]![Text0] is in the database. If the table already exists I want to delete it because otherwise the new data that I am importing gets added to the current table. So basically...
  8. chris9

    Not changing the values during UPDATE

    Thanks Bob for all the help. I figured out how to add the column and everything is working very good. DoCmd.RunSQL "ALTER TABLE " & tnm & " ADD COLUMN MakeName TEXT" Another question a little different, is it possible to not have the alert box come up telling you...
  9. chris9

    Not changing the values during UPDATE

    This statement puts the correct values into the Update_MakeAbbr! DoCmd.RunSQL "UPDATE " & tnm & " AS A INNER JOIN Makes AS B ON A.MakeAbbr=B.MakeAbbr SET A.Update_MakeAbbr = B.MakeName" However this statement is not changing the value of A.MakeAbbr DoCmd.RunSQL...
  10. chris9

    Not changing the values during UPDATE

    When I DoCmd.RunSQL strSQL am I supposed to be able to see the results in the update in the [Forms]![Form1]!Text0.Value table? I get a message back that it's updating 2775 records out of the 3303, so it must be doing something but I can't tell. I trying to the the value of MakeAbbr and it's not...
  11. chris9

    Not Changing Tables Info on Update

    When I use this code I do not get an error, but it doesn't appear that the MakeName is the tnm table. I really need to get the MakeName somewhere into the tnm table either in it's own column or replace the MakeAbbr if the tnm.MakeAbbr = Makes.MakeAbbr. Hopefully I've this is clear to understand...
  12. chris9

    Can't get my table to Update in my form

    When I use this code I do not get an error, but it doesn't appear that the MakeName is the tnm table. I really need to get the MakeName somewhere into the tnm table either in it's own column or replace the MakeAbbr if the tnm.MakeAbbr = Makes.MakeAbbr. Hopefully I've this is clear to understand...
  13. chris9

    Not changing the values during UPDATE

    When I use this code I do not get an error, but it doesn't appear that the MakeName is the tnm table. I really need to get the MakeName somewhere into the tnm table either in it's own column or replace the MakeAbbr if the tnm.MakeAbbr = Makes.MakeAbbr. Hopefully I've this is clear to understand...
  14. chris9

    Not changing the values during UPDATE

    When I use this code I do not get an error, but it doesn't appear that the MakeName is the tnm table. I really need to get the MakeName somewhere into the tnm table either in it's own column or replace the MakeAbbr if the tnm.MakeAbbr = Makes.MakeAbbr. Hopefully I've this is clear to understand...
  15. chris9

    Updating Table - Missing Operator Error

    When I use this code I do not get an error, but it doesn't appear that the MakeName is the tnm table. I really need to get the MakeName somewhere into the tnm table either in it's own column or replace the MakeAbbr if the tnm.MakeAbbr = Makes.MakeAbbr. Hopefully I've this is clear to understand...
  16. chris9

    Updating Table - Missing Operator Error

    OK, here's the code that I am trying to use: Dim strSQL as String Dim tnm as String 'Get the table name that I am creating in a form tnm = Text0.Value 'I am adding another column to my trm table that is generated from my Makes table. strSQL = "UPDATE " & tnm & " INNER JOIN...
  17. chris9

    Trouble Linking Table's Columns

    When I try this code, I'm getting a syntax error(missing operator) in query '2002.MakeAbbr = MAKES.MakeAbbr'. 2002 was the table that I created or that was in tnm. Any suggestion to get this debugged.
  18. chris9

    Trouble Linking Table's Columns

    I have: -one Access table called Makes containing two columns MakeAbbr and MakeName. Example: MakeAbbr=Chev and MakeName=Chevolet -one table created from a form, where user enters the table name in to [Text0] and in [Text2] the text file to be imported. The user then clicks on the Create Table...
  19. chris9

    Read all Table names function

    Does anyone know if there is a function that can List all the Tables you have in one Database?
  20. chris9

    DLookup in Macro

    Does anyone know how to use the DLookup in a Macro? according to the help it can be done, but I'm not sure where you can enter it.

Part and Inventory Search

Back
Top