Search:

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...

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...

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...

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...

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

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...

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...

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...

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.

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

Many thanks again.

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...

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...

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

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...

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...

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...

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...

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,...

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...

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...

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...

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...

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...

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...

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...