Hello,
Please see the screen shot attached.
I have a single form with multiple tabs. At the top of the form appears the name of an individual and below the name are multiple tabs containing information specific to that individual. Each tab has a separate underlying table, which is the data...
Hi Spikepl,
You're spot on. I found a thread in another forum from a user with the exact same issue. You have to explicitly tell Access that a particular folder/location is "Trusted".
Everything works fine now. Lesson learned.
Thanks again for your help. much appreciated.
MM
So here is what is weird. I created a new database, added a few fields, wrote some simple code/events and everything worked fine. Then I closed the DB, re-opened it, and guess what...Nothing Works. Aaaargh!
Hello Bob,
Thanks for replying. What is the difference between MDB and ACCDB formats? It is saved as an Access 2007 file?
Here is an example of what I'm talking about:
Option Compare Database
Option Explicit
Private Sub Form_Current()
SSN.SetFocus
Me.WorkPermitExpiration.Enabled = False
End...
Hello Everyone,
I am writing Access VB code for the first time. Here is my first really basic question...
What would cause an Access DB to ignore any and all code that I write?? Is there a switch or something that tells it to read the code I've written? A line of code inserted in the...
What would cause an Access DB to ignore any and all code that I write?? Is there a switch or something that tells it to read the code I've written? A line of code inserted in the "Declarations" perhaps? My DB is not recognizing any of the code I've written!?
I have a form with a checkbox (Is a Work Permit required?)and a date field (Work Permit Expiration date). I want the date field to be dimmed when the form opens. I want the focus to go to the checkbox first. The checkbox asks whether a youth is required to have a Work Permit. if the user...