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

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

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

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

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

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

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

Hi, I wondered if it is possible to run an update query automatically by clicking on a checkbox in a form, which would eliminate the need to go to queries and click on the update query. Thanks, Maddi

Hi there, I have a calculated field [date] in a report that has the format yyyymm. One subreport is linked to this field. I tried to add another calculated field with DateAdd ("m",2,[date]), but it did not work because of the format. The problem is that I have to link the second subreport to...

Hi all, I put a code into the on load event of a form that blocks the scroller of a mouse so that people cannot accidentally skip between records. The problem now is that I have several subforms on different pages of the form and the scrolling works for these subforms. If someone is on tab...

Dear friends, I made a form and set its property to navigation = no and cycle = current record, in the hope that people will not haphazardly use their scroll thingy on the mouse and skip between records in the middle of data entry. These settings do not prevent skipping between records at all...

I have created a form for sales people to enter data they received from the customer. One part of this form, a subform, is also used by service people, but they use an Excel template to update the information for a company. It is pretty easy to export the data of the current customer from the...

I have created a big form and people enter data, but they are used to use the scroll "thingi" on their mouse and they accidently switch to another record and then get confused. Teh continue entering data for another record already in the database and the data gets skewed. Can I somehow stop...