Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    2
    Views
    396

    Re: Disable Mouse Wheel (2003)

    Thanks, I'll try that
    Allison
  2. Replies
    2
    Views
    1,151

    Re: Shell to Excel (2003)

    Thanks - fixed!
    Allison
  3. Replies
    2
    Views
    1,151

    Shell to Excel (2003)

    I have a folder with a space in the name called Performance Information.
    The command
    Shell "EXCEL.EXE charliedocumentsPerformance Information18WeekMonitoring.xls", vbNormalFocus
    tries to open a...
  4. Replies
    2
    Views
    396

    Disable Mouse Wheel (2003)

    Is there any way to disable the mouse wheel within Access to stop it scrolling between records accidently? Preferable so that only affects the one form (ie so that scrolling is still allowed when...
  5. Replies
    6
    Views
    512

    Re: SQL Update Query (2003)

    Thanks, I'll try that
    Allison
  6. Replies
    6
    Views
    512

    Re: SQL Update Query (2003)

    No, now it reckons that there is;
    Incorrect syntax near the keyword 'INNER'
    on Line 2
  7. Replies
    6
    Views
    512

    Re: SQL Update Query (2003)

    Having taken out the 'from' statement, I still get the same error
    Allison
  8. Replies
    6
    Views
    512

    SQL Update Query (2003)

    I have another probelm; The following query,

    UPDATE WSH18Week.dbo.TblAppointmentsWithPPI
    SET WSH18Week.dbo.TblAppointmentsWithPPI.PPI = WSH18Week.dbo.TblAppointmentsWithPPI.CRN + ...
  9. Replies
    8
    Views
    546

    Re: SQL Queries (2003)

    Yes, I am using 2 different databases, so that accounts for it - thanks again. (I expect I'll have more queries!)
    Allison
  10. Replies
    8
    Views
    546

    Re: SQL Queries (2003)

    Thanks, that's a clear explaination - I have had a look round the internet and couldn't figure out what it meant. Does that mean there is something wrong - ie set up incorrectly - with one of the...
  11. Replies
    8
    Views
    546

    Re: SQL Queries (2003)

    Thanks - that's done it. why does that work?
    Allison
  12. Replies
    8
    Views
    546

    Re: SQL Queries (2003)

    Thanks - it had to be something simple.
    BUT I now get the error "Cannot resolve collation conflict for equal to operation."
  13. Replies
    8
    Views
    546

    SQL Queries (2003)

    Sorry if this is in the wrong place, but: I can't find the correct forum.
    I am trying to move a series of queries into SQL. The syntax for the Access query doesn't work in Enterprise Manager. The...
  14. Replies
    4
    Views
    479

    Re: Updating & Links (2003)

    Thanks for this - I was using Output to... instead of transfer spreadsheet - I now know the difference!
    Allison
  15. Replies
    4
    Views
    479

    Re: Updating & Links (2003)

    Doesn't the export from Access overwrite the old file? That was why I kept the data file separate from the formatted version.
    Thanks for the other bit of code, that's soved one problem!
    Allison
  16. Replies
    4
    Views
    479

    Updating & Links (2003)

    I have a macro in Access that outputs to a spreadsheet in Excel. This is then linked (so I can format the cells) into a second spreadsheet. The problem I have is that firstly, the second...
  17. Replies
    3
    Views
    492

    Re: Detecting cells (2003)

    Thanks
    Allison
  18. Replies
    3
    Views
    492

    Detecting cells (2003)

    Is there any way I can detect that a cell is clicked - so that when a user clicks in a cell it runs a macro, based on the contents of the clicked cell?
    Thanks
  19. Replies
    2
    Views
    306

    Re: Filters on Multiple Combo Boxes (2003)

    Thanks you very much
    Allison
  20. Replies
    2
    Views
    306

    Filters on Multiple Combo Boxes (2003)

    How do I filter records with multiple combo boxes on a Form, so that when selections are made from say more than 1 combo boxes at the same time, they work together like AND statements, but if they...
  21. Replies
    2
    Views
    315

    Re: Option Groups (2003)

    Thank you - it was the yes/no field type that was the problem!
    Allison
  22. Replies
    2
    Views
    315

    Option Groups (2003)

    when using an option group is there anyway to make all the buttons appear unchecked unless one of them is physically clicked.
    Once the user has started to enter the data the lowest value button is...
  23. Replies
    2
    Views
    359

    Re: Linking Tables (2003)

    Thanks, that's just what I wanted!
    Allison
  24. Replies
    2
    Views
    359

    Linking Tables (2003)

    I have a set of tables where the link has to be changed on a monthly basis. The path to these tables stays more or less the same, but with just the month name changing. Is there anyway I can change...
  25. Replies
    2
    Views
    310

    Re: Sub-form records (2000)

    Thanks - yes there was a errant bit of code
    Allison
Results 1 to 25 of 134
Page 1 of 6 1 2 3 4