Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: essaytee
Forum: General 05-15-2019, 08:22 PM
Replies: 26
Views: 458
Posted By essaytee
Re: Run-time Syntax Error

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...
Forum: General 05-15-2019, 07:00 PM
Replies: 26
Views: 458
Posted By essaytee
Re: Run-time Syntax Error

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...
Forum: Modules & VBA 05-15-2019, 02:55 PM
Replies: 23
[SOLVED] ListBox VBA
Views: 591
Posted By essaytee
Re: ListBox VBA

Yep, I picked up on that just after posting. Damn, forgot to read twice, submit once.
Forum: Modules & VBA 05-15-2019, 02:38 PM
Replies: 23
[SOLVED] ListBox VBA
Views: 591
Posted By essaytee
Re: ListBox VBA

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...
Forum: General 05-15-2019, 04:07 AM
Replies: 26
Views: 458
Posted By essaytee
Re: Run-time Syntax Error

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...
Forum: General 05-14-2019, 12:20 AM
Replies: 26
Views: 458
Posted By essaytee
Re: Run-time Syntax Error

Make sure that "Event Procedure" is selected in the Double Click event property window.
Forum: General 05-13-2019, 07:40 PM
Replies: 26
Views: 458
Posted By essaytee
Re: Run-time Syntax Error

Try the code snippet that The_Doc_Man has supplied, that should see you right.
Forum: General 05-13-2019, 06:57 PM
Replies: 26
Views: 458
Posted By essaytee
Re: Run-time Syntax Error

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,...
Forum: General 05-13-2019, 06:45 PM
Replies: 26
Views: 458
Posted By essaytee
Re: Run-time Syntax Error

Try this:
[Internal Unit Code] =
Also, I think you may need to surround your search string in quotes.
Forum: Forms 05-12-2019, 02:50 PM
Replies: 15
Views: 335
Posted By essaytee
Re: validate in access 16, to start with a specific character

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.
Forum: Forms 05-12-2019, 05:29 AM
Replies: 15
Views: 335
Posted By essaytee
Re: validate in access 16, to start with a specific character

You need to also add the InputMask to the textbox control on the form.
Forum: Forms 05-12-2019, 03:31 AM
Replies: 4
Views: 119
Posted By essaytee
Re: en/em dash

Works for me, dash lines.
Forum: Forms 05-12-2019, 03:04 AM
Replies: 15
Views: 335
Posted By essaytee
Re: validate in access 16, to start with a specific character

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. ...
Forum: General 05-07-2019, 03:09 AM
Replies: 8
Views: 307
Posted By essaytee
Re: Access as a front-end only (replace? with what?)

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...
Forum: Modules & VBA 04-30-2019, 12:26 PM
Replies: 12
Views: 207
Posted By essaytee
Re: Open certain forms based on cbo value

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 =...
Forum: General 04-29-2019, 07:59 PM
Replies: 2
Views: 119
Posted By essaytee
Re: LH Column of tables, queries etc

Select 'All Access Objects' and make sure the search bar is empty. You should also see a menu item for Macros.
Forum: General 04-28-2019, 08:24 PM
Replies: 4
Views: 131
Posted By essaytee
Re: Finding things

Right click in panel, select 'Navigation Options'. A dialog opens, you'll see a checkbox for 'Show Search Bar'.
Forum: General 04-28-2019, 08:09 PM
Replies: 4
Views: 131
Posted By essaytee
Re: Finding things

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.
Forum: Forms 04-28-2019, 08:04 PM
Replies: 8
Views: 135
Posted By essaytee
Re: How to remove Label stuck to Text box?

We've all been there, not to worry, it was worked out in the end.
Forum: Forms 04-28-2019, 07:37 PM
Replies: 8
Views: 135
Posted By essaytee
Re: How to remove Label stuck to Text box?

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...
Forum: Forms 04-28-2019, 07:23 PM
Replies: 13
Views: 209
Posted By essaytee
Re: Switching subforms within forms

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...
Forum: Forms 04-28-2019, 03:43 PM
Replies: 13
Views: 209
Posted By essaytee
Re: Switching subforms within forms

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...
Forum: Forms 04-28-2019, 02:52 PM
Replies: 13
Views: 209
Posted By essaytee
Re: Switching subforms within forms

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...
Forum: Tables 04-28-2019, 02:25 PM
Replies: 5
Views: 223
Posted By essaytee
Re: IDs in Lookup tables

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...
Forum: Forms 04-28-2019, 02:35 AM
Replies: 22
Views: 299
Posted By essaytee
Re: count records in search from

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...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 12:30 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World