Search results

Thank you very much, that did the trick! I tried looking for some kind of requery statement, but I didn't realize it was a command.

I'm working on a "login" form, I've borrowed the concept from another topic in this forum. I'm using a Subform, visible = False when they start. A Listbox with names fed from Personnel_table displays all the users of my Database. By clicking on a name, and then the "Login" button my VBA code...

This should be an easy one. I have a query I'm working on. I use three tables to pull my data. WorkTracker - each record is a date, worker name, and chore name completed Chores - list of chores and the allowance received for each Transactions - date, child, and money spent I have a query that...

Thanks again, I just figured it out. Silly me - I forgot that I renamed the checkbox (I was trying to standardize my naming conventions) so I had to change the code to say "Lockout_Check" when referencing the Lockout checkbox. Thanks! Works as advertized – you are awesome. ~Kit

I really appreciate the help - the code worked perfectly - impressive for off the top of your head! I did try to create a shared module for the Public Sub doLockout bit - I created a separate module for it but I don't know how to make it "Shared" as you suggested. I tried using it this way and...

I have some VBA that I wrote a while back when I first started working in Access, and I'm trying to find if there is a better way of doing this. On my form I have a set of fields that can be displayed as editable or read-only depending on a "Lockout" checkbox for that record. But it feels...

In my office we often get requests from higher ups about the support we've supplied to our customers. We try to keep track in Excel, but this is such a primitive way of doing things, and I would much rather use Access. Rather than explaining the whole situation I'm going to just dive into the...

This place looks pretty great. I was googling some Access help questions when I found this place so I'm pretty excited to try and learn some things. I live in California, work as a Database Manager, and recently I've been making the jump from Excel to Access (Like so many of us do). For the...