Search:

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

Page 1 of 14 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    14
    Views
    2,964

    I tried using the VB Code supplied in the DB...

    I tried using the VB Code supplied in the DB above, and it works insofar as I can get the Dialog Box to appear if there are no results. If it has results, instead of opening the form (which is based...
  2. Replies
    4
    Views
    4,380

    Fair enough. Thanks for your reply. Bottom...

    Fair enough. Thanks for your reply. Bottom line: there's no easy way to dynamically create charts in a Word Mail Merge. :( Maybe a few versions of Office down the road!? :)
    Many thanks again...
  3. Replies
    4
    Views
    4,380

    Thank you for your reply, but we're still having...

    Thank you for your reply, but we're still having to create 100+ images manually. If it were a Pivot Chart, the Chart would change based on the current value, although I imagine that would also...
  4. Replies
    4
    Views
    4,380

    Dynamic Charts in Word Mail-Merge?

    We have conducted a Survey for more than 100 companies, and we would now like to give them personalized Reports on their results. We obviously know how to merge this into Word, but we'd like each...
  5. Replies
    7
    Views
    4,292

    To be honest, I haven't tried and wouldn't be...

    To be honest, I haven't tried and wouldn't be sure of the syntax to find or list 'old stuff'. Could you point me in the right direction, please?

    many thanks

    Brian
  6. Replies
    7
    Views
    4,292

    Hi Joe Thanks for your reply. I would assume...

    Hi Joe
    Thanks for your reply.
    I would assume that if a user had imported an old PST, it would only affect that user. However, this has appeared in several people's Calendars. Also, I doubt any of...
  7. Replies
    7
    Views
    4,292

    Thanks Joe. I'm the Exchange Admin! LOL! I...

    Thanks Joe. I'm the Exchange Admin! LOL!

    I didn't do a database restore (we don't even use the same tapes we used a few years back). The Server is newer than the one that contained the Old...
  8. Replies
    7
    Views
    4,292

    VERY old calendars have reappeared

    All of a sudden, a whole slew of old calendars have reappeared in some users' Outlook Calendar Views. We're talking about people who left the organization years ago, and meeting rooms from the...
  9. Thanks again for your post. I checked this out,...

    Thanks again for your post. I checked this out, but it doesn't seem to relate to my problem. Would you have any other ideas as to why this might be happening?

    Many thanks for your ongoing help.
  10. Thank you. I'll check that out and will post...

    Thank you. I'll check that out and will post back with a result.

    Many thanks again.
  11. Outlook 2010: Email group 'Date=None' won't send

    For no reason that I can identify with any consistency, when I'm sending and receiving e-mails, one message (grouped under 'None') will not send but the (eg) 4 or 5 (grouped under 'Today') send as...
  12. Replies
    1
    Views
    409

    I have tried recording multiple macros to search...

    I have tried recording multiple macros to search through an Excel spreadsheet for an item and then apply formatting and delete the item (row) when it finds the required text. However, none of them...
  13. Thanks John, you're a star! That worked...

    Thanks John, you're a star! That worked perfectly.

    Thank you so much for all your help, and thanks to everyone else for your replies--all greatly appreciated.

    Have a great day!

    Brian
  14. Thanks for your reply, Wendell, but could you...

    Thanks for your reply, Wendell, but could you advise what line of code I'd need to add at which point, please?

    I tried adding # to the sql line, eg

    sql = "INSERT INTO tblMonthlyForms...
  15. Thanks again John I added the Debug line and...

    Thanks again John

    I added the Debug line and ran it again.

    In the Immediate Window, I got the following:
    Start Date: 16/02/2010
    Date 1: 16/03/2010
    Date 2: 13/04/2010
    Date 3: 11/05/2010...
  16. Thanks. I changed the name at the beginning too,...

    Thanks. I changed the name at the beginning too, but it's still coming in as 30 December 1899?

    Could this be a bug in Access, or would there be another method that would force Access to recognize...
  17. Thanks so much for your help John. It is...

    Thanks so much for your help John. It is excellent.

    Both of those Code snippets worked great except that the Dates that are inserted into the tblMonthlyForms are all 30 December 1899?

    Maybe I...
  18. Hello We have a small new Database that is...

    Hello

    We have a small new Database that is keeping track of Students. Certain Fields are incumbent on other Fields, and I'd like to create an Event Procedure so that when 1 Date Field is entered,...
  19. Hi Slinky First of all, sincere apologies for...

    Hi Slinky

    First of all, sincere apologies for the delay in getting back to you. It's been way longer than expected since I've had to revisit this problem.

    Having said that, I added the...
  20. Replies
    4
    Views
    605

    Hello I have a simple bit of code that I'd...

    Hello

    I have a simple bit of code that I'd like to get working. We have a Purchase Order Database, and I want to ensure that a User enters a Valid password to authorize a Purchase Order.
    If the...
  21. Replies
    11
    Views
    611

    Thanks to everyone for your replies. This is a...

    Thanks to everyone for your replies. This is a small company, so I can't afford to spend a lot of time on Coding (I'm not an expert coder anyway).

    I think I'll have to a think about it.

    Many...
  22. Replies
    11
    Views
    611

    Hi I'm creating a Project Database that staff...

    Hi

    I'm creating a Project Database that staff will complete showing the work they've done in a particular week. I've been asked whether it's possible for Access to open a Form that's almost like...
  23. I just tried this using Outlook 2007 and Exchange...

    I just tried this using Outlook 2007 and Exchange (V whatever my employers have).
    I displayed two calendars in day/week/month view (mine and a colleagues)
    I used View > Current View > All...
  24. Yes, they're there if you're working with your...

    Yes, they're there if you're working with your own Calendar, but as soon as you select a colleague's calendar, Outlook switches to Day/Week/Month view, and there's no way to modify this view. If you...
  25. Prior to Outlook 2007, when a user drilled down...

    Prior to Outlook 2007, when a user drilled down through the "Customize Current View" Dialogs to the "Show Fields" Dialog, at the top of the dialog there is a "Select Available Fields From:" drop down...
Results 1 to 25 of 339
Page 1 of 14 1 2 3 4