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

    How to redefine a mouse button click

    I have a program that gets data from a weigh scale and puts the data into an Access database. Presently, the user must press the 'F12' key to retrieve the data from the scale. There are a number of text boxes that accept the data from the scale and the user 'tabs' to the next box after each...
  2. lmarles

    How can I pass a parameter to a Data Report?

    I have a Data Environment deBlue I have a Connection cnnSamples I have a Command comDailyShift I have a Data Report drDailyShift I have an SQL statement in comDailyShift that pulls data from 'Samples' table in an Access 97 database (Blue.mdb). I want the report to show only certain records...
  3. lmarles

    Navigate filtered recordset with PgUp/PgDwn/Home/End

    Hi, I have a Data control (datSamples) with RecordSource pointing to the 'Samples' table of my database. My program creates a filtered recordset from the datSamples.recordset. I can navigate through the filtered recordset using the mouse to click the navigation arrows on the data control...
  4. lmarles

    Update a Field in a Second Table from a Combo Box Lookup.

    I have a form 'Job Number Update'. The Record Source for the form is table 'Job Numbers'. On the form I have a combo box that looks up records from a different table, 'Location'. I have a 'Save Record' button that, when clicked, adds a record to table 'Job Numbers'. I want the 'Save Record'...
  5. lmarles

    Print two (2) pages with one 'Print' button - Access97

    Access97. I have a form that uses a tab control to create two pages (two tabs). I have a 'Print' button on each page that, when clicked, will print the data on the page. The user can tab to either page and then print the page. I would like to set it up so that the user can print the current...
  6. lmarles

    Export Current Record to Text File

    Access 97. I have a form, FORM1, and a table, TABLE1, that is the record source for the form. I have a text field in the table called TEXTFILE. TEXTFILE contains the name of a text file. I have a command button on the form that I have called 'Export Current Record to Text File'. When I...
  7. lmarles

    Automatic update of field from data in other fields

    I have a table with seven (7) fields, A1, A2, ATOT, B1, B2, BTOT, TOTAL (all are data type Number). I have a form with controls (Text Boxes) for each field. I have set the form up so that when I enter data in A1 and/or A2, ATOT automatically gets updated. I did this, for A1, and similarily...
  8. lmarles

    Default to first record in table when form is opened.

    Using Access97, I want to set up a form that will default to the first record in a table when the form is first opened. I have a table 'Employees' and a form 'Employee Info'. The form has controls bound to 'Last_Name' and 'First_Name' in the 'Employees' table. When I open the form I want the...
  9. lmarles

    Adding New Table with Relationships

    I have an EMPLOYEE table. I want to create a new table, ABSENT2000, to record days absent in the year 2000. The ABSENT2000 table will have fields for each month of the year and a 'total' field. I will create a form for entering data into the ABSENT2000 table. I want to be able to key off...

Part and Inventory Search

Back
Top