By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,460 Members | 2,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,460 IT Pros & Developers. It's quick & easy.

Help!! Absolutely baffled ...

P: n/a
Hi all ...

I have an Access XP application that works fine at 8 separate locations.

The 9th location however has all sorts of strange things happening.

For example, as a test, I created a new database and made one form with 2
textboxes. I added the following functions behind the form:

Function SetBack()
Me.ActiveControl.BackColor = 8454016
End Function

Function ReSetBack()
Me.ActiveControl.BackColor = -2147483643
End Function

In the two textboxes gotfocus events, I've added =Setback(). In the
lostfocus events, I've added =ResetBack()

The functions are called as expected, however 'after' the backcolor has been
successfully changed, I then get an error:

"The expression On Got Focus you entered as the event property setting
produced the following error: The expression you entered contains invalid
syntax. * The expression may not result in the name of a macro, the name of
a user-defined function, or [Event Procedure]. * There may have been an
error evaluating the function, event, or macro."

Can anyone clue me in on what's wrong? I've tried installing/uninstalling
Access. This same code works fine at ALL the other locations.

Your help is greatly appreciated.
--Terry
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/23/2003
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
By the way, it's running on Windows 2000 Server machine which is also
running Terminal Services. The problem occurs regardless of whether I'm
running from a Terminal OR logged in as Administrator at the server.

Thanks again,
--Terry
Hi all ...

I have an Access XP application that works fine at 8 separate locations.

The 9th location however has all sorts of strange things happening.

For example, as a test, I created a new database and made one form with 2
textboxes. I added the following functions behind the form:

Function SetBack()
Me.ActiveControl.BackColor = 8454016
End Function

Function ReSetBack()
Me.ActiveControl.BackColor = -2147483643
End Function

In the two textboxes gotfocus events, I've added =Setback(). In the
lostfocus events, I've added =ResetBack()

The functions are called as expected, however 'after' the backcolor has been successfully changed, I then get an error:

"The expression On Got Focus you entered as the event property setting
produced the following error: The expression you entered contains invalid
syntax. * The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. * There may have been an
error evaluating the function, event, or macro."

Can anyone clue me in on what's wrong? I've tried installing/uninstalling
Access. This same code works fine at ALL the other locations.

Your help is greatly appreciated.
--Terry
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/23/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/23/2003
Nov 12 '05 #2

P: n/a
Terry,

Check the verions of the references on the one of the computers that
works vs the one problem machine. You can check the references by
opening a module and clicking on the "Tool" menu then references. My
guess is you have a newer/older or missing reference library. Find
which one, then copy it to the machine with the trouble.

Hope this helps!
Mark

"JustMe" <te******@sasktel.net> wrote in message news:<vn************@corp.supernews.com>...
Hi all ...

I have an Access XP application that works fine at 8 separate locations.

The 9th location however has all sorts of strange things happening.

For example, as a test, I created a new database and made one form with 2
textboxes. I added the following functions behind the form:

Function SetBack()
Me.ActiveControl.BackColor = 8454016
End Function

Function ReSetBack()
Me.ActiveControl.BackColor = -2147483643
End Function

In the two textboxes gotfocus events, I've added =Setback(). In the
lostfocus events, I've added =ResetBack()

The functions are called as expected, however 'after' the backcolor has been
successfully changed, I then get an error:

"The expression On Got Focus you entered as the event property setting
produced the following error: The expression you entered contains invalid
syntax. * The expression may not result in the name of a macro, the name of
a user-defined function, or [Event Procedure]. * There may have been an
error evaluating the function, event, or macro."

Can anyone clue me in on what's wrong? I've tried installing/uninstalling
Access. This same code works fine at ALL the other locations.

Your help is greatly appreciated.
--Terry
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/23/2003

Nov 12 '05 #3

P: n/a
Hi Mark ...

THanks for your reply. Unfortunately that wasn't it. I've already checked
the references (even copied known good copies from one working machine to
this machine) with no success.

Any further ideas?

THanks,
--Terry
"mgoodrum" <mg******@aol.com> wrote in message
news:69**************************@posting.google.c om...
Terry,

Check the verions of the references on the one of the computers that
works vs the one problem machine. You can check the references by
opening a module and clicking on the "Tool" menu then references. My
guess is you have a newer/older or missing reference library. Find
which one, then copy it to the machine with the trouble.

Hope this helps!
Mark

"JustMe" <te******@sasktel.net> wrote in message

news:<vn************@corp.supernews.com>...
Hi all ...

I have an Access XP application that works fine at 8 separate locations.

The 9th location however has all sorts of strange things happening.

For example, as a test, I created a new database and made one form with 2 textboxes. I added the following functions behind the form:

Function SetBack()
Me.ActiveControl.BackColor = 8454016
End Function

Function ReSetBack()
Me.ActiveControl.BackColor = -2147483643
End Function

In the two textboxes gotfocus events, I've added =Setback(). In the
lostfocus events, I've added =ResetBack()

The functions are called as expected, however 'after' the backcolor has been successfully changed, I then get an error:

"The expression On Got Focus you entered as the event property setting
produced the following error: The expression you entered contains invalid syntax. * The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. * There may have been an
error evaluating the function, event, or macro."

Can anyone clue me in on what's wrong? I've tried installing/uninstalling Access. This same code works fine at ALL the other locations.

Your help is greatly appreciated.
--Terry
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/23/2003

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/24/2003
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.