Search results

There's no attachment.

Not a problem :) Welcome to the forum, by the way.

If you're a total rookie and haven't changed any of the default settings on the form, first thing to do is open the form in datasheet view and look at the bottom of the window for a scroll bar. p.s. Welcome to the forum...you'll find most everyone is very nice and helpful, and there is no need...

The short answer to your last question is "No". I think the best thing to do is split the table as you need to, create a query that includes all of the fields you will need from each table, and base your form on the query instead of on a table. Your other option is to use subforms.

Q. What has 12 heads but no brain? A. A Texas jury http://www.courttv.com/trials/durst/verdict_ctv.html (No offense to the lone-star state members!)

Why did the pervert cross the road? Because his #*&% was stuck in the chicken!

Oh, I love that one! This is a version I saw posted on the door of a social psychologist's office (for obvious reasons): When the moon hits your eye like a big pizza pie, that's amore. When you're swimming with zeal and an eel bites your heel, that's a moray. If your culture eat...

Oh, no you don't - ya can't pin this one on me, see? I din't do nuthin', see?

Rich: "That sounds brilliant! I'll make the arrangements." :p

Let's get back to the purported topic of the thread: "Honey, you know those pills I was supposed to be taking?..."

There's just no pleasing you people. She even offered you her pen! She sounds like a lovely lady to me, and if I may be so bold I'd say your taste improved over the years. ;)

dcx, Sorry my post wasn't clear. I understand how default values work. What I meant was that the method you described is the best way to go if one always wants to store the date the record was created. If one wants to store, say, the date the record was last modified and have this field...

dcx's suggestion is the way to go, provided that you always want to store the date that the record was created.

How are you logging calls? I assume you have a table containing a record for each call, and that one field in that table is the date of the call? If this is the case, then the answer to your question is you shouldn't be storing calculated fields in your database. Set up a query that gives you...

Gunawan, I experimented a bit and found the same problem you had. I don't think you can get the look you want using a list box. BUT, I don't think you want to use a list box for printing, and as the others have said it's better to use reports for printing than forms anyway. The problem with...

This won't directly address the cause of your problem, but it may be a way around it. I would add a record to tbl shop for "unknown" or something. I've found it's a good idea to force entry for every field - that way you don't have to wonder later whether the omission was deliberate or...

Is it possible that you are confusing the Control Source with the Row Source? Can you be a little more specific about how you have things set up and what you're trying to do? If you list the relevant table and field names and what you want the combo box to do it'll be easier to answer your...

The PopUp property is used to specify whether you want the form to remain on top of other open forms until it is closed or not. It's not meant to be used to set the size of the form/window. Do a search in MS Access help (or a book on Access if you have one) on the terms "PopUp", "Modal"...

If I understand the box that you mean, try this: Click on "View" and make sure "Ruler" is checked.

Does your printer have white ink, then? ;)