Search results

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

What is happening here is that whenever I move from one location to another my public IP address changes which is cumbersome, now Imagin we have salesmen moving to different locations in a day. This means that they cannot login or connect to PHP cPanel MYSQL database, is there a way to sort out...

Thank you so much Edgar! 1. It seems like the error message indicates that there’s an issue with the parameters in your request. You seem to have a very clear understanding of this error message, I need to concentrate on this point, I will be back with the results tonight.

Point taken and thanks for the correction to all contributors

Now the last part I'm struggling with is how to make a wildcart IP address which will allow connection for all IP addresses in the range. Here is my public IP address which which I use Public IP address = 41.224.117.250 Submask = 255.255.255.0 Now how do I make a wildcard IP address from it ...