Replies

Try opening Outlook in Safe Mode. ( http://www.outlook-tips.net/beginner/safemode.htm ). If that works, disable all your add ons and re enable them one at a time until you find the culprit.

Jerry

Hi, Jerry. Thanks for the suggestion. Outlook wouldn’t let me open it in safe mode.

If you have web access to your mail account try using that and check for any strange looking emails, extremely large emails, emails with large attachments, etc. Delete what you can using the web interface then try Outlook again.

If that fails you could try creating a new mail profile.

Joe

Hi, Joe. Thanks for the suggestions. I went to the web-based account and deleted the incoming emails. Outlook still tried to download them. I will try the new profile suggestion. I don’t know if I will have enough time to do this before it malfunctions.

Sounds like a great plan! It’s a bit far from Canada, though.

Hans, yet another success story. I got rid of the quotations and found that amperands (&) and number signs (#) didn’t make Access too happy either.

One day, I would like to meet the person behind the answers. You never cease to amaze me with your knowledge. I often say that using Access is like three-dimensional chess. Well, you are the Bobby Fischer of Access.

Thanks a lot.

Solved it!!! Went to the address book of Outlook Express and found the option of not sharing the address book with Outlook. Once I closed everything down and opened them again, everything was back to normal. Whew! I thought I had lost everything. Fortunately, all of the deleted contacts in Outlook were in the deleted items folder and I hadn’t closed Outlook, thereby getting rid of them.

Life is good, isn’t it!

Thanks for the help. First time I have heard of a twip! Hey, maybe I can use that one in the classroom. “You little twip.” Funny that the Access help mentioned inches and centimetres, but not twips.

Thanks, Hans. As usual, you come to the rescue. I tried the DoCmd.MoveSize. I wanted it to move 3 inches to the right, 2 inches down and have the default width and height.
It looked like this …

Private Sub Form_Open(Cancel As Integer)
DoCmd.MoveSize (3,2,,)
End Sub

To you it is probably obvious why it didn’t work. To a novice like me, it is like unlocking the secret to the universe.

Thanks for everything, John. Unfortunately, this is much, much to complex for me. My learning curve on visual basic is rather steep right now. I’ll just stick to cramming all the fields I need in one table and show the ones I need for each value on the tabs that apply to it.

I do appreciate your reply, though. Maybe one day I will comprehend all of this. I understand it in principle

Ok, I will type it out at half speed. Let’s say I had different forms that I want to appear on the record of my employees. They are: application form, tax form, and insurance form. Each form will have its data stored in a separate table (although different parts of the same table could work, too).

I want to create a combo box to select the form title field, thus, showing: Application form, tax form, and insurance form. When I select one of them, the proper subform created from its table will appear or on a tabbed form. When I select another, the other subform will appear that matches the type of form selected. Thus, I will have 3 tabs in the subform, but the information will only appear on the proper tab when the type of form is selected in the combo box.

I hope that explains it better.

Boy, that was quick. I just got back from a day of substitute teaching grade 6, so my brain is a bit fried. I tried it and it worked. Thanks.

Either I didn’t explain myself too well or I don’t understand your reply. I want the parameter in the query and the resulting report. However, when making the report look nice you often flip back and forth between the design and print preview to see how you are doing. Each time you go to the print preview, you have to put something in the parameter. If it is a date field, you have to stick in a date. What I am looking for is a wildcard to put in any parameter that tells Access to show everything or to bypass the parameter so I don’t have to waste so much time typing in jan 1 2008, for example.

Thanks. Worked like a charm. What fooled me was the default values of the fields in the table. I had them set as zero, which to me means that the field is not null, but the numerical value zero. Obviously, this is not the case.

By the way, is there a casebook on Access written? I have a couple that are as thick as Bibles, but they are boring, too technical (above my knowledge level) and not project driven. I know enough about Access to be dangerous, but still struggle with many aspects. My strength is to take complex ideas and explain them simply. For example, I am still struggling with the cascading combo boxes. If there was a book that talked about how Hans was building a database to do x, y and z, and here is what he did step by step to achieve it. I know every situation is different, but there must be something we can do.

What are some examples of projects that come to mind?
A school with teachers, courses, students, marks, timetables (which is sort of what I am building now).
A football league with teams, players, schedules, games, scores, statistics, standings.

Got to run now. I am going to teach soon.

I created the filtered combo boxes – when you select the value from one, it gives you only the choices from the linked table that relate to that value. I wanted to then create a subform that would like to the second combo box so that when I select the value there, the subform is populated only with the choices that releate to the value of the second combo box. I also want to be able to add records in this subform. I hope that explains it better.

OK, I have the filtered combo box working. I spent hours on it. Don’t know what I finally did right (that’s dangerous), but it works. Now, is it possible to have the second combo box connect to a subform, so that when I select the value, it shows all of the values pertaining to that selection. If the answer is no, I won’t be unhappy. I have spent hours just getting this far.

Works like a charm. Thank you so much.