Search results for query: *

I have 10 buttons on a form. Each button needs to call a subroutine. Each subroutine is basically the same. Do I have to write 10 separate OnClick event procedures, or can I call the same procedure from each button's OnClick event? For example: If btn1 is clicked, On Click -> Call...

Access 97 I have a subfom on a form. The subform basically just displays a large textbox for comments. The subform gets the comments from a table called tblComments. If there is a record to display, the subform shows the record from the table and the user is able to edit that record...

Access 97 I have a textbox on a report that displays text from a field on a form (frmSubForm). That field gets its text from a table called tblComments. The actual record from which to display, is determined from the RecordSource of frmSubForm. The textbox on the report has the following...

Excel 97 Two textboxes on a form User enters a date into txb1 (format = mm/dd/yy) User enters a time into txb2 (format = hhmm) Then I use: dteStart = CDate(txb1 & " " & Left(txb2, 2) & ":" & Right(txb2, 2)) where dteStart is of type Date I use dteStart in the header of a worksheet. It...

Access 97 I have a form with a subform. The main form has a multiselect listbox. I want to refresh the subform when the listbox selection is changed on the main form. I have been using the lost_focus event for the listbox, but I would really prefer to trigger the change when the listbox...

I have a form with a subform on it. The RecordSource for the subform is a table. The problem is as follows: User selects a textbox on the subform and begins typing. The first keystroke appears in the textbox and then the textbox loses focus. The user must select the texbox again to continue...

Access 97 I have a chart on a report. The report does not have a recordsource. The chart is based on a query. Everything is plotted fine on the chart when the query returns a limited number of records. I am not sure what the cutoff is, but when the query returns somewhere around 1000...

Is there anyway to add text directly on a chart when a report is in Preview mode? That way the users could preview thw report, add some info and print it out. If not can the report (chart included be exported out of Access into a format that they could edit (say .jpg)? I know that they can...

I know this must be simple, but I am totally stuck. TIA... If I try to enter the following as a criteria of a query: [Forms]![frmMetricsReports]![tab1].Pages(tab1).name I get the following error: The expression you entered has an invalid . (dot) or ! operator or invalid parenthesis. You may...

Excel 97 Cells A1:A3 are as follows A1: 1 A2: 2 A3: 3 The cells are formatted as text cell B1 contains =AVERAGE(A1:A3) Cell B1 displays DIV/0 error If I change the format of A1:A3 to general, cell B1 still gives the error The Average function does not calculate unless I actually retype...

I have a form named myForm There is a subform named mySubForm on myForm I want to put a textbox on myForm that displays the Comments field from the current record of the mySubForm I am struggling. TIA...

Access 97 I have a report with a chart on it. The chart is based on a query. Is there any way to save a copy of the report that displays the chart with the current query results (basically make a snapshot)? It can be in Excel, Word, or Access..

Access 97 I have a report with a chart in the detail section. The Record Source property of the report is empty Everything works fine. However, I want to display the count of the records on the report. I tried: Count(*) in a textbox, and it didn't work. When I set the Record Source...

I am trying to create a query and I’m about to pull out my hair. Please help… I have a table with test info. One of the fields in the table contains a true/false value indicating if the test was INVALID (true = Invalid, false = valid) I want to create a query that returns what percentage (or...

Excel 97 I have not adjacent data that I want to select. I have column and row numbers that define the range to select. i.e. Columns 2 and 7 Start row 3 end row 5 Based on the above, the selection should be: Range("B3:B5,G3:G5").select How can I create a VBA statement using the numeric...

Access 97 How do I run a report from vba? TIA..

Access 97 I have been learning Access development for several months now. I am still struggling with sizing of forms. I would think that if I set the form width to 5 inches that the form would be displayed 5 inches wide on the screen. However, it seems that it is actually displayed based...

Access 97 I have a select query that returns data for a particular lab. I tried to change the criteria to return data for both Lab1 and Lab2. If I change the first criteria line for the Lab field to "Lab1" or "Lab2" and get 9336 records If I change the criteria so that the first criteria...

I am trying to pass an string such as Lab1 AND Lab2 to the criteria of a query. The string will come from a textbox on a form. The user will enter something like Lab3 AND Lab5 AND Lab6 to the textbox. When the query is run, it should read the textbox and use it for the criteria of the Lab...

Access 97 I am creating a report with a chart on it. The chart is based on a query that has uses "Between And" for one of the ctriteria. If I hardcode the dates in the query criteria: Between #9/1/04# And #12/15/04# the Report shows the graph as expected. However if I try to read the...