Search results

  1. I

    SQL Query is making me tear what little hair I have left out.

    Afternoon all. I'm running my own report on the database. This is basically a SQL query constructed depending upon options on the form. All works great and I have it saving to the person's desktop and opening in Excel automatically. I'm recreating the Querydef each time; So creating this...
  2. I

    Check Query Exists?

    How would I check programmatically that a querydef already exists. I.e. something along these lines: If Db.QueryDefs(strQueryDef).Exist = False Then Set QD = Db.CreateQueryDef(strQueryDef, strSQL) Else ..... and so on. It's the If line I'm interested in. strQueryDef is a...
  3. I

    Emboldening a string...

    This is where I'm at at the moment: If Who = "SSR" Then Dim mess_body, Email, boldmess As String Dim appOutLook, MailOutLook Email = "Me" Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook =...
  4. I

    Emailing within Access - 'From' Field?

    I have the following code: Dim mess_body As String Dim appOutLook Dim Email As String Dim MailOutLook Email = MPTM Set appOutLook = CreateObject("Outlook.Application") Set MailOutLook = appOutLook.CreateItem(olMailItem)...
  5. I

    Preventing Record Navigation

    When opening a form based upon a table, it is possible to prevent the user from navigating to other records? I've changed the properties so the navigator buttons don't appear on the form however scrolling the click wheel still cycles through the records. I need to prevent this from happening...
  6. I

    Record Lock Status & Exist Query

    Afternoon. I have had a search through the forum however am unable to find anything... I have two questions: a) How do I check whether someone else is currently accessing a record / form? i.e. Opening the form (SchemeDetails) like this: DoCmd.OpenForm "SchemeDetails", acNormal, "", ""...
Back
Top Bottom