Recent content by kptasteve

I have a form with a combo box. I want to keep the control source the same but change the row source for the combo box to different tables based on the on click event of a command button. How do I change the row source property programmatically. Steve Marcum PT, CSCS Programmer

What is the maximum number of sub reports that are allowed in a report. Does having subreports speed up or slow down a large report. Steve Marcum PT Programmer

I want to set up forms using wizards and text fields. Then change the text fields to combo fields, but would like a way set the properties for all the combo fields at once. Then I can copy the form and use it with a different record source without having to tediously go through the setting...

I need to calculate the age of a child down to the month and day does anyone have a set of code that will give me the age of a child in years months and days?? Steve Marcum PT Programmer

I have a combo box on a form cmbCombo48 that gets its data information from a query. I then use it to select and fill in text boxes. What I Would like to do is use a command button to change the source of the information data that the Combo box is using. That way I can vary the information to...

This may seem like a DUH! question, but it just hit me. Say I have a Sub procedure named "popitup" that opens a form using VBA code. To call or run the subroutine or function routine, is to just put the name "popitup" in the area next to the event using the properties...

I know I should know how to make this work, but it continues to allude me. How do I use an ActiveX control DTPicker to chose a date then use the values to query for a report. I would like to assign it also to an unbound text box. Steve Marcum PT Programmer

I have learned that I can copy and paste Excel Data into a Memo field. Only thing is that is will only paste 2 columns Is there a reason for this. Steve Marcum PT Programmer

I want to be able to begin using the Tag property to make groups of fields visible on a form. A short example would be to have a short and long version of a form based on how much information is needed. How it the TAG property used for this and to maybe set background colors based on a input...

That is exactly what I am doing. I need to have each record print on a separate page, I have to have this as each one represent a different note for a different patient. I have the report coming from a query, with two table. One table is Subscribers and the other is Soap notes. The query is...

Neither of these seem to work. What I have resorted to is using a old report and reformatting it. It works fine. But I am still wondering why the other one is printing the blank page, but more importantly how to troubleshoot to find the answer. Steve Marcum PT Programmer

I have a report that used a query and it formatted fine. Then I added conditions to the query and now the report prints with one blank page at the end of the report. I am not sure why, but how do I trouble shoot this?? Steve Marcum PT Programmer

I have two tables : one "SOAP" and another "SoapQuick" both tables have a field [soapdate] and a relation field [SubscriberID]. However the two tables have different text fields that contain descriptions of patient encounters. I need to be able to print a comprehensive list...

How do I get a report to print text fields that only have data in them AND have the detail lines shrink if there is no data, so as not to have gaps in the printed output. Steve Marcum PT

I would like to have a check box form that the user can fill in fields and check boxes. Then run the report and show only those fields that have check marks or have data in the text boxes. I want to show the label corresponding to the check box as well. And finally not have blank fields...