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

SQL utility form for Access

P: n/a
Jim
Last year I downloaded a form that can be put in an Acces database that
writes SQL text for VB. I have it in an older database but it won't work in
my current project. I get an error message ("The expression After Update
you entered as the event property setting produced the following error:
Variable not defined.") when I try to use it. The form in my db is named
frmSearch... I think I downloaded it that way. I am using XP now and was
using 2000 last year.

Anyone recognize the utility? My apologies to the creator... it worked
great last year and I really need it now!

Thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies

P: n/a
An****************@See.Comment.Header (Paul Simone) wrote:
I think maybe that the searchxp.zip or frmsearch2.zip -- or just look
through the search section at


Do NOT click on the above URL.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #2

P: n/a


Tony Toews wrote:
An****************@See.Comment.Header (Paul Simone) wrote:
I think maybe that the searchxp.zip or frmsearch2.zip -- or just look
through the search section at


Do NOT click on the above URL.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm


Nov 12 '05 #3

P: n/a
Jim,
I don't know if this is what you want:

SQL2Var is a util to format a SQL-string to a var.
SQL2VB is a util that creates a form from a table

Both can easily be found just by typing their names in a Google-search
--
Hope this helps
Arno R

"Jim" <ji******@REMOVETHISkc.rr.com> schreef in bericht
news:zR*********************@twister.rdc-kc.rr.com...
Last year I downloaded a form that can be put in an Acces database that
writes SQL text for VB. I have it in an older database but it won't work in
my current project. I get an error message ("The expression After Update
you entered as the event property setting produced the following error:
Variable not defined.") when I try to use it. The form in my db is named
frmSearch... I think I downloaded it that way. I am using XP now and was
using 2000 last year.

Anyone recognize the utility? My apologies to the creator... it worked
great last year and I really need it now!

Thanks in advance.

Nov 12 '05 #4

P: n/a
I'm not sure what you're referring to, but here's an addin I made that
does what you describe

http://amazecreations.com/datafast/G...astUtility.zip

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"Jim" <ji******@REMOVETHISkc.rr.com> wrote in message news:zR*********************@twister.rdc-kc.rr.com...
Last year I downloaded a form that can be put in an Acces database that
writes SQL text for VB. I have it in an older database but it won't work in
my current project. I get an error message ("The expression After Update
you entered as the event property setting produced the following error:
Variable not defined.") when I try to use it. The form in my db is named
frmSearch... I think I downloaded it that way. I am using XP now and was
using 2000 last year.

Anyone recognize the utility? My apologies to the creator... it worked
great last year and I really need it now!

Thanks in advance.

Nov 12 '05 #5

P: n/a
"Jack Tripoli" <ja**********@verizon.net> wrote in message
news:LJ**********************@bogg.dynu.com...
I think maybe that the searchxp.zip
or frmsearch2.zip -- or just look
through the search section at
http://xxx.xxxx-xxxxx.xxx/xxxxx


Clicking on the URL in "Jack Tripoli's" message will lead you to an unending
chain of popups of scat port. Right-clicking on "Jack's" message and
choosing Properties will reveal that it is posted via an Anonymizer and a
mail-to-news service. You can include the headers, and forward the message,
with a polite complaint to both services. If enough ask them, they might
even block this newsgroup as a destination for anonymized posts.
Nov 12 '05 #6

P: n/a
bo*****@localhost.not (Larry Linson) wrote in
<5R**************@nwrddc01.gnilink.net>:
"Jack Tripoli" <ja**********@verizon.net> wrote in message
news:LJ**********************@bogg.dynu.com...
I think maybe that the searchxp.zip
or frmsearch2.zip -- or just look
through the search section at
http://xxx.xxxx-xxxxx.xxx/xxxxx


Clicking on the URL in "Jack Tripoli's" message will lead you to
an unending chain of popups of scat port. Right-clicking on
"Jack's" message and choosing Properties will reveal that it is
posted via an Anonymizer and a mail-to-news service. You can
include the headers, and forward the message, with a polite
complaint to both services. If enough ask them, they might even
block this newsgroup as a destination for anonymized posts.


Uh, Larry, you're being pretty parochial in the advice you're
giving. Not everyone is reading with a newsreader that requires
right clicking on anything to get information about who posted the
messages.

I use xNews, which is a dedicated newsreader, and vastly superior
to Outlook Express. It is a free download.

In regard to the popups, no one has to put up with unrequested
popups. If you insist on using a browser that doesn't give you
control over unrequested popups, like both Mozilla and Opera do,
then you might try the Google Toolbar for IE, which gives you the
ability to block popups.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.