Search results

Sorry I did a bad job of explaining my last reply. I want the button to be disabled on form open and new record creation. But when I update a certain text field, the button should be enabled. So the way I've set up the button so far, is to become enabled when a new record is created. Once the...

Hello, yes, enable once on each record but not on new record It is a single form

Hi, sorry where am I inserting this particular code?

So I have a particular button that starts as disabled when a New Record is created and also when the form is opened. The button only becomes enabled once a certain text field has been updated. So I added an AfterUpdate event on the text field to enable the button. But obviously doing this means...

Thankyou!

Cheers! That worked out perfectly.

Hello there, in the web browser control I added =[txtFileLocation] in the base URL. So what exactly am I changing here and in the form's open event?

I have a web browser control (wbFile) that will display a file on a form. The control source of the WBC is to a text field (txtFileLocation) that will contain the file location. I have a button (cmdBrowse) that is used as a browse function to open file dialog. I have created what I wanted...

Wow this is very in depth Pat. I was actually after some help with creating User level security but wasn't clear on how to start. Thanks for the extra initiative.

Oh yes I see what you mean, cheers for that!

Thanks for the example Arnel, will go about it like this.

I didn't consider a switchboard form, that's really helpful actually. Thank you sir.

Oh, that's a good idea actually. Thank you kindly!

Just wondering if there is a way to make a database startup with a welcome message box and button to open a certain form. This means there is no form set to default open on startup. Let's say there are only 2 forms for now. Will it be an AutoExec / Macro / VBA thing? Or is there a simpler...

So how do I efficiently proceed with having a timer feature on my form (for the user to see) and that being saved (with my save button) into my table for that record. Using DAO was the only way I knew how. But I know it's not a good way of doing it. Sorry I'm an inexperienced coder.

Hi Pat, so the way I've done it is.. I have the time text fields that are unbound and then I created bound text fields that have the control source going back to those unbound fields. The bound fields are set to not visible in my Form Header. Don't know if that's what you meant, but yeah.

Yeah it does seem quite complex. I might need to make a separate question based on this entirely. Thanks for the food for thought. Much appreciated.

Thanks so much man, this worked!! You've saved me further headache tonight. I did consider the rs.Edit but completely forgot to specify WHERE in my table *facepalm* 😂. And you have a very valid point about the buttons, I will take you up on that and try to work on the other method you suggested...

Hi Gasman, thanks for the humble suggestion. I actually gave your code a go and I see what it's doing. And you have a valid point about the issues of using buttons. I guess that is something I need to think about. I just really liked the idea of a timer that can give me these variable times. But...

Sorry I'm not that advanced at all this. So what exactly does this code do and would that mean I don't have to change anything from my above code? Just add an beforeupdate event? What are you alluding to as created and amended date? Does this give me start and end times? And I also want to...