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...
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!
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!
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...
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...
I have a table that holds a value (lastidtab)--one record. In my program I have a command button assign the next id number by getting the value in the lastidtab and adding 1. It then updates the the lastidtab with the incremented number. And so on.
The problem I am having is that the user...
I have a table that holds a value (lastidtab)--one record. In my program I have a command button assign the next id number by getting the value in the lastidtab and adding 1. It then updates the the lastidtab with the incremented number. And so on.
The problem I am having is that the user...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.