Search results

Hey, now that looks good! Being the pragmatic type, I will try it (esp since the code I have now has caused other problems). THANKS!

Doc Man, thanks for the comments. As I mentioned in my first post, I didn't write the code (IIRC someone on this forum wrote it for me) and being a VBA novice, I don't understand how some of it works. Functionally, its purpose is to simply change the background & foreground colours in text and...

Gizmo, thanks for the assistance. I'm not sure I understand what you are suggesting but I created a blank dbase in 2010 and imported the relevant table, form and vba module into it. I then created a blank dbase in 2013 and performed the same procedure from the just created 2010 dbase. The...

Posted this on Mr Excel/Access forum a while ago with no response so hoping someone here can help. My Access 2010 developed database has a problem when a particular form is switched to Design View from Form View when running under Access 2013. I get an "MS Access has Stopped Working" error...

Re: Performing a spell check on the contents of a userform field Have been experimenting with the spell checker with text in text boxes. It seems to work pretty well but have noticed a couple of quirks. First is when the spell checker is invoked (due to a spelling error), the cursor in that...

I have an embedded macro (in a form) that duplicates/appends the current record displayed by the form and I would like to add a bit of VBA code to the macro (to increment a text box value on the appended form). As I understand it, this can be done by the RunCode macro command in which a Function...

Nigel, thanks much for the explanations and suggestions. I was hoping to find a method that did not require the ribbon and c) is close enough to a good solution.

The records are being displayed as a form (not a subform). Using 2010 BTW. The text filter works as expected with text boxes or combos that are displaying text for the specific record displayed on the form. As I noted in the edit above, specifying `Null` works for text boxes with null values...

Thanks guys for the help but I fear I am not explaining the situation properly (or I am misunderstanding your replies). If one right-clicks on a text or combo box on a form, a pop-up menu appears that gives choices for sorting or filtering on the text or combo contents. One of those options is...

Thanks for that information Pat but I would still like to know how to specify a null field for a filter if anyone can help with that. This would be for occasional use so efficiency is not that important.

Can't figure out the syntax for specifying a null value for a text or combo box when filtering a table via a form. "Is Null" seems to work for query criteria but doesn't work for form controls. If one right-clicks on a form control displaying a null value, one of the choices is "Equals Blank"...

. Pat, I hear what you folks are saying but my users are responsible and intelligent. They know if they screw up the data, they will have to correct it. I think I also mentioned that we keep daily backups which would be useful in that regard. Trouble with generic queries is that we have...

Thanks CJ but I've already checked that the Trusted Locations contains the folder in which the Access files in question (and including my own databases) are stored. I've noticed the icons to the left of the table etc. names in the navigation(?) pane for the problem databases have a blue dot in...

CJ, thanks for responding. I'm not sure where to find the attachment you mentioned but both the programs I have tried (the "Northwind sales web database" and the "Desktop services template") are stored in a trusted folder, along with database files of my own creation (as per "Trust Center...

Thank you for responding to my post. All the users would be doing is using the wizard (only) to create a tabulation of data in "table" form (and maybe print it) containing only the fields wanted and also sorted or filtered to certain field values as required. They would be instructed to...

Tried a couple of questions on the MrExcel forum with no response so far so though I might post them here also. First is: The only way I can figure out how to launch the Query Wizard by a button click is to use a SendKeys macro. I have looked at other macro commands but there does not seem to...

OK, fair 'nuff. Thanks...

So you're cross posting yourself to nag about cross posting - how ironic. I posted the same question to both forums because, in past, I sometimes don't get a reply on any one forum. I apologize if that offends you.

John, it works fine (the first suggestion) and thank you! The reason I'm not using Default Value is that I wish the user to have to actively select contents for the field(s) by clicking or tabbing to it. If they don't do that, it should remain blank. If they do click or tab, they can keep...

I thought this would work but it doesn't - would appreciate any assistance. If one has text boxes or combo boxes on a form and wishes certain text to appear in a box when the box gets focus, how is this done? I have tried placing (for example) ="123" in the On Got Focus property of the box...