Search results

I have a database that is really just a bunch of reports based off of one excel sheet. I am using the excel sheet as a linked table. My problem is that there is going to be a number of copies of this database in use, and i want the user to be able to say where this excel sheet is located, but...

I have multiple reports. I would like the user to be able to see a main one, which has averages of six different sections on a test. I would like that the user can click on a button (or some other event) under one of the sections that will open up a detailed report of that section. I would also...

I need some help with charts: I know that the wizard wont allow me to put in more than six fields in the chart. Is there any way that I can get around this??? PivotChart: if i have a field named "Jan", when i put it in the pivot chart or table as a sum, it changes the name to Sum_Of_Jan. Is...

I have a form with a listbox on it. the list box contains site numbers. (lstSite) i would like the user to select which site/s they want information for. i have another query that includes site,date,and other data i put in the criteria for site as being forms!main!lstSite.value but it is not...

I have a form with a listbox on it. the list box contains site numbers. (lstSite) i would like the user to select which site/s they want information for. i have another query that includes site,date,and other data i put in the criteria for site as being forms!main!lstSite.value but it is not...

What is the general rule in reports - when do you set the running totals property to "over group" or "over all" or when do you use the sum() function? I am so confused and i can never figure out which one to use so if someone can explain it I would be forever greatful. Thank you.

I have a crosstab query that new data is added for every month so the column headings change. How can i create a report based off of this query without having to go in and update the design of the report every month? thanks in advance

I have a crosstab query where my column headings are the names of the months based on invoice dates. what i currently have: Month: MonthName(Month([AnnualIncome]![InvoiceDate])) so this spits out April May and June in the column headings. The problem is that it is sorting it alphabetically, not...

I currently have a database on my hd and four other ppl have a copy on theirs. (We are in different physical locations which makes it very slow to put the database on our server). Currently eveyrone is sending me files that i upload to my copy of the database so i have all of their data. the...

i am using a macro that sends an email with a file attachment. is there any way to get this working without having outlook or outlook express running on the computer? are there any windows restrictions to this feature?