Replies

You are right about it. The mdw file is used only to control access to an Access .mdb file. Per itself, the mdw file is rather useless.

As I thought. Thank you however for backing my thoughts up on this.

Went to the path you stated except went into Exchange Add-ins after finding nothing in disabled items
Found the outex2.ecf file (it has a 2 on it) and it is checked, also found the outex.ecf and said OK for the both of them….nothing…
(and it does show Out of Office, Folder Design and Form for this (outex2.ecf) so you are correct in that these are the file I should grab, but as it is already checked and logging off and logging on still does nothing for the Tools menu

The link you gave has been covered

Nothing

Running diagnostics now

EDITED – NOPE…none of these things work. It is probably some setup conflict that our tech did just getting Outlook 2007 on my office machine. We have Novell groupwise mail, and it’s been installed so that I can run both, independently, and can also read my groupwise mail through outlook…am sure it must be something in the way he set it up. I will check the classroom computers upstairs and see if I have better luck. Will let you know. If it’s the same upstairs where Novell groupwise is not a mail service that would be the answer.

HTH,

Thank you. That was it. You saved my fried brain from exploding.

You can’t send a popup form to the back of another window. But if you open popup form B from popup form A, it’ll open in front of popup form A.

Understood. And that is working fine. It was just after opening form B from from A (after entering DB Password), form B (which there are several as there are several directors)…has macros that open that particular Directors reports, etc…and the popups do what popups do…stay in front of everything. So…

I had thought that as the user clicks a button on Form B to open a report, there would be a possible way of minimizing or closing form B in the On Lost focus event (or some event) to close the popup as the report would be the desired object to now have the focus. (Yet it remains in the background behind Form A and Form B as they are popups doing what I wanted them to do, staying the size they are supposed to be…however removing themselves from view would have been nice too)…can’t have both. Now if Reports could be changed to popups, I’d be in the pink!

solved

they can be. thank you guys. sometimes we answer our own questions. that solved it. make the reports popups as well
Anyway…
Thank you for your help

Wendell,

Thank you. Yes, I am aware that users should not use the datasheet view. This database is a bit different…not the norm. That is why I am restructuring it…and the datasheets will appear in Add-Only mode when through. If they want to view anything else they must open the report.

Appreciate all the help on this. Will work it out. Plus am rebuilding it on a 2007 Access loaded computer and have to make it complient with 2003 Access which everyone else has. What looks good in design on 2007 doesn’t always appear as well in 2003.

There is another way to keep a form a fixed size, and that is to make it pop-up. Then even if the main Access window is maximized it will float over top of whatever else is open. Will that improve your situation?

Wendell,

Creating a pop up form works for keeping the size of the forms the same and stops the maximization of it when something is open. It keeps the size of the windows great, however, it does keep them in front of whatever you are opening, which I think will aggravate the person trying to open their reports etc…to view.

On the “On Click” code event that I have at the beginning of this thread to open the example of “frmNannetteEnterRecords”, would there be a command I could use to make the pop up form go to the back of whatever they are opening?

You could add the line DoCmd.Restore to the On Close or On Deactivate event of the datasheet form.

Hans, I will try both you and Wendells suggestions on Monday morning. Thanks you again. If either works will let you know.

Wendall,

I will try this. Must wait until I can get back to the server on Monday, but definitly will give this a try. Thanks so much for the idea of the popup.

Darn…was hoping to find a way around it. Thank you Hans for your feedback.

Thank you Hans for the clarification on the code for acNormal

The problem (even after entering your DoCmd.Restore is that when someone clicks on a macro button on the form (its of the proper size at the moment)…but when they click a button on the form for example to open another object like a datasheet, the datasheet opens in maximized mode, and when closed there is the form they originally used that maximized itself in the background instead of staying the size it was before the datasheet was open. It is like:

1. The form is the perfect size
2. Click a button on the form to open a datasheet in maximized mode
3. Enter records.
4. Close the datasheet
5. There is the form used to enter the datasheet in the background but it grew (it maximized itself when the datasheet was open)

Why can’t it remain the size it was before?

Create a column with the formula of DaysOut:[rew comp date] – Date(). Set the criteria to <=14.
Set the Act Comp field's criteria to "Is Null" (without the quotes)

Will let you know if this works for him when he emails me back. Thank you for helping. It is MCI's fault that he can't do this for himself, as MCI blocks anything that looks like a chat room where he works, so I am having to do the asking myself today (which I always told them I would). I still give Woody's all the KUDUs.

Ok, here is a better understanding of what he is looking for:

Proj number Location Description Req comp date Act comp date remarks

He wants to be able to query a list of incomplete jobs
within 14 days of req comp date. The act comp date will have a null criteria
to identify it to be incomplete as I understand it.

Can you help me with the Access query formula that will help him get what he wants?

Thank you.

I received a description of a problem (no example) from a former student today. Have a question maybe you can help me solve.

Here is his original question:
I need to propagate a list of cells that are 14 days
from reaching the date in the cells. This is not working “(14
day)<(DbDate)" this is Access 2003.

I am guessing what he is trying to say here. I think in a query he needs a new column to contain a formula like:

Getting Close: =IF([DueDate]=[OverDue]-14,[DueDate],""]) but how would he write this

HELP! My mind is gone today…heck it's gone on most days, you've probably guessed that by now…but appreciate the help on this.

He may also just need a filter…any help at all

If you unprotect the workbook, you’ll be able to move its window, resize it etc.
To do this:

[*]Activate the Review tab of the ribbon.[*]In the Changes section, click Unprotect Workbook

That’s it!

I was working with the protect sheet ensuring it wasn’t protected…didn’t notice that the workbook was protected as I expected a password box to appear and because there was no password, did not notice that it “was” in fact protected. Gosh I hate days like this.

Thank you Hans…and believe it or not…I figured that out after screwing around with it here for a little…but thank you as you found the same result nearly at the same time as I did.

It is over 2 mg

I don’t see a graphic. Could you post a copy of the workbook?