Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.44 seconds.
Search: Posts Made By: The_Doc_Man
Forum: General Today, 01:51 PM
Replies: 4
Views: 94
Posted By The_Doc_Man
Re: Every Growing Database and Compact doesn't work

Something is being appended WITHOUT being deleted. By any chance, do you have anything that does OLE operations? Importing an object? Using an attachment field (and then actually attaching...
Forum: General Today, 01:47 PM
Replies: 4
Views: 4,217
Posted By The_Doc_Man
Re: !!!!!WINDOW SIZE & POSITION!!!!!

Good and totally relevant post, Adam, but you might have noted the date of the last action on the post before your contribution. A 14-year-old post that hadn't been "bumped" for a long time might be...
Forum: Tables Today, 01:41 PM
Replies: 11
Views: 104
Posted By The_Doc_Man
Re: Lookup Fields are evil? Or is this ok? Need a little guidance

I'm going to clarify one fine point. June7's advice about "<something> is available by association with <something else>" was indeed accurate. She was explaining something to do with table...
Forum: Modules & VBA Today, 01:29 PM
Replies: 12
Views: 158
Posted By The_Doc_Man
Re: VBA Help

This is a marginally different statement than you gave us before. From the description here, you don't want to know on which visit the person is eligible. You want to know on the current visit that...
Forum: Modules & VBA Today, 01:22 PM
Replies: 4
Views: 68
Posted By The_Doc_Man
Re: Copyeng folders to another Directory

Adam, that was theDBguy's suggestion. You do that with a shell script.

But you are quite right. A single XCopy command might be all that is required.
Forum: Politics & Current Events Today, 01:20 PM
Replies: 7
Views: 63
Posted By The_Doc_Man
Re: will trump really be impeached?

The question of whether he will be impeached is meaningless. The question is, will he be convicted on the articles brought forth?

On that, I think the answer is NO. Remember, the House has a...
Forum: Site Suggestions Today, 01:18 PM
Replies: 23
Views: 226
Posted By The_Doc_Man
Re: session timeout

Ah, that's interesting. Check to see the timeout settings on each of your internet zones. They can differ.
Forum: The Watercooler Today, 09:05 AM
Replies: 22
Views: 318
Posted By The_Doc_Man
Re: Is OOP actually useful?

MajP, since I am somewhat inexperienced in deep use of OOP, I would have to defer to your opinion.

Having said that, I will state with absolute certainty that in a strongly-typed language (take...
Forum: Modules & VBA Today, 06:34 AM
Replies: 4
Views: 68
Posted By The_Doc_Man
Re: Copyeng folders to another Directory

While I agree with theDBguy, let me point you to an article that might help you.

https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/filesystemobject-object

From...
Forum: Modules & VBA Today, 06:27 AM
Replies: 12
Views: 158
Posted By The_Doc_Man
Re: VBA Help

OK, here are PARTs of the issue.

IF both DOB and Visitn are DATE variables or DATE fields, then their values are computed in DAYS (not years). So your formula would work if the visit occurred on...
Forum: Introduce Yourself Today, 06:04 AM
Replies: 2
Views: 34
Posted By The_Doc_Man
Re: Hello

Hello, Unni Nair, and welcome. I had to look it up, but I see you are from the southwestern coast of India. I hope you weren't too badly affected by the August flooding.
Forum: Introduce Yourself Today, 06:01 AM
Replies: 2
Views: 33
Posted By The_Doc_Man
Re: hey everybody

Welcome, Roy
Forum: Introduce Yourself Today, 06:00 AM
Replies: 4
Hey
Views: 40
Posted By The_Doc_Man
Re: Hey

Hello, Petr, and welcome. But let me correct you on a minor point. Access is not tricky. Learning to switch your thought processes from Excel to Access is tricky.

It is sort of like the...
Forum: The Watercooler Today, 05:55 AM
Replies: 22
Views: 318
Posted By The_Doc_Man
Re: Is OOP actually useful?

I think that perhaps a part of the issue is that VBA is only pseudo-compiled into an intermediate code that isn't directly executable. Perhaps the polymorphism doesn't work quite right in an...
Forum: Site Suggestions Today, 05:42 AM
Replies: 23
Views: 534
Posted By The_Doc_Man
Re: Another strange site quirk?

Adam: I got that error last night on both of Jon's forums. But it has (obviously) cleared up this morning. Part of the problem, I think, is that Jon moved things to another server some time ago...
Forum: Queries Yesterday, 10:59 AM
Replies: 22
Views: 264
Posted By The_Doc_Man
Re: Chicken and Egg situation, which comes first?

SELECT
tblType.Type,
IIf([qrySummaryPrevWeekly].[Vehicle Received Previous Week] Is Null,0,
[qrySummaryPrevWeekly].[Vehicle Received Previous Week]) AS [Received PW],
...
Forum: Forms Yesterday, 10:29 AM
Replies: 8
Views: 127
Posted By The_Doc_Man
Re: Draw on a form?

Ahmed_Optom:

Part of the problem is that the Access form builder will not allow drawing. It isn't an easel, it is a BACKGROUND. If you haven't thought about it before, here is the way that...
Forum: The Watercooler Yesterday, 10:14 AM
Replies: 12
Views: 137
Posted By The_Doc_Man
Re: navigational software

But I carry a flip-phone with the really old-style keypad where you have to hit the same key a few times to cycle through the letters. And as to smart phones, (a) I don't trust them with my personal...
Forum: Politics & Current Events Yesterday, 06:40 AM
Replies: 615
Views: 30,488
Posted By The_Doc_Man
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

I once met Al Hirt when he and his 4th wife went on a riverboat cruise and my wife and I were on the same cruise. He was a nice guy, just couldn't keep wives happy. Al played the "Green Hornet"...
Forum: The Watercooler Yesterday, 06:28 AM
Replies: 12
Views: 137
Posted By The_Doc_Man
Re: navigational software

If I know ahead of time that I am going to a new area in the USA, while still home I call up Google Maps and study the area. Where possible, I drop down to street view so that I might recognize...
Forum: Introduce Yourself Yesterday, 06:23 AM
Replies: 4
Views: 78
Posted By The_Doc_Man
Re: Hi from Switzerland

Hello, Moritz. Glad you came in.
Forum: General 11-11-2019, 08:38 PM
Replies: 20
Views: 263
Posted By The_Doc_Man
Re: Moving Access Database to OneDrive

Typical management viewpoint - from someone who doesn't understand that the cloud is a "one size fits all" solution to a wildly variant world. In my 40+ year career, I have NEVER seen any manager...
Forum: General 11-11-2019, 08:33 PM
Replies: 8
Views: 173
Posted By The_Doc_Man
Re: Random problem

Ah, yes... Access gives you the ability to use so many different events that it is MARVELOUS - except that sometimes it can be as confusing as an art nouveau movie. Picking the right event can be...
Forum: Tables 11-11-2019, 08:27 PM
Replies: 16
Views: 305
Posted By The_Doc_Man
Re: what's the best backend for a split DB?

Sherlock himself dawdled with opiods. See "The Seven Percent Solution."
Forum: Tables 11-11-2019, 08:26 PM
Replies: 10
Views: 146
Posted By The_Doc_Man
Re: Design of table structures

Thanks for the vote of confidence, MickJay.

Charlie G.>> Be sure to take the time to write down a list of things you expect to get out from this app, whatever it turns out to be. I.e. be sure to...
Showing results 1 to 25 of 500

 
Forum Jump



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