Recent content by PhilTFC

the txtInvoiced was originally for the lable which i changed to txInvoiced temporarily while i was testing the txtInvoiced in the code. I have also tried the code in the OnCurrent event and still get the same results. Maybe i should change it to a check box control. Thank you for all your...

good luck and thank you so much for your help :)

Still the same result only this time the [Invoiced] text box is always visible :(

Thanks Bob, that is exactly what i want to happen :) The only difference is that my db has a Text box control ([Invoiced]) which its control source is [InvoicedHO] (Date/Time data type) from the same table as [Location] and is a date as opposed to your example being a check box. would this make...

I get exactly the same results with that code too :( it is obvious i am doing something wrong somewhere

It seems the email reply and the reply on the web site are different. The email suggest's "Arriva*'***'*" whilst here it says Like "Arriva'*'" and "Arriva'*'" either way i have tried all combinations and get the same result :(

Hi Bob Thank you for your quick reply. I have tried the "Arriva'*" and the result is the same as before :banghead:

Hi Jd thank you for your reply. I was not getting any error messages at all, the code i am using now looks like this: Private Sub Location_BeforeUpdate(Cancel As Integer) If Me.Location.Value Like "First*" Or Me.Location.Value Like "Arriva*" Then Me.Invoiced.Visible = True...

Hi i am sure this is a easy question for you guys I need a [Location] control on a form when = "First*"or"Arriva*" set [Invoiced] on the sameform to visible this is the code i am trying Private Sub Location_BeforeUpdate(Cancel As Integer) If Me.Location.Value = "First*" or "Arriva*" Then...

Please help I am using Access 2007 and have a table to store PDF file certificates (tblPDF) with 4 field names pdfID (PK) AutoNumber CertNumber (Number) indexed no duplicates PDF (Attachment) GaugeID (Number) GaugeID is the FK in the tblPDF table. The PDF certificates have unique certificate...

Hi all. I Have just gained my basic Access 2007 certificate online from gcflearnfree (great starting point by the way). My aim is to create a database based on an existing Borland Paradox database which has no support. My company owns the copyright and intellectual rights to this database. I may...

I am new to Access 2007 and would now consider myself as slightly above beginner status thanks to your easy to follow and understand tutorials. Excellent work :)