Recent content by ronymaxwell

monbois, thanks for your solution. I have a list box with a number of strings in it, clicking on one causes it to appear in a text box. This is as a short cut for the user whn typing into the text box. I needed the user to be able to continue typing without interruption. Your simple piece of...

That came up when I loaded it as an .mdb file, ie, not updated to 2010. A message said MS Access no longer supports User Level Security. Then that wouldn't work either. Was perhaps MySysAccessObjects something used by older versions of Access, as it looks like a system file or table?

It won't update to Access 2010. An error message says 'The Microsoft Access database engine cannot find the input table or query MySysAccessObjects. (Stefan is retired and doesn't respond to emails so I can't ask him.)

There is a solution on his site, thanks, Dave. It's in an old version of Access so I'm going to have a look how he did it and try to reproduce it. (It won't upgrade to Access 2010 as it employs user level security which is no longer supported.)

I have an Image control on a form which I want to examine programatically. It seems there used to be a way of doing it using Point and PSet from info I have seen online. Is this contained in any of the libraries available under References in Access and if so which one please.

I have managed to solve it. Those 3 fields in the table were formatted '@'. This seems to cause the forecolor to revert to black. Strange, but it works okay with the formatting removed. Stranger still, I'm sure I didn't add the formatting.

I have a listbox with a blue background and forecolor set to yellow. It has 6 columns, the first one hidden. The rowsource is set in code using a query. Only the 3rd and 4th visible columns appear in yellow as they should. The other 3 are black. I tried setting the forecolor in code as well, it...

Thank you, Smig. That works perfectly.

I have code attached to a command button to fill a Combo Box with data from a music collection. A letter of the alphabet is entered into a Text Box then records beginning with that letter are copied from a table, either by Artist or Title. They are saved to a temporary table at which time they...

I have tried it out and disabling the control does work. It stops the icons appearing but I can still change the picture using the command buttons I've added. Perfect. Thanks, missinglinq.

It's that easy? Thank you. I did consider that but thought I wouldn't then be able to use the control at all. Thanks missinglinq.

When a user clicks an attachment control, three small controls appear for manipulating records. I don't want the built in controls to be used. I have command buttons already coded to do what I want which work fine. How do I stop the built in controls appearing when the user clicks the...

jdraw, thank you very much for that. It works great. I have looked at the code and there is stuff for me to learn there, using 'Like' for instance. I used to use recordsets a lot at one time but Access 2010 doesn't seem to like them.

The database will not save in .mdb format so I've reproduced the form, table and code.

fWord is a field name from the table WORDLIST I compile crosswords which friends and family have a go at. I have a list of words in a table which I want to search using wildcards. For instance, if I have a space in my puzzle that needs a seven letter word with particular letters in particular...