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 Wanet Telecoms Ltd 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. Penrodcigar

    Query to make a table with Autonumbered records how?

    How can I write a make a table query that will add an autonumbered field to the new table ? DoCmd.RunSQL "SELECT Inventory.Face, Inventory.Price, Inventory.Quantity INTO Autonumber FROM Inventory WHERE (((Inventory.Face)="xxx"))" This DoCmd will produce a table called Autonumber with records...
  2. Penrodcigar

    "The Data Has Changed" message box

    I get the following message eacj time I click on a combo box "The Data Has Changed. Another user edited this record and saved the changes before you attempted to save your changes. Redit the Record" After I click the message box, and retry the combo box, the message doesn't come up and I can...
  3. Penrodcigar

    Script.Shell directory search

    Dim S As Object Set S = CreateObject("WScript.Shell") S.Run Chr(34) & "C:\01_LawSchool\12 Spring 2007\Independent study\Data zoning exceptions 2000-2004\2000 vol I\HPIM3948.JPG" & Chr(34) Set S = Nothing I'm using the above code to open scans with a command button on a form. But the directory...
  4. Penrodcigar

    JPG picture viewer on Access

    How can I open Microsoft picture/fax viewer from access? The data table has a file name for the .jpg scan. I need to open the scan from a form command button that will reference the .jpg file name. Is there another application I can use if not the picture viewer? I don't find the viewer...
  5. Penrodcigar

    Append Query on Autonumber Field

    Is it possible to use an append query SQL statement with DoCMD.RunSQL when updating a table that has an Autonumber ID field? I keep getting a key violation. It's no problem without the Autonumber field.
  6. Penrodcigar

    .Move numrecords, start: method problem

    Using the .Move numrecords, start: method Access gives me the error message “Sub or Function not Defined”. The actual lines of code read: Dim PrIDVar As String PrIDVar = Me.Face.Value ‘where the value is the row selected with a combo box...
  7. Penrodcigar

    Subform to query repeats same record

    The subform based on a query repeats the first record of the table in each instance. The main form and the subform are based on the same query. I use a purchase order number on the main form to call up different information on the subform. Everything works fine, except every instance of the...
  8. Penrodcigar

    Truncate string with decimal point

    Anybody have a simple way to truncate a string number with a decimal so it limits the places after the decimal?

Part and Inventory Search

Back
Top