Recent content by jplum

Without seeing your database it's a little hard....but maybe instead of having that 3rd subform (the no data form), you could just create a field on your main form with default text of "No Data" and visible set to no. Then if there is no data for your other two subforms you could set...

Can you open it while holding the shift key down? Another thing you might want to try is to create a brand new blank database, and then try to import all of the tables, forms, etc.. from the corrupt database into the blank database.

It sounds like all your calculations are being done on the form, which is the way it should be done. What this means though, is that you will have to recreate those calculations on the report as well because the calculations are not being saved in the table. You should just create your report...

Thanks so much. That worked great!

I have some code that creates a querydef, runs an export with the newly created query and then deletes the querydef. What I'd like to do is check to see if the querydef already exists before I try and create it, but I cannot figure out the code for this. Thanks!

Thanks! I guess there is no easy way to do this.

I'm am trying to figure out how to print from an array to the printer. Is there an easy way to do this?? Thanks

Yes that is what I meant. I have both text boxes and NumericUpDown boxes on my form and neither of them work like that. Once you put the text boxes on your form did you have to set any particular property for them or did they just automatically work like that? Thanks!

Is there a property that needs to be set in order for the value of the field you are tabbing to, to be selected? So that you can tab to a field that already has a value in it and just start typing, which will over write the current value. This is a bit hard to explain. Thanks Jennifer

Thanks!

No, I never did figure it out so I just used additional forms.

Is there a way to read a text file in field by field? I have a text file with multiple records, each record is made up of multiple fields which have quotes around them and are separated by commas. One thought is to read the whole record in and then search for the commas to read the fields in...

This sounds pretty basic, but I cannot figure it out. I am trying to make my form longer than one screen. I have AutoScroll set to True, but the height will not go beyond 612. Thanks.

Is there some action that the users takes (ex: a button that the users hits) before you want those fields to populate? Jennifer

I am assuming that DEMProjectID is the Primary Key in your table and that it is the name of the field on your form. I am going to call your report button cmdPrint (you can just replace the word cmdPrint with the real name of your button) Private Sub cmdPrint_Click() Dim intProjectId as...