dbTalk Databases Forums  

Access 97 Passing NULL Value Instead of Actual Value

comp.database.ms-access comp.database.ms-access


Discuss Access 97 Passing NULL Value Instead of Actual Value in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rich G
 
Posts: n/a

Default Access 97 Passing NULL Value Instead of Actual Value - 07-09-2003 , 11:48 AM






Hi All,

Have you ever seen this problem with Access 97 running on Win2K?

From my Access application, a user enters information into two fields
and then clicks on a button that launches their web browser and sends
them to a specific URL. The query string of the URL contains the
information the user entered in those fields. A normal URL looks
something like:
http://127.0.0.1/display.jsp?name1=val1&name2=val2

In a lot instances after the user enters the information in the two
fields and clicks on the button, the values that the user entered are
NULL instead of the proper values. So the URL looks something like:
http://127.0.0.1/display.jsp?name1=null&name2=null

Sometimes it works fine the first time the user clicks the button.
Sometimes it takes 3 or 4 clicks of the button before the application
sends the information correctly in the URL. There is no consistency
to the problem and I am having a hard time figuring it out.

If it helps at all, I am making a call to Application.FollowHyperlink
in my Access application to send the user to the URL, although I do
not suspect that to be the problem.

Thanks in advance for any help.
Rich

Reply With Quote
  #2  
Old   
Ira Solomon
 
Posts: n/a

Default Re: Access 97 Passing NULL Value Instead of Actual Value - 07-09-2003 , 05:51 PM






Rich:
Could you send the exact code you are using?
Good Luck
Ira Solomon
On 9 Jul 2003 09:48:24 -0700, dejagroup (AT) yahoo (DOT) com (Rich G) wrote:

Quote:
Hi All,

Have you ever seen this problem with Access 97 running on Win2K?

From my Access application, a user enters information into two fields
and then clicks on a button that launches their web browser and sends
them to a specific URL. The query string of the URL contains the
information the user entered in those fields. A normal URL looks
something like:
http://127.0.0.1/display.jsp?name1=val1&name2=val2

In a lot instances after the user enters the information in the two
fields and clicks on the button, the values that the user entered are
NULL instead of the proper values. So the URL looks something like:
http://127.0.0.1/display.jsp?name1=null&name2=null

Sometimes it works fine the first time the user clicks the button.
Sometimes it takes 3 or 4 clicks of the button before the application
sends the information correctly in the URL. There is no consistency
to the problem and I am having a hard time figuring it out.

If it helps at all, I am making a call to Application.FollowHyperlink
in my Access application to send the user to the URL, although I do
not suspect that to be the problem.

Thanks in advance for any help.
Rich


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.