Recent content by lmarles

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...

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...

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...

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")...

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...

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...

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...

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...

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...

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'...

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...

Hi Rick, Thanks for your response. I will follow your method. Lou Marles

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...

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

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...