Search results

Debug.Print "Show this message" Will merely print, "Show this message" in the immediate window. It is a very useful tool when trying to debug code. Debug.print strMsg will display whatever strMsg holds. Can't check your db at the moment, still at work, will check later.

Something to try and without any other changes the result should be the same. Run the subform directly (not as a subform). Does the double-click event work? On the same subform, create another textbox control, add a double-click event, code a simple message or a debug.print statement, just...

Yep, I picked up on that just after posting. Damn, forgot to read twice, submit once.

I can't see how in your immediate window you got the result you posted, what I highlighted in red above. (I don't normally use the end of line _ character to continue string building on the following lines, but I assume that is set up correctly.) Did you actually directly copy the result of...

Have you made sure that "Event Procedure" is selected against the relevant textbox control? If it's not selected your double-click event will never be activated, even though you can see and modify the code. Sample image for clarity:

Make sure that "Event Procedure" is selected in the Double Click event property window.

Try the code snippet that The_Doc_Man has supplied, that should see you right.

In the form you are attempting to open, check that the field names are correctly spelt. Does your field name have spaces in it, if so, that is the reason for the brackets surrounding them, if not, brackets are not required. Check your recordsource of the form to be opened, the searched field...

Try this: [Internal Unit Code] = Also, I think you may need to surround your search string in quotes.

Have you checked the docs? I supplied a link in an earlier post, all the information is in there. I haven't got access to Access at the moment but check out 9.

You need to also add the InputMask to the textbox control on the form.

Works for me, dash lines.

There's no inputmasks against any of the fields (in the form) in the db you uploaded. Edit: Add the inputmask to the form field. Also, remove the @ symbol from Format property of the the field. If you leave it there, your "A " part will not be displayed. Edit: Edit: Use the inputmask I...

I agree with the adage 'if it ain't broke don't fix it'. Having said that, you mention that some users are using Apple machines, so you may want to consider cross-platform developing. So, check out Xojo. It's free to download and develop (learn). It compiles to an exe and whatever the...

Depending upon what you want to achieve, if you want to reference your second form on return to your first form, that is possible. While in the second form you set the form to SecondForm.Visble = False, that hides the form and you are returned to the first form. At this point you can then...

Select 'All Access Objects' and make sure the search bar is empty. You should also see a menu item for Macros.

Right click in panel, select 'Navigation Options'. A dialog opens, you'll see a checkbox for 'Show Search Bar'.

In the left hand column, there is a search bar, enter partial element of your query (form, module, table etc) and the list will be accordingly filtered.

We've all been there, not to worry, it was worked out in the end.

I get the same behaviour when selecting the Label control from the Property Window. The Label control does get the focus, but the delete key doesn't work. I have to click back into the form (top menu bar), then the Label control still has the focus and the delete key deletes the Label...