Search:

I posted this question in the VBA section -- please refer to this post.

Thanks,

Tom

Access 2007 SP2
Outlook 2007 SP2

I'm opening Outlook from Access VBA, composing an e-mail message, and then sending it. If I watch Processes in Task Manager, the instance gets created fine and I...

John,

Sounds like this has already been beat to death, but a few comments nonetheless (no magic solutions, though):

If you are going back and forth between Access 2007 and prior versions on the...

John,

Sorry to be so slow in getting back to you; obviously other Loungers have come to your rescue!

Here's a brief accounting of my experience with the Access 2003 to 2007 transition (so far):...

Thanks for the tip. I'll take a look at that alternative. Sounds like it might be a more elegant solution than the graphics option (even if placing the pictures were faster!). We do still have...

I am (slowly) in the process of converting my Excel 2003 spreadsheets to Excel 2007. For the most part this has been fairly painless. I have run across one particular annoyance so far, though.

I...

I have an Access application that is being used via both Access 2003 and 2007. It is set up with a custom menu so that the interface "looks like" Access 2003 even when opened with Access 2007. For...

Okay, here's another peculiarity that maybe someone's seen or can explain, or (better yet) can tell me how to fix!

I have a custom menu (Command Bar) that I configure during start-up based on the...

Hans,

Yes, it is set to "Break on Unhandled Errors". So I guess it can't be trapped... (Does the huge negative error number indicate that it's a "built-in" error?)

Thanks for your help.

Hans,

The line of code immediately preceding objMailItem.Send is On Error Goto Send_Error, so I think error handling is active, unless I'm overlooking something fundamental regarding error...

I use VBA (from within Access) to create and send e-mail via Outlook. If the user's Outlook "message store" is full, an error is generated when the .Send method is executed (see attachment).

I've...

I am JUST BEGINNING the process of testing the use of a production Access database (Front-End on client, Back-End on server) using Office 2007 (the application was developed using Access 2003). For...

Hans & Andrew,

Thanks - certainly a more rational explanation for the behavior I was observing.

If a Word document is saved after printing, it appears to save the printer choice in the document. Is this true? If so, is there a way to override this so that the document, by default, prints to...

Thanks. Easy enough!

Mark,

Maybe this is a no-brainer, but how do you force the bottom one to get the focus (so the drop down shows only current staff) when the user clicks on the combo box to make a selection? Seems...

John,

This technique works nicely for me -- for single forms (for continuous forms, as noted in. It has the advantage that an additional control doesn't need to be created (Hans' solution). I'll...

Hans/Mark/John -

Thanks for the tips. Very sneaky. I have this situation for both single forms and continuous forms. I'll try Hans' overlaid text box scheme first, although I'm wondering if...

I use a combo control to select a person's name from a staff list. The record ID for that person in the staff table is the bound field for the control (the bound column width is set to zero so only...

Hans & Jezza,

Thanks to you both. Between the two options, it looks like I can solve his problem!!

I have a user who is continually frustrated with his mouse scroll wheel causing a form to move from record-to-record rather than scroll the text within a scrollable text box. Is there an...

I've created a "master" report with a bunch of "artificial" groupings (=1, =2, etc. in Sorting and Grouping). I specify a Footer for each of these sections. Based on guidance provided in response...

That'll work... I'll do the loop-through-the-QueryDefs thing -- that's what I was going to do with the Destination DB property anyway (until I couldn't find it!).

Thanks, Hans!

Is there a way to access (view) the "Destination DB" property of the QueryDef object through VBA code?

I relinked some tables to a backend database that's now in a different location. My action...

Hans,

Progress...

No word yet from the network guys, but I've found an acceptable workaround, which I think may be helpful for others faced with this annoyance.

As described, I get the...