Search results

Interesting. The report does contain a subreport. When I removed the subreport, the report printed with no errors.

Greeting to the well of knowledge... I hope someone can explain to me what happens when a report is printed. I have a report that "previews" fine. I can scroll through all the pages and everything looks right and proper. When I hit the print button in the ribbon, I get the dreaded "Item Not...

Oh, and further, if an individual made more than one donation on a given most recent date, I want to select the record that has the highest donation amount. I don't think I have any such records, but I've been asked to account for this.

Greetings to the well of knowledge... I have a table of donations made by various individuals. Each individual may have made one or more donations over time. I need to find the one record for each individual that has the most recent donation date. I can't seem to find the right method for...

I understand this. The issue is identifying the end user's file/save folder. For example, my default file/save folder is on my E: drive, but using Environ("USERPROFILE") only tells me that profile is on my C: drive. There must be another system variable that tells me where that file/save...

:banghead: Greetings to the well of knowledge... Running Access 2010 and suffering from CRS... There was a time, as I recall, when one could launch Excel from Access VB with a single command line but now I cannot recall how to do this. Additionally, when I execute TransferSpreadsheet, I only...

Greetings to the well of knowledge... This is weird one :confused:. Using Access 2010... I run my application and then I use a form to provide parameters for a report. When the parameters are fully entered, it launches the report just fine. However, when I click Print Report, what prints...

Cool! Thank you!

Hmmm...I'm not quite sure how I'd do that.

Let's see if I can explain this, then: I think I need to transform... Record I: Name A lives at Address 1 Record II: Name B lives at Address 1 ...into... Record I: Name A and Name B lives at Address 1. There could be one or more records per Address.

Apologies. The tables don't look good when posted.

Greetings to the well of knowledge... I have received an unusual query request that I need help to put together: I have a table of clients. For each client, there may be one or more family members identified. We are going to be doing a mailing out to all family members but in order to save...

The entirety of the message is: "You can't carry out this action at the present time. You tried to run a macro or used the DoCmd object in Visual Basic to carry out an action. However <DBNAME> is performing another activity that prevents this action from being carried out now. For example, no...

Greetings to the well of knowledge... Have read every other posting on this particular error message but have not found my particular circumstance. It's an Access 2010 front-end using an SQL Server DB using ODBC. The users reporting this error successfully opened the database at some point...

Thank you! Perfect!

Greetings to the well of knowledge... My people table consists of a primary key (person's name), address information, etc. My donors table consists of a primary key consisting of the person's name and an auto-increment field for each donation made by the person (for unique key purposes...

That's a possibility. I'll see what I can come up with. Another suggestion I hear is that Windows arranges the tabs in alphabetical order by either tab caption title or the name of the form itself. Another interesting thought.

Would it possibly have anything to do with what form has the focus when the others are opened? When the People:Client:Service forms are open, the People:Client form has the focus becuase that's the form that opens the People:Client:Service forms. Intuitively, I would expect the...

No, this is not a tabbed control embedded in a form. Each form is separate and independent. They are certainly linked from a relationships perspective, but they are not subforms. I have, as you noted, set the database options (File/Options/Current Database) to display documents as "Tabbed...

Greetings to the well of knowledge... Because of certain design considerations and the amount of data I'm maintaining, I have chosen to use tabbed documents rather than floating windows or subforms. The hierarchy is supposed to be a person who is categorized as either a client, family...