Search results

  1. S

    Borders on a report

    That's ok for one section at a time, but what about a "per page" border?
  2. S

    Borders on a report

    Is there a way to have a border print around the perimeter of a report?
  3. S

    Check box useage

    Very good. Thank you. However, I am somewhat unfamiliar with the using "YesNo Msg box" to replace the "built in ones". Can you show me how to do this?
  4. S

    Check box useage

    I am considering using a check box in a form based on an "Equipment List" table so that the user can "check" the items he wants to ship and put on a "Packing List" form (new table). Is this a good method? How would I "clear" the checks once the user has selected them? I hope someone out there...
  5. S

    Open a form

    How can I open a specific form based on the value of a pulldown cell in another form? (ie. value list = blower, burner. I want to open the blower form if value is blower and the burner form is value burner)
  6. S

    Datasheet View Form

    I have created several forms to open in Datasheet View. When I open any of these forms from either another form or the switchboard, only one record shows. I have to select View and Datasheet View before I get what I want. Can someone tell me how to get the datasheet view the first time?
  7. S

    Date range selections for users

    Where is the "Solutions" database employee's dialogue?
  8. S

    Date range selections for users

    Need a way for users to select beginning and ending dates for queries/reports instead of having them type them in. Is there a calendar out there or something in Access that will do this?
  9. S

    Subform with field for multilple tables

    I have a timesheet subform that contains a combo box that I want the user to be able to select cost codes from various tables based on the value of the Projects combo box in the same subform. Can this be done????
  10. S

    Vacation Days calculations

    I have a table of employees. I have a timesheet database that keeps track of, among other things, vacation days. How can I calculate "Vacation Days Remaining" for the previous and current calendar year?
  11. S

    Control to pull from two tables.

    How can I make a control (i.e. [ShipTo]]) have the user be able to select from two separate tables (i.e. tblCustomers and tblVendors)???
  12. S

    Zero Suppression of calculated controls

    This did not work either. One of the Textboxes is named "DH Prop" with a Control Source of =sum([DH-Proposal]), Standard format, decimal places = 0. This cell sums the hours reported from a timesheet table that were charged to DH-Proposal. If no hours were reported the resulting sum of course...
  13. S

    Zero Suppression of calculated controls

    On Format event? What is that? The text boxes that are showing zeros do not have any event available. The report does not have the "On Format" event as a selection. Please advise. thx
  14. S

    Zero Suppression of calculated controls

    No, not currency field. Is a text field with calculations typed in it using other fields data for the calculation. Result is a general number in some of the calc fields and is a percent in other calc fields. thx
  15. S

    Zero Suppression of calculated controls

    How can I suppress zero values for calculated controls on a report?
  16. S

    TransferDatabase Action

    Using the above in a macro to transfer a table from one database to another. Error message reads "You tried to lock table 'joblist' while opening it, but the table cannot be locked because it is currently in use. Wait a moment and try the operation again." Please advise.
  17. S

    TransferDatabase Action

    Am using this in a macro to transfer a table from one database to the other. Error message reads "You can't delete the table 'Joblist'; it is participating in one or more relationships. If you want to delete this table, first delete its relationships in the Relationships window." I do not...
  18. S

    Display 3 fields in a combo box after update

    Have a combobox that lets user see 3 fields in a pull down list. After he selects the right item from the list based on the three values, I can only display the first value. How can I get the other two fields to display?
  19. S

    How to duplicate a specific record

    Have users that are engineers putting engineering data in a database of "projects". They want the ability to copy engineering data from one record (project) to another and then modify to keep from having to key the data in everytime. How?
  20. S

    Split database - need to marry

    After a database has been split for the purpose of networking, how can you unsplit it for the purpose of taking it offsite?
Back
Top Bottom