Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    7
    Views
    526

    OK thanks.

    OK thanks.
  2. Replies
    7
    Views
    526

    Thanks for your replies. Yes, the Access front...

    Thanks for your replies.

    Yes, the Access front end is linked to the SQL database back end by ODBC.

    I tried adding an extra criterion in the WHERE statement to specify a range of records by...
  3. Replies
    7
    Views
    526

    Delete query with joined tables

    In Access 2020, I have a delete query like this. (Access is a front end to a SQL back end database.)

    38679

    The SQL code is like this.

    DELETE dbo_Client.*, dbo_Client.NewClient,...
  4. Replies
    13
    Views
    546

    Thanks for your reply. I tried again and it...

    Thanks for your reply. I tried again and it worked this time ... must have had a typo before.
  5. Replies
    13
    Views
    546

    This method has a one-to-one correspondence...

    This method has a one-to-one correspondence between cells in the source and destination worksheets; e.g.,


    Cells(1, 1) = .Cells(2, 7)
    Cells(1, 2) = .Cells(2, 8)
    Cells(1, 3) = .Cells(2, 9)

    ...
  6. Replies
    13
    Views
    546

    Thanks, that works fine.

    Thanks, that works fine.
  7. Replies
    13
    Views
    546

    Thanks for your further replies, from which I'm...

    Thanks for your further replies, from which I'm now wondering whether there may be a simpler way to do what I need. Here is a cut down example of what I am trying to do.

    File A:
    37659

    File B:...
  8. Replies
    13
    Views
    546

    Thanks for the reply. It looks like the copy...

    Thanks for the reply.

    It looks like the copy destination cell in File A is set as Range ("A1") - is that right? Can it be "R1C1"?

    If I want to do multiple copies into various cells with various...
  9. Replies
    13
    Views
    546

    Syntax in macro

    I am creating a macro in File A to copy values from File B into File A, depending on a condition in File B. I tried this, but it doesn't work.

    Range("R1:C1").Select
    If "'File B.xlsx'!R2C2" = ""...
  10. Thanks for your reply. This did the trick in...

    Thanks for your reply. This did the trick in Windows 7 64-bit on my two laptops.
  11. Replies
    2
    Views
    430

    Thanks for your reply. I have since discovered...

    Thanks for your reply. I have since discovered the following also.

    Sub DeleteAllComments()
    ActiveDocument.DeleteAllComments
    End Sub
  12. Replies
    2
    Views
    430

    Macro code to delete all comments

    In Word 2010, I want to include a line in a macro to delete all comments in the current document. I tried recording a macro and using the "Delete all comments in document" function on the Review tab,...
  13. Replies
    7
    Views
    850

    Thanks again. I followed your suggestion and it...

    Thanks again. I followed your suggestion and it works fine. I couldn't find the VBA colour code for hex CCFFCC but found that Val = ("&H" & "CCFFCC") works.
  14. Replies
    7
    Views
    850

    Thanks for your further reply, much appreciated....

    Thanks for your further reply, much appreciated. The only thing I don't quite understand is why or whether both OnCurrent and AfterUpdate events are needed. The Status field cannot be edited in this...
  15. Replies
    7
    Views
    850

    Thanks for your reply. As I have not used events...

    Thanks for your reply. As I have not used events before and don't know what code to use, are you able to provide an example or suggest an online resource that shows how to do this? All I need is...
  16. Replies
    7
    Views
    850

    Conditional data entry

    I have an Access 2010 form with a field that I want to be editable and to have a green background if the value in another field is one thing, but to be not editable (locked) and to have a grey...
  17. Replies
    0
    Views
    271

    Exporting formatting

    I have an Access 2010 report, which is based on a query, which includes a "Net surcharge or discount" field (Net S/D for short) .

    The data is stored in a table as a number in a field named...
  18. Replies
    2
    Views
    349

    Thanks for your reply.

    Thanks for your reply.
  19. Replies
    3
    Views
    753

    Thanks for your reply. Changing the Windows time...

    Thanks for your reply. Changing the Windows time format to 24 hour worked. I thought that specifying a format mask should override that.
  20. Replies
    2
    Views
    349

    Desktop shortcut option

    I have created shortcuts for some reports by dragging their menu items to the desktop. It appears that reports open from shortcuts in Print preview by default. I can switch from Print preview to...
  21. Replies
    3
    Views
    753

    Time formatting

    I have a form in Access 2010 with a datetime field that has the mask "dd Mmm yyyy hh:nn", which works correctly except that hours less than 12 are displayed with one digit; i.e., 8 am appears as...
  22. Replies
    3
    Views
    583

    Thanks for your replies. This appears to have...

    Thanks for your replies. This appears to have been updated in Access and/or Excel recently, as this now behaves differently, but still not properly. Now, the format mask from the Access report...
  23. Replies
    7
    Views
    799

    Bingo ... as it happens, a Windows update was...

    Bingo ... as it happens, a Windows update was scheduled for this morning, and it included SP2 for Office 2010, which appears to have resolved the issue.
  24. Replies
    7
    Views
    799

    Thanks for your replies. I have also since...

    Thanks for your replies.

    I have also since discovered that the same issue also happens with other reports that have similar totalling fields. If the report has only one totalling field, then...
  25. Replies
    7
    Views
    799

    Hiding total field in report

    I have a report in MS Access 2010, running on Windows Server 2008 R2, that includes the following field in the footer, to display the total of values in the [OrderValue] column.

    =Sum([OrderValue])...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4