Search results for query: *

The procedure will receive an integer based on which button is clicked. For example: If btn1 is clicked, On Click -> Call sbPreviewReport(1) If btn2 is clicked, On Click -> Call sbPreviewReport(2) If btn3 is clicked, On Click -> Call sbPreviewReport(3) The flow of the procedue is based on the...

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

Thanks...both good ideas.

Yes the comments are a bit an the rare side and cannot be put in the main table. Thanks for the insight though.

It has something to do with the group permissions on tblComments. If I give the Users Group Update Data and Insert Data permissions everything works fine. Not sure why I need to do this. I better brush up on my security knowledge.

Yes it is. Not sure why this is happening.

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

Thanks...I guess I'll keep it as a string and only use the CDate when I make chronological comparisons.

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

The txb was not corrupt. I found a workaround. In the GotFocus event for the textbox: me.Selstart = 100 Thanks for the help...

I already tried: Private Sub MyListBox_AfterUpdate() Me.MySubForm.Requery End Sub and it does not work... I was able to make use of the listbox click event in a round about fashion. Thanks for the help...

Thanks...the Form _Current event was set for the Subform. I removed that and it is no behaving slightly differently. After I type the first character, that character beomes selected, Then When I type the next character it overwrites the first. For example, if I type: Hello I will get...

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

Thanks again for the previous help. I was able to use your suggestion in a couple queries. I have another tricky one that I have spent hours on. Somewhat similar to before in what I am looking for. I have the same table with test info. It contains the following fields: StartDate EndDate...

Thank you...I just downloaded the trial version to check it out.

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

Sorry...It looks like the ReQuery method of the combobox works if I put it in the OnEnter event. Thanks for the ideas. Was my first approch completly not doable (ie trying to write it as [Forms]!...)? If so is there a quick explanation as to why.?