fields populated by error (2nd post)

  • Thread starter Thread starter Richard
  • Start date Start date
R

Richard

Hi

I have a form which on exit (for new records), all the fields will be
populated be the word "error" but it does save the record. Why is it so?

This is the code for the onexit event (different forms may open this form to
add data)


Private Sub exit_Click()
On Error Resume Next
DoCmd.Close
Forms!contacts!companyid.Requery
Forms![Enrolments]![COMPANY].Requery
Forms![Roombooking]![COMPANY].Requery

End Sub

Thanks in advance

Richard
 
well, since this is your 2nd posting of this question and
nobody has posted back to it yet, i'll take a look at your
db and see if i can figure it out - if you want to email a
copy to me. if so, copy your db, delete proprietary data,
compact, zip if necessary to no more than 1 MB, and send
it along.
 
Thanks Tina for your help

Will see if I can compact it to below 1mb

Richard

tina said:
well, since this is your 2nd posting of this question and
nobody has posted back to it yet, i'll take a look at your
db and see if i can figure it out - if you want to email a
copy to me. if so, copy your db, delete proprietary data,
compact, zip if necessary to no more than 1 MB, and send
it along.


-----Original Message-----
Hi

I have a form which on exit (for new records), all the fields will be
populated be the word "error" but it does save the record. Why is it so?

This is the code for the onexit event (different forms may open this form to
add data)


Private Sub exit_Click()
On Error Resume Next
DoCmd.Close
Forms!contacts!companyid.Requery
Forms![Enrolments]![COMPANY].Requery
Forms![Roombooking]![COMPANY].Requery

End Sub

Thanks in advance

Richard




.
Click to expand...
Click to expand...
 
Hi Tina

I am still working on how to minimise the db. The error doesn't show in the
mdb (the one I'm using) but it shows on the mde files. Does this help?

Thanks again in advance

Richard

--


tina said:
well, since this is your 2nd posting of this question and
nobody has posted back to it yet, i'll take a look at your
db and see if i can figure it out - if you want to email a
copy to me. if so, copy your db, delete proprietary data,
compact, zip if necessary to no more than 1 MB, and send
it along.


-----Original Message-----
Hi

I have a form which on exit (for new records), all the fields will be
populated be the word "error" but it does save the record. Why is it so?

This is the code for the onexit event (different forms may open this form to
add data)


Private Sub exit_Click()
On Error Resume Next
DoCmd.Close
Forms!contacts!companyid.Requery
Forms![Enrolments]![COMPANY].Requery
Forms![Roombooking]![COMPANY].Requery

End Sub

Thanks in advance

Richard




.
Click to expand...
Click to expand...
 
hmmm, unfortunately no. i've never had a .mde file present
an error that did not occur in the .mdb file.
your db must be fairly large; if you've removed excess
data, suggest you remove forms that are not related to the
form you're having trouble with, and remove reports. sorry
for the inconvenience, my email has fits with large
attachments; we can bump the file size up to "under 2 MB"
and just cross our fingers that i can download it, if that
will help.
suggest you email me directly re anything further on this
thread - no point cluttering up the newsgroup.

-----Original Message-----
Hi Tina

I am still working on how to minimise the db. The error doesn't show in the
mdb (the one I'm using) but it shows on the mde files. Does this help?

Thanks again in advance

Richard

--


tina said:
well, since this is your 2nd posting of this question and
nobody has posted back to it yet, i'll take a look at your
db and see if i can figure it out - if you want to email a
copy to me. if so, copy your db, delete proprietary data,
compact, zip if necessary to no more than 1 MB, and send
it along.


-----Original Message-----
Hi

I have a form which on exit (for new records), all the fields will be
populated be the word "error" but it does save the record. Why is it so?

This is the code for the onexit event (different forms may open this form to
add data)


Private Sub exit_Click()
On Error Resume Next
DoCmd.Close
Forms!contacts!companyid.Requery
Forms![Enrolments]![COMPANY].Requery
Forms![Roombooking]![COMPANY].Requery

End Sub

Thanks in advance

Richard




.
Click to expand...
Click to expand...


.
Click to expand...
 
oops, accidentally deleted your email, so i don't have
your email address. i'll use the one you entered here in
the newsgroups, i hope it's valid.

-----Original Message-----
Thanks Tina for your help

Will see if I can compact it to below 1mb

Richard

tina said:
well, since this is your 2nd posting of this question and
nobody has posted back to it yet, i'll take a look at your
db and see if i can figure it out - if you want to email a
copy to me. if so, copy your db, delete proprietary data,
compact, zip if necessary to no more than 1 MB, and send
it along.


-----Original Message-----
Hi

I have a form which on exit (for new records), all the fields will be
populated be the word "error" but it does save the record. Why is it so?

This is the code for the onexit event (different forms may open this form to
add data)


Private Sub exit_Click()
On Error Resume Next
DoCmd.Close
Forms!contacts!companyid.Requery
Forms![Enrolments]![COMPANY].Requery
Forms![Roombooking]![COMPANY].Requery

End Sub

Thanks in advance

Richard




.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top