Search results

Well said the doc man and highly appreciated. Just for curiosity's sake, since I'm able to access the resources on the local network by do the following (1) "http://192.168.xxx.x.xx:8080/XXXXXXXXXXXXXXXXXXXXX" Dim Request As Object Dim stUrl As String Dim Response As String Dim requestBody As...

I'm not sure whether I got a response on this, I have staff who are relatively new and so are not competent to process the landed costing, since we are using the cloud accounting software, I'm able to see their work where we are based. The problem here how to approve their work digitally since...

The printing is called automatically after the last API is complete, the only problem is the last call function is updating the stock twice, but if I use the onclick button all is fine, could it be I'm doing something wrong on the code below? If (DCount("ItemSoldID", "QryPosReceipts"...

Okay thanks Minty the rest I will do it

@ Check your count of records returned by the source query for your report before trying to print it. If it's zero don't try and print it, and don't call your other routines. How do I do the count, sorry for sounding foolish????? Here is my query SELECT tblPOSStocksSold.ItemSoldID...

Dear all, Is it possible someone can have an idea how to call two functions immediately after successful printing of a receipt, the print function is stated below, and so once its run and the document comes out, I need to call the other two functions which links to two APIs to update inventory...

I want to implement the error handling mechanism in the code below, the objectives of the error handling are to give the error message and once the user click okay the code must exit the processing immediately. This will help to ensure that the stock levels are only updated once there no errors...

Sorry I think people misunderstood my situation here, the form data entry property is set to "YES" meaning once data saved , there will not be any opportunity to correct any errors at all because the data is gone for good unless if someone has an opportunity to correct it directly in the tables...

Hi I'm now doubting myself here on a single form data clone, I want to clone the underlying data on a single form called frmProducts so that people can edit that data anytime they want to. Here is what I'm doing: Private Sub CboSelectProducttoedit_AfterUpdate() Me.Filter = "ProductID = " &...

I think you need a text box for Date select just below your onclick command, for example you may call it txtRequiredDate, then you code will be as follows: Private Cmd28_Onclick() Dim Cancel as integer If DLookup("lookupDate", "YourTable", "[ShiftDate] <>#" & Me.txtRequiredDate & "#) Then Beep...

Many thanks The Doc Man, you have cleared my worry am not thinking of summing several products I'm only interested with one product and one record at a time.

I had to reconstruct the table from scratch and the query including the forms its now working as required, my last question is since I'm using the open record set instead of the Dsum can this change the speed over time for example after having like 2000000 lines per product line. Kindly advise...

Okay this appear to work Private Sub Form_AfterInsert() Me.Dirty = False End Sub

theDBguy Ok Where do I put it, which event?? Me.Dirty = False

Sorry people, this question was asked here before, but I seem to see where the problem is coming from and if the permanent solution is found then it will help others as well. When MS Access is used as Front End with MYSQL then whichever form you use for entering new data the Primary Key does...

Well noted

Okay many thanks here are the small database attached, all what is required is to grab the following: Latest Closing Balance: (1) Mango Juice = 7 (2) Orange Juice = 20 (3) Pineapple Mix = 5 My query is also there to easy the checking

I have two forms, one the parent form also called Invoice header, and the sub form referred as detail Ines. Now when users are entering data in the sub form the form calculate also the remaining balance of the stock being sold, so in short, the running balances per each product latest balance is...

Many thanks for the clear help

Where does the requirement of the specific IP address originate? If it is the standard MySQL login system, you can enter * into the host name column to allow logins from any IP address. @ sonic8 AWF VIP You seem to know exactly my problem when you say I * in the remote host column do you mean...