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!

  • Congratulations TouchToneTommy 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: *

  • Users: ChrisBair
  • Content: Threads
  • Order by date
  1. ChrisBair

    Prompted to save record without auto save

    What script can you use to place on a Form where it will not save the record until you click to save. Where nothing is entered into the table, then it asks you do you want to save. ' Thanks
  2. ChrisBair

    Report lists in Combo

    How do you place a Combo box on a form listing reports. Instead of having buttons to get to your reports; Have a List to choose from. Thanks
  3. ChrisBair

    Linking Pictures

    I have a Employee Database. How do I link the Drop Dowm Combo box to display the cooresponding images? Have the pictures in the same folder as the access database. Thanks
  4. ChrisBair

    Time on Report

    How do I calculate time on a query, I have start time, end time, and lunch on fields. How do I calculate a field on a query that will show total hours? Thanks
  5. ChrisBair

    Time Card

    Trying to create a employee database. trying to create time card entry. how do i make a field calculate time? Is there a sample database that I can use as a template Thanks
  6. ChrisBair

    Drop down list

    I have a form setup that when i place a number in the field(text field linking to table1.)The subfom pulls up the linked info from table2. How do I make the field from table one a dropdown list pulling from the table, then pulling the information to the subform. Did a combo box, but the...
  7. ChrisBair

    Text Field

    How do you make a Text Field on a form a Requirement. Where when entering data, one must fill in that field before you can go to the next one. Thanks
  8. ChrisBair

    Form

    Trying to create a basic Data entry form for returned product. Have tables with the Customers and the product , Transaction, and receiving. Want to create a form using another table where the RA # is and the QTY, Date, etc.. However having trouble having the form open without the previous...
  9. ChrisBair

    Form Create

    Trying to create a form to enter counts into a field. I am pulling the numbers from the inventory table. I want to be able to enter the physical counts into a blank field on the same form. How do i create the field without the control source going to a table? Thanks
  10. ChrisBair

    Opening Database

    Created a Login Form to add security. Works fine, however when I go to startup options and tell it to open that form when the database is open, the switchboard is still opening also. Where else can I turn off the swithcboard from opening? thanks!!
  11. ChrisBair

    Creating Check Box

    Trying to place a Sales order on hold(OrderOnHold Field) with a check box. Want it to warn before placing on hold, then a warning to take off hold. Private Sub Order_On_Hold_Click() If MsgBox("Do you want to close out this Sales Order?", vbYesNo, "Close out SO?") = vbYes Then...
  12. ChrisBair

    Report Data specified

    Trying to create a Query to specify to the field; [Enter Transaction Type] - which works, but would like to have the option to pull all transaction types. What expresion can i add to place "All" Transactions Thanks
  13. ChrisBair

    Creating a List box for reports

    Have several reports that I want to add to a form. How do I create a drop down list for those reports?
  14. ChrisBair

    opening report directly to Excel

    How do you create a command button to open a report directly into excel, without exporting? Thanks
  15. ChrisBair

    Totaling tables in a Report

    Have a inventory report showing the total of each item. Using a UnitsOnHand quesry(taking out damages and quarantine- UnitsOnHand: Sum(IIf([WarehouseName]<>"Quarantined" And [WarehouseName]<>"Damaged" And [WarehouseName]<>"King Street Office",[TotalUnits],0)) No i want to add that together in...

Part and Inventory Search

Back
Top