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

    Deleting entire record in table, including primary key

    Hello! I have two tables, one is Emp (basic employee information) and the other is EmpAudit (results from auditing file). They are linked using the EmpID, and EmpId is the primary key in both tables. I've been trying to create a re-hire button that eliminates the record in the EmpAudit table...
  2. jweber

    Multiple records viewed on multipage form

    I am working on a computer inventory database. We want to record some of the individual components in the various machines (as we build all our computers in-house). I have made a table for components, a table for configurations, and a table for software. I would like to be able to use a form...
  3. jweber

    Coding problem for opening form, finding record

    Hello. I am working on a workorder form that, after an update, opens and finds the inventory record in another form. I keep getting "Run-time error '2501': The OpenForm action was canceled. This is what my code looks like. If Me.Dirty Then ConfirmChg DoCmd.OpenForm...
  4. jweber

    Using Key Press Event

    I would like to force one field in a form to store only capital letters, while the rest of the form is in the first letter capitalized form. Anybody know how to do this via code? I think you would use the Key Press, but I have NO sample code...and I am lost.... Thanks!
  5. jweber

    Calculate Evaluation dates (90 day and 1 year)

    I have a field for the hire date, and I also have a form that SHOWS the evaluation dates, but there is not a field for them. I am currently trying to create a report where the Personnel Dept. can enter a month, and it will pull up any employe that is due for an eval (either 90 day or 1 year). I...
  6. jweber

    having access automatically enter a criterion for a parameter query

    I am working on a form where (after pressing a button) key elements are deleted. I have a parameter query set to pull up the correct record, however, this still requires the user to enter the ID as it appears on screen. Is there any way to have access put that ID in the criteria when the query...
  7. jweber

    Have access put value into criteria field automatically

    I am working on a form where (after pressing a button) key elements are deleted. I have a parameter query set to pull up the correct record, however, this still requires the user to enter the ID as it appears on screen. Is there any way to have access put that ID in the criteria when the query...
  8. jweber

    Automatic Sizing of Access Forms

    I am working on an application for multiple users. Some of them have their monitor settings at 800 X 600(pixel) instead of 1024 X 768. This causes the forms to be "blown up" and makes them have to scroll. Is there a way to have access automatically size the app according to screen...

Part and Inventory Search

Back
Top