Access World Forums > Search Forums Search Results

User Name Remember Me? Password

Page 1 of 20 1 2 3 11 > Last »

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 Dsum not giving expected results. 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 Problem in conversation of date 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 Exporting tables to CSV - unparsable records 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 Social Media Platforms and Campaign Ads 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 Getrows 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 we seem to be getting more visitors lately.... 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 Hello 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 Hey! 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 And OR 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 Getrows 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 we seem to be getting more visitors lately.... 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 Hello from the UK 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 we seem to be getting more visitors lately.... 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 pop up 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 [SOLVED] Merry Christmas everyone! 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 Problem with Access with Windows Server 2019 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 Exporting tables to CSV - unparsable records 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 we seem to be getting more visitors lately.... 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 Problem with Access with Windows Server 2019 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 You can't exit Microsoft Access now. 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 Linking two backends together 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 we seem to be getting more visitors lately.... 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 Greetings from Missouri! 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 You can't exit Microsoft Access now. 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 [SOLVED] Dmax error 2465 cannot locate field 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

Page 1 of 20 1 2 3 11 > Last »

Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World     Access World News     Site Suggestions     Introduce Yourself     The Watercooler Microsoft Access Discussion     General     Tables     Queries     Forms     Reports     Macros     Modules & VBA     Theory and practice of database design     Access Web Microsoft Access Reference     Access FAQs     Code Repository     Sample Databases     Microsoft Access Tutorials     Microsoft Access User Groups Apps and Windows     SQL Server     Crystal Reports     Visual Basic     VB.NET     Word     Excel     Web Design and Development         ASP and ASP.NET         PHP & MySQL     Windows     Other Software     Hardware Questions and Answers Non-Access Issues     Politics & Current Events     Debates     Gaming     Sports, Health & Fitness     Gadgets     Small Business