473,387 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Domain functions and parameter queries

I have a situation where a Dcount function against a complex query
works great on my PC but not on a test PC in an Access 2000 database.
The underlying query is a query based on a query - with a parameter
that is filled via an open form (a date range).

When it errors out on the test PC, it returns an Invalid Use of Null
error - however, there are no null values in the underlying data - no
left joins. Running the query that is used as the basis for the
domain function returns the same data on both PC's.

I found a post from Allen Browne that said dfunctions won't run
against a parameter query - so it sounds like that's my "answer" -
except that it DOES run on my PC!! Hmmm....??? (And Allen is as
close to infallible as people can be, no doubt.)

Given that I have a workaround, one could say this is just a post to
grumble -<g- BUT, I'm wondering if anyone can shed any further light
on the why of what might be going on!!! Many thanks.

Cindy

Nov 2 '07 #1
0 1063

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Lapchien | last post by:
I have 2 queries, 1 produces a list of direct debit payments, the other then 'marks' those records as processed. The parameter is a date (usually today's date). I run these 2 queries from a...
1
by: Cory | last post by:
When I run the subroutine testEmailContacts the msgbox says that there is only 1 record. The sql for qyEmailContactsQyCard is below. There is over 3000 records in the table "tbl:Contact". What am i...
7
by: Z D | last post by:
Hello, I was wondering how I would go about writing some code that would be able to authenticate a user atainst a Domain Controller on an old NT4 domain. The call would be coming from a server...
22
by: TC | last post by:
I have an Access database application with a lot of custom row functions written in VBA. In other words, a lot of queries contain calculated fields which use functions defined in the modules. I...
21
by: Marc DVer | last post by:
I am trying to create a query that can be loaded as a querydef object but not having to assign values to the parameters if I don't want to. Normally when using a parameter query in VBA my code...
0
by: tlyczko | last post by:
Can anyone give me a website reference(s) wherein I can learn how to use a form and parameter queries to generate an Access report *without* having to reference the form or hard-code the query in...
0
by: Billie Boy | last post by:
Hi to all. I’m new here and am coming to you from Melbourne Australia. So a big HELLO 2 ALL. Now I am encountering an annoying problem in the SQL builder of the copy of VB.6 that I am using at...
1
by: TonyJH | last post by:
Hello, I have a database in Access2003. I have set up several queries that use the parameter entry . Each query produces different outputs from various tables that go into a report. Sometimes, a...
8
by: DanicaDear | last post by:
I have something interesting...looking to see if anyone else has came across this. I have a query with parameter and and the query works beautifully every time. However, when I use the wizard...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.