Search results

Thanks for your help vbaInet, I sorted the problem by setting a couple of fields to Required (something I took away earlier for reasons I no longer recall). Now it can't go to a new record unless the previous one has data. Ray

Is does have a primary key. I suppose I am happy about it moving to a new record because I have never had this problem before. A quick spin of the mouse wheel at the end of the records is creating several blank records, I'm sure this is not normal/default behaviour. I must have...

Thanks vbaInet, but that does not deal with the issue. I have other forms on which I can mouse scroll and when I reach the last record it just stops, nothing happens but on one form mouse scrolling to the last record and beyond is creating new (blank) records. I have no default values in fields...

Version 2003

Hi All I've just discovered my mouse scroll wheel is creating new blank records when I scroll and I reach and pass the last record. I'm sure it wasn't doing this earlier in the development of my database. Can someone suggest reasons why it may be doing this so I can track it down and stop it...

Thanks Dave, solved. I had a bit of code being called by On Current all the time. Move it elsewhere. Cheers Ray

I suspected as much. Okay, I'll try your tip. Many Thanks. Ray

Hi All I am trying to use the following code on a form to record when the data in a record is modified: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo BeforeUpdate_Err ' Set bound controls to system date and time. UserModified = fOSLogin() DateModified =...

Thank you JANR. Problem solved. :)

Hi All I have two forms using the On Keypress event, one works fine, the other doesn't respond yet the code is identical. I have debugged but it simply doesn't fire when a key is pressed on the faulty form. My gut feeling is there is nothing wrong with the code (after all it works on the other...

Excellent Dave, a much neater solution. No need for the Function. Many thanks. Ray

Thanks for the reply Spikepl. I used debugging and discovered the code was fine but the filename of the doc was slightly different than in the code. Embarrassing. Cheers

Just to be clear, the attachments will be in their own folder within the folder holding the database .mdb

Hi All The code below attaches a word doc to an email and works fine: If recBookingQry("Workshop") = "Facilitated" And recBookingQry("OnSiteOffSite") = 1 Then .Attachments.Add ("\\barton\home\15311\Museum_Usage_Database\Attachments\Facilitated_Workshop_Visit_Confirmation_Form.doc")...

Thanks John. Problem solved, it wasn't nearly so complicated as I thought it was.

Thanks for that John, that page has helped me in the past. Just to clarify, form 2 is not a subform. It's just a small popup type form to ask you which method of response you want. My limited abilities suggest to me the answer lies with passing arguments, but maybe I'm wrong. Ray

Hi All I have a form (lets call it "form 1") on which are two buttons, one will print a letter, the other will send an email, you choose which to press depending on preference. The content of the email and letter comes from form 1. This all works fine. I would like to simplify the look of...

Hi JANR You solved it. Many thanks. The Bookings_ID field vanished from the query when I removed the criteria as it was a Where clause, I didn't notice before I post the DB. I take your point about the non-distinct records but those fields have to stay in because it forms part of my next...

Hi JANR Here is the database. I hope you can solved this one for me. Edit - go to forms and open frmLearning, you will see the button to send the email. I've just tried to use it and my pc froze up, so I may have missed something in this version. I'll review it to see what's up. Thank you.

Hi JANR Bookings_ID is a number field (autonumber, primary key) In the query the Bookings_ID field had the criteria [forms]![frmLearning]![txtBookings_ID] I've removed it as you asked and the click event sent an email BUT it will only send the last record, not the current. This is...