Recent content by Anika

  1. A

    query over my head (order vs in stock inventory)

    Thank you for your reply Bob. I will provide my database most likely Monday as I am away from home for the weekend. I apologize for multiple posts. I posted my other question in General as it was not Query related, thinking that was the best place for it. Thank you for a lesson in posting...
  2. A

    query over my head (order vs in stock inventory)

    The oddest thing is that I actually chose to show only the records whre both fields match. I think my problem may be is that I am trying to select based of too many criteria. How would you write a query where you want to display results from table Inventory only where fields amount, color and...
  3. A

    database structure/change advice

    I am working on a project where I have 2 warehouses, each with it's own inventory and am trying to create a way to compare the inventory in each. When I get an order, I would like to know if I have the items on hand and which warehouse houses my goods. At this time I have my small database...
  4. A

    query over my head (order vs in stock inventory)

    I have 2 tables. OrderInfo and Inventory. I created a one to many relationship with Order ID being the linking field. In OrderInfo, I can have up to 6 distinct items being ordered but some fields will always remain the same. Example: 20 | Cotton | White (will be the same) and then T-shits |...
  5. A

    Import confirmation / status message box?

    This is my code: Private Sub Import_Sbod_Click() Dim path As String path = InputBox("Enter the full path to your text file. Example: C:\TestFile.txt", "File Location") DoCmd.TransferText acImportDelim, "test", "Sbod", path MsgBox "Import Complete", vbOKOnly, "Confirmation" End Sub If...
  6. A

    Import confirmation / status message box?

    OK, so I figured out how to import my data and now I'd like to display a message box with either success or failure message. How would I be able to determine whether my import failed? Sorry for the begginer types of questions, still learning. - Code Kiddie
  7. A

    Semicolon (;) import specification behaving as fixed length

    All fixed! I decided to use the transfertext method instead. -Code Kiddie
  8. A

    Semicolon (;) import specification behaving as fixed length

    I am very unfamiliar with VB and am dabbling in Access more as self-study and a hobby. I am attempting to import a semicolon delimited text file into an existing table using a comand button and saved import specifications. The file imports, but it acts as though my specs were fixed length not...
See more
Back
Top Bottom