Recent content by MaddiMond

I have a subreport, in which data is summarized by month. This subreport is linked to the main report by employee id and year. After December 2007, data for January, February, March, April, May, June, July, August, September, October, November and December 2007 will appear in the report. My...

I have followed the steps outlined in the Access Module FAQ about the Error message "Error Accessing File. Network Connection May Have Been Lost." I deleted the code behind forms and reports, set HasModule to no and imported the forms and reports into a new access database. But there is still a...

Does anyone have experience with the following error message? It appeared suddenly while someone was working with a form. This action will reset the current code in break mode. Do you want to stop the running code? We do not want to cause problems. Any inputs on how we could handle this...

Hi Remou, The Run -> reset did not work. When I try to open forms, I get the following error: Error accessing file. Network connection may have been lost. Any other ideas? If I have to create a new database and import all objects into there, it will take me days and unfortunately I do not...

I tried to import forms, reports and queries from another database. Because somehow it did not seem to work, I imported some forms like three times, but the never showed up under forms. This never happened before. Now, when I want to open the form as usual it says: Error and something like...

Hi, I have a supreport that acts strangely and I cannot figure out what the problem is. The subreport is connected to the main report by an Employee ID and the Year. The subreport has controls that are calculated using running sum. The main report displays numbers per month. For July 2007...

I have an unbound Combo Box in a form set to display Month and Year only. The value of this combo box determines which month is shown in the report. The row source of the combo is: SELECT DISTINCT Format([tblSales].[SignedDate],"yyyymm") AS Expr1, Format([tblSales].[SignedDate],"mmmm yyyy")...

I have a subreport with several fields in it. I want it to display "No Sales" if the report has no data. I tried it the following ways, none of which were successful. 1st: I put the following code into a field in the subreport: IIf ([Sub].Report.HasData = True, [Sub].Report!Comp, "No Sales")...

No. Oftentimes when a user hits print preview, the report opens in Portrait and half the numbers are invisible. So the problem is that he always has to go to File--> PageSetup and change the orientation manually. I have been told this is a drag. Furthermore, in the Access manual it says that if...

I wonder if I can put a codeline into the regular printreport code that specifies that the report has to be previewed and printed always in layout page setup. I have to keep changing the page setup of the report manually through the file menu and it has become a big hassle. Somehow the format...

Maybe I was too unspecific. In the form, the database users have to choose an employee name from a drop-down menu, they also have to choose a month form a drop-down menu. These two parameters determine what will be seen on the report. Once these tow parameters have been chosen, the users can...

What could be the problem if a report displays the right numbers on the screen, but if you click print reports, it prints a report displaying wrong numbers? I want to print exactly what is displayed on the screen. I have a button; I click in the form view to print the report. There are two...

I tried to use DLookUp in the expression of a control on a report to lookup a value in a query. I get Name# and I think it might have to do that I have to criteria. "[EmployeeID]"= Forms![rptMain]![EmployeeID] & "[YearMonth]"=Forms![rptMain]![MonthYear]) Or can I not lookup values in a query...

Hi, I need to assign people a rank on how much they sold in comparison to their colleagues. The rank should be placed on the individual persons sales report. My approach so far was to create a query sorting the records by how much was sold. This query then would be the basis for a report...

I have five date fields and am supposed to create a report summing up the dollar amount for records that have a signed date (date1) in January, next to it should be the sum of the dollar amound in January for for records that have a paid date in January(date2), etc. until December for all five...