Good Morning Experts,
I was trying to find a way to automatically open a report in MS Word when I click on a command button. I was not able to find a way to do that.
I was able to open the report in Access and then I can send it to Word. I also was able to save the file as a .rft or .txt file and then go to Word and open it.
Is there a way to click the command button and have the report open in Word...
dougmeece
Last Activity: Jun 24 '08, 06:05 PM
Joined: Feb 5 '08
Location:
-
Open an Access report in Word by clicking a command button
-
Open a specific Word doc from an Access query result field?
Good Morning Everyone,
I had a idea that I woulld like to pose to the forum. I have no idea if this is possbile but from what I could find searching it does not appear to be.
I created a datebase of my writings with two forms, one for creating records and one for searching records. If I wanted to open Word to read one of my writings from the results of a query by double-clicking on the title, is that possible?
... -
That seems to have taken care of it. I installed the hotfix, recreated the radio buttons and tested it. I had no problems with the field getting set to zero.
Thanks again...the form just looks so much better with the buttons instead of another drop down. -
Yep, I have Access 2003 SP3. I'll check out the link you provided and thanks to everyone for the help.Leave a comment:
-
Well it appears that it this problem had something to do with the radio buttons I was using. I removed them and went to just a combo box with "Yes" and "No" as the options. Everything now works fine. I still will try to find out what the problem was but for now it works...so...Wo o Hoo!!!Leave a comment:
-
I have two radio buttons (Yes and No). I also have a text box that I populate with whichever radio button is selected. I return the results in a subform. I have one subform per query search. They are all invisible until the corresponding button is clicked. I am just starting to figure out how to reduce my code so I know I have quite a bit of unnecessary code and I plan to figure how to combine things in time. First though, I would like to get...Leave a comment:
-
I have not seen the error before but it sounds like you did not create the database and simply need to be given permission to admin it. I don't think it is really an Access issue.
It appears to be either related to the database itself or the folder it resides in and you do not have the access to one or the other or both for performing the conversion.
I am assuming you are on a work PC.
If so, is the database you are...Leave a comment:
-
By the way, I forgot to mention this. The field gettin gchanged is not a numeric field. It contains either Yes or No only.Leave a comment:
-
It is happening on only the first record. I have stepped through and checked the table after each step; the field is set to zero after I click the Close Form button.
- It happens when I run each query and close the form after each one.
- It does not happen when I go to the serach form and then only click the Close
Form button
- It does happen if I go to the search form and click the Clear Form button ...Leave a comment:
-
Field getting set to zero
OK so I have been able to fix all of my problems with much help from the experts...thank you experts.
However, now something really weird is happening. As you know I have two forms (one appends/updates a table and the other is just for searching records).
Since I corrected the problem from my previous post of adding a new blank record when searching I now how one field in only the first record that is being set to zero... -
I have this fixed. Turns out it was two things. One the form was not set with the proper data source. Second, the query was not setup properly. Once I change those two things it stopped adding the blank record.
Thanks for the help....Leave a comment:
-
Its actaully a form with some subforms on it. I'll check out the link.
Thanks...Leave a comment:
-
Here is the Code for the 2nd form:
...Code:Private Sub CboTitleSearch_AfterUpdate() Me![TxtTitleSearch] = Me![CboTitleSearch].Column(1) End Sub Private Sub cboPublisherSearch_AfterUpdate() Me![TxtPublisherSearch] = Me![CboPublisherSearch].Column(1) End Sub Private Sub CmdSearch_Click() On Error GoTo Err_CmdSearch_Click Dim stTitle As StringLeave a comment:
-
New "Blank" Record Added When Search Runs
I have two forms with one calling the other to perform searches. When I run the search form the 2nd form a blank record is added to my table. The table is appended or updated from entries on the first form but the second form doesn’t reference the table at all. The queries ran from the form obviously query the table for data but these are not the same queries that update/append.
Any ideas what would cause this to happen?... -
Sorry about the double post. In the first I had entered the word "Thanks" at the end of the subject and I thought that might lead people to think that I had my answer and was thanking people for the help.
NeoPa,
I am so far removed from VB and Access that I am basically starting over. I am sure I have many things wrong in my code and I appreciate any and all critiques.
I have tried entering...Leave a comment:
-
Cannot get Append/Update queries to work..Please Help
Morning Everyone...
I have a table that needs to be append to and also updated. All the fields in the table are populated with data from the text boxes and combo boxes on a form. The Date Submitted defaults to 1/1/00 if the cboSubmittedBox field is "No". Otherwise it is selected from a calendar. The Date Entered field defaults to the current date. There are 3 sets of criteria that need to be checked for the update or append... -
This is the entire active code for that event:
...Code:Private Sub CMD_AddRecord2_Click() On Error GoTo Err_CMD_Add_Record2_Click If [Forms]![Poetry]![TxtTitle] = [Created_Submitted].[Title] Then Dim stUpdate As String stUpdate = "Created_Submitted_Update" DoCmd.OpenQuery stUpdate, acNormal, asEdit End If Exit_CMD_Add_Record2_Click: Exit Sub
Leave a comment:
-
I did that but I am now getting the message: Microsoft Access can't find the field "|" referred to in your expression.
I have also created...Code:If Me![TxtTitle] = [Created_Submitted.Title] Then Dim stUpdate As String stUpdate = "Created_Submitted_Update" DoCmd.OpenQuery stUpdate, acNormal, asEdit End IfLeave a comment:
-
Unable to run Update Query...Please Help
Hello experts,
I have an update query that I want to modify records meeting a certain criteria in a table based on information on a form.
I am having trouble recognizing the table for a comparison to text box on the form.
Table Name: Created_Submitt ed
Update Query: Created_Submitt ed_Update
Text Box: TxtTitle
...Code:If Me![TxtTitle] = (Created_Submitted.Title) Then
-
I read online that Access 2000 and 2002 will not allow the Currentdb command to work. I am using Access 2003 Sp3 on an XP machine. Do you think this be a problem for me?...Leave a comment:
No activity results to display
Leave a comment: