Search results

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...

It's 4.15 am in the UK, so I suppose all my UK friends are sleeping, so I'll add my two bits in regarding Uncle Gizmo's example. I think what @Uncle Gizmo is suggesting (suck it up) is import the code and try it out (if that's not what he's suggesting I'm sure he'll correct me). That 32,768...

Yes, in design mode, it can appear to be a bit of a mess. Another consideration is the use of a Tab Control, in your case 5 page tab control, each page containing a subform. In design mode it will appear tidier, but that is not the reason to adopt the Tab Control approach, who cares what...

My initial thoughts are to include in your main form all the subforms required, I'm assuming not that many. Anyway, from your combobox when selecting an entry, make visible the relevant subform and hide all the others, this would be done from the AfterUpdate event of your combobox. I would...

What @theDBguy said. OP, in your situation I would still have Lookup tables but I would not refer to their PrimaryKeys but to the actual values. This has a side benefit of not needing to include the Lookup tables in other queries, the data is contained in the main table. Simplifies things...

I'm not really sure what the OP wanted help on, as he didn't offer any further explanation to your earlier questions. I merely assumed dcount, provided an example and was waiting for a response from the OP, which may have elicited further information. Admittedly, I didn't check the actual...

Damn, you are right. I obviously did not test the last test.

@JHB - you hadn't posted when I started. It took me 15 mins just to download db, check form, confirm dcount, but actually took me longer to compose and submit post.