473,326 Members | 2,173 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.

Getting rid of #DELETE on form with application.echo

Hello,
I have a form linked to a table with a button that deletes the
currently selected record with a VBA sub. When I perform the delete
query, the data in the fields are replaced with #DELETE, something I
would rather not occur. I would really prefer that the fields just
appear blank. Sifting through some of the messages on this newsgroup
has revealed that setting something called application.echo equal to
false will prevent this from occuring. However, none of my
experimentation with application.echo has worked.

Basically, this is what I have tried to do (bear in my I have really
have no idea what I'm doing):

private sub delete ()
dim db as dao.database
set db = dbcurrent

dim strSQL as string
string = "Delete query stuff."

application.echo "false"
db.execute(strSQL)
application.echo "true"

end sub
Thanks for your help!
Swann
Nov 12 '05 #1
2 2408
Swann wrote:
Hello,
I have a form linked to a table with a button that deletes the
currently selected record with a VBA sub. When I perform the delete
query, the data in the fields are replaced with #DELETE, something I
would rather not occur. I would really prefer that the fields just
appear blank. Sifting through some of the messages on this newsgroup
has revealed that setting something called application.echo equal to
false will prevent this from occuring. However, none of my
experimentation with application.echo has worked.
Try requerying the recordset.
Basically, this is what I have tried to do (bear in my I have really
have no idea what I'm doing):

private sub delete ()
dim db as dao.database
set db = dbcurrent

dim strSQL as string
string = "Delete query stuff."

application.echo "false"
db.execute(strSQL)
application.echo "true"

end sub
Thanks for your help!
Swann


--
regards,

Bradley
Nov 12 '05 #2
Swann wrote:
Hello,
I have a form linked to a table with a button that deletes the
currently selected record with a VBA sub. When I perform the delete
query, the data in the fields are replaced with #DELETE, something I
would rather not occur. I would really prefer that the fields just
appear blank. Sifting through some of the messages on this newsgroup
has revealed that setting something called application.echo equal to
false will prevent this from occuring. However, none of my
experimentation with application.echo has worked.

Basically, this is what I have tried to do (bear in my I have really
have no idea what I'm doing):

private sub delete ()
dim db as dao.database
set db = dbcurrent

dim strSQL as string
string = "Delete query stuff."

application.echo "false"
db.execute(strSQL)
application.echo "true"

end sub
Thanks for your help!
Swann


Have you considered using the OnDelete event instead?

Nov 12 '05 #3

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

Similar topics

3
by: Boefje | last post by:
The variable contains: delete from divisies where divisieid='1c' After posting it contains: delete from divisies where divisieid= So the part '1c' is magically lost! How is that possible? This...
2
by: Swann | last post by:
Hello, I have a form linked to a table with a button that deletes the currently selected record with a VBA sub. When I perform the delete query, the data in the fields are replaced with #DELETE,...
9
by: Dejan | last post by:
Hy, Sorry for my terreble english I have this simple code for deleting rows in mysql table... Everything works fine with it. So, what do i wanna do...: my sql table looks something like...
1
by: bigabytes | last post by:
I'm just learning PHP (extreme novice) and I'm struggling with deleting records using a checkbox included within each row. I have a few idea but I'm not sure if my thoughts are correct. I think I...
8
by: prosad | last post by:
Hi! Have been hitting my head on the wall for two weeks now. am a php newbie. have a form that on submitting to a MySQL DB instantly generates a HTML table on the same page. what i need now is way...
4
imarkdesigns
by: imarkdesigns | last post by:
Hello everyone.. a newbie programmer here wants to ask why is my codes for deleting rows from my databse won't work.... seems that this codes spread to the net and no one refuse to correct it... ...
1
by: chocciies | last post by:
Hi! I want to delete multiple record via checkboxes. However, with no success. Is there sthg wrong with the value of my checkbox? Your help will be greatly appreciated. Thanks! <form...
2
by: DavidPr | last post by:
PHP Version 5.2.3 MySQL version - 5.0.45 magic_quotes_gpc - On I'm using the edit script below. When the form is displayed with the information to be edited - if there is a single quote in...
1
by: ahilar12 | last post by:
Hi all, I am new to php,my question is that in this following code i am retrieving many rows from the database which is working good.i want to delete a particular row(s) which is checked(checkbox)...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.