Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.19 seconds.
Search: Posts Made By: The_Doc_Man
Forum: Theory and practice of database design Today, 10:23 AM
Replies: 39
Views: 8,083
Posted By The_Doc_Man
Re: Meaningless vs Meaningful Primary Keys

Absolutely true, JDraw... as a pragmatist, I do what is necessary to make it work, staying within the lines as much as possible and straying when the situation demands it.

Which is why I sometimes...
Forum: Politics & Current Events Today, 07:26 AM
Replies: 136
Views: 12,151
Posted By The_Doc_Man
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Your closing sentence says it all, G. Argumentum ad hominem strikes YET AGAIN.

I have honest doubts on the validity of some of those studies. For instance, the infamous "hockey-stick" graph is...
Forum: General Today, 07:09 AM
Replies: 13
Views: 142
Posted By The_Doc_Man
Re: Bug You tried to open a database that is already open by the user 'Admin' on the

I'm with CJ on this one. The message you are getting suggests that Access is running into an exclusive file lock, which might indeed be due to being synchronized with DropBox operations. And I...
Forum: Theory and practice of database design Today, 07:02 AM
Replies: 39
Views: 8,083
Posted By The_Doc_Man
Re: Meaningless vs Meaningful Primary Keys

I'm seeing this as just a multi-field index that isn't the primary key because, for complexity's sake (or perhaps simplicity's sake), you chose a synthetic/autonumber key as the PK.

If course we...
Forum: Politics & Current Events Yesterday, 09:17 PM
Replies: 136
Views: 12,151
Posted By The_Doc_Man
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Greg: In various posts in this thread, you have said:

Post #9: "Perhaps you could rephrase what you are trying to say because, on the face of it, that is a ridiculous statement to make."

Post...
Forum: Theory and practice of database design Yesterday, 12:15 PM
Replies: 39
Views: 8,083
Posted By The_Doc_Man
Re: Meaningless vs Meaningful Primary Keys

Talk about a blast from the past! I remember this discussion. Haven't changed my viewpoint of pragmatism, so haven't changed my viewpoint on the desirability of natural keys when they exist. But...
Forum: Queries 02-14-2019, 08:57 PM
Replies: 7
Views: 139
Posted By The_Doc_Man
Re: Hello from Toronto

Got it - "Current yard status."

I'm going to use short field names for this only because of typing issues.

In/Out status will be IOS. Loaded/Empty status will be LES. Date & Time will be DT. ...
Forum: Modules & VBA 02-14-2019, 02:04 PM
Replies: 6
Views: 132
Posted By The_Doc_Man
Re: Access 16: how to schedule export of table data to a text file daily at specific

I don't have a sample either.

However, one thing to be aware of when using macros - don't forget to include a Quit at the end of the macro.

One thing to be aware of when using Windows Task...
Forum: Introduce Yourself 02-14-2019, 01:58 PM
Replies: 3
Views: 65
Posted By The_Doc_Man
Re: Back making Access databases

Welcome, Nick. A little advice: Pick the most important parts of the work stream first. I started a similar project to support our department of about 35-40 admins (varied over time depending on...
Forum: Introduce Yourself 02-14-2019, 01:55 PM
Replies: 2
Views: 38
Posted By The_Doc_Man
Re: Hello

You are welcome, Victor. It was a blessing for me to find it some years ago when I started with Access. Now, I find satisfaction in passing it forward.
Forum: Modules & VBA 02-14-2019, 06:24 AM
Replies: 10
Views: 188
Posted By The_Doc_Man
Re: Building collection loop efficiency

Like I said, MajP, minimal difference. What was it that P.T. Barnum's barkers used to say in the side-show carnival? "You pays your money and you takes your chances."
Forum: Introduce Yourself 02-14-2019, 06:21 AM
Replies: 3
Views: 65
Posted By The_Doc_Man
Re: Hello

Some things have changed a bit, some things are the same. Access is just a bit pickier (if there is such a word) than it used to be when considering certain operations.
Forum: Queries 02-14-2019, 06:20 AM
Replies: 7
Views: 139
Posted By The_Doc_Man
Re: Hello from Toronto

The part that is a bit confusing and thus is unclear to me - you talk about trailer entry and exit from your truck yard, and I understand that part. My grandson sometimes works as a security guard...
Forum: General 02-13-2019, 02:24 PM
Replies: 3
Views: 78
Posted By The_Doc_Man
Re: Extracting data between two commas

Or, for that matter, use SPLIT to pull the second string out of the implied array:


TheName = Split(TheString)(1)


Note that SPLIT returns its answers as a 0-based array, so the 2nd element...
Forum: Modules & VBA 02-13-2019, 02:18 PM
Replies: 19
Views: 290
Posted By The_Doc_Man
Re: Creating variables out by splitting a string

Again, look at the tail end of the example I posted earlier. It is relevant.
Forum: Introduce Yourself 02-13-2019, 02:17 PM
Replies: 3
Views: 54
Posted By The_Doc_Man
Re: Hello, it's me

Well, Chip, if we are going that way...

How many mystery writers does it take to change a light bulb?

Two. One for the main work and one for the unexpected twist at the end.
Forum: Modules & VBA 02-13-2019, 09:49 AM
Replies: 10
Views: 188
Posted By The_Doc_Man
Re: Building collection loop efficiency

MajP says NO DIFFERENCE, I say MARGINAL DIFFERENCE AT BEST. So in the end analysis, you make your choice and take your chances.
Forum: Introduce Yourself 02-13-2019, 09:46 AM
Replies: 3
Views: 62
Posted By The_Doc_Man
Re: Hello from Las Vegas

Just remember, what happens in Las Vegas stays in Las Vegas - but that only applies to being naughty. Techie questions are not naughty, so you can ask them when you need to.
Forum: Introduce Yourself 02-13-2019, 09:45 AM
Replies: 2
Views: 48
Posted By The_Doc_Man
Re: Hi from London

This is not a bad source for help. The only advice? Give clear descriptions of your problems and be prepared to answer questions to give us supplemental information. The key to getting answers...
Forum: Modules & VBA 02-13-2019, 06:27 AM
Replies: 10
Views: 188
Posted By The_Doc_Man
Re: Building collection loop efficiency

I'm of the opinion that you should make the changes to one collection at a time, though it MIGHT be a marginal speed difference.

I say that because of the "collection probes" required. In...
Forum: Modules & VBA 02-12-2019, 08:21 PM
Replies: 7
Views: 96
Posted By The_Doc_Man
Re: Import spreadsheet into table but....

The least failure-prone way to do this might be to open the spreadsheet first as an Excel Application object and examine the offending column header. If it is blank, you can simply make it not...
Forum: Queries 02-12-2019, 08:13 PM
Replies: 7
Views: 139
Posted By The_Doc_Man
Re: Hello from Toronto

First, in EXCEL you can have headers with special characters, but in Access they are not a good idea. Particularly that ampersand, but the slashes are not good either. To keep from having typing...
Forum: General 02-12-2019, 01:55 PM
Replies: 3
Views: 95
Posted By The_Doc_Man
Re: Split DB Performance Over Network

In general, the larger the geographic scope of your network, the worse it will perform. Not because of literal geography, but because when you are using Ethernet-based networks, there is a distance...
Forum: Introduce Yourself 02-12-2019, 11:46 AM
Replies: 3
Views: 74
Posted By The_Doc_Man
Re: New Member

This site should offer a wealth of information about your problem with non-confirming materials. We are the biggest bunch of non-conformists I've ever seen.
Forum: Modules & VBA 02-12-2019, 07:27 AM
Replies: 19
Views: 290
Posted By The_Doc_Man
Re: Creating variables out by splitting a string

You certainly COULD write a loop and use an array of strings. Or... look at the bottom example in the link below:

https://www.techonthenet.com/access/functions/string/split.php
Showing results 1 to 25 of 500

 
Forum Jump



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