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
My computer has been upgraded to MS Office NT. This of course upgraded the Access Database Program which results in my inability to create hyperlinks quickly. What used to take a maximum of 4 clicks of the mouse now takes 14 - 15 clicks. This is due to a new hyperlink popup window that forces...
Well, I kinda did that, what I entered was...
"Me!FileType = UCase(Left(Right(HypLnk,4),3))"
And that seems to do quiet well. However, if I used yours would that allow the chkHypLnk to click off in the event that I have to delete the hyperlinks to where non are Hyperlinked to that client...
OK, Can you say MUD ON FACE? I went back to my query that my subform is based on and guess what. I didn't have the FileType form in there from the table but rather as an expression when I was trying to get the extension all in capital letters. Rectifying this by removing the the Expression...
I mean with the subform filetype field at present is an unbound textbox and the program is working. However when I try to bind the textbox to the FileType Field in my tblHyperlink then it crashes with...
"Run-time error '3327': Field 'FileType' is based on an expression and cannot be edited."...
Ok y'all, the program is up and running, almost as needed. It is automatically making chkHypLnk as true, and putting "pdf" in the file type. However, the Filetype in the tblHyperlink is not being updated. This of course is due to the filetype textbox being unbound. When I try to bind it the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.