Search results

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

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

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

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

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

I tried to create a switchboard using the wizard. I didn't like it so I tried to make my own. I didn't like that one either so I deleted it and tried starting again. When I use the wizard it brings up the first switchboard and tells me that there is an error on the switchboard table. How can...

I have a membership form that has all the usual contact information. As we have a lot of members who are from other countries, next to the area code I have a field called "Country Code". I also have a table called "tbl CountryCodes" which lists all the countries that most of our membership use...