Search results

Hey arnelgp, Thanks for your code and help! I've tried this and got an error, "err_handler" was missing a ":" so that' works now, now it disabled the key, but now can't enable it, I have a backup before I added your code, so I'll make a few copies of that and try to figure it out. Any reason...

Hey there, I've actually tried this code and it won't work at all. '** This code to allow (Bypass Key) ensures the user is the programmer needing to disable the Bypass Key ** Private Sub bDisableBypassKey_DblClick(Cancel As Integer) On Error GoTo Err_bDisableBypassKey_Click Dim strInput...

Hey there, thanks for your reply, I currently do this, however, since this is done remotely, I often use teamviewer to go in and diagnose from their side of things. I guess this is also wanted to protect my work from reproduction, etc. Any chance there is a code that either can enable the menus...

Hey guys, I've got a database that I'm building that will be used by hundreds of people per day, per property at my company. To limit the possibility of design changes etc, I've created a login screen and on startup have disabled basically every menu and toolbar, as the database is made to be...

Hey All, This may be very easy, or very difficult, I'm not entirely sure. Basically, there is a user form that is filled out as a regulatory obligation for every transaction completed. These records require some personal information, and based on this information collected (first, last, date...

With some great help, this issue has been solved!

He Hey Gasman, this would be where I am a touch out of my league, any chance if I attach a copy you could have a peak?

If it makes i Hey Gasman, I guess that would be what I'd need, however what would I write in vba if the record and field I'd like to update is in another table? Also, how would I be sure that if I select John DOE under query field "Employee Name", that only that person's status goes to 10-7/10-8?

Hey All, I've created a new project for my work, it's essentially a computer assisted dispatch, storing call records for Security Operations. Essentially with each "call" (record) there is a total of 6 fields to assign "staff" to. What I'd like to do is make it so that only staff with the...

Hello, I've checked this, they are all correct and the drop downs show text but when manually inputting it saves as an interger. Thank you for your response - if you would have any other ideas why this may be happening?!

Hey All, So there are a few things to note about my database - firstly it's a comprehensive database for Employees. One of the issues I am having is with training. I have a form that creates new entries for training (for example, lets say next week I roll out a training/sign off for a Health...

Life saver, thanks so much

Darn thanks anyways

I could save it as an older version if that works

@Gasman @Pat Hartman @Uncle Gizmo I do appreciate your support, the reality is I am learning as I go and am having a really hard time keeping up with the advice, I have tried multiple methods and have had no luck. I have uploaded a partial of my database, the training modules and employee list...

Hey thanks for your response, I believe I have done this, a few questions... The criteria you mentioned, does that need its own collum or that criteria to another row (such as TrainingID), also I am unsure how to write the VBA code for the AfterIntsert, the resources I found online did not do...

I appreciate your response, I have not a clue how to do that, would doing this creat records for each Employee.ID when I make a new "module" for training?

Thanks for your response, not sure how I would normalize it, basically I have a form that you can add training "modules" to, this is a separate table that specifically houses the training only, then I have another table that has all the employees training. So let's say that I add a new "module"...

Hello all, I have been building an employee database, it has gone amazingly, just ran into something I wouldn't know how to sort out. Basically, when we have a new training requirement come out we need to track completion. The way I currently do that is adding it in through the "Add New...

Not sure how to write that for mine. Here is the layout of my database tblEmployees (master for all employee data) ID (autonumber) EmployeeID (the number I designate them) Name and so on tblEmployeeTraining TrainingID Employee (so their auto ID in the tblEmployees table) NameofTraining...