Recent content by imperator

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.