I have MS Access 2000. I have recently installed it on a new computer and
transferred my mbd files across. These work OK, including those using SQL
Aggregate funtions. However if I set up a new database, I find that some
of these functions do not work. For instance, I get #Error messages when
trying to use count([fieldname]) or Date(). Sum works OK. As far as I can
see all relevant parts of Access and MS office seem to be installed.
I have run repair and installed the latest MS Office service packs (to SP3),
but the problem remains.
In answer to an earlier post, en****@ridesoft.com suggested that I look at
my references - some are missing. I do not understand this - what are
references and where do look for them?
Can any one help please?
Peter 6 1375
On Mar 27, 2:50 pm, "Peter B" <kealtiess...@f2s.comwrote:
I have MS Access 2000. I have recently installed it on a new computer and
transferred my mbd files across. These work OK, including those using SQL
Aggregate funtions. However if I set up a new database, I find that some
of these functions do not work. For instance, I get #Error messages when
trying to use count([fieldname]) or Date(). Sum works OK. As far as I can
see all relevant parts of Access and MS office seem to be installed.
I have run repair and installed the latest MS Office service packs (to SP3),
but the problem remains.
In answer to an earlier post, eng...@ridesoft.com suggested that I look at
my references - some are missing. I do not understand this - what are
references and where do look for them?
Can any one help please?
Peter
Assuming you have not load the particular feature that require your
application
On Tue, 27 Mar 2007 10:50:55 +0100, "Peter B" <ke**********@f2s.com>
wrote:
Open a code window Tools References
They are explained in the Help file.
-Tom.
>I have MS Access 2000. I have recently installed it on a new computer and transferred my mbd files across. These work OK, including those using SQL Aggregate funtions. However if I set up a new database, I find that some of these functions do not work. For instance, I get #Error messages when trying to use count([fieldname]) or Date(). Sum works OK. As far as I can see all relevant parts of Access and MS office seem to be installed.
I have run repair and installed the latest MS Office service packs (to SP3), but the problem remains.
In answer to an earlier post, en****@ridesoft.com suggested that I look at my references - some are missing. I do not understand this - what are references and where do look for them?
Can any one help please?
Peter
>
Assuming you have not load the particular feature that require your
application
I think I did, but can you advise which feature I should have loaded,
please.
Peter B wrote:
Are you referring to the visual basic window? There is a long list of
references there, but I cannot see which might be relevant. There are 5
unchecked refs lower in the list all titled 'Visual basic for Applications'.
Should these be checked? I am not actually wishing to use VBA, only to get
the functions to work in my reports.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:a7********************************@4ax.com...
>>On Tue, 27 Mar 2007 10:50:55 +0100, "Peter B" <ke**********@f2s.com> wrote:
Open a code window Tools References
They are explained in the Help file.
-Tom.
>>>I have MS Access 2000. I have recently installed it on a new computer and transferred my mbd files across. These work OK, including those using SQL Aggregate funtions. However if I set up a new database, I find that some of these functions do not work. For instance, I get #Error messages when trying to use count([fieldname]) or Date(). Sum works OK. As far as I can see all relevant parts of Access and MS office seem to be installed.
I have run repair and installed the latest MS Office service packs (to SP3), but the problem remains.
In answer to an earlier post, en****@ridesoft.com suggested that I look at my references - some are missing. I do not understand this - what are references and where do look for them?
Can any one help please?
Peter
Open up a code module. On the menu, click Tools/Reference.
In my example I am using an old version of Access. My refs, in this
order, are
Visual Basic For Applications
Microsoft Access [Access version] Object Library
Microsoft DAO [DAO version] Object Library
Which ones do you have at the top? In what order? You check the
refereneces in the order you want them to appear.
"salad" <oi*@vinegar.comwrote in message
news:Bk********************@newsread2.news.pas.ear thlink.net...
Peter B wrote:
>Are you referring to the visual basic window? There is a long list of references there, but I cannot see which might be relevant. There are 5 unchecked refs lower in the list all titled 'Visual basic for Applications'. Should these be checked? I am not actually wishing to use VBA, only to get the functions to work in my reports.
"Tom van Stiphout" <no*************@cox.netwrote in message news:a7********************************@4ax.com.. .
>>>On Tue, 27 Mar 2007 10:50:55 +0100, "Peter B" <ke**********@f2s.com> wrote:
Open a code window Tools References
They are explained in the Help file.
-Tom.
I have MS Access 2000. I have recently installed it on a new computer and transferred my mbd files across. These work OK, including those using SQL Aggregate funtions. However if I set up a new database, I find that some of these functions do not work. For instance, I get #Error messages when trying to use count([fieldname]) or Date(). Sum works OK. As far as I can see all relevant parts of Access and MS office seem to be installed.
I have run repair and installed the latest MS Office service packs (to SP3), but the problem remains.
In answer to an earlier post, en****@ridesoft.com suggested that I look at my references - some are missing. I do not understand this - what are references and where do look for them?
Can any one help please?
Peter
Open up a code module. On the menu, click Tools/Reference.
In my example I am using an old version of Access. My refs, in this
order, are
Visual Basic For Applications
Microsoft Access [Access version] Object Library
Microsoft DAO [DAO version] Object Library
Which ones do you have at the top? In what order? You check the
refereneces in the order you want them to appear.
The attachment to my last post showed my checked references. They are in
order from the top:
Visual Basic for Applications
MS 9.0 object library
OLE Automation
MS ActiveX Data objects 1.0 Type Library
These were checked by the system, not by myself.. I have no idea why.
Peter
Thanks guys - problem now sorted by adding references
"Peter B" <ke**********@f2s.comwrote in message
news:eu**********@news.freedom2surf.net...
>I have MS Access 2000. I have recently installed it on a new computer and
transferred my mbd files across. These work OK, including those using
SQL
Aggregate funtions. However if I set up a new database, I find that
some
of these functions do not work. For instance, I get #Error messages when
trying to use count([fieldname]) or Date(). Sum works OK. As far as I
can
see all relevant parts of Access and MS office seem to be installed.
I have run repair and installed the latest MS Office service packs (to
SP3),
but the problem remains.
In answer to an earlier post, en****@ridesoft.com suggested that I look at
my references - some are missing. I do not understand this - what are
references and where do look for them?
Can any one help please?
Peter
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Gustavo Randich |
last post by:
Hello,
Is there a way to revalidate (rebind) all inoperative packages
(SYSCAT.PACKAGES.VALID = 'X') via a stored procedure that scans invalid
packages from SYSCAT.PACKAGES and execute the CLP...
|
by: Artur |
last post by:
(DB2 9) Inoperative packages must be explicitly rebound, but invalid
packages can be rebound automatically. Do you know what is the
difference?
Example:
create function f1
create procedure...
|
by: mryangza |
last post by:
Hi all,
Is there a mechanism for manually marking routine packages as
inoperative in DB2LUW?
The problem I'm trying to solve is one of recreating interdependent
functions. My application...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
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$) {
}
...
|
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...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
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...
|
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...
| |