Recent content by JJordan

Well, it does not work again on the new Three Trees computers so I guess I need to isntall WinFax on them ??? Damg it this is a bunch of BS !!!!

I DO have WinFax installed on ONE of the computers that I work on the database with (work). I did what you suggested -- added the Winfax combo box to ONE form, closed that form without saving and ALL my forms work now. What The heck is Up with That ? I hope they stay working. I will have to...

I have already tried completly starting the Forms over from scratch and it still happens.

Any One Have any other thoughts -- this is a real problem since there are about 2000 donors entered and scrollling down to find a person whose name starts with S is Baloney ! I have created new forms and they work and then quit.

And doesn't the Command Button wizard get you the same place by setting the button to record operatins, undo ? CLears the whole form for me.

Sounds like you need to store the Name of the Report they chose in a Table (ReportName) so that after they pick a name one time, it is always available to the reports. You can cause the Querys used for the reports to pick up that stored name and put it in the Header. You can create a Form to...

I am not sure I understand either. I assume you have an underlying report you want to run and that the report is run off a Query. I assume then that the form is what you want the user to use to generate the Report and it has a combobox that the user selects that ONLY changes the Title to the...

If the report is the SAME and All you ned is for it to report a different title based on the combo box slection, just create a Text Box in theForm Header and in that box, put in =[forms]![yourformname]![comboboxname] Edit: Can you beleive how bad my tying was on that.

Thanks Pat, that changed the Box contents, but did nto fix the probelm that when you start typing the list does not jump forward to the J's for example when you type J or to "Jor" when you tyope "Jor" . I hav eno idea except i tink it has something to do with the fact that the Bond colum is...

Yes, it is.

It is set to YES. Could it be becuase I have three items in the query/combobox, ContactID and two Expr's and the ContactID (number) field is the Bound Column with its width is set to Zero? I have no idea. It was working and now it does not. Could it be that I need to open the form with some...

I have a form that selects Contacts from the contacts table to enter donations in the Donations table. Because there are companies and individuals in contacts (fistname, lastname and companyname fields) I set up the box to select as follows SELECT Contacts.ContactId, IIf([companyname] Is...

I think you need to start with a Query that gets the data you want from your table with a Between clause in the Criteria for the Query. You can link the criteria to your form as follows: Between [forms]![yourformname]![FormFieldNameForStart] AND [forms]![yourformname]![FormFieldNameForEnd]...

Edit: Yes it does, I will try the Macro. As to the structure and need for multiple tables, Caveat - I am NOT a programmer -- this is a volunteer project for Three Trees :) TableNames Below are made up for illustration of what I have (the actual names are worse - spaces and stuff I learned is...

The form I am working with is to Add a NEW CONTACT (which is assigned a ContactID) and then Open a form to enter Famly Data for that contactID. It is not really populating a new form with data because the "Family" does not exist yet in the Family Table (both forms are being opened in Add mode...