Search results

Hi. I have a bit of code that is designed to disable an user from closing the database via the top-right corner "X". Instead they follow the method setup in my own database to Close the Database. I've done this as there are some data that may be left in limbo if the database isn't saved...

Hi Pat Yes I ended up using your sample to create my switchboard. Not too sure what happened with my previous database, but seems like all is fine now that I exported the database to a new one and deleted the old one.

Sorry to bring up this post again, just ran into an issue. So I used this template as a means to create a Switchboard for my database. I made 2 databases. One of them had no issues and works like a charm. The other one which has the exact same Switchboard (but different names for the list box...

Thankyou very much!!

This worked, thankyou very much!

Hi yes, I am a new user to Access. I am here to learn, so everything you experts have to say is always taken as constructive for me. I understand your point about the code belonging in the form's current event as opposed to the button click. Will fix that up. So I'm not looking for the button...

Hey thanks, will try this out.

Hi, I did think of that, but how would I go about writing in the Timer event?

Just really curious. Like I know there is no Sleep/Wait/Pause functions in VBA. But is it possible to maybe try a DoEvents with While loop to delay a button from being enabled? Because say I had the following code which has a button disabled from another event. Say that once I click on New...

Sorry, so I got rid of the entire CreatedBy column that was created earlier and created the one you have asked with User: GetUsername() so there is no criteria specified. When I run the query, it shows me the all the records. What I meant by same thing, was it was showing me the records in the...

Done, but it's doing the same thing. Ok so what I'm understanding from the issue, is that the records can be viewed on the split form after they are made. But when I close the form or database, the splitform shows as blank and the records created are no longer viewable.

Yep that's correct. All of them have my username in the CreatedBy field.

Yep I've now changed my Environ("username") to a module with the WShell.Network code. Declared the function to GetUserName() As String. Specified my text field to = GetUserName(). Tested it and that's working fine with the form. Now I've invoked the query for the record source of the form. The...

So I have a username field on my form (CreatedBy). On the click event of my 'New Record' button, I've written: Private Sub cmdNewRecord_Click() If Me.NewRecord Then Me.CreatedBy = Environ("username") End If End Sub So whenever an user creates a new record, the username field automatically...

How do I define this?

Sounds familiar, but I'm not too accustomed to flags. Is that something to do with the on-dirty event?

Oh ok, so my form's record source is to a table, so how does this work exactly?

Just wondering if there is a way to set permissions or some VBA that will render records viewable and editable only to the user that has created it on the split form? Currently I have it set as a single form. But surely there's a way of doing the above mentioned? My goal is that I don't want...

The button is a start timer. I have the button disabled on Form_Open and will only enable on creating a new record. So I have that part sorted. No issues. I have set button to be only clicked once and then disable after clicked. Then it is re-enabled when a new record is created. I've got this...

Thanks for persisting Arnel, this is almost what I needed. I think I can figure it out from here, but you've pretty much solved my issue. Thankyou!