Recent content by carolinera

I'm exporting a report from Access into excel which has a different name each time during the export function. This worksheet then becomes part of another worksheet by being referenced into certain cells. My question is: I would like the user to be prompted to type in the new worksheet that...

Hi Colin, This group meets three times a year so yes in answer to you question there will be a lot of meeting ids. - Caroline

Oops...Sorry I meant the user would have to use the button on the main switchboard everytime they started the database if they were to review reports. The user would not have to use the button on the main switchboard everytime they started the database if they were to input data but only to...

Not sure if I'm in the right forum but here goes. I have a series of reports that work from dynamic queries prompting the user to input the meeting id. Is it possible from the main switchboard to have a button that says configure database that will then prompt the user for a meeting id that...

Thank you both for your suggestions. I tried both but of course I forgot to let you know that my query is a "dynamic query" that prompts the use for a meeting id number. That means that the only information that was imported was the headings. Any other suggestions....I'm starting to pull my...

I understand that Access is the much better program but my client is insisting on a link to an excel spreadsheet. Never having done one of these from Access I'm not sure how to go about it. I have put together a query that has member id, meeting id, reg type, reg amt, sumofreg amt, refund...

After many discussions with the client on this database they would still like to see their final report exported into Excel. My problem, I am only getting the date in the Excel sheet and not the rest of the report after using the office links and a macro that takes the report into word and...

I am trying to take information from a report and import that information into certain cells in Excel i.e.: I have (3) attendees who have each paid ($350.00) and the total is ($1050). The brackets are the information that needs to be imported or linked to the Excel sheet. Any suggestions? I'm...

I'm having a problem with a mail merge document in Word and the query that I'm trying to use for the data. I have a dynamic query that lists all the individuals that registered twice for a particular meeting. This query asks for the meeting id number to run it. I have the word document set up...

I'm not sure how complex this question will turn out to be but here goes.... I have a membership database that records every meeting that any individual has attended and each meeting includes the amount they paid, when they paid, etc, etc, etc. With that information I have numerous reports...

Excel Link Thank you....I've tried to convince the client that Access is the better medium but I can see their point in regards to this spreadsheet. Unfortunately there are a few more variables that have to be considered....to the point where they will actually have to add some information...

I have designed a membership database that includes all meetings that any individual that attends these particular meetings has ever attended. In a subform, the information captured is the amount paid, their receipt number, the date they paid, etc, etc, etc. My client has sent to me an excel...

I have a form with contact information for the membership and in this form is a subform that lets us know what meetings any particular member has attended. I receive their registration information via an Excel spreadsheet that import into the database. My question is: is there a query that...

Thank you Jack....but I have already got that part. My dilemma is that once I add a member, the find box doesn't have the name on the list in the combo box therefore I have now got duplicates in my database. How do I get the list to update? The names are already on the table named...

On my form I have a find box which the user types in the last name of the member. This in turns brings up the information for this member. I have since added a few new names but their last names are not showing up on the find function. This "find" is connected to "tblmember". These...