Search results

  1. M

    Report to select certain records only

    Personally I like to diplay this as a form then if I need to I create a report for printing. This can easily be accomplished with a continuous form and a couple of combo boxes and a subform control. Create a form add the subform with the continous form as its source. The continous forms control...
  2. M

    Refreshing SubForm

    Try tblLPtsubform.Requery assuming this is the name of your subform ... requeried from the form within your subform otherwise use the above syntax
  3. M

    Query Left Join Issue

    apply the date range first then add that query to your second
  4. M

    Popup Form to Print or Email Report

    Yes you can restrict users from right clicking the toolbars to add to them look at the Database startup options also so you know for the future you can add custom toolbars to reports and forms .. a diff one for each if you desired. You build your toolbar by customizing then save it. Then in the...
  5. M

    History 101

    INTERESTING HISTORY LESSON Railroad tracks. Be sure to read the final paragraph; your understanding of it will depend on the earlier part of the content. The US standard railroad gauge (distance between the rails) is 4 feet, 8.5 inches. That's an exceedingly odd number. Why was that gauge...
  6. M

    Popup Form to Print or Email Report

    again... why not use access Tool Bars to email/print/cancel the report .. you can customize the menu and have it open with the report. The menu option in access for emailing when clicked will cause a pop up to appear and give your users the option of sending the report in several formats ...
  7. M

    Help Please! Database Design - Relationships

    For data entry on forms you can have a control that is bound to a Control Source. The control sourcee is usually a table or query. this means the data entered is written to that field on your table. If it is a combo box you can select the property Row Source and to the right you will see a...
  8. M

    Popup Form to Print or Email Report

    why not use a tool bar ?? assigned to the report
  9. M

    What am I doing wrong????

    Quick solution to references > getting them right every time Open the form you wish to reference. Open a query .. any query In any field right click and select Build In the menus on the left click forms >> Open forms >>find your form and select it >>find your control and select it .. click...
Back
Top Bottom