Search results

  1. imperator

    Mouse scroll wheel is creating new records

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

    Before update is called when only viewing a record

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

    On Keypress not working

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

    CurrentDB path

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

    Run a procedure from a second form

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

    Send current record to Outlook

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

    Open form from selected record on datasheet

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

    Free Development software

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

    Unique ID field

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

    Access VBA vs. VB .Net

    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...
Back
Top Bottom