Search results for query: *

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

Hi, I have a problem with group permissions that I cannot figure out. I created a new group that has only limited access to forms and reports, but when I log in with a member of this limited access group, I always get the message: You do not have exclusive access to the database at this time...

I looked at the example you listed but it was not quite what I was looking for. Thank you anyways. I found out so far how to have a command button open a query. Now, you can press on the binoculars in the form and the query with all the records for the currentuser shows up. I just do not know...

So far, I just have this simple Find command button in my form that is automatically created by access. I have this idea in mind to expand the Find function, but do not know where to start. I imagine people being able to press a find button, then enter search terms for different fields. When...

I found out that the problem was caused by a subreport having margins that were too big. But why do these margins always change?

The weirdest thing is happening to a database we use. When we preview a report, all the label fields of the data, the text only, do not show up. The label field property visible is set to yes. What could possibly be wrong? [ponder] The data that we entered in the form show up on the report, but...