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: *

  1. lmarles

    How to redefine a mouse button click

    Ok, I've figured out how to handle the text box array. So my code will include MouseDown checks for the form, frame, and text boxes. Private Sub form_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) If Button = 1 Then ' MsgBox "Lefthand mouse button...
  2. lmarles

    How to redefine a mouse button click

    CraigSander, Actually, having the event fire when in the text boxes would be good. The problem I'm having now is that the text boxes are an array (Text(0) thru Text(18)) so I get a "Compiler error: Expected: identifier" when I use the following code: Private Sub...
  3. lmarles

    How to redefine a mouse button click

    The best solution would be to allow the user to click anywhere but I don't know how to use WinAPIs. Can you help me with that? Otherwise, I can use the frame instead of the form and that may be ok. Using the frame the code looks like this: Private Sub fraFrame1_MouseDown(Button As Integer...
  4. lmarles

    Data Report Parameter passing

    The parameters must be defined in the command for the data report using the 'Parameters' tab. You pass values to the report like this: ' Set the Value for Parameter 'Param1' With deYourDataEnvironment.Commands("comYourDataReport")...
  5. lmarles

    How to redefine a mouse button click

    Thanks dragnut. My form has a frame and the text boxes are in the frame. As long as the mouse pointer is outside of the frame the following code works. If the mouse pointer is inside the frame then the mouse buttons work as per normal. I would like the code to work even if the mouse pointer...
  6. 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...
  7. 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...
  8. lmarles

    Navigate filtered recordset with PgUp/PgDwn/Home/End

    Thanks all. I added the following code and it worked. Private Sub Form_Load() KeyPreview = True End Sub Private Sub Form_KeyDown(keycode As Integer, shift As Integer) With Me.datSamples.Recordset Select Case keycode Case vbKeyPageUp 'Page Up Key Pressed...
  9. 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...
  10. 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'...
  11. lmarles

    NWadmin causes Illegal Operations/shutdown

    This is problem that shows up fairly regularly on Win9x machines. Go to Novell's support site www.support.novell.com/index.html and then to the 'Knowledge Base'. Put a check mark in the box beside 'Netware' and then do a search on Technical Information Document (TID) 10016433. This document...
  12. lmarles

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

    Hi Rick, Thanks for your response. I will follow your method. Lou Marles
  13. 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...
  14. lmarles

    Export Current Record to Text File

    Thanks everyone. I have it working using Do.Cmd TransferText. I have filed all suggestions though since I will likely need the other solutions in the future. Lou Marles e-mail: lmarles@trentu.ca
  15. 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...
  16. lmarles

    Automatic update of field from data in other fields

    Thanks everyone for your suggestions. Here is what I did to get it to work. I finally clued in that I could update TOTAL in the same way as I was updating ATOT and BTOT. I was trying to update TOTAL using Control Events (AfterChange, AfterUpdate, etc.) for ATOT and BTOT. But since ATOT and...
  17. lmarles

    Automatic update of field from data in other fields

    jfhewitt, Can you give me some details on how to do that? Thanks. Lou Marles
  18. lmarles

    Automatic update of field from data in other fields

    I tried that with no luck. The only thing that appears in the control for TOTAL is 'Name?'. This is Access97 I should mention. I want the record field in the table to update as well as have the total appear on the form. Lou Marles
  19. 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...
  20. lmarles

    Default to first record in table when form is opened.

    Thanks Doug, I will try that method also. Lou Marles lmarles@trentu.ca

Part and Inventory Search

Back
Top