Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    17

    Unanswered: Linking Field from Two Different Tables

    Hey guys,

    I'm creating a Repair Log for all the computers here at work. I've constructed all the tables and now I'm working on the forms. I've pretty much got everything in the forms that I want. I have two questions though. I have a Desktop Form that allows me to enter desktops that are new into the system. Also it will allow me to query on any desktop in the database to get information from it. On top of this I have a repair log table. The repair table will give me any given computer name and the work that has been done on it. What I want to do is in the desktop form when I query on a particular computer. I want the last repair date to show up. Essentially it will need to pull the Repair date from the repair log table.

    Outside of that situation when I'm on the desktop form. I can scroll with my mouse and it will show me all the records I have in the table. I don't want the form to have the ability to scroll like that. Do you know if there is some sort of lock that when you scroll it doesnt show you all these records.

    I appreciate all the help.

  2. #2
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    To disable the scrolling with the mouse, you'll need to look up disabling the scroll mouse (on this site - I posted an example here: http://www.dbforums.com/showpost.php...9&postcount=52.) There are a few different techniques to do this. One of them involves adding a few lines of code which utilizes a *.dll file you would copy to the same folder. I've used this method and like the way it works. Also note that one of the Form properties (Cycle), lets you select "Current Record" to prevent automatically going to the next record in the tabbing sequence.

    To get the last Repair date on the form, you can utilize the dlookup command and put this in the controlsource for a text field. You may have to do the dlookup to lookup the date in a query which utilizes the Last or Max function for the date field and criteria where it = ID value of the field on the form.
    Last edited by pkstormy; 10-27-07 at 12:50.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  3. #3
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    See http://www.dbforums.com/showpost.php...8&postcount=54 for the mouse wheel or from the original source: http://www.lebans.com/mousewheelonoff.htm per Royvidar.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  4. #4
    Join Date
    Oct 2007
    Posts
    17
    Thank you for the help I appreciate it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •