Search results

Thanks Micron

Thanks again Colin, it works a treat!

Thanks mate I'll have a play around......

Same problem when I use MouseUp....

What does Sinister mean?

I just tried the following but it doesn't bring the form to the front of the Main form: I have also tried to point to a specific control of the fPartsEdit form without any luck: If Button = acRightButton Then sWhere = "[PartID] = " & Me.PartID DoCmd.OpenForm...

Thanks mate, I'll try that and let you know the outcome.. Cheers Greg

Thanks for the quick reply. Are you saying that I can't use it to open a form?

Hi guys I've been trying to figure out the following for some time. I have the following code on the On Mouse Down event of a TextBox control on a form in Continuous form mode that is in a Tabbed form that I have been using to try to determine the cause of my problem: Private Sub...

Thanks JHB

Hi JHB Thanks for the quick reply. I spent more time on looking at my code and I think I came up with the same idea. OldValue and NewValue are text fields because they can also contain text or numbers. This is because the Audit table is used to keep track of any changes to any field in any...

Getting most recent record using Grouping query Hi guys, I have been struggling trying to resolve this issue for days and just can't seem to crack it so I'm throwing it out there for some help.I have attached a stripped down version of the database as well.I have a table called "PARTS". It...

Hi Gasman Here is the code...it's pretty simple: Private Sub Form_Load() Command1.Visible = False End Sub Private Sub Form_Timer() Command1.Visible = True End Sub You then need to set the Timer Interval to some value Cheers Greg

Thanks for your suggestion..

I just figured it out! I needed to add some code to the On Load event that initially set the Visible property of the button to False and then set the On Timer to set the Visible property to True after a few seconds....

Hi guys I have tried to figure this out myself without success. I have a form that is popped up when the user clicks a button on the main form. This popup provides information that the User must read. There is a "CLICK TO CONTINUE" button on the popup to enable them to continue to the...

Thanks mate

The Date_WO_Sent is not always populated that is why I was checking for nulls...I'll have a play with the NZ function

Hi CJ, I'm not seeing any errors. How would I change the code to handle this type of condition?

I will put together a cut down version of the database tomorrow and get it to you...thanks for helping me with this. Cheers