Search results

SO sorry Bob! and Thanks DCrake Hi Bob and D, Thanks for your replies. I'm SO sorry I didn't post the code correctly. It was my first time posting code and I didn't know how to do it properly. The changes I made to the forms were to add the 2 fields. I've done simple apps before and had no...

I have been asked to make changes to an app that is WAY more complicated than anything I've ever done. The changes themselves are no problem (add 3 new fields to each of two tables and modify 2 forms and a report). The problem is after I make the changes the app doesn't work. The database...

Wayne, Thanks. Believe it or not, despite my ineptness I had tried that. The thumbtack remains at the bottom. Private Sub Form_Open(Cancel As Integer) Me.List9.Selected(Me.List9.ListCount - 1) = True Me.List9.Selected(Me.List9.ListCount - 1) = False Me.List9.Selected(0) = True...

I'm getting there, I did a requery and the listbox scroll works again, but can you help me get it to to top of the list again? Sorry to be a pest! Erika

Wayne, That seems to be a great idea. I'm new at this and I'm afraid that I was able to implement the select and deselect, but now the scrolling in the box is frozen. It seems that I have to do something like selecting the listbox again, but I'm not sure how to do it. Thanks for your help...

I have a list box on a form that runs a query returning 1315 records. If I click on the down arrow at the bottom of the vertical scroll bar the list box works fine. But if I click in the vertical scroll area, click and drag the thumbtack or click on a record I can't get beyond about 24 records...

Thanks! Thanks, Pat. You're the best! Erika

I have a form where a user can enter part of a description and press a button which will open a form using their input as a filter. I was using the filter by form, but ran into what appears to be a common problem that there is no easy way for an uneducated (or lazy) user to apply the filter...

Can't thank you enough Adam, I'm obviously in over my head, but your help has taught me a great deal. Thanks very much! Erika Donahue

Chagrined Sorry, Pat. You're right. As you can see I'm new at this. I'll follow your advice on the keys, etc. and I'm still thinking about combining the CP and AO table. The problem I've been having is on the Proposals form.

Thanks, but still not working Thanks Adam, unfortunately it still doesn't work. It actually doesn't work for CP or for the AO number. If CP is typed in it brings back a description, but not the right one. VERY frustrating. :(

Still stumped Thanks to both who responded to my plea. The form is still working as in my code. If the number starts with CP it picks up a description that doesn't match the the cp number in the cp numbers table. If the number doesn't start with cp it picks up no description at all. This...

I am trying to do a dlookup to fill in a description field on a form based on a number that might be stored in either of two other tables. I have CP numbers and A numbers. If the user types a CP number in I want the Dlookup to go to the CP Numbers table. If the user types in an A number I...

I'm executing a macro to run some reports from an Access Database and saving them as HTML format, but when I view them in IE the columns are all misaligned. What is the easiest way, if there is one, to force the columns to align properly in the browser? Thanks

I'm trying to create a report that, for each record, links to a different scanned image. The file name for each image is stored in the table with the document number and other info. I created a query, concatenated the fields that contain the path and filename and, for that field on the report...