473,886 Members | 2,366 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help: 'trim()' Function not recognized

I created a church database in Access 97 that contain the typical Name,
Address, and Phone Number information fields. I had a number of
different reports to print query data in different formats.

I had a number of textboxes in the report designs that used the trim()
function to suppress printing of leading spaces. As an example, one of
the textboxes had the following:
=Trim([Address])
Basically, this is looking for a situation where someone accidentally
created spaces at the beginning of the address field and the report
suppresses the leading spaces for appearances. All the textboxes used
the trim() function which include some boxes that concatenated several
fields together.

The problem is that when the database were moved to two other computers,
one worked correctly; the other one didn't.

One system is XP, the other is 2000. Both are running identical version
of Access 2002 (10.4302.4219) SP-2. The database was converted to Access
2002 file format by the Windows 2000 system and works correctly. The XP
version does not; it apparently thinks 'trim()' is a variable and
requests an input value from the user. The two databases are identical
(byte for byte). The options for Access on the two systems are
identical.

I suspect that something is not loaded correctly or not loaded at all on
the XP system but I don't know where to look. I thought I should have
some of idea of what the real problem is before I blindly reload Access
on the XP system.

Any ideas would be greatly appreciated.

Thanks,
Dave

*************** *************** **
Dave Bovey
de*****@netzero .com
*************** *************** **
Nov 12 '05 #1
5 10541
Your references could be messed up.

This can be caused by differences in either the location or file version of
certain files between the machine where the application was developed, and
where it's being run (or the file missing completely from the target
machine). Such differences are common when new software is installed.

On the machine(s) where it's not working, open any code module (or open the
Debug Window, using Ctrl-G, provided you haven't selected the "keep debug
window on top" option). Select Tools | References from the menu bar. Examine
all of the selected references.

If any of the selected references have "MISSING:" in front of them, unselect
them, and back out of the dialog. If you really need the reference(s) you
just unselected (you can tell by doing a Compile All Modules), go back in
and reselect them.

If none have "MISSING:", select an additional reference at random, back out
of the dialog, then go back in and unselect the reference you just added. If
that doesn't solve the problem, try to unselect as many of the selected
references as you can (Access may not let you unselect them all), back out
of the dialog, then go back in and reselect the references you just
unselected. (NOTE: write down what the references are before you delete
them, because they'll be in a different order when you go back in)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)

"Dave Bovey" <La*********@ya hoo.com> wrote in message
news:40******** *******@netzero .net...
I created a church database in Access 97 that contain the typical Name,
Address, and Phone Number information fields. I had a number of
different reports to print query data in different formats.

I had a number of textboxes in the report designs that used the trim()
function to suppress printing of leading spaces. As an example, one of
the textboxes had the following:
=Trim([Address])
Basically, this is looking for a situation where someone accidentally
created spaces at the beginning of the address field and the report
suppresses the leading spaces for appearances. All the textboxes used
the trim() function which include some boxes that concatenated several
fields together.

The problem is that when the database were moved to two other computers,
one worked correctly; the other one didn't.

One system is XP, the other is 2000. Both are running identical version
of Access 2002 (10.4302.4219) SP-2. The database was converted to Access
2002 file format by the Windows 2000 system and works correctly. The XP
version does not; it apparently thinks 'trim()' is a variable and
requests an input value from the user. The two databases are identical
(byte for byte). The options for Access on the two systems are
identical.

I suspect that something is not loaded correctly or not loaded at all on
the XP system but I don't know where to look. I thought I should have
some of idea of what the real problem is before I blindly reload Access
on the XP system.

Any ideas would be greatly appreciated.

Thanks,
Dave

*************** *************** **
Dave Bovey
de*****@netzero .com
*************** *************** **

Nov 12 '05 #2
> The problem is that when the database were moved to two other computers,
one worked correctly; the other one didn't.


This is likely a "references " issue and the following page at Doug Steele's web
site should help you out:

Access Reference Problems
http://members.rogers.com/douglas.j....nceErrors.html

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.o rg (See the Access FAQ at http://www.mvps.org/access)
NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<
Nov 12 '05 #3
Classic "Missing Reference" syndrome :-)

In the code window of the affected machine, select Tools->References,
see which is missing and fix.

--
A)bort, R)etry, I)nfluence with large hammer.
Nov 12 '05 #4
Have a look at Tools then References from a VBA module window. You may
find something is missing on your new PC.

Dave Bovey <La*********@ya hoo.com> wrote in message news:<40******* ********@netzer o.net>...
I created a church database in Access 97 that contain the typical Name,
Address, and Phone Number information fields. I had a number of
different reports to print query data in different formats.

I had a number of textboxes in the report designs that used the trim()
function to suppress printing of leading spaces. As an example, one of
the textboxes had the following:
=Trim([Address])
Basically, this is looking for a situation where someone accidentally
created spaces at the beginning of the address field and the report
suppresses the leading spaces for appearances. All the textboxes used
the trim() function which include some boxes that concatenated several
fields together.

The problem is that when the database were moved to two other computers,
one worked correctly; the other one didn't.

One system is XP, the other is 2000. Both are running identical version
of Access 2002 (10.4302.4219) SP-2. The database was converted to Access
2002 file format by the Windows 2000 system and works correctly. The XP
version does not; it apparently thinks 'trim()' is a variable and
requests an input value from the user. The two databases are identical
(byte for byte). The options for Access on the two systems are
identical.

I suspect that something is not loaded correctly or not loaded at all on
the XP system but I don't know where to look. I thought I should have
some of idea of what the real problem is before I blindly reload Access
on the XP system.

Any ideas would be greatly appreciated.

Thanks,
Dave

*************** *************** **
Dave Bovey
de*****@netzero .com
*************** *************** **

Nov 12 '05 #5
Many thanks for all the responses. One good answer is worth a thousand
guesses!

Thanks,
Dave

Dave Bovey wrote:
I created a church database in Access 97 ...

*************** *************** **
Dave Bovey
de*****@netzero .com
*************** *************** **


Nov 12 '05 #6

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

Similar topics

0
2810
by: mcp6453 | last post by:
I am trying to use Jack's FormMail script (http://www.dtheatre.com/scripts/formmail). Since I'm brand new at PHP and not very good at HTML, I have an easy question, which I will narrow down. When the email arrives, it has this information: v_firstname: asdf v_lastname: asdf b_email: asdf@bellsouth.net v_phone: asdf v_cellphone: asdf
1
1377
by: Manu Ashok | last post by:
can any body help me with this........... i donno what's happening.....the value enterd is not being trimmed.....it leaves the blank spaces as it is in the form. <SCRIPT language=javascript> function trim(inputString) { if (typeof inputString != "string") { return inputString;
0
1181
by: John | last post by:
When I enter data into my access db through the gui, my SQL Query recognizes the data it is looking for and returns the result. ie I enter "Dog" through the Access GUI and when my SQL query asks for "Dog" it returns all the records with "Dog" in it. The problem is if I enter "Dog" through my ASP web interface to exactly the same database, I can see "Dog" in the table through the gui, however when I run the SQL query, it only returns...
2
3819
by: Chris Millar | last post by:
Can anyone help me on converting this vb asp page to C#, thanks in advance. chris. <!DOCTYPE HTML PUBLIC "-//W3C//Dtd HTML 4.0 transitional//EN"> <% '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ''
1
3729
by: Rahul | last post by:
Hi Everybody I have some problem in my script. please help me. This is script file. I have one *.inq file. I want run this script in XML files. But this script errors shows . If u want i am attach this script files and inq files. I cant understand this error. Please suggest me. You can talk with my yahoo id b_sahoo1@yahoo.com. Now i am online. Plz....Plz..Plz...
0
5294
by: Johan Neidenmark | last post by:
When i try to run this SQL statements in iSeries Access for windows (against my customers db2) i get: SQL State: 42904 Vendor Code: -7032 Message: SQL procedure, function, or trigger GET_INVENTORY_SEQUENCE in BPCSAX_PRD not created. Cause . . . . . : SQL procedure, function, or trigger GET_INVENTORY_SEQUENCE in BPCSAX_PRD was not created. The compile was not successful. SQL creates an SQL procedure, function, or trigger as a C program...
7
2307
by: William (Tamarside) | last post by:
Please, if you have the time and knowledge to help me I'd truly appreciate it! I need to build a calendar page that displays available/unavailable info from a DB and colour a cell according to that info, but somewhere I've gone completely off the rails! Basically it is a room availability page for an intranet and should simply colour a calendar cell red if the room is booked, or green if it isn't. Rooms are typically booked by lecturers...
3
2219
by: ibeehbk | last post by:
Hi. I have a form made in xhtml. I test via vbscript to make sure none of the fields are empty and properly formatted (ie email). All the regular fields work. However, I have two drop down menus that are SELECT elements (javascript-- one named arrivalcity and one named returncity). Basically they ask for a departure and return city and another menu appears with options based on that city. I can't seem to get the input from these fields in the...
5
4968
by: jrod11 | last post by:
hi, I found a jquery html table sorting code i have implemented. I am trying to figure out how to edit how many colums there are, but every time i remove code that I think controls how many colums there are, it crashes. There are currently 6 columns, and I only want 4. How do I remove the last two (discount and date)? Here is a link: http://www.jaredmoore.com/tablesorter/docs/salestable.html Here is some jquery js that I think...
0
11172
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10770
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10873
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9593
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7988
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7141
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5809
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4632
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3245
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.