Search results for query: *

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...

I have two table that each are a many to one relationship to a main subscriber table. Each are linked by the same SubscriberID field. How can I bring the data together so that each many record will print as a separate entry, based on a DATE field called SoapDate?? Steve Marcum PT Programmer

What is the exact steps to perform the following activity in Access. reference the Microsoft DAO 3.6 Object Library Steve Marcum PT

I have a form that has a multiselect list box and takes the values from this list box and places it in a text box. However, when I come back to the form it erases out the values in the text box because (I think) there are no values selected in the list box, and it is re-running the on gotfocus...

I have an update query that clears a yes/no column to allow me to select records to print. When I run the command button to run the query I get the usually message something like "you are about to update 3 records " . I want to make it so I don't have to respond to this each time I...

I have a field in table subscribers, data type = hyperlink. I want to link an object on my form with the same hyperlink address so that there is a "sample" of what the hyperlink goes to. In this case the hyperlink will be the address to a JPEG file. Steve Marcum PT programmer