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...
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...
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.
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.
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...
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...
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...
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.
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...
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...
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...
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...
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.
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...
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...
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]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.