Search results

I copied everything into a new mdb. I still get the error! Any ideas? Sup

Wow, that was fast Bob! I am using DoCmd.RunCommand acCmdPrint so I can choose my printer and # of copies, Etc. Sup

I'm unable to trap an Error 2501 that occurs when I cancel the acCmdPrint print dialog. Here's my code: Private Sub CmdPrint_Click() On Error GoTo CmdPrint_Click_Error If Forms![frmEquipmentRates]![FrameSort] = 1 Then DoCmd.OpenReport "rptEquipRateAlpha", acViewPreview DoCmd.RunCommand...

I've been unable to find a way to navigate the selected items, though I know there must be a way to do it. Any new direction would be greatly appreciated! Thanks, Sup

Yes, download the attachment in my second post. You can scroll through the list, if you open the detail form via a DblClick. But I don't want the entire list, I want only the selected items. Vic, I understand the theory behind your explanations, but (though I've tried) I'm not able to...

After reviewing ItemsSelected in help, I can count selected items and loop through selected items. What I can't figure out how to do is determine which of the selected items I am currently viewing, and how to navigate to the next (or previous) selected item. Any further direction would be...

I got the count part, this works: Dim cntSelected as integer cntSelected = [Forms]![frmRecordList]![lstRecords].ItemsSelected.Count But how can I determine which listbox row I'm on, and which one is the next (or previous) selected row? Thanks, Sup

I've attached a sample of what I'm trying to do. On DblClick of a listbox row frmViewDetail opens and shows the record in that row. There are next & previous buttons that will navigate up and down the listbox using the ListIndex property adding or subtracting 1 from the current index. This...

On a form called "frmRecordList" I have a multiselect listbox "lstRecords" and a command button that opens a form "frmViewDetail" based on the selection in the listbox. I would like to add record navigation buttons to "frmViewDetail" so I can move down (or up) the selected records in the listbox...

This is my new code behind cmdViewDetail which does open the first record: Private Sub cmdViewDetail_Click() Dim stDocName As String Dim stLinkCriteria As String Dim x As Integer stDocName = "frmDetail" For x = 0 To lstProcedures.ListCount - 1 If...

I have a multiselect listbox on a form, and a command button which brings up a record detail form. If the user selects only one item in the listbox it works great. If the user selects multple items in the listbox, it shows the LAST record selected. I would like to show the FIRST record selected...

Hi Wayne, Thanks for the info. I found Leban's RTF control. It seems to only work on forms (I could be wrong), and I need this to work on a report. The solution that I came up with is to create bitmaps of the combined bold and normal text and put them in image controls. It seems to work...

I have a report that requires a line of text that has both normal and bold text. I currently have three labels next to each other, 2 normal and 1 bold. This works fine on my printer, however, we have an HP 3330 which formats the report differently and the labels don't align properly. I would...

The recordsource of a listbox is a query which is filtered by a combo box on the form. There are 4 possible groups to be viewed and the values for each group are Group 1=(Null or " "), Group2="Denied", Group3="Restricted" and Group4=("Approved" or an approval number). The query worked fine until...

I have setwarnings false in code and added If not isnull() code before each field that could be null. Both fixes seem to be working. Thanks for the replies, Sup

I have an A2K FE with an A2003 user. The database is SQL Server via ODBC connection. The A2003 user is having several issues with 'Error 94 invalid use of null' when appending records. In A2K this error never occurs, even while appending EXACTLY the same data. Also, the Error 94 seems to be...

OK, the code is correct! I checked the data in the table. This is a linked sql server table. When I view the data directly on the server it is correct, but when I view it from my db, all of the label values are '1'. I've deleted and relinked the table, and it's fixed. Here's what I think...

As suspected, the absolute position changes but the label_value remains [1]? Sup

Exactly! The other field in the table will be the same value for all of the filtered records. Sup

T_Labels contains 32 records, where label_value = 1 thru 32. Depending on the selection of cboProcedure, some (or all) of the labels are visible and some (or all) are not. The labels are named 'lbl1', 'lbl2', etc thru 'lbl32'. So, if the recordset filtered by cboProcedure contains label_values...