Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.55 seconds.
Search: Posts Made By: The_Doc_Man
Forum: Modules & VBA Today, 06:41 PM
Replies: 7
Views: 187
Posted By The_Doc_Man
Re: Programming Issue

Your highlighted error indicates that you are getting results for a probability computation that are not in the double-ended range 0-1. (Single-ended would of course be 0-0.5)

Looking at the...
Forum: The Watercooler Today, 06:16 PM
Replies: 2,741
Views: 540,156
Posted By The_Doc_Man
Re: What's your best/worst joke?

It probably belongs in its own thread, but Harvey Weinstein pretty much killed his career and opened the floodgates for accusations of sexual misconduct on the casting couch. Bill Cosby is another...
Forum: Modules & VBA Today, 05:53 AM
Replies: 5
Views: 84
Posted By The_Doc_Man
Re: Getting correct syntax for where clause

OK, that proves that your [PaidDate] is null when you expect it to be. That is an important finding because it eliminates one set of problems.



OK, let's clarify. Does this method work...
Forum: General Yesterday, 06:20 AM
Replies: 17
Views: 299
Posted By The_Doc_Man
Re: Unexplained Crashes of Access 2010 DB

Error C0000005 is an "addressing exception" error. In essence, it is telling you that you have tried to touch some part of memory that isn't within your allowed memory space at the Windows memory...
Forum: The Watercooler 10-16-2017, 05:17 AM
Replies: 2,741
Views: 540,156
Posted By The_Doc_Man
Re: What's your best/worst joke?

Good, one, Gent. Made ME laugh, and there is very little about HRC that can do that!
Forum: Tables 10-13-2017, 11:34 AM
Replies: 4
Views: 195
Posted By The_Doc_Man
Re: Linking tables / Lock status

In theory you will have two lock files, one for the BE and one for the FE. However, it should be noted that there will be no contention for the FE file if you have individual copies for each user.
Forum: Politics & Current Events 10-12-2017, 10:24 AM
Replies: 13
Views: 551
Posted By The_Doc_Man
Re: Defiant Catalans Block Spain’s Military Boats From Landing; Spain Seizes “.CAT” D

And yet people wonder about how contentious the USA Civil War was from 150+ years ago.

Yet another case of federalism vs. local rights playing out in modern times.

I don't know the specific...
Forum: Modules & VBA 10-12-2017, 05:23 AM
Replies: 7
Views: 194
Posted By The_Doc_Man
Re: Keep showing error 461 after press button

Error 461 is "Method or member of object not found" so my question is, WHERE is this code located? Is it in the class module of the form that is the parent of sfrmpcbuPNlst? Because that code won't...
Forum: General 10-11-2017, 08:15 PM
Replies: 34
Views: 634
Posted By The_Doc_Man
Re: Alignment of text

OK, if that is a single text box, then the reason it doesn't align is because you have spaces between the elements.

I don't know how you put them there, but you might make this box get loaded by...
Forum: General 10-11-2017, 03:45 PM
Replies: 16
Views: 515
Posted By The_Doc_Man
Re: Running slow in design mode

If the problem changes when you move it to another directory-enabled device (and USB IS a directory-enabled device), the problem that you left behind is often lock contention. The lock database for...
Forum: General 10-11-2017, 03:18 PM
Replies: 34
Views: 634
Posted By The_Doc_Man
Re: Alignment of text

You are not following what we are asking.

You show two values that are clearly of type String (or Text), each of which begins with TH. You want them to align. If this is a pair of text boxes,...
Forum: Modules & VBA 10-11-2017, 05:53 AM
Replies: 2
Views: 127
Posted By The_Doc_Man
Re: Dynamically relink Access tables - Split Database

Do you mean to say "works as long as the ORIGINAL FE and the current BE are in the same place"? Because if you had to have the BE and FE in the same folder, there is no point in splitting.
Forum: The Watercooler 10-11-2017, 05:48 AM
Replies: 104
Views: 2,164
Posted By The_Doc_Man
Re: Las Vegas

Yes, we don't throw away stuff either. I've got some of my dad's carpentry and automotive tools from the 1960s.
Forum: Modules & VBA 10-10-2017, 07:40 PM
Replies: 11
Views: 304
Posted By The_Doc_Man
Re: Error in module and query

The DCount function counts based on what you give it as a domain, so instead of looking at a table ("knitting" in your example), make a named query that uses a SELECT DISTINCT on the machine ID. ...
Forum: The Watercooler 10-10-2017, 01:07 PM
Replies: 104
Views: 2,164
Posted By The_Doc_Man
Re: Las Vegas

Colin



It's a contract thing. The A team is secretly sponsored by an ammunition company that wants to blow through hundreds of rounds of ammo per episode. Well, if they hit the bad guys too...
Forum: The Watercooler 10-10-2017, 01:02 PM
Replies: 2
Views: 197
Posted By The_Doc_Man
Re: My ex dumped me again

nfk, sorry to hear you are having trouble with your ex. Good luck with that.

I have to say that this time your post was a lot milder. Enough for me to honestly say, good luck in your new...
Forum: Access World News 10-09-2017, 07:09 PM
Replies: 7
Views: 420
Posted By The_Doc_Man
Re: Chris Howarth aka stopher - illness

We will miss you, Chris. May you and your family find whatever peace there is to be found, now and in the coming days.
Forum: The Watercooler 10-09-2017, 12:55 PM
Replies: 104
Views: 2,164
Posted By The_Doc_Man
Re: Las Vegas

Colin... All this time you've been touting how good your British system works vs. the USA, and yet here you come up with the perfect comparison ... and both systems work the same. Knowledge does not...
Forum: Modules & VBA 10-08-2017, 07:08 PM
Replies: 9
Views: 196
Posted By The_Doc_Man
Re: Loop thru Text Values and save to Recordset

Your question is a bit abstracted and betrays various design issues. For instance, that record is SO not normalized as to be almost painful. (When considering how much typing is going to be...
Forum: The Watercooler 10-08-2017, 12:06 PM
Replies: 104
Views: 2,164
Posted By The_Doc_Man
Re: Las Vegas

Those two, I can answer. Overzealous sound-effects technicians with a limited library of sounds.
Forum: The Watercooler 10-08-2017, 05:25 AM
Replies: 104
Views: 2,164
Posted By The_Doc_Man
Re: Las Vegas

OK, Mike. Having never used a rifle suppressor or silencer of the type appropriate for the weapons in question, I will defer to your expertise.

But your comments bear out the other side of my...
Forum: The Watercooler 10-07-2017, 09:32 PM
Replies: 104
Views: 2,164
Posted By The_Doc_Man
Re: Las Vegas

Colin, regarding your question on silencers:

First thought: ISIS is now claiming he was one of theirs. If that is true, then his goal was terror and why would he want a silencer? He wouldn't, I...
Forum: Tables 10-07-2017, 08:04 AM
Replies: 7
Views: 278
Posted By The_Doc_Man
Re: You cannot add or change a record because a related record is...

The problem is that your relationship "arrow" must be pointing the wrong way.

The record to which the optional service applies must be the "one" side of the relationship. The service record (that...
Forum: General 10-06-2017, 06:29 PM
Replies: 11
Views: 524
Posted By The_Doc_Man
Re: Who originally designed MS Access and What happened to the initial core team?

Just to amplify one part of Pat's answer:



It is frequently the case on this forum that our best answer is just to inform the original poster what question to ask. I.e. supply a topic name,...
Forum: Modules & VBA 10-06-2017, 05:52 AM
Replies: 11
Views: 261
Posted By The_Doc_Man
Re: Error : You cannot assign a value to this object

Just as a point of clarification:

If the field's value is defined as "= variablename" then it is an expression even if there are no operators and only one variable. It is the equals-sign that...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 08:53 PM.


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 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World