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

    Eliminate Mas90 SOTAMAS90 LOGIN Screen

    I have an access database with files linked to Mas90 4.05. I have created a new DSN and set it up with the Company Id and User Id for Login. If I use Excel to test, it does not ask me to login and brings in the data from the correct company. I linked the tables in my access database using this...
  2. CaiSupport

    VB and Mas90 ODBC Connection....

    I am using Mas90 4.05. I created a DSN with the Company and User ID. I am using the switchboard to open a form and I always get the Mas90 login box. I have linked all the tables using the correct DSN. Where can I turn the Login box off? It does go to the correct company data, but I would...
  3. CaiSupport

    Syntax for Multiple Inner Joins

    Now when I update it says it did not update the 2 fields due to a type conversion failure. I tried it with and without the single quotes. Both dates are defined as Date/Time. Thank you again for your help.
  4. CaiSupport

    Syntax for Multiple Inner Joins

    I never thought this would be so hard and thank you for all your help. Now it says it is going to run and am I sure I want to run it and the it says "Operation must use an Updateable query". Thank you again.
  5. CaiSupport

    Syntax for Multiple Inner Joins

    That seems to work, no error messages, but I have one last request. The UpdateServiceDates is using CS.[Next Date], I wanted to change it to calculate based on ARN_InvHistoryHeader.InvoiceDate. When I change it as follows, it prompts me for a date. I do not know access well. If I do put in a...
  6. CaiSupport

    Syntax for Multiple Inner Joins

    Thank you for your quick response. I still get Syntax error in Update statement.
  7. CaiSupport

    Syntax for Multiple Inner Joins

    Original Code UPDATE CustomerService AS CS INNER JOIN AR_95_UDF_ARInvoiceLines AS Inv ON (CS.[Next Date]=Inv.Nextservicedate) AND ((CS.ID)=Inv.Scheduleid) SET CS.[Previous Date] = CS.[Next Date], CS.[Next Date] = UpdateServiceDates(CS.[Next Date],CS.Interval,CS.Frequency); Changed To add an...
  8. CaiSupport

    Adding Table and Changing code

    We had someone help us write this code and now they are gone and the client wants changes. Currently we update the Access database (Customerservice) by matching with a Mas90 table. Everything was fine, but we were calculating the next date based on what was the last next date in access, they...
  9. CaiSupport

    Strsql - Multiple matching conditions

    Thank you so much. Using the query you helped me create as a guide, I managed to change the code and it is working. The correct prices are coming through. Thank you again so much for your time and patience, I really appreciate it.
  10. CaiSupport

    Strsql - Multiple matching conditions

    The code asks for a start and end date and Product line. It then selects records from the customer service table and uses the SQL to create a file for input into another system. Here is the code. Public Function CustomerServiceReport(blnCreateCustomerOrderFile As Boolean) Dim intFileNum As...
  11. CaiSupport

    Strsql - Multiple matching conditions

    Thank for your patience. You give great instructions. I now have the following code in Query1 for the time being. The pricing is correct, but I do have too many records which is probably because the data from the select did not come over. Now how do I get this into my Modules... General...
  12. CaiSupport

    Strsql - Multiple matching conditions

    Thank you for your patience. Here is more information. This code is under General Functions. It runs a report from the menu and creates this file. It asks for a date range and type of item to select. I can get the red-dots, but if I click by the Strsql the whole statement is highlighted in...
  13. CaiSupport

    Strsql - Multiple matching conditions

    I did realize that much. I am not sure how to do the breakpoint and if I try the Union and just copy the whole STRSQL it says too many line continuations. I can get some debug stuff to display on the bottom, but it usually says out of context. (I said I do not know what I am doing) I also get...
  14. CaiSupport

    Strsql - Multiple matching conditions

    I am not an access person and someone did this code for us a year ago. I really need detail instruction if you could please. The first post shows the code as it is. Thank you for your quick response.
  15. CaiSupport

    Strsql - Multiple matching conditions

    Everytime I add my other condition, I do not get any records. Please help. Original works "INNER JOIN IMB_PriceCode " & _ "ON (CustomerService.[Price Level]=IMB_PriceCode.ItemCustomerPriceLevel) " & _ "AND (CustomerService.[Item Number]=IMB_PriceCode.ItemNumber)) " & _ Added or condition - No...
  16. CaiSupport

    Strsql - Multiple matching conditions

    I have the following working code to create a file with a price matching to the price file on Item number and price level. I now need to check for the price based on Customer number and item number besides Item number and Price Level. The pricing will be one or the other, but not both. This...
  17. CaiSupport

    Dlookup Multiple Conditions

    Thank you. Works great.
  18. CaiSupport

    Dlookup Multiple Conditions

    I am looking for a price, but the Price file could match on Item Number and Price Level or on Item Number and Customer Number. I can get each one to work, but I do not know how to combine them. Works for Price Level Lookup =DLookUp("[DiscountMarkupPriceRate1]","All Prices Query","[ItemNumber]...

Part and Inventory Search

Back
Top