Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.50 seconds.
Search: Posts Made By: The_Doc_Man
Forum: Queries Yesterday, 09:42 AM
Replies: 6
Views: 89
Posted By The_Doc_Man
Re: Join on substring

Good luck. You are trying to simulate the matching pattern of the human brain which is hard-wired to ASSOCIATIVELY match things almost as a "gestalt" (i.e. parallel, not linear) match. The problem...
Forum: The Watercooler Yesterday, 09:17 AM
Replies: 24
Views: 329
Posted By The_Doc_Man
Re: Song Lyrics

128 TB RAM? I can only think of a couple of reasons for such machines. One would be a really complex, detailed map of the world. The other would be because you wanted to build a virtual RAM drive....
Forum: General Yesterday, 05:42 AM
Replies: 12
Views: 193
Posted By The_Doc_Man
Re: Form with lookup tables

First, that table tblPeopleMachine IS a junction table except that you don't need the PK on it that you have: PeopleMachineID. It is redundant. Instead, the two fields PeopleID and MachineID can...
Forum: Forms 10-15-2018, 10:02 PM
Replies: 9
Views: 106
Posted By The_Doc_Man
Re: How to requery from a form button

Something about your setup sounds odd. June7 is right that normally you would bind the form to an underlying record, in which case Access would take care of business for you.

So ... what's up...
Forum: General 10-15-2018, 02:31 PM
Replies: 15
Views: 364
Posted By The_Doc_Man
Re: Open Report remotely from other database

If the .ACCDE in file B contains data not in file A, you could copy the report to file A and LINK to the tables in file B, then re-point that report's data sources and run the PRINT operation...
Forum: The Watercooler 10-15-2018, 02:25 PM
Replies: 24
Views: 329
Posted By The_Doc_Man
Re: Song Lyrics

I might well be a dinosaur, but my cell phone is an LG 3G model that doesn't have a touch screen, doesn't have a virtual keyboard on-screen, and doesn't have a lot of memory. All it really does is...
Forum: General 10-15-2018, 12:03 PM
Replies: 15
Views: 364
Posted By The_Doc_Man
Re: Open Report remotely from other database

The problem is that most button clicks, if implemented by the form wizards, are defined with Private button_Click... which means that external access to the button click code using VBA to call it is...
Forum: General 10-15-2018, 04:52 AM
Replies: 3
Views: 95
Posted By The_Doc_Man
Re: Unrecognized database format

"Unrecognized database format" is commonly seen when the database has become corrupted.

First, copy your file to a work area. Then attempt to perform a Compact & Repair (C&R) operation on that...
Forum: Introduce Yourself 10-14-2018, 01:10 PM
Replies: 1
Views: 64
Posted By The_Doc_Man
Re: Greetings

Welcome, flump. And don't worry, a lot of us "inherited" someone else's pile of dyspeptic dragon droppings, so we understand the learning curve. That's how I got involved "for real" myself - taking...
Forum: The Watercooler 10-14-2018, 01:08 PM
Replies: 5
Views: 143
Posted By The_Doc_Man
Re: Checking AWF hit Count...

Perhaps UA is less about wheat and more about chaff?
Forum: Queries 10-14-2018, 09:38 AM
Replies: 15
Views: 12,893
Posted By The_Doc_Man
Re: Adding comments into SQL code

Actually, there is - but not in the SQL text. As I described, you can put a description on every named object visible via the Access object navigation panel. But not in the actual object. You put...
Forum: Queries 10-14-2018, 07:10 AM
Replies: 15
Views: 12,893
Posted By The_Doc_Man
Re: Adding comments into SQL code

I checked, and here is the problem. Given the age of the original post, I'm pretty sure that SQL 92 was the standard applicable at that time. Might still be right for ACE but I haven't looked. I...
Forum: The Watercooler 10-14-2018, 06:41 AM
Replies: 24
Views: 329
Posted By The_Doc_Man
Re: Song Lyrics

I have to admit a certain fondness for the sentiments expressed in this song, particularly since I am getting older...

This is All I Ask

https://www.youtube.com/watch?v=rbSsLwGC61I
...
Forum: The Watercooler 10-13-2018, 07:11 AM
Replies: 2,907
Views: 567,968
Posted By The_Doc_Man
Re: What's your best/worst joke?

Gotta love golf jokes!
Forum: General 10-12-2018, 10:27 AM
Replies: 6
Views: 226
Posted By The_Doc_Man
Re: Splitting database

If you are sharing a monolithic database, it has to be in a shared area on a commonly accessible server.

Assumption: For the split case, you are only sharing the back-end with the tables in it. ...
Forum: Modules & VBA 10-12-2018, 06:44 AM
Replies: 22
Views: 311
Posted By The_Doc_Man
Re: Programmatically deleting all records in a table

Perhaps because the "DELETE * FROM whatever;" is treated as SQL, but opening the datasheet view is actually a hidden form. Doing a select all for that form might require something so inelegant as...
Forum: Introduce Yourself 10-12-2018, 06:34 AM
Replies: 4
Views: 145
Posted By The_Doc_Man
Re: New guy on the block

Here you are, 88, and just now learning lessons... such as

"Book learning" doesn't prepare you for the reality of something.

Microsoft books sometimes barely scratch the surface of reality.
...
Forum: Introduce Yourself 10-11-2018, 07:31 PM
Replies: 2
Views: 53
Posted By The_Doc_Man
Re: This is me

sprijohn - with that background, you will have limited trouble with the VBA portion of Access. The GUI portion does a lot for you behind the scenes as a "black box" but the VBA part can be...
Forum: Sports, Health & Fitness 10-11-2018, 11:08 AM
Replies: 130
Views: 36,804
Posted By The_Doc_Man
Re: What do you eat?

My doctor and I don't agree on this fine point.

I say I eat anything.

He says I eat everything.

SUCH a small nuance between those two viewpoints...
Forum: Modules & VBA 10-11-2018, 10:58 AM
Replies: 22
Views: 311
Posted By The_Doc_Man
Re: Programmatically deleting all records in a table

You, Colin, regarding how long it took to repopulate your test table.
Forum: Modules & VBA 10-11-2018, 10:57 AM
Replies: 17
Views: 357
Posted By The_Doc_Man
Re: Error 'Constant Expression Required' For Constant

Understood. Sometimes you have to shrug and walk away. And file the event under "yet another day programming in the Twilight Zone."
Forum: Modules & VBA 10-11-2018, 10:54 AM
Replies: 7
Views: 134
Posted By The_Doc_Man
Re: Run-time Error '3061' Too Few Parameters. Expected 6

Just by way of clarification, to amplify pbaldy's comment:

CurrentDB.Execute takes the named query string AS-IS and passes it to the DB Engine (probably ACE unless you have a version of Access...
Forum: Modules & VBA 10-11-2018, 10:40 AM
Replies: 22
Views: 311
Posted By The_Doc_Man
Re: Programmatically deleting all records in a table

Probably have to repopulate an index? Might go faster if you remove the index, reload the table, and then reassert the index. I know it's not a life-threatening issue, but I recall many times out...
Forum: Modules & VBA 10-11-2018, 10:38 AM
Replies: 17
Views: 357
Posted By The_Doc_Man
Re: Error 'Constant Expression Required' For Constant

I wonder if the problem is that the extra parameter "broke" something. I can't find ShowFile in the object browser but then I might not have the references you do. See if Object Browser finds...
Forum: Modules & VBA 10-11-2018, 05:18 AM
Replies: 17
Views: 357
Posted By The_Doc_Man
Re: Error 'Constant Expression Required' For Constant

Yep, thought so. I cannot tell you WHY, but for some reason you MUST put all constant declarations before any variable declaration and/or any executable code lines. I've seen that before and have...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 12:34 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World