Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    1,764

    Macros

    I had found that page and it's very helpful about how to make the button but it assumes you have a macro and that's the bit I can't sort out.
    The macro I made to Print Page in Word does not appear...
  2. Replies
    3
    Views
    1,764

    Print Page macro wanted for Outlook 2007

    I want to create or copy a macro to simply print the first page of any open e.mail. I can't find a ready made command to do this so thought I could use the VBA code from the macro to perform this...
  3. Replies
    3
    Views
    5,193

    Wendell, thank you. I will explore that, I also...

    Wendell, thank you. I will explore that, I also realised that I could just export to Excel, which is neater than what I had done hitherto; export the raw data and pivot in Excel. This means one...
  4. Thread: Form Display

    by maryweale
    Replies
    8
    Views
    2,304

    I am not sure if this is what you mean, but I...

    I am not sure if this is what you mean, but I think you are missing things like scroll bars. If so, go into design view and bring up the properties of the form (double click the black square top...
  5. Replies
    3
    Views
    5,193

    Printing Pivottables in Acess 2007

    I have created a pivottable based on a query in Access 2007 but I want to make it into a report, just as it appears in the pivottable view of the query.

    The pivottable is for other users and a...
  6. Replies
    4
    Views
    1,195

    Hope I haven't posted this twice, but thank you...

    Hope I haven't posted this twice, but thank you very much - it works brilliantly and has given me ideas about how to sort out some other niggles I had.
  7. Replies
    4
    Views
    1,195

    No, that doesn't work. I am typing this into the...

    No, that doesn't work. I am typing this into the ControlSource section of Properties. It just doesn't recognise GetDataPath. Did you intend me to put the actual name of the report in between the...
  8. Replies
    4
    Views
    1,195

    Database name in a report footer

    I want to put the name (and if possible path) of my database in the footer of my report. I currently put the title of the report in the footer using =[Name] but I can't find the equivalent for the...
  9. Replies
    3
    Views
    832

    Thanks, those were both a great help. I created...

    Thanks, those were both a great help. I created my own defined view and then added editd the Advanced toolbar to contain 'Current View' which means I can switch the view to my own design in two...
  10. Replies
    3
    Views
    832

    We recently changed to Outlook 2007 but our new...

    We recently changed to Outlook 2007 but our new network managers installed it with a very irritating default folder view. Every time I create a new folder, or go into an old one I haven't used since...
  11. Replies
    5
    Views
    1,384

    I mean the shortcuts within the navigation pane...

    I mean the shortcuts within the navigation pane 'shortcuts'. These used to lead to the actual folders in the folder list and so give instant access to the subfolders.
  12. Replies
    5
    Views
    1,384

    We have just migrated to Outlook 2007 and I am...

    We have just migrated to Outlook 2007 and I am being driven mad by the shortcut folders. In our old, ancient, version when you clicked on to a shortcut, it took you to the folder and you could...
  13. thank you, that works perfectly - very grateful...

    thank you, that works perfectly - very grateful it will save me lots of time and angst.
  14. I can't work out how to put in the name and path...

    I can't work out how to put in the name and path of the database in a report which would be very useful so that I can immediately identify where a report is generated without building it into the...
  15. Replies
    2
    Views
    561

    spot on, thank you very much.

    spot on, thank you very much.
  16. Replies
    2
    Views
    561

    I can't get my right mouse button to work in...

    I can't get my right mouse button to work in Access 2007, it works in all other Office applications. This means that I can't open a make table query in design view - any ideas gratefully received.
  17. Replies
    6
    Views
    1,211

    Re: Making a subform visible (Access 2002)

    thank you so much, you have shed more light in five lines than five hours of reading manuals!
    Regards
    Mary
  18. Replies
    6
    Views
    1,211

    Re: Making a subform visible (Access 2002)

    Dear Hans
    That did not work, but I fiddled around a bit and came up with a line that did which read:
    Me.Client_Totas.Visible=Me.NewClient
    I think I now realise that I am working under some...
  19. Replies
    6
    Views
    1,211

    Re: Making a subform visible (Access 2002)

    that doesn't work because I get the error message 'method or data member not found'. It does not appear as an option after placing the dot after the M, nor does any variation of the name.
    I have...
  20. Replies
    6
    Views
    1,211

    Making a subform visible (Access 2002)

    I have a subform inserted in a form whose standard state is not visible. I want it to become visible if I check a box. I have written the following event for the NewClient check box:
    Private Sub...
  21. Replies
    11
    Views
    587

    Re: Filling dialog boxes (Access 2002)

    works like a dream, thank you. Not sure what the OpenArg Me.Policy is doing though, is it saying that this is the field that should be the source of the data in the On Load event of the second form?...
  22. Replies
    11
    Views
    587

    Re: Filling dialog boxes (Access 2002)

    That would be a perfect solution but I cannot get the code to work. I have added the DAO 3.6 as a library to start with and have now got the following codes on the forms:

    frmContCert, Event code...
  23. Replies
    11
    Views
    587

    Re: Filling dialog boxes (Access 2002)

    That has all worked brilliantly but it leaves me with an open dialog box. I tried to tidy it up by adding some send keys "%F" at the end to execute the find, but this then interferes with/overrides...
  24. Replies
    11
    Views
    587

    Re: Filling dialog boxes (Access 2002)

    text boxes on both forms, they have different sources but are both data type text.
  25. Replies
    11
    Views
    587

    Re: Filling dialog boxes (Access 2002)

    It's on the On open event (deliberately!) and reads as follows:
    Private Sub Form_Open(Cancel As Integer)
    DoCmd.GoToControl "Policy"
    DoCmd.DoMenuItem acFormBar, acEditMenu, 10, ,...
Results 1 to 25 of 32
Page 1 of 2 1 2