Search results

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...

My name is Ken Carter and I'm the IT Manager of Toward Independent Living and Learning (TILL), in Dedham MA USA. I've been a casual Access developer for many years, usually as a result someone hearing that I've done it before, so I get the job. :banghead: TILL is a non-profit organization that...

Greetings to the well of knowledge... Newbie to the forum, pretty fluent in Access development. But I've a bit of a dilemma. Using Access 2010. My tables are stored in SQL Server and are linked within the Access app. My DB consists of these tables: tblPeople tblPeopleClients...