Search results

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.

From my immediate window, from your db: ? DCount("[Lab]","DevicesTbl", "Lab = 'Lab-A' AND device = 'LCD'") 3 Enter the above code in the control source of the relevant text box, image below: This should give you an idea how to configure your other counts. Also check out this link for...

No problems, I thought you would.

Do a Debug.print of your SQL variable and post here. Your screenshot does not show the entire creation of your SQL query. I haven't analysed it for syntax errors at this point in time.