Search results

@June7 Yes; I'm starting to agree. It was just something that I thought might be quite simple to implement. But it's starting to look as if the juice isn't worth the squeeze.

Better than that, here's a copy of the DB

I'm currently playing with some code to deal with plurals in a combo box. So depending on a text box that accepts a numeric value, the combo will show either singular or plural depending on the value in the text box. The code is If Me.Quantity.Value > 1 Then Me.Combo0.ColumnWidths...

Is there an event or a way to detect when a form's native filter button is clicked?

My bad :(

Storing the number as short text and adding the leading zero back on, does the trick. However, I'm still interested on an academic level whether or not this can be achieved using code :unsure:

Thanks that code is a whole lot simpler (y) In answer to your questions; Me.Text21 = Combo11.Column(2) 01234 stored appears as 1234 Single form

Because Access will drop off the leading zero in numeric fields. I'm going to try storing the codes as Short Text which should fix the problem

Yep, the table is formatted to store leading zeros. Yes, the variables are picking up the values I'm expecting

I'm populating an unbound text box from a column in a combo box. This combo is selecting a suburb from a rowsource dependent on the country of origin. For each country, the post code is a fixed numeric length. Each of the tables is formatted to show the leading zero, and this displays just fine...

Well it was AUD 19.99, they had a "Sale" on ;)

Just the one payment (y) It also says full lifetime access

@Pat Hartman possibly, it's been almost two years since I signed up for that course. TBH I was a little surprised when I logged back in and found that I could still access the course material.

Not that I'm aware of

@Pat Hartman , I've just checked, and I still have access to the Udemy course. Also, there are a bunch of PDFs for each unit which you can download for future reference.

Thank you ever so much @arnelgp works a treat 😍 Just had to insert the PtrSafe attribute in a couple of locations

Sorry, it's too big. I suspect the problem lies in this portion of the code; varFileName = tsGetFileFromUser( _ fOpenFile:=True, _ strFilter:=strFilter, _ rlngflags:=lngFlags, _ strInitialDir:="C:\Windows\", _ strDialogTitle:="Find File (Select The File And Click The Open...

I have the following code under a button, which opens the file explorer window, and then moves the selected document to the target file and notes its location in the DB. In 64 bit the file explorer windows does not open and the MsgBox "File selection was canceled.", vbInformation is shown...

Watched the Richard Rost video recommended by jdraw and had it sorted fairly quickly. Thanks to all for their input :love:

Only one user (me) so no biggy :)