f



run-time error 2471 'The object doesn't contain the Automation object 'qry_prodreport_ALL.SSN."

I'm getting this error:  run-time error 2471 'The object doesn't
contain the Automation object 'qry_prodreport_ALL.SSN."

Here is the code:

Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As
Integer)

Dim strcount As Double, strpts As Double

    strcount = Nz(DSum("[Miles]", "Productivity", "[SSN]=
qry_prodreport_ALL.[SSN]" & _
     "and [Date] >= DateAdd(ww, -13, (Now))"), 1)
    strpts = strcount / 13
    Me.txtpts = strpts
End Sub

qry_prodreport_ALL definitely exists, and it returns a field called
"SSN."  Is there some error in syntax that I'm missing.

Thank you

0
3/27/2006 9:44:13 PM
comp.databases.ms-access 42670 articles. 0 followers. Post Follow

1 Replies
1102 Views

Similar Articles

[PageSpeed] 43

linoleum79@hotmail.com wrote in
news:1143495853.698563.144680@u72g2000cwu.googlegroups.com: 

> I'm getting this error:  run-time error 2471 'The object doesn't
> contain the Automation object 'qry_prodreport_ALL.SSN."
> 
> Here is the code:
> 
> Private Sub GroupFooter0_Format(Cancel As Integer, FormatCount As
> Integer)
> 
> Dim strcount As Double, strpts As Double
> 
>     strcount = Nz(DSum("[Miles]", "Productivity", "[SSN]=
> qry_prodreport_ALL.[SSN]" & _
>      "and [Date] >= DateAdd(ww, -13, (Now))"), 1)
>     strpts = strcount / 13
>     Me.txtpts = strpts
> End Sub
> 
> qry_prodreport_ALL definitely exists, and it returns a field
> called "SSN."  Is there some error in syntax that I'm missing.

You can only have criteria that apply to the domain you've given for
your DSum(). That is, the "Productivity" table/query is the only
source you can use for criteria. Your 2nd argument needs to be a
query that joins Productivity and qry_prodreport_ALL, and get rid of
the SSN part of the criteria. 

-- 
David W. Fenton                  http://www.dfenton.com/ 
usenet at dfenton dot com    http://www.dfenton.com/DFA/
0
XXXusenet (2387)
3/27/2006 10:56:31 PM
Reply:

Similar Artilces:

"Run-Time Error '3012' : Object "------------" already exists
Dear Sir or Madam : Hello ! Newbie to Access 2010 programming here ; I've a form which is almost complete -- HOWEVER, whenever selecting a specific pull-down, I'm thrown the error : "Run-time error '3012' : Object "------------" already exists " Where "------------" is a 'set' statement... Hmmm... So... My code's below and if anyone can take a gander, it would be greatly appreciated ! ( The error checking MsgBoxes are showing me the data being returned is correct. ) It will help my office run more smoothly... Thanks in advance ! -- B. Private Sub UserID_Click() Dim dbs As Database, qdf As QueryDef, sqlQry As String, strSQL As String Set dbs = CurrentDb If (Court222 = "Middlesex") Then strSQL = "SELECT Middlesex FROM Pricing WHERE Testpanel ='" & Panel & "'" ElseIf (Court222 = "Suffolk") Then strSQL = "SELECT Suffolk FROM Pricing WHERE Testpanel ='" & Panel & "'" ElseIf (Court222 = "Essex") Then strSQL = "SELECT Essex FROM Pricing WHERE Testpanel ='" & Panel & "'" Else strSQL = "SELECT Norfolk FROM Pricing WHERE Testpanel ='" & Panel & "'" End If MsgBox "strSQL: " & strSQL 'THE LINE BELOW IS WHERE THE ERROR OCCURS FOR "S...

solving a "ActiveX component can't create object or return reference to this object Run Time Error 429"
I open Access 2007, open the mydatabase.accdb database, run the below code as a macro and it runs fine. But, if I open a Word 2007 document, try to run this as a macro, I get the error "Run Time Error 429 ActiveX component can't create object or return reference to this object". on the line where I am trying to open a handle to the database at OpenDatabase("C:\mydatabase.accdb"). I want the below part to run in a Word document so it can read the data in the last column of every row of all the tables in a document, populate a recordset with the values...

ERROR: "Method 'Connection' of object '_Current Project' failed."
I have created a front-end application and back-end database. Everytime that I opened the program in the past, it open just fine with no errors when linking to the back-end tables. lately, I get the following error message whenever I open my application: ERROR: "Method 'Connection' of object '_Current Project' failed. Check to see if you installed the tables used for storing data is in the default directory. -2147024769 After clicking, "OK", my application continues on to open anyway. I have checked the application to determine if the intended location for...

Compile time error: "error: 'write_n' is not a member of 'ACE'"
Hi All, ACE VERSION: 5.5.6 HOST MACHINE and OPERATING SYSTEM: LINUX, Kernel 2.6.19-1.2288.fc5, i686 I tried to compile the program given below, but was giving following compilation error: Please help me to compile this proram --------------------------------------- COMPILATION------------------------------------------ [root@paresh ACE_MSG_BLOCK]# g++ main.C -o main -lACE -IACE_ROOT main.C: In function 'int main(int, char**)': main.C:9: error: 'read_n' is not a member of 'ACE' main.C:20: error: 'write_n' is not a member of 'ACE' ----------------------------------END COMPILATION-------------------------------------------- ---------------------------------------------PROGRAM main.C--------------------------------------------- #include "ace/OS.h" #include "ace/Message_Block.h" int main(int argc, char* argv[]) { ACE_Message_Block *head = new ACE_Message_Block(BUFSIZ); ACE_Message_Block *mblk = head; for(;;) { ssize_t nbytes = ACE::read_n(ACE_STDIN, mblk- >wr_ptr(), mblk->size()); if(nbytes <= 0) break; mblk->wr_ptr(nbytes); mblk->cont(new ACE_Message_Block(BUFSIZ)); mblk = mblk->cont(); } for(mblk = head; mblk != 0/*NULL POINTER*/; mblk = mblk- >cont()) { ACE::write_n(ACE_STDOUT, mblk-&g...

ERROR: "Method 'Connection' of object '_Current Project' failed.
I have created a front-end application and back-end database. Everytime that I opened the program in the past, it open just fine with no errors when linking to the back-end tables. Lately, I get the following error message whenever I open my application: ERROR: "Method 'Connection' of object '_Current Project' failed. Check to see if you installed the tables used for storing data is in the default directory. -2147024769 After clicking, "OK", my application continues on to open anyway. I have checked the application to determine if the intended location fo...

'''''''''''''The Running Update/Append Queries Using VBA code Ordeal'''''''''''''' #2
Hi, Thanks for ur help there HJ. I know how to do the tasks you specified there. I would like for the update query to use field values from some of the fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, DateTo. My problem is that an append/update query can't find the values in the open Form (frmInvoices) when I specify them as; [Forms]![frmInvoices]![InvoiceNumber] a select query has no problem finding the field values on a form. please help. Aaron Hi Aaron, Could you post the entire code that you are having trouble with? Now it is not possible to see what goes wrong. HJ "Aaron" <aaron@rapid-motion.co.uk> wrote in message news:260d7f40.0408120245.2f3d01f8@posting.google.com... > Hi, > > Thanks for ur help there HJ. > > I know how to do the tasks you specified there. > > I would like for the update query to use field values from some of the > fields on the form (frmInvoices) such as InvoiceNumber, DateFrom, > DateTo. My problem is that an append/update query can't find the > values in the open Form (frmInvoices) when I specify them as; > > [Forms]![frmInvoices]![InvoiceNumber] > > a select query has no problem finding the field values on a form. > > please help. > > Aaron First off, if you are not always using all the parameters specified in your form, then you have to add parameters to your query on the fly. Also, you can't just do something like qdf.SQL = "SE...

Re: [ace-users] Compile time error: "error: 'write_n' is not a member of 'ACE'"
Hi, You lack an include, include "ace/ACE.h" in your program Regards, Johnny Willemsen Remedy IT Postbus 101 2650 AC Berkel en Rodenrijs The Netherlands www.theaceorb.nl / www.remedy.nl "Paresh" <pareshspednekar@gmail.com> wrote in message news:<1173985162.346951.209100@y66g2000hsf.googlegroups.com>... > Hi All, > > ACE VERSION: 5.5.6 > HOST MACHINE and OPERATING SYSTEM: LINUX, Kernel 2.6.19-1.2288.fc5, > i686 > > I tried to compile the program given below, but was giving following > compilation error: > Please help me to compile this proram > > --------------------------------------- > COMPILATION------------------------------------------ > [root@paresh ACE_MSG_BLOCK]# g++ main.C -o main -lACE -IACE_ROOT > main.C: In function 'int main(int, char**)': > main.C:9: error: 'read_n' is not a member of 'ACE' > main.C:20: error: 'write_n' is not a member of 'ACE' > ----------------------------------END > COMPILATION-------------------------------------------- > > > > ---------------------------------------------PROGRAM > main.C--------------------------------------------- > > #include "ace/OS.h" > #include "ace/Message_Block.h" > > int main(int argc, char* argv[]) { > ACE_Message_Block *head = new ACE_Message_Block(BUFSIZ); > ...

Tk::Browser, "Can't locate object method 'Construct'"
Using perl 5.10, I'm trying to run the Tk::Browser.pm SYNOPSIS example. I get a "Can't locate object method "Construct" via package "Tk::Widget" " error. In more detail --- use strict; use warnings; use Tk::Browser; my $b = new Browser; __END__ gets --- Can't locate object method "Construct" via package "Tk::Widget" at C:/Perl/site/lib/Tk/Frame.pm line 13. Compilation failed in require at (eval 15) line 3. ...propagated at C:/Perl/lib/base.pm line 93. --- etc The "Construct" that can't be located for Tk::W...

'Run in' or not 'run in'?
Hei I have just bought another QuickSilver 867mhz G4, which is going to have = a new 'motor' with a GigaDesigns 7447A Dual G4 1,6-2,0ghz processor. I=20 have more CPU upgraded Macs and have always with these set the CPU a=20 step lower to 'run in' the CPU and then set it up to full speed after=20 apprx. a month or so, - just like you run in a new car... My experiences = are that this always gives the best results With fx. PowerLogix processors this is rather easy, since the speed is=20 controlled by 'CPUDirectory' software, but with Giga's Processors it is=20 do...

unix2dos ( tr '\12' '\15\12' ) doesn't run
Hi, m3vmsa3.caddebug /tmp > tr '\12' '\15\12' < foo > foo.tr m3vmsa3.caddebug /tmp > od -t c foo 0000000 o n e \n t w o \n t h r e e \n 0000016 m3vmsa3.caddebug /tmp > od -t c foo.tr 0000000 o n e \r t w o \r t h r e e \r 0000016 Why does tr not add '\12' to foo.tr? Thanks in advance, Jose Luis On Tue, 18 Dec 2007 04:08:26 -0800 (PST), Jose Luis wrote: > > Hi, > > m3vmsa3.caddebug /tmp > tr '\12' '\15\12' < foo > foo.tr > m3vmsa3.caddebug /tmp > od -t c ...

'^=' and '~='?
Hello, What is the difference between '^=' and '~='? Thanks, Duckhye ...

'is not' or '!='
A newbie question to you; what is the difference between statements like: if x is not None: and if x != None: Without any context, which one should be preferred? IMHO, the latter is more readable. On 2014-08-18 21:35, ElChino wrote: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: > > Without any context, which one should be preferred? > IMHO, the latter is more readable. > "x == y" tells you whether x and y refer to objects that are equal. "x is y" tells you whether x and y actually refer to the same object. In the case of singletons like None (there's only one None object), it's better to use "is". "ElChino" <elchino@cnn.cn>: > A newbie question to you; what is the difference between statements > like: > if x is not None: > and > if x != None: Do the following: take two $10 bills. Hold one bill in the left hand, hold the other bill in the right hand. Now, the bill in the left hand "is not" the bill in the right hand. However, the bill in the left hand "==" the bill in the right hand. > Without any context, which one should be preferred? > IMHO, the latter is more readable. In almost all cases, both tests would result in the same behavior. However, the "is not" test is conceptually the correct one since you want...

error: expected '=', ',', ';', 'asm' or '__attrib
Hi I'm trying to compile an ADC Driver & come acrosss the following error. I've no experience writing drivers before, and hence have no clue how to fix it. Hope someone out there has encountered the problem & suggesst a fix for the same. The Error is I get is : qadc.c: At top level: qadc.c:97: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'qadc_read' make: *** [qadc.o] Error 1 [root@localhost qadc]# ########################################################################### ADC Driver Code ##...

error: expected '=', ',', ';', 'asm' or '__attrib
Hi I'm trying to compile an ADC Driver & come acrosss the following error. I've no experience writing drivers before, and hence have no clue how to fix it. Hope someone out there has encountered the problem & suggesst a fix for the same. The Error is I get is : qadc.c: At top level: qadc.c:97: error: expected '=', ',', ';', 'asm' or '__attribute__' before 'qadc_read' make: *** [qadc.o] Error 1 [root@localhost qadc]# ########################################################################### ADC Driver Code ########################################################################### #define MODULE #define __KERNEL__ #include <linux/config.h> #include <linux/module.h> #include <linux/kernel.h> /* printk */ #include <linux/fs.h> / #include <linux/errno.h> /* error codes */ #include <linux/types.h> /* size_t */ #include <linux/proc_fs.h> /* proc file system */ #include <linux/fcntl.h> #include <asm/system.h> /* cli, flags */ #include <asm/uaccess.h> /* copy from/to user */ /*Registers to get qadc access*/ volatile unsigned short * qadcmcr = (unsigned short *)0x40190000; volatile unsigned short * qacr0 = (unsigned short *)0x4019000a; volatile unsigned short * qacr1 = (unsigned short *)0x4019000c; volatile unsigned short * qacr2 = (unsigned short *)0x4019000e; volatile unsigned short * qasr0 = (unsigned short *)0x40190010; volatile unsigned short * qasr1...

ATTRIBUTE ERROR: 'module' object has no attribute 'ssl'
I am getting the following errors: File "H:\xampp\xampp\xampp\python\lib\httplib.py", line 679, in _send_output self.send(msg) File "H:\xampp\xampp\xampp\python\lib\httplib.py", line 646, in send self.connect() File "H:\xampp\xampp\xampp\python\lib\httplib.py", line 1073, in connect ssl = socket.ssl(sock, self.key_file, self.cert_file) AttributeError: 'module' object has no attribute 'ssl' Thank You in Advance johnny wrote: > I am getting the following errors: That is *one* error. > > File "H:\xampp\xampp\xam...

Need API help- getting "Run-time error '-2147417848 (80010108)': Automation error
It says "the object invoked has disconnected from its clients" I'm trying to draw an arc and then extrude it as a thin feature... Here's my code: Part.ClearSelection2 True boolstatus = Part.Extension.SelectByID("XY (Front)", "PLANE", 0, 0, 0, False, 0, Nothing) 'start sketching Part.InsertSketch2 (True) Part.CreateArc2 0, 0, z, 1, 1, z, -1, 1, z, 1 Part.InsertSketch2 False boolstatus = Part.Extension.SelectByID("Sketch1", "SKETCH", 0, 0, 0, False, 0, Nothing) empty_var = Part.FeatureBossThin2(True, True, False, swEnd...

When I do from lxml import etree I've this error : AttributeError: 'module' object has no attribute 'BytesIO'
Hi, I'm on Ubuntu 8.04.1 I've installed lxml with easy_install lxml command. Now, when I load etree I've this error : $ python Python 2.5.2 (r252:60911, Apr 21 2008, 11:12:42) [GCC 4.2.3 (Ubuntu 4.2.3-2ubuntu7)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> from lxml import etree Traceback (most recent call last): File "<stdin>", line 1, in <module> File "lxml.etree.pyx", line 40, in lxml.etree (src/lxml/ lxml.etree.c:119415) AttributeError: 'module&#...

????? Error: -2147467259 Method 'Visible' of object 'ComandBar' failed!
Hi folks, I have an Access 2003 app that works perfectly on my computer. However, when we install it on OTHER computers that ALSO have access 2003 we get an error on startup: Error: -2147467259 Method 'Visible' of object 'ComandBar' failed! At this point, I am stumped. Anyone have a clue why this is happening? -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Did you spell CommandBar correctly (there are 2 m's)? Do you have a Reference to Microsoft Office 11.0 Object library? This is in the VBA window, menu item Tools > References... . The CommandBar is an item in ...

Can't "mk CONF=9pcdisk" --> gives error "rc: #d/0: token '=': syntax error"
I'm in /sys/src/9/pc and I type `mk CONF=9pcdisk` and rc gives me the error "rc: #d/0: token '=': syntax error". Why is this? Just doing mk works fine (I think). Thanks! Plan9 looks very cool... just finished reading through intro (all of it). you're using backquotes, why? that would be `{mk CONF=3D9pcdisk} in rc's syntax. now to compile that kernel the syntax is: % mk 'CONF=3Dpcdisk' now are you sure you want a pcdisk?=20 On Jul 19, 2012, at 6:07 AM, kalaracey@gmail.com wrote: > I'm in /sys/src/9/pc and I type >=20 ...

Parse error: parse error, expecting `','' or `';''
I'm getting the following error Parse error: parse error, expecting `','' or `';'' in /home/notarywe/public_html/php/update2.php on line 108 Here is line 108 <input type="text" name="ud_first" value="<? echo "$first" size="20"?>"></td> Any help would be appreciated. On 3-Aug-2003, "entoone" <entoone@pacbell.net> wrote: > I'm getting the following error Parse error: parse error, expecting `','' > or > `';'' in /home/notarywe/public_h...

waitfor(obj,'property',value) doesn't work for Java objects ?
Hello, I'm trying to use Java GUI interface for some matlab function . All stuff goes as it should with the exception of the case when i have to pass some Java event back to Matlab it doesn't work: Here is Java jar : http://sites.google.com/site/stasgold/Home/MainFrame.jar?attredirects=0 MainFrame.state is defined as public integer field in Java. Matlab code: javaaddpath('MainFrame.jar'); obj = javaObject('MainFrame'); disp('Starting jump'); obj.start(); disp('Stoping jump'); obj.stop(); disp('Waiting for you to start jumps'); waitfor(obj,...

Run-time error '440': Automation error
When run the FO (Polish scientific botanical application) "Run-time error '440': Automation error" message appears and application crashes. What is the reason? system: Fedora Linux 2 kernel: 2.6.7-1.494.2.2 wine version: 20040716 Installation of FO seems to proceed OK but I can`t run program. The full output (very long...): [pmad@localhost pmad]$ wine "/usr/share/wine_c/Program Files/Flora ojczysta/flora.exe" fixme:ole:CoRegisterMessageFilter stub fixme:ole:OleLoadPictureEx (0x7e063934,88407,1,{7bf80980-bf32-101a-8bbb-00aa00300cab},x=0,y=0,f=0,0x...

Removing the letters 't' 'i' 'x' and 'y'
Im having trouble with figuring out how to write a function which will remove the letters 't' 'i' 'x' and 'y' from any input string in matlab. for example modstr(pixy) should result in ans = 'p' or modstr(picture) should result in ans = 'pcure' if anyone could offer any help or hints i would really appreciate it. Thank You >> modstr=@(s) s(~ismember(s,'tixy')) modstr = @(s)s(~ismember(s,'tixy')) >> modstr('picture') ans = pcure % Bruno ...

'super' object has no attribute '__setitem__'
I'm using Python 2.7 and the code below fails at the 'super' statement in the __setitem__ function in the HistoryKeeper class. The error is: 'super' object has no attribute '_setitem__' Can anyone please tell me why and how to fix it? (I've googled endlessly and I don't see the problem.) [The code will seem silly as it is, because it's pared down to show the example. The goal is that multiple classes, like the Vehicle class below, will inherit HistoryKeeper. History keeper overloads __setitem__ and will eventually keep a running history every t...

Web resources about - run-time error 2471 'The object doesn't contain the Automation object 'qry_prodreport_ALL.SSN." - comp.databases.ms-access

Resources last updated: 3/21/2016 4:37:32 AM