raddrummer
Joined: Oct 26 '07
Location: Bay Area, CA
-
Will do. Thanks to all for checking it out. -
How do I set path and name of report printed to virtual printer?
Hi,
I've installed a virtual printer that allows me to save access reports as .pdf files. Within Access (using VBA) I'm using the DoCmd.OpenRepor t action to send the file to be printed. When I do this a pop up box appears asking me for the path and name of the file to be saved.
Since I'm trying to automate this process, how do I set these parameters programatically in VBA?
Below is an excerpt of the code... -
raddrummer started a topic how do I filter by the current record in the recordset (when no Form is involved)in Accesshow do I filter by the current record in the recordset (when no Form is involved)
Hi gang,
I'm stumped on something that I've been at for a few days and so am seeking help.
I'm sending emails to managers to let them know that a performace review is due and attach a custom form for the employee referenced. I have the query working and have created the recordset. The emails are generating correctly from the recordset but I can't get the code to send the active record info over to populate a report... -
SOLVED:How to state web-based location when using SaveAsWeb method
Hi ADezii,
Thanks so much. This worked perfectly!Leave a comment:
-
How to state web-based location when using SaveAsWeb method
I'm using Access to call Visio and generate organization charts (using Visio's Org Chart Wizard) and then us the SaveAsWeb method to save the file as a set of web pages.
As long as my target is on a "normal" drive (i.e. "k:\mydrive\Org Chart.htm") things work fine. As soon as I change the target to one of the folders on our intranet, I get an error message that the path name is invalid.
I thought I'd... -
Ah, good catch. I guess it's the simple things some times = ).Leave a comment:
-
VB not closing application with .Quit
Hi there,
I have 2 issues happening that I could really use some help with. These are probably really easy....
1) I'm using VB in Access to generate a Visio org chart and then save it to my machine. I'm running into syntax issues near the bottom of the page for the Target of the new org chart. I've tried:
objAddOn2.Run "/QUIET=True /NAVBAR=False /SEARCH=true /TARGET="C:\Docu ments and Settings\SLozan o\My... -
raddrummer started a topic MS Access error 429: ActiveX component can't create objectin Visual BasicMS Access error 429: ActiveX component can't create object
Hi everyone,
I'm trying to open a Visio document from Access and am getting an error that says "ActiveX component can't create object". I checked the reference library and couldn't find anything out of sorts there, but I'm no expert so I could be overlooking something. Any ideas on how to fix?
Thanks!
Here is the code I'm using:
...Code:Public Sub OpenDocument_OrgChart()
-
updating a chart on a form when data on a subform changes
I'm sure this is probably really easy but it's hanging me up so I'll go ahead and ask the question.
I have an unbound form that contains a subform containing query results in tabular format.
I want a chart on the main form that updates itself based on the currently selected record in the subform.
So far I've tried using the refresh method placed in the on change() event of the subforms properties box but... -
Now I'm getting the Enter Parameter Value msgbox looking for the values of PayrollContacts !PayrollContact , etc.....
Ist seems like the values from the current record in the record set are not being passed into the query...Leave a comment:
-
Oh boy...
1. OK, so does
Set qd = CurrentDb.Query Defs("qryLocati onCutTemporary" )
get placed in before the loop starts? If so then I get an error stating that the object could not be found as I don't create it from the template until the loop starts.
when I tried placing
Set qd = CurrentDb.Query Defs("qryLocati onCutTemporary" )
inside the loop I got an error...Leave a comment:
-
M,
Thanks so much! You're the best!!!
RadLeave a comment:
-
OK, thanks NEoPa. Let me know what details you need and I'd be happy to post them.
RadLeave a comment:
-
OK, I posted a screen shot at the link below which should help things.
http://raddrummer.spaces.live.com/default.aspx
The user makes selections from the 3 combo boxes at the top of the screen which then pass parameters to a query that filters the recordset in subform (shown in table-like format).
You can see that the user has selected the row containing Manager, Catecories 3. What I want to do is have that (current)...Leave a comment:
-
Alright, I'm officially frustrated now. The replace method isn't taking and I;m ending up with the entire (unfiltered) ataset as an attachement for all emails.
I am having success getting the recordset to advance when adressing the individual emails though.
I thought maybe tying the recordset to a form and then advancing to the next record in the form and passing the parameters of the current record through to the query...Leave a comment:
-
Thanks NeoPa,
I'm playing with this but still getting an error message saying that a dialog box is open on line 30.
any ideas????
...Code:Public Function SendEMail() Dim rs As DAO.Recordset Dim strEmailRec As String Dim strSubject As String Dim strMessageText As String Dim qdT As DAO.QueryDef ' Make sure you have a reference set to the DAO library Dim qd
Leave a comment:
-
I have a form called FRMMAIN with combo boxes that sends values to a query qryexistingjcod e that then displays the results (in tabular format) in a subform called subformExisting JCodes. -This part works fine and I've used the code below (minus the me! reference) to populate the qryexistingjcod e query.
I want the end user to be able to click on a row in subformExisting JCodes and have the data contained in the JobCode field of that...Leave a comment:
-
how to reference active record in subform list into a query
I think I'm close on this one but just need a bit of help! I have a subform that has the results of a query listed in a table view. I want the user to be able to click on a record and have that feed the information of that record to a query that will ultimately output to a chart.
I thought putting the Me! reference at the beginning of the location string would do it but it's not working.
Here's what I have so far...... -
Can you explain more about using the template? I'm not sure I get it after all...Leave a comment:
-
using VBA to download report from subscribed website.
I'd like to write a script that goes to a particuar web site, logs in with my user info, goes to a reports page, and then downloads the report into my access database. Can this be done with VBA?
Any tips on the commands that I should use to do this?
Thanks!
No activity results to display
Leave a comment: