Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.22 seconds.
Search: Posts Made By: The_Doc_Man
Forum: Queries Today, 10:20 AM
Replies: 5
Views: 46
Posted By The_Doc_Man
Re: Dsum not giving expected results.

Also, just on the practical side, you would have to type less AND clarify the exact intent of the comparison if you used


tamount = DSum( "[InvTotal]", "tblsalesinvoice", "[InvDate] Between #" &...
Forum: Tables Today, 10:14 AM
Replies: 5
Views: 88
Posted By The_Doc_Man
Re: Problem in conversation of date

I'm going to add my two cents into the consensus here and say, in the table keep the two fields separate. In a query, you can concatenate strings safely and almost never know the difference, because...
Forum: Tables Today, 09:53 AM
Replies: 15
Views: 304
Posted By The_Doc_Man
Re: Exporting tables to CSV - unparsable records

Adding to Cronk's comments - if you do that export and DID have a corrupt object, I believe Access would report errors in attempting to do the import AND it would name the specific object that...
Forum: Politics & Current Events Today, 09:44 AM
Replies: 30
Views: 430
Posted By The_Doc_Man
Re: Social Media Platforms and Campaign Ads

Adam, now and then we might disagree on some minor things. On this one, we are in VERY close alignment. My take is that she is a definite whack-job, or as us old curmudgeons used to say,...
Forum: Modules & VBA Today, 07:30 AM
Replies: 23
Views: 213
Posted By The_Doc_Man
Re: Getrows

I'm confused over your expectations here. GetRows will ALWAYS return two dimensions because a recordset is always potentially two dimensional. The mere fact that you only have one field doesn't...
Forum: The Watercooler Today, 06:58 AM
Replies: 29
Views: 367
Posted By The_Doc_Man
Re: we seem to be getting more visitors lately....

I've heard many variations, Micron. The implication either way is that you can ask but it is possible that what you requested wasn't in your own best interests.
Forum: Introduce Yourself Today, 06:56 AM
Replies: 2
Views: 47
Posted By The_Doc_Man
Re: Hello

Hello, fertooos. New folks are always welcome.
Forum: Introduce Yourself Today, 06:55 AM
Replies: 4
Views: 37
Posted By The_Doc_Man
Re: Hey!

Glad you chose to join us rather than just lurk around. Welcome.
Forum: Queries Yesterday, 09:52 PM
Replies: 9
Views: 134
Posted By The_Doc_Man
Re: And OR

Even though there is such a thing as operator precedence, I always try to remember to use explicit parenthetical grouping rather than rely on (my very poor memory of) the rules of operator precedence.
Forum: Modules & VBA Yesterday, 09:48 PM
Replies: 23
Views: 213
Posted By The_Doc_Man
Re: Getrows

Don't forget, Adam, that when MS was trying to find a way to do Access-based web pages, they tried to emphasize ADO for web situations. However, that attempt didn't go over so well (can you say...
Forum: The Watercooler Yesterday, 09:37 PM
Replies: 29
Views: 367
Posted By The_Doc_Man
Re: we seem to be getting more visitors lately....

No, Tera, your comments were not out of line considering we are in the Watercooler section. We try to avoid vulgarity, and actual name-calling is terribly frowned upon unless it is clearly in jest,...
Forum: Introduce Yourself Yesterday, 09:25 PM
Replies: 4
Views: 57
Posted By The_Doc_Man
Re: Hello from the UK

Hello, Stephen, and welcome to the madhouse.
Forum: The Watercooler Yesterday, 03:06 PM
Replies: 29
Views: 367
Posted By The_Doc_Man
Re: we seem to be getting more visitors lately....

Adam, the issue is different if the headhunter company gives you a crappy test and if the actual employer gives you a crappy test. You can tell the headhunter that their test contains errors. They...
Forum: The Watercooler Yesterday, 02:47 PM
Replies: 6
Views: 85
Posted By The_Doc_Man
Re: pop up

Or you could use your browser to find and remove all cookies from that site. They will be viewable, usually.
Forum: The Watercooler Yesterday, 02:46 PM
Replies: 2
Views: 51
Posted By The_Doc_Man
Re: Merry Christmas everyone!

Terminally cute.

When you see a little one whose life can be so drastically changed by a relatively small and common piece of technology, you can't help but offer thanks to those still alive and...
Forum: General 12-06-2019, 11:14 PM
Replies: 6
Views: 123
Posted By The_Doc_Man
Re: Problem with Access with Windows Server 2019

If you changed the macro and things worked better (even if not perfectly) such that you did not get more of the "resources" message, then your guess about blaming the macro might have been right. ...
Forum: Tables 12-06-2019, 08:35 PM
Replies: 15
Views: 304
Posted By The_Doc_Man
Re: Exporting tables to CSV - unparsable records

In fact, though I agree with theDBguy, I'm going to say it more strongly. If you have a corrupt FE file, you MUST eventually get rid of it because you don't know what else will get hosed by a broken...
Forum: The Watercooler 12-06-2019, 08:29 PM
Replies: 29
Views: 367
Posted By The_Doc_Man
Re: we seem to be getting more visitors lately....

Adam, I have no idea because that is an open-ended question. Do you have the skills to do the job? I don't know because I don't know which job you were seeking. And there are a LOT of different...
Forum: General 12-06-2019, 11:16 AM
Replies: 6
Views: 123
Posted By The_Doc_Man
Re: Problem with Access with Windows Server 2019

Check around the recent threads here. We've had a couple of complaints about a recent patch that seems to have hosed one of the libraries. The articles get more specific.

The "System Resources...
Forum: General 12-06-2019, 11:12 AM
Replies: 10
Views: 145
Posted By The_Doc_Man
Re: You can't exit Microsoft Access now.

The other thing that fits the "oneness" criterion is permissions, since permission profiles depend very much on the environment (and the persnickety nature of IT security shops).
Forum: Tables 12-06-2019, 11:07 AM
Replies: 5
Views: 106
Posted By The_Doc_Man
Re: Linking two backends together

I'm with theDBguy on this one. I would advise against having a "series" connection and would suggest instead that you have two parallel connections. The 2GB limitations would apply either way and...
Forum: The Watercooler 12-06-2019, 10:59 AM
Replies: 29
Views: 367
Posted By The_Doc_Man
Re: we seem to be getting more visitors lately....

Adam, testing software cuts both ways. For employment exams that were set up by the company, it tells you as much about whether YOU wanted to work with a bunch of incompetent stumble-bums as whether...
Forum: Introduce Yourself 12-06-2019, 10:55 AM
Replies: 2
Views: 39
Posted By The_Doc_Man
Re: Greetings from Missouri!

Welcome Mike. To some people, "more efficient VBA" is somewhat akin to "military intelligence" or "jumbo shrimp" - a definite oxymoron. Still, good programming practices ARE possible with any...
Forum: General 12-06-2019, 07:33 AM
Replies: 10
Views: 145
Posted By The_Doc_Man
Re: You can't exit Microsoft Access now.

The biggest problem is USUALLY something that you have opened cooperatively. The discussions frequently talk about OLE or other connection methods that implicitly open something else. For instance,...
Forum: Modules & VBA 12-06-2019, 07:19 AM
Replies: 11
Views: 179
Posted By The_Doc_Man
Re: Dmax error 2465 cannot locate field

Sometimes all it takes is another pair of eyes. What happened to you is "writer's hypnosis" (which, as an amateur writer, I run into all of the time.) Your mind remembers clearly what you intended...
Showing results 1 to 25 of 500

 
Forum Jump



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