Search results

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...

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 =...

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...

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")...

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 All Below is a click event which sends the data in a query to Outlook and emails it. It works a charm though I'm sure it lacks programming finesse as I am a novice, but books and the web have got me this far. My question is this: the click event is on a form showing one record, how can I...

Hi all I have a form which lists records from a search in a datasheet view. I want to open another form based on a selected record from that search. I have achieved this with DoCmd.OpenForm "frmClient", acNormal, , "[ClientID] = " & Me.frmsubClients![ClientID] but the client also has...

Apologies to the moderators for posting here but I wanted many to see this. http://downloads.channel8.msdn.com/Default.aspx Follow this link for free software, the titles are listed below. There are two requirements, 1. You must be a student. 2. You need a hotmail type passport, you know what I...

Hi all I have been discussing DB table design with a colleague and we have a difference of opinion with regards to primary key ID fields . My argument is that they should not be actual data but separate, that is an unique record identifier typically an autonumber type. I'm sure I picked this up...

I'm a newbie with a simple question for the experts. Say you wanted to build a database for distribution that was multiuser and worked over a server; given a choice would you build a database entirely in Access using modules for full functionalitly, or use VB .Net to develop the forms and code...