Recent content by imstuck

Is there a way to change a combo box's recordsource if an item is not found in the list? I want the user to be able to search another field (but in the same table) if a name is not found in the list under lastname. The other field is an "other name" field. I tried setting the...

Thanks dreamboat--I'll look for a converter--I don't have a font in particular, the situation has come up at different times with the staff needing different fonts--

Can an Adobe font, with an extension of .pfb or .pfm be used in Word? Windows does not recognize it as a valid font file if you try to copy it to the Windows font directory or if you go throught the install new font process in explorer ?? Thanks!

After several test pages, I believe I have mastered the printer defaults for the paper trays on our 95/98 systems, but our one NT system is driving me nuts while using Outlook! I have set the "document defaults" by right clicking on the printer and choosing the correct tray. In...

Can someone explain how printer settings are saved in Office? More specifically, printer trays. We have a HP 4+ Laser printer with 2 paper drawers, an envelope feeder and a flip down multi-purpose tray. We have plain white paper in one drawer and letterhead in another. If I want certain...

I get an error when trying to compact an Access database on a NT network. It says that the database is open exclusively by person A on machine A. But person A does not have it open, nor is her machine even on! What would make a database think it is opened exclusively when it is not even open...

I have a tab control on a form that has three pages. The first page is a fact sheet, 2nd page has a subform that lists estimates and 3rd page has a subform that lists repairs. The form is based on two tables related by a studio field (primary key) with a one-to-many relationship. The join...

I'm new to tab controls--I created a tab control with 3 pages. The 1st page is general information, and I'd like the second page to be formatted as continuous forms or datasheet view to view more than one related record. Is that possible? Thanks!

Thanks Kathryn--I've read the running sum help several times--I need a two running totals one for each "group". Setting the Running sum property to Over All would give me total for all the groups combined instead of separately, wouldn't it? I need to summarize types and then categories...

I am trying to create a report that counts the number of records for a particular category and type, but also gives me a total for the category itself and then at the end a grand total. Example: Cat 1 Type A 5 Cat 1 Type B 2 Cat 1 Type C 9 Category 1 total 16 Cat 2 Type X 3 Cat...

I am trying to create a report that counts the number of records for a particular category and type, but also gives me a total for the category itself and then at the end a grand total. Example: Cat 1 Type A 5 Cat 1 Type B 2 Cat 1 Type C 9 Category 1 total 16 Cat 2 Type X 3 Cat...

Perhaps I shouldn't have used the term summarize. I need to list the years, not perform a math function on them. I don't believe the report wizard allows for that. Thanks anyways--anyone else have any other ideas?

I have a report based on two tables with a one to many relationship. For each id in table 1, I need to have one field that will summarize a particular field from all the records in table 2 for that id. Example: ID 1 1990, 1995, 1997 ID 2 1978, 1981 etc. What's the best way to do this...

The id field is not "Access" autonumbered--not the Autonumber data type. My program increments it. I thought locking the table would work, but it just locks someone out while accessing it which is not the problem. It's not two different users that's the problem, it's the same user...

HI, Are you sure that field is not a memo field? What you describe is how a memo field looks on a form.