Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MaddiMond

    one month does not show up in subreport, but shows in underlying 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...
  2. MaddiMond

    Error Accessing File. Network Connection May Have Been Lost

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

    message: action will reset curent code in break mode

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

    module in break mode?

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

    module in break mode?

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

    Running a report by selecting a date range from a calendar control

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

    Set combo box default to current month and year?

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

    Subreport to display "no sales" if it has no data

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

    Code on PrintReport_Click to specifiy page setup

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

    Code on PrintReport_Click to specifiy page setup

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

    Print Report problems

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

    Print Report problems

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

    DLookup in Report displays Name#

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

    Giving records in query a rank?

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

    summing up for five different date fields?

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

    Startup msg no exclusive access disables users of certain group. Why?

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

    find command, datasheet pop-up, double click, populate form?

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

    find command, datasheet pop-up, double click, populate form?

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

    labels on report do not show, only data

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

    labels on report do not show, only data

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

Part and Inventory Search

Back
Top