Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.52 seconds.
Search: Posts Made By: The_Doc_Man
Forum: Tables Today, 05:41 AM
Replies: 9
Views: 104
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 Today, 05:34 AM
Replies: 10
Views: 83
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 Today, 05:31 AM
Replies: 20
Views: 183
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 Yesterday, 05:22 AM
Replies: 13
Views: 176
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: 176
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: 150
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: 9
Views: 181
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: 83
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,715
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: 100
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: 251
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: 47
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: 174
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: 131
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: 251
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: 92
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: 311
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: 251
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...
Forum: Tables 09-16-2019, 05:51 AM
Replies: 13
Views: 174
Posted By The_Doc_Man
Re: Calculated Field?

In general a calculated field belongs in a query. Your design that uses the initial quantity is almost "right" (acknowledging that "right" is a relative term.) Here is a different way (but only...
Forum: Modules & VBA 09-16-2019, 05:40 AM
Replies: 26
Views: 460
Posted By The_Doc_Man
Re: Import Record count

OK, my error of omission, .Execute works for QueryDef objects too. The only thing I can add to arnelgp's comment is to make the .Execute have parameter dbFailOnError as a parameter, just to give it...
Forum: Theory and practice of database design 09-16-2019, 05:24 AM
Replies: 6
Views: 134
Posted By The_Doc_Man
Re: Position Msgbox

Let's not forget that you CAN manually drag a modal message box to the side to see things if it is covering up something. You just can't do anything underneath it.
Forum: Theory and practice of database design 09-15-2019, 06:15 PM
Replies: 6
Views: 134
Posted By The_Doc_Man
Re: Position Msgbox

The only way to do that is if the message box is NOT modal (which means that other code can run behind it) but it also requires you to find ALL windows (including child windows) to find which one is...
Forum: Tables 09-15-2019, 12:16 PM
Replies: 9
Views: 142
Posted By The_Doc_Man
Re: table problem, field shows #deleted

If it was a query, check the table that was the source of the query. If you can identify the offending record by some key value, you might be able to see something different.
Forum: Modules & VBA 09-15-2019, 12:14 PM
Replies: 26
Views: 460
Posted By The_Doc_Man
Re: Import Record count

Don't know if this will work for this case, but instead of doing a DoCmd.whatever for the append, do a CurrentDB.Execute of the same append query. If that query works in "Execute" context, you can...
Forum: Introduce Yourself 09-15-2019, 12:09 PM
Replies: 4
Views: 75
Posted By The_Doc_Man
Re: Hello

World Peace isn't such a bad goal, Iggy. Welcome.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 06:47 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