Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.34 seconds.
Search: Posts Made By: The_Doc_Man
Forum: Modules & VBA Yesterday, 06:30 PM
Replies: 41
Views: 383
Posted By The_Doc_Man
Re: Populate the name of the active control on focus in a form.

MajP in re post #27. I agree that we are probably looking at two different issues because, let's be honest, it IS a confusing problem.
Forum: Modules & VBA Yesterday, 06:26 PM
Replies: 41
Views: 383
Posted By The_Doc_Man
Re: Populate the name of the active control on focus in a form.

It's a real pain in the toches, but the way I did this to get the effect I think I am seeing was to put code in the GotFocus routine for each control that said, in effect,


[Hint]="Enter the...
Forum: Queries Yesterday, 06:14 PM
Replies: 13
Views: 232
Posted By The_Doc_Man
Re: I a little direction in starting my project

Obviously you thought this was for a business need, but the truth is that you need consistency to manage search such as you described. Whether you are doing this in Access or Excel, you are...
Forum: General Yesterday, 05:45 PM
Replies: 6
Views: 166
Posted By The_Doc_Man
Re: NOTICE TO ALL MEMBERS : Site Issues

No recent problems here.

EDIT: I take that back. Just got a double-post.
Forum: Modules & VBA Yesterday, 10:24 AM
Replies: 41
Views: 383
Posted By The_Doc_Man
Re: Populate the name of the active control on focus in a form.

And what event will run the BE code to do this? Events are governed by actions of, and are in the context of, the FE. When the BE is opened implicitly, it doesn't run events in the same way that it...
Forum: Introduce Yourself Yesterday, 10:19 AM
Replies: 3
Views: 33
Posted By The_Doc_Man
Re: New member

Good luck with that, John. Moving a server usually doesn't stop it from rebooting unless someone wants to play rugby with one of the hard drives. As long as you don't hire "Wreck-It Ralph" as your...
Forum: Modules & VBA Yesterday, 08:29 AM
Replies: 41
Views: 383
Posted By The_Doc_Man
Re: Populate the name of the active control on focus in a form.

But the code you added ALREADY would force you to release a new FE. Basically, there is almost no time (I did say "almost") that you want any code at all in the BE. The ONLY time I ever put code in...
Forum: Tables Yesterday, 05:41 AM
Replies: 10
Views: 119
Posted By The_Doc_Man
Re: Help! Autonumber messed up

Your image doesn't show an unusual set of autonumbers and they are in proper order. Were you expecting them to also be contiguous? Because they won't be. "Contiguous" ISN'T a property of...
Forum: Modules & VBA Yesterday, 05:34 AM
Replies: 10
Views: 104
Posted By The_Doc_Man
Re: Save & new button

By the way, and she is usually pretty cool about this so don't worry about the error, but ... Pat Hartman isn't a "Sir" she's a "Ma'am."
Forum: Modules & VBA Yesterday, 05:31 AM
Replies: 41
Views: 383
Posted By The_Doc_Man
Re: Populate the name of the active control on focus in a form.

Instead of all of this, put something in the "ToolTip" property, so that if you hover over the control, you get a one-line explanation. I understand what you want to do, but because of sub-form...
Forum: Site Suggestions 09-18-2019, 05:22 AM
Replies: 13
Views: 189
Posted By The_Doc_Man
As to the case where it drops you into the...

As to the case where it drops you into the "advanced edit" box, in that mode you can usually see the last post. If you do, just don't edit. Navigate without saving and at least you can avoid the...
Forum: Site Suggestions 09-17-2019, 06:38 PM
Replies: 13
Views: 189
Posted By The_Doc_Man
Another strange site quirk?

I have noticed a couple of users posting twice and I have seen where Access is trying to double-post me. Is something odd going on with the site? Has anyone else noticed this?
Forum: Forms 09-17-2019, 06:36 PM
Replies: 9
[SOLVED] Form won't open
Views: 152
Posted By The_Doc_Man
mpaulbattle: If you have the means to do so,...

mpaulbattle:

If you have the means to do so, create an event table in your database. It needs an autonumber, a date/time field, and a short text field with at least a little bit of room to hold a...
Forum: Queries 09-17-2019, 06:25 PM
Replies: 13
Views: 232
Posted By The_Doc_Man
The question here is, is there any time when the...

The question here is, is there any time when the allocation sheet becomes static. You said they are yearly documents and differ by year number. My question is, if you have one of these documents...
Forum: The Watercooler 09-17-2019, 06:04 PM
Replies: 3
Views: 87
Posted By The_Doc_Man
I would argue that like many other intellectual...

I would argue that like many other intellectual trends, the idea of gender being a social construct is because of attempting to pigeon-hole some things in a way that makes it socially acceptable. ...
Forum: General 09-17-2019, 12:51 PM
Replies: 6
Views: 1,719
Posted By The_Doc_Man
Re: Results of DLookup not showing in Report View, but are visible in Print Preview

adh46, obviously not in this thread, which was six yeas ago. If you need an answer, I suggest you start your own thread and just reference this thread.

I suspect it has to do with whether the...
Forum: Queries 09-17-2019, 12:45 PM
Replies: 7
Views: 104
Posted By The_Doc_Man
Re: Group Mulitple Data Ranges by ID and Plan Code

The question is not clear regarding the start/stop dates. You define date ranges based on two dates. But you are not clear on the selectivity of those date ranges with respect to the other groups...
Forum: Modules & VBA 09-17-2019, 12:38 PM
Replies: 16
Views: 254
Posted By The_Doc_Man
Re: To 'Call' or not to 'Call'

Access is OK even though it has automatic type up-conversion within a statement. The one I don't like is old-style C which requires you to run a pre-compiler to catch datatype issues. Classic C...
Forum: Introduce Yourself 09-17-2019, 12:24 PM
Replies: 2
Views: 49
Posted By The_Doc_Man
Re: Hello! Let Me Introduce Myself

Welcome, Karen. Always happy to have new members with definite projects.

HR systems are always a lot of fun because they get so downright complex what with all of the state and federal...
Forum: Tables 09-17-2019, 06:35 AM
Replies: 13
Views: 178
Posted By The_Doc_Man
Re: Calculated Field?

To be perfectly honest, I've been using Access since Ac 2.0 (we are now above 16.0) and I am STILL learning Access. Don't feel bad, even a little bit, at not knowing something. There was an old...
Forum: Modules & VBA 09-17-2019, 06:28 AM
Replies: 6
Views: 135
Posted By The_Doc_Man
Re: Total beginner lost with VBA and Macros

You are confused because you see a lot of primitive functions but you don't know how they fit together. That's OK, it happened to all of us. I'll give you an "overview" of how we approach what you...
Forum: Modules & VBA 09-17-2019, 05:47 AM
Replies: 16
Views: 254
Posted By The_Doc_Man
Re: To 'Call' or not to 'Call'

Seems to me that NOT using the CALL prefix would be faster because of having fewer characters to type. It wouldn't be much faster to execute. In terms of compiler theory, the only difference...
Forum: Theory and practice of database design 09-17-2019, 05:37 AM
Replies: 6
Views: 98
Posted By The_Doc_Man
Re: Junction table inventory

You have obviously thought about this, but I'll comment on the issue of tracking both kits and their components. What's on the shelf?

That is a rhetorical question of sorts. Your business flow,...
Forum: Modules & VBA 09-16-2019, 07:48 PM
Replies: 18
Views: 316
Posted By The_Doc_Man
Re: Last updated object in a database

Actually I dug this up from a rather circuitous method:

https://access-programmers.co.uk/forums/showthread.php?t=103811

Pat Hartman and I answered a question for a user looking at database...
Forum: Modules & VBA 09-16-2019, 10:09 AM
Replies: 16
Views: 254
Posted By The_Doc_Man
Re: To 'Call' or not to 'Call'

I think I recall a discussion similar to the issues noted by MajP in that linked article. Though it is about VB, a lot of it applies to VBA.

I rarely use CALL myself, but every now and then a...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:50 AM.


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