Search results

For a questionnaire scenario, if the answer is 'Yes', then the next three question's checkboxes, should become active/undulled, so that they can be answered. If the answer is 'No', then the question's checkboxes should remain dulled out so as not to be answered. Can someone post a link that...

Yes, I believe it is a switchboard, now that I think of it. Let me get to it, and I'll let you know. Thanks y'all!

Something like this but not a navigation form. I'm looking through a book I have, but can't find it, yet.

I can't remember what it's called when an Access database is opened and a default form opens. On the form, the user clicks buttons to open items or run queries. If I had the name, I could look up how to do it. It's not hard. Thanks!

Got it all working. Thanks for the help vbaInet. It was definately an Else If issue. For 'clean-up', I'm going to turn off the navigation window and have it open to a form with controls, etc for reports. Thanks again!!

Give me a bit. I'll rewrite the macro and then attach the sample database. It's very small. You can then look at the Customer Table's macro. Thank you for your time.

There are no other people using the database. I have a sample database that I'm trying to set this up on, therefore any number increment is a result of me. The macro is attached directly to a table, not a form or control. Boss wants to know who makes changes on the tables. Not much in the...

Everything else works fine whether the macro is there or not. The macro is what writes the record, so if it's not there it can't perform. The macro performs a 'CreateRecord' on an AuditTable whenever my Customer table has a field that has been changed. This works great when I change one field...

Unhinged??

When I make two changes to a record, only the latter one writes to the AuditTable. For example, If I change the last name and then the first name, only the first name change is written to the AuditTable. I need both changes to write.

Cell Phone -> Desktop! Not yet. I'll probably need you to hold my hand and point to it. I've tried the second 'If'' and when I make changes, the second if writes. The first on does not. It also doesn't work when I do it separately. So I delete the 2nd 'If'..Now the first one doesn't work...

My work computer won't allow replies, so I type jibberish on my cell phone, and then edit on my desktop. Go figure. Thanks for the image. I'm slow, I guess! Let me give it a shot. Thanks!

I see the 'IF'. I see the '+'. I click the '+'. It opens and shows all my SetFields. At the bottom right, I see 'Add Else' and I see 'Add Else If'. I have used 'Else If''. When I change multiple fields, using 'Else If', only one change is written to the AuditTable. 'Else' means do instead.

Access 2010

Thanks vbaInet. If you mean the 'Else If' I've tried that and it only writes one field change. ie: If I change the Last Name and the First Name, only the last change writes to a table. Or maybe there is something like a 'GOTO' command that I could put at the end of an 'If' statement.

I got the macros working. So far as 'And If' scenario, when a table field is changed, I want to write to an AuditTable. When one field is change, my macros work great. When two fields, in a record, are changed only the later is written. I need my macros to write both changes.

My macros worked yesterday, now they don't. ???? They work in my other databases, though. Ideas? And I need a suggestion for an And If scenario. If I update one field, the second databases macros work fine. If I update multiple fields, only the first instance writes to a table. Hence...

INSERT INTO EventLog ( [DateTime], UserName, Action ) VALUES '7/2/2014 3:24:51 PM' , mebailey, ' Opened: Customer Report '; Fixed. Dim SQL As String should have been Dim SQL I assume that I was trying to write a DateTime format as a string.

It didn't work. The code is a suggestion that is getting the same error. After looking, I like it better.

What's odd is that, I copied this code from another database. It worked fine. All I did was rearrange the fields. I also had this as a suggestion to paste into the On Open cntrl. I get the same error. ??? Dim sSQL As String Dim sUser As String Dim sForm As String sUser =...