Posted on 2004-04-27
I'm an Access novice...
I'm trying to edit an Access program I've been sent in which for a reason I can't understand there are sections shown in the VB editor that the author doesn't have in his original.
When I call up the editor in the DB I get a top section: Option compare database
Then I get a section: Private Sub Command1_Click()
(that's the bit of the program I want to keep)
I also get an Adtext section:
Private Sub AdText_BeforeUpdate(Cancel As Integer)
... a Detail section
Private Sub Detail_Click()
and a Form section:
Private Sub Form_Load()
and another weird one -
Private Sub ÊÓãíÉ9_Click()
None of these were in the file at source. i don't know how they crept in or if they are responsible for the fact that the file doesn't work.
I can see how I can call up these functions in the right hand column, but I can't see how to get rid of them. just effacing them and saving doesn't do anything. When I open the file again, there they are!
I'm actually trying to find the best way of incorporating data coming in from a web forms page either by email or some other method - I've been playing around with asp but it seems to need to be installed on a paying server... cgi-bin etc
I'm open to any suggestions as to the best way of doing this but at the moment I'd be very happy if I could automatically point Access at the email replies (saved into Word or excel files if necessary)
They come in like this
Any help gratefully accepted
All the best