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 Chriss Miller 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: morg59jeep
  • Content: Threads
  • Order by date
  1. morg59jeep

    Newbie Drawing queston

    how do you turn on the dashed guidelines that help you line up things to another object? For example if I want to draw a line and I want the starting point to be at the intersection of a point on an object above and to the side of where the line needs to go. How do you turn on the feature that...
  2. morg59jeep

    Record Date Changed for a record when not using a form

    Is there any way to update a DateModified field in a table if a record is changed? I know this is possible when the data is changed in a form but what if someone changes the data directly on the table. Is there any way to record this?
  3. morg59jeep

    Bank Loan Database Help

    I have to setup a system to track our loans. Need it to work like a bank would handle the loans. Here is what I have so far. Tables LotInfo LotID(primarykey) LotLoanRef LotID(primarykey) LoanID(primarykey) LoanInfo LoanID(primarykey) LoanType Bank LoanNumber Interest Rate...
  4. morg59jeep

    Limit choices in combo box 2 based on box 1 choice

    I have a Vendor field for each Vendor and a cost code field. What I need to setup is when a vendor is chosen only the appropriate cost codes for that vendor are available to choose from the combo box. How do I do this on my form. We are having problems where the data entry person enters a cost...
  5. morg59jeep

    Record history upon change

    I have a table that I want to lock the data once it is entered so that it cannot be changed. The data in the table however needs to be modified when errors are found and a history of the the changes, who changed them, and why needs to be recorded. What is the best way to go about this kind of...
  6. morg59jeep

    excluding non-consecutive items?

    I have a record that excludes one record using this code <>"4097" I now need to exclude a few more records as well. I tried to use <>"4097" And "5002" And "5474" This did not work. It only excluded the 4097 .. so what do I use to exclude more than one non-consecutive record.
  7. morg59jeep

    Filtering at report level?

    I have a report that has various grouping for subtotals and a grand total at the bottom. Is there a way to total a range of items at the bottom of the page that is not influenced by my grouping? The range of items i need a total for falls into many of the different groups.
  8. morg59jeep

    Show group name even with no records

    I have a report that has different sorting and grouping levels. The group names come from a group name table. How do I get the report to show a group name in the header for a group that does not have any records? It works fine for any groups that have at least one record but I need it to show...

Part and Inventory Search

Back
Top