Recent content by RobotMush

Thank you TechnoDuh for telling me how to set up the update query. Your instructions are quiet helpful and after having read some in my "Access Bible" I am able to follow what you are telling me. (I.E. I know enough about it now to aske the smartter dumb questions.) Got the Update Query up and...

Thank you mstrmage1768, however I am unable to make changes to the Control Source without getting errors. I.E. "#Name?" I'll read up on the Update Query in my Access Bible and see if that works. Thank you for your help and suggestions. Robotmush (Technical User, self taught)

Thank you Adalger, I'll read up on it in my Access Bible before trying it. Was unable to change the Control Source without getting errors. Robotmush (Technical User, self taught)

I have successfully created a field that calculates the date seven years after data from another field. My problem now is getting the data that was calculated moved or copied to the proper field in my table. Example. Table "Year Field", "Year + 7 Field" Query "Year Field", "Year + 7 Calculated...

In order to print just the client and all pertaining data for that client I have created a print client data button. Which is... Private Sub cmdPrevRpt_Click() On Error GoTo Err_cmdPrevRpt_Click Dim stDocName As String Dim stLinkCriteria As String stDocName =...

If I understood your question... "What happens if you click the ellipsis (...) in the AfterUpdate property cell of DeptFltrSlct ? " What happens is it brings up the Filter Program that does not work. When I did The Cut/Past I copied the working Filter Program (Combo24) to the (DeptFltrSlct)...

I have a sub-form with a combo box to filter selections that works very well. When I created another form with the need for the exact same filter process I did a cut/paste and adjusted the names to agree to the new form. However, when I run the filter in the new form I get the following...

SUCCESS!!!!! Thanks to PHV for giving the final piece of the matrix. Here is the final Program result... Private Sub cmdPrevRpt_Click() On Error GoTo Err_cmdPrevRpt_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "rptClientDetail" stLinkCriteria =...

Thank you for the suggestion PHV. I have tried it as DoCmd.OpenReport stDocName, acViewPreview, stLinkCriteria and it still displays all the clients When I tried it with the extra comma as in DoCmd.OpenReport stDocName, acViewPreview,,stLinkCriteria I got an Enter Parameter Value Error and...

Pampers; In answer to your questions… (1)It is better not to use # as in strClnt# (reserved); beter would be something like ClientID. If so, should it not be ClientID” (without str)? If strClnt# a reserved variable, I have not had any problems with it. However, in using the “str” in front of...

Thanks to all of you, specially to Pampers for spelling it out for me and also to Aceman, always great to get info from you. Will see how the suggestions work and let y'all know what the results are. RobotMush (Technical User) Self Taught

My appologies for not making myself clear. I have tried your suggestion and the report comes up but still lists all clients and their data rather than just the client and data I am wanting. Thank you for your help RobotMush (Technical User) Self Taught

I'm not quiet following your insturctions the "frmClientDetail" is the name of that I gave the report and it was picked up as such by the Button Wizard. I agree it should be "rptClientDetail" strClient# is a text string. the "#" is shorter than "Num#" Was working on matching space to data...

I have a long list of clients with their Data as a subform. What I am trying to do it to get only the Client with their Data to be the only thing that prints. What I have created in my form is a "Print Preview" button that brings up the Report. The code is... Private Sub cmdPrevRpt_Click()...

Ok, My mistake, its Microsoft Office XP... Still gives me trouble in creating the hyperlinks. Any suggestions? Thanks for your question and help RobotMush (Technical User) Self Taught