473,326 Members | 2,114 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,326 software developers and data experts.

The Expression "On Load" you entered....

Hello all,

I recently inherited a SQL 7.0 Server db accessed by a 2000 Access interface.

When I try to open "Shipping Check Out" I am greeted with the following:

The expression On Load you entered as the event property
setting produced the following error: Syntax error.

*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.

I am not very good with code, but if someone could help me...

thanks,

Michelle
Nov 13 '05 #1
2 19386
Michelle, Could you post the code that is running when the form is loaded?

--
Reggie

----------
"Michelle" <ct*@e-sa.com> wrote in message
news:80**************************@posting.google.c om...
Hello all,

I recently inherited a SQL 7.0 Server db accessed by a 2000 Access interface.
When I try to open "Shipping Check Out" I am greeted with the following:

The expression On Load you entered as the event property
setting produced the following error: Syntax error.

*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.

I am not very good with code, but if someone could help me...

thanks,

Michelle

Nov 13 '05 #2
Open the database
Select a form in the database window,
Select View|Code from the Access menu.

In the code window,
Select Tools | References

Check to see if any reference is broken

Close the references window and
Select Debug | Compile

Check to see if any errors are shown

(david)
"Michelle" <ct*@e-sa.com> wrote in message
news:80**************************@posting.google.c om...
Hello all,

I recently inherited a SQL 7.0 Server db accessed by a 2000 Access interface.
When I try to open "Shipping Check Out" I am greeted with the following:

The expression On Load you entered as the event property
setting produced the following error: Syntax error.

*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.

I am not very good with code, but if someone could help me...

thanks,

Michelle

Nov 13 '05 #3

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

Similar topics

0
by: Thomas Reat | last post by:
The postgresql documentation claims that "on insert" rules are executed after the insert. This is not happening for me. I have a rule that is being executed even though the insert should have...
6
by: John Baker | last post by:
Hi: Does "On Open" code execute before or after related data is loaded? I want to test before the form appears on the screen to see if there is any data in the queryresult, and if there is not...
2
by: Danny | last post by:
Hello I am trying to create a separate listbox and fill it with items based on what is in another field in a database. This field is bound to a field in the underlying database. But the data...
1
by: Bob Alston | last post by:
I am trying to highlight required data fields in a continuous form situation. Got it working for all but date fields. For date fields, I am trying setting default date to -1 (=12/29/1899) and...
7
by: Aaron G via AccessMonster.com | last post by:
Wanted to share a solution to something which I didn't find on the net: EVERY form in my Microsoft Access 2002 database gave an error any time any code was to be called: form OnOpen, button...
0
by: jhonz | last post by:
I have come across a strange circumstance. I have user controls with dropdownlists that interact fine during times where the web server has minimal load. But once things pick up and postbacks...
2
by: Lenonardo | last post by:
Hi. I'm writing a VB.Net application to update multiple Excel Worksheets. I'm using late binding (i.e. all variables are objects + use createobject) I develop the application on an XP...
2
by: Serious_Practitioner | last post by:
Good day, and thank you in advance for any assistance. I'm having trouble with something that I'm trying for the first time. Using Access 2000 - I want to run a function either on the click of a...
4
by: lander | last post by:
I've read the page life cycle thing in msdn, still, i'm getting a bit confused of thinking how all the things are going under the hood... I know that when page loading, that the controls'...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
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...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
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 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.