Search results

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

@ComputerVersteher Mnay thanks. I can tell you after implimenting the following all is working great! (1) #Deleted data , here I'm using Me.requery to clear that (2) Timestamp = require current time on both Default and atribute Plus a null tick (3) BIT data type I have gotten lid of it...

Finally the Timestamp is solved by using Now() function

@theDBguy Not sure if this is relevant, but the same thing could happen with a linked SQL Server table if the bit field doesn't have a default value assigned since Access cannot contain Null values in bit fields. Actually I followed your advise and it has sorted out 90% what happens if the BIT...

The PK is there, I remove the field with a BIT datatype all is fine, that is where I am getting puzzled. I use requery on the add or save button the #delete error also goes away on the form , now on the subform where do I put the Requery?????????/