Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 1.05 seconds.
Search: Posts Made By: The_Doc_Man
Forum: Queries Today, 04:32 AM
Replies: 8
Views: 91
Posted By The_Doc_Man
Re: How to stop field from calculating beyond the query it's in

Ah, missed that one, CJ. It was buried in a complex query. Good catch.
Forum: Queries Yesterday, 09:54 PM
Replies: 8
Views: 91
Posted By The_Doc_Man
Re: How to stop field from calculating beyond the query it's in

Hmmm - what you posted SHOULD have worked correctly because it appears you correctly layered it. Before, I didn't know how you had done the JOIN - but this doesn't look wrong.

By "layering" it, I...
Forum: The Watercooler Yesterday, 09:35 PM
Replies: 10
Views: 119
Posted By The_Doc_Man
Re: Depth of Sink Hole

Dick, you are welcome to visit any time. That little joint we tried is one of literally a thousand places in the greater New Orleans area where you can get quite decent food. Heck, I can't go there...
Forum: Queries Yesterday, 06:36 PM
Replies: 3
Views: 47
Posted By The_Doc_Man
Re: Sum of a field defined by query expression

First thing to do would be to open the query that shows you "ExtendedPrice" and verify that you have no nulls or #error in THAT column. Because what is going on is that some error is propagating...
Forum: The Watercooler Yesterday, 06:29 PM
Replies: 10
Views: 119
Posted By The_Doc_Man
Re: Depth of Sink Hole

Guess it could be worse. If you lived in south Louisiana in Bayou Corne, THAT sinkhole swallowed a whole small community.

https://en.wikipedia.org/wiki/Bayou_Corne_sinkhole
...
Forum: General Yesterday, 03:25 PM
Replies: 11
Views: 118
Posted By The_Doc_Man
Re: Nz function - error "undefined function"

First, Jiri's directions are good.

To add to Jiri's comments, note this fact: The references of which we speak are pointers to function, subroutine, symbol, and text libraries that define things...
Forum: General Yesterday, 03:04 PM
Replies: 9
Views: 99
Posted By The_Doc_Man
Re: Frustrated....dec 2 hex

Is the boss savvy enough to catch that the decimal is stored but the hex only exists in a query? You can (truthfully) tell the boss that Access works better when things are driven off of a query. ...
Forum: General Yesterday, 02:59 PM
Replies: 11
Views: 110
Posted By The_Doc_Man
Re: table design parts drawing revisions and suppliers

Remember, I might be wrong, too, because in this discussion, only YOU really know the business model. Always, always, always take ANY advice you get here as coming from the outside looking in. We...
Forum: The Watercooler Yesterday, 02:51 PM
Replies: 10
Views: 119
Posted By The_Doc_Man
Re: Depth of Sink Hole

IF you have a golfing buddy who has a visual range-finder and you can see the bottom of the hole at noon, you could get an approximation.
Forum: Introduce Yourself Yesterday, 02:49 PM
Replies: 2
Views: 33
Posted By The_Doc_Man
Re: Hello from Wyo

Deep dive or shallow, everyone is welcome in the pool.
Forum: Modules & VBA Yesterday, 09:39 AM
Replies: 18
[SOLVED] Record.AddNew
Views: 262
Posted By The_Doc_Man
Re: Record.AddNew

If this [Cert] field is displayed via ListBox, the fields of the listbox are READ-ONLY. You CANNOT update them on-the-fly. You have to directly update the underlying .RowSource and then .Requery...
Forum: Modules & VBA Yesterday, 09:27 AM
Replies: 7
Views: 88
Posted By The_Doc_Man
Re: Find Record Count during transaction

To amplify DBG's absolutely correct statement, when using D-anything() functions, they imply a separate query through a private recordset (private to the function code of the domain aggregate). If a...
Forum: Introduce Yourself Yesterday, 09:22 AM
Replies: 3
Views: 39
Posted By The_Doc_Man
Re: Hello everyone!

First, welcome, sifuhall.

Second,



It ain't the programs - it's the environment that anytime someone builds a better mousetrap, better mice come your way.
Forum: General 05-21-2019, 02:54 PM
Replies: 10
Views: 154
Posted By The_Doc_Man
Re: Is this Obtainable in MS Access?

Fairly easy, but we need more info. We need to know some specifics.

There is ALWAYS the brute-force method of defining forty text boxes in a grid and then manually loading the form in the...
Forum: General 05-21-2019, 02:48 PM
Replies: 11
Views: 110
Posted By The_Doc_Man
Re: table design parts drawing revisions and suppliers

I would step into this more, but the others have already steered you in the right direction. This is just a case of "purity of entity." You determine where something goes by purity of definition. ...
Forum: Modules & VBA 05-21-2019, 02:39 PM
Replies: 5
Views: 100
Posted By The_Doc_Man
Re: VBA Code Not Recognizing subform property

EFJK - it happens now and then that you run afoul of the complex syntax Access needs to use to find something. Here's a quick and (very) dirty thumbnail for what appears to be your case.

Me as a...
Forum: Modules & VBA 05-21-2019, 02:05 PM
Replies: 10
Views: 120
Posted By The_Doc_Man
Re: Run-time Error 424

I concur with Linq that the form has to be open. I don't think visibility is a factor, but Class modules do not fully honor the PUBLIC attribute of a declaration. It might be called PUBLIC but it...
Forum: Modules & VBA 05-21-2019, 01:43 PM
Replies: 18
[SOLVED] Record.AddNew
Views: 262
Posted By The_Doc_Man
Re: Record.AddNew

When you say "to no avail" - you do yourself a disservice. What happens that avails you nothing? Do you get an error message? Does Access crash on you? Does Windows crash on you? Do you get a...
Forum: Introduce Yourself 05-21-2019, 01:35 PM
Replies: 2
Views: 51
Posted By The_Doc_Man
Re: First Post

Glad you came, Southardde - new folks are always welcome.
Forum: General 05-21-2019, 05:29 AM
Replies: 18
Views: 240
Posted By The_Doc_Man
Re: Sample DB like Northwind that is intuitive

When you take this particular garden path you are about to explore, ALWAYS keep two simple ideas in mind.

1. Every business-tracking database depends on having FULL KNOWLEDGE of the formal...
Forum: Queries 05-21-2019, 05:19 AM
Replies: 8
Views: 91
Posted By The_Doc_Man
Re: How to stop field from calculating beyond the query it's in

Your problem is "order of execution" of SQL. This link MIGHT give you problems because its certificate may have expired, but it explains things pretty well and my anti-virus didn't barf on the...
Forum: Modules & VBA 05-20-2019, 07:17 PM
Replies: 10
Views: 99
Posted By The_Doc_Man
Re: Make form control value required with VBA

The function difference between a test for Null and using NZ is that NZ allows you to "kill two birds with one stone."

Ask yourself this question: If you test for something using If xxx Is Null,...
Forum: Theory and practice of database design 05-20-2019, 02:15 PM
Replies: 21
Views: 317
Posted By The_Doc_Man
Re: Normalization - Qs about junction tables and booleans.

With no shade being thrown in ANY direction, it is not uncommon for folks accustomed to using flat files including basic EXCEL to suddenly realize that more than two dimensions are possible in a...
Forum: Theory and practice of database design 05-20-2019, 12:04 PM
Replies: 21
Views: 317
Posted By The_Doc_Man
Re: Normalization - Qs about junction tables and booleans.

Actually, not unexpected. Queries get complex so tables don't have to.
Forum: Introduce Yourself 05-20-2019, 12:00 PM
Replies: 4
Views: 49
Posted By The_Doc_Man
Re: Hello world

Welcome, TMBIT. Regardless of why you are here, we are glad to add another voice to the chorus - or the chaos, as applicable.
Showing results 1 to 25 of 500

 
Forum Jump



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