Well, in VB this works:
db.Execute ("DELETE FROM students WHERE studentCode = 'somecode'")
Of course DB is the name *I* chose in my program for the database
connection. I have no idea what name Access uses for it's own self
generated forms, and I've spent some amount of time trying to find out!
Well, in VB this works:
db.Execute ("DELETE FROM students WHERE studentCode = 'somecode'")
Of course DB is the name *I* chose in my program for the database
connection. I have no idea what name Access uses for it's own self
generated forms, and I've spent some amount of time trying to find out!
However, my problem gets a bit more complicated now. I've
designed a delete query and it works fine, but i want to
put that query on a form...somehow. I tried assigning it
to a command button, but it won't let me select the
delete query. I was thinking maybe Access won't let u
put a delete query on a form???
Its all ok, i found it. The wizard never allowed me to
select the delete query, so i selected another query, went
into the code, and changed the name of the selected query
to the one that i wanted. Thanx Adrian for you help!!
However, my problem gets a bit more complicated now. I've
designed a delete query and it works fine, but i want to
put that query on a form...somehow. I tried assigning it
to a command button, but it won't let me select the
delete query. I was thinking maybe Access won't let u
put a delete query on a form???
The wizards (and the Documenter) apparently can't see delete queries.
It's a bug.
What you can do is use the wizard; pick some query that you *can* see;
then go into the VBA editor and edit the button's Click event code to
change the name of the query that's being executed.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
