Search:

Type: Posts; User: kentg; Keyword(s):

Page 1 of 16 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    962

    Rule for Subject "Re:"

    I get a lot of spam with the Subject "Re:"

    the body of the email varies so I can't pin down a rule there.

    The outlook rules only seem to allow a 'With [text] in the Subject'.

    Is there a way...
  2. Replies
    6
    Views
    6,445

    Where is the Style manager in 2010

    I want to import styles from another document but can't find where they've hidded the old style manager.
    Where the * is it?
  3. Replies
    2
    Views
    4,083

    The contols are currently grouped in Layout so in...

    The contols are currently grouped in Layout so in design view -

    Select the control, right click>slelect row

    Now right click again Layout>remove Layout.

    The controls are now independent.
  4. Replies
    19
    Views
    3,320

    I really like the improvements in 2010. There is...

    I really like the improvements in 2010. There is nothing I don't like about it.
    I'm using the 32 bit version

    Major Likes -
    The ease of modifying the ribbon. You can put stuff where you want it....
  5. Replies
    6
    Views
    8,263

    It is entirely possible and indeed most probable,...

    It is entirely possible and indeed most probable,

    This notebook is using MS security essentials whereas my PC was using ZoneAlarm.

    I'll check it out, thanks.
  6. Replies
    5
    Views
    702

    Setting a forms modal property in design view is...

    Setting a forms modal property in design view is a waste of time, it just makes it hard to Switch from from view to design view.

    And only opens Modally if you open it from the database window /...
  7. Replies
    6
    Views
    8,263

    Outlook on my laptop (Win 7 Office 2010) is not...

    Outlook on my laptop (Win 7 Office 2010) is not displaying images.

    I've unchecked "Don't download pictures automatically..." in Trust Center settings and now there is no right click option to...
  8. Replies
    4
    Views
    625

    Thanks

    Thanks
  9. Replies
    4
    Views
    625

    If I grab a cell and drag it, sometimes Excell...

    If I grab a cell and drag it, sometimes Excell increments numeric values (even if they are on the end of a string) and sometimes it doesn't. Sometimes I want it to and other times not.

    What...
  10. Once you've done what John suggests then you can...

    Once you've done what John suggests then you can use a WHERE clause to show just mother with kids or mothers without kids
    eg for Mothers without kids

    SELECT * FROM Mothers WHERE ChildID Is Null
  11. Replies
    8
    Views
    1,071

    if you put MsgBox Me.Name in the open event...

    if you put

    MsgBox Me.Name
    in the open event it will display the form name

    so as RetiredGeek suggest, passing either the name of the form from the Open event


    If DoWhatever(Me.Name) Then
  12. Hi Jason, I guess you have a table with the...

    Hi Jason,

    I guess you have a table with the template names in it.

    Now add another table with a list of variables required for each template.

    Now you can have a form where the user selects...
  13. what do you mean "modify" Do you mean you want...

    what do you mean "modify"

    Do you mean you want them to enter a value for the variables?

    Or do you mean you want them to be able to change the name of the field being used?
  14. Thread: VBA help

    by kentg
    Replies
    1
    Views
    450

    you might like to give your button a meaningfull...

    you might like to give your button a meaningfull name instead of just leaving it as 'Command92'.

    try this

    On Error Resume Next

    Do Until Err.Number <> 0
    DoCmd.OpenReport "Agent Report...
  15. Contrary to what I previously said, and although...

    Contrary to what I previously said, and although I haven't tried it, you can have multiple criteria in the subform links if you separate them by a semicolon.
    you may like to try that.
  16. Replies
    9
    Views
    2,348

    Does it populate the BCT when you select a...

    Does it populate the BCT when you select a system?

    The before insert won't fire until you enter your first bit of data on the form.

    if you need it to populate when you move to a new record then...
  17. Replies
    9
    Views
    2,348

    the variables should be module level not global...

    the variables should be module level not global as they are only used by this form.

    Don't try and set the default property at runtime, it screws up in later versions of Access.

    the code behind...
  18. Replies
    9
    Views
    2,348

    I actually put the code in cmdNew_Click not in...

    I actually put the code in cmdNew_Click not in the Form_BeforeUpdate event, see if this makes a difference.
  19. Replies
    9
    Views
    2,348

    strEBC_Code should be a module level variable and...

    strEBC_Code should be a module level variable and you should name it mstrEBC_Code to make this obvious in your code.

    a better test for Not isnull(strEBC_Code) would be to concatenate the...
  20. Replies
    4
    Views
    527

    using the criteria when you open the form is the...

    using the criteria when you open the form is the best way to do this, so stick with what you have. I assume [State] is a long integer? Just a tip but to make your code easier to understand you should...
  21. Replies
    16
    Views
    4,220

    or you can just open the query in code to run it...

    or you can just open the query in code to run it but set warnings to false first to suppress the message.

    DoCmd.SetWarnings False
    DoCmd.OpenQuery "qryAppendStuff"
    DoCmd.SetWarnings True
  22. Thread: table locked?

    by kentg
    Replies
    5
    Views
    802

    You could try using the substitue command to...

    You could try using the substitue command to create a Z drive. I've done this in the past and it works fine.

    create a batch file on your desktop


    subst z: "c:\my Documents"

    When you run it...
  23. Replies
    16
    Views
    4,220

    You can copy the sql from the append queries you...

    You can copy the sql from the append queries you created in the QBE, wrap them in quotes and use them like this -


    Dim strSQL As String

    strSQL = "INSERT INTO Travellers SELECT People.*...
  24. Replies
    7
    Views
    1,448

    What about using a continuous form with combo...

    What about using a continuous form with combo boxes in the header for filtering and command buttons in the header above each column to sort. You can then track the current filters and send them to...
  25. First you need to understand that dates are just...

    First you need to understand that dates are just numbers. In fact they are more or less double, so the time now is 40438.6782638889

    Anything to the left of the decimal point is the day, the...
Results 1 to 25 of 387
Page 1 of 16 1 2 3 4