Recent content by dibblermail

Because life, I've just been pulled away from this & onto something else for the rest of the day. I'll send the database home & have a play over the weekend. Thanks for the help so far, much appreciated.

That's not a property I can see, so I assume that's an argument in the code? maybe in the change event for the combobox?

Thanks for the suggestions, I've tried that, but when I set the column width to 0,2 I get an error. I cant set it to 0 because I need limit to list to be No. So I set width to 0.01,2 & it ends up with the ClientID in the box

Please can someone put me out of my misery. This cant be as hard as I'm making it. I've looked at old posts and nothing I've tried from them seems to work, so I'm not understanding something, or I'm looking straight through something. I have a combo box with 1 column in it. But it also pulls...

Got it. No idea how that got changed. Thanks for the helping hand again, Hopefully I'm learning.

Perfect. No Idea why that changed (I don't recall changing it). When would I want it set to Yes. I edited the form & it saves back with No set. I assume I can change the Form's Data Entry property back to Yes on the fly should I need to using VB? (A very quick Google search was inconclusive)

Thought I would simplify by hard coding the JobID to 1 DoCmd.OpenForm "form0_AddEditJob", , , "JobID=1" This is what should have opened... This is what opens...

Nothing that SHOULD affect this. It's being called from a different place & the code written yesterday is part of that call not this one & not part of the form itself (other than 1 text box where the date which is set to now() in the properties of that text box). So If I've broken it I have no...

Sorry, me again. This code was working a few days ago & upon testing it again today it isn't. Yesterdays code was to fill in text boxes for a new record in this same form. So I've broken something, or more likely, I need to be more specific to stop the code going off at a tangent. The code...

I understood the basics, but some on the nuance was new to me. You've just pointed out the difference between Date & Now which I hadn't caught until now. I was trying to control how the date appeared in the text box of a user form. Whilst I was ignoring how it appeared in the back end database...

Thanks for the nudge in the right direction. I just tested your method & its working just fine. I still don't understand why what I was doing was failing, but I have a working solution so that's the important thing

The same form is used to open existing jobs or new jobs. It currently opens an existing job & shows the date the job was created correctly. If I were to set the textbox properties to show todays date at a form level, would that not cause an issue to existing jobs displaying their dates correctly?

The table has DateInitail set as Date/Time with no validations or masks this is set up as back end / Front end databases, in case that has its own potential explanation.

this looks even more like a format issue as the text box is now showing #Name? I'll check the table holding the info & report back

If I use exactly that, it Errors with "Runtime error 438: Object doesn't support this property or method" If I lose the speech marks it strips the parenthesis off leaving me with = Date & the text box shows 00:01:54