Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.14 seconds.
Search: Posts Made By: The_Doc_Man
Forum: The Watercooler Today, 11:59 AM
Replies: 35
Views: 507
Posted By The_Doc_Man
Re: Distractions, Distractions, Distractions

My wife hates the tangle, too, but doesn't understand that coiling the wires leads to induction problems in electrical connections and broken cables in fiber connections. Can't tell her there is a...
Forum: Modules & VBA Today, 11:50 AM
Replies: 31
Views: 269
Posted By The_Doc_Man
Re: IsTime Function

The thing about extended properties is that depending on who supplied the software used for your camera, phone, or other image-maker, not all extended properties are equally honored by all software...
Forum: Modules & VBA Today, 06:34 AM
Replies: 16
Views: 202
Posted By The_Doc_Man
Re: Access VBA DAO records need to know ID field

Pat: Confirming the very narrow statement that Access is single-threaded, with a caveat. Access is single-threaded but JET and ACE are not necessarily so. Both of the engines can simultaneously do...
Forum: Modules & VBA Today, 06:22 AM
Replies: 31
Views: 269
Posted By The_Doc_Man
Re: IsTime Function

To answer the question of when images first got computerized, look up the image types on something like Wikipedia. I don't think you CAN care about when the image was taken. You can only care about...
Forum: Tables Today, 06:07 AM
Replies: 3
Views: 76
Posted By The_Doc_Man
Re: Referencing a lookup field in a separate table in Lookup field

Although it seemed like a good idea at the time, the "lookup field" where you have a field that "contains" multiple values based on some internal index has proved to be very bad in complex...
Forum: General Today, 06:00 AM
Replies: 27
Views: 252
Posted By The_Doc_Man
Re: MSOUTL.OLB Version 9.4 missing

Another issue with Outlook is that you might have two versions installed but can only use one of them at a time. If you attempt to launch Outlook and one is already running, the second launch WILL...
Forum: The Watercooler Yesterday, 02:52 PM
Replies: 9
Views: 220
Posted By The_Doc_Man
Re: What would this TURF war look like?

The only sporting case that I recall offhand is tennis player Renee Richards (formerly Richard Raskin or a similar last name). She was very tall, which makes for serving and overhead slamming...
Forum: The Watercooler Yesterday, 02:40 PM
Replies: 35
Views: 507
Posted By The_Doc_Man
Re: Distractions, Distractions, Distractions

By any chance was that an LCD TV? Or an LCD-over-LED? Because my 13-year-old Sony 3LDO (an LCD projection system) was giving me a cluster of blue stars in one section (middle and slightly left of...
Forum: The Watercooler Yesterday, 05:27 AM
Replies: 35
Views: 507
Posted By The_Doc_Man
Re: Distractions, Distractions, Distractions

That nail gun keeps driving in the nails. The PC shop confirmed that the brand-new SSD died. I looked it up: SSDs fail during their warranty period at a rate of 0.3% overall, and apparently with...
Forum: General Yesterday, 05:20 AM
Replies: 4
Views: 90
Posted By The_Doc_Man
Re: Combobox hide values already in table

If this is a value list combo box, it wouldn't take much to empty it. If the combo box gets its values from a table of possible values, you could define the .RowSource query that drives the combo...
Forum: General Yesterday, 05:06 AM
Replies: 23
Views: 260
Posted By The_Doc_Man
Re: Calculate the age

A couple of comments...

First, you could fix this with two lines of code.

At the top of the routine among the other declarations, add

Dim Age as String

Just before the End Sub, add
Forum: Queries 10-17-2019, 06:06 AM
Replies: 36
Views: 479
Posted By The_Doc_Man
Re: Appending an auto-increment date to a Query

Question: Suppose that a person misses being in this list? I see your list of 11 people - but what happens if somehow Walter was also supposed to be there but wasn't put in.

Question: I noticed...
Forum: General 10-17-2019, 05:41 AM
Replies: 23
Views: 260
Posted By The_Doc_Man
Re: Calculate the age

If you write a function in a general module and make it public, you can call that function from a query as part of the SELECT field-list clause. The function takes the place of a field. A function...
Forum: General 10-16-2019, 09:08 PM
Replies: 23
Views: 260
Posted By The_Doc_Man
Re: Calculate the age

The question is how you will use it. Making a date data type hold exactly some specific number of years, months, and days will be trivial. The question will always be "so now you have this value......
Forum: General 10-16-2019, 08:48 PM
Replies: 6
Views: 111
Posted By The_Doc_Man
Re: Set Recordset = Nothing

There is a matter of style to consider. Where it is feasible, you should always close objects (when done with them) in the same scope from which they were opened. This would be an issue of...
Forum: Queries 10-16-2019, 08:11 AM
Replies: 9
Views: 108
Posted By The_Doc_Man
Re: uncombine string

I'm not clear on something. Are you saying that what was stored as a single string was stored by concatenating something, and that now you want to undo that concatenation? And you really just want...
Forum: General 10-16-2019, 07:57 AM
Replies: 4
Views: 84
Posted By The_Doc_Man
Re: Error "The record source '|' specified on this form or report does not exist"

The PIPE character or vertical bar is an indicator that one of the fields you named in a query isn't in the indicated location. It CAN be as simple as spelling the field name wrong or by using a...
Forum: Tables 10-16-2019, 05:59 AM
Replies: 3
Views: 95
Posted By The_Doc_Man
Re: Multi-value lookup field

CJ's advice is good. If you want to find more about this idea, look up "JUNCTION TABLE" on this forum as a way to implement a many-to-many JOIN. You have many companies and many activities, and...
Forum: Politics & Current Events 10-16-2019, 05:45 AM
Replies: 7
Views: 113
Posted By The_Doc_Man
Re: Hong Kong Protest

One could hope that a moderate candidate might emerge from all of this. The "socialized services" crowd always forgets the greatest weakness of socialism - that it fails when they run out of someone...
Forum: Politics & Current Events 10-15-2019, 07:30 PM
Replies: 531
Views: 27,427
Posted By The_Doc_Man
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

As I understand it, ANY slow crystallization will have that "purification" effect. It is how we make "pure cane sugar" in the deep South. Crush the sap out of sugar cane, heat it to a boil, and...
Forum: Politics & Current Events 10-15-2019, 07:22 PM
Replies: 12
Views: 216
Posted By The_Doc_Man
Re: Confused: Trump/Biden/Ukraine

True, but needs to be put in context. If we had elected the bitchy president, things could have been worse for some of us. Col, our biggest nightmare is that election in which NONE of the...
Forum: Politics & Current Events 10-15-2019, 07:14 PM
Replies: 7
Views: 113
Posted By The_Doc_Man
Re: Hong Kong Protest

I have given up trying to predict what those lunatics will try to do. I'll wait and find a few news reports to tell me who said what.
Forum: Politics & Current Events 10-15-2019, 07:11 PM
Replies: 531
Views: 27,427
Posted By The_Doc_Man
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

You are correct. This is also how you make super-pure metals, in a technique called "zone refining." You should be able to find that on the net so I'll summarize. In essence, the entropic forces...
Forum: Macros 10-15-2019, 06:49 PM
Replies: 8
Views: 114
Posted By The_Doc_Man
Re: How much of a performance impact does declaring variables / passing arguments hav

Colin, is your reference in post #7 the one you intended?

I interpreted the question as having to do with argument passage in a more traditional subroutine setting. I agree and understand why...
Forum: Macros 10-15-2019, 11:38 AM
Replies: 8
Views: 114
Posted By The_Doc_Man
Re: How much of a performance impact does declaring variables / passing arguments hav

OK, up front let's be clear. We cannot see the code built by Access to do the things you have asked about. There is no "show compiled code" option.

HOWEVER, if you had a true compiler that...
Showing results 1 to 25 of 500

 
Forum Jump



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