Jollywg
Last Activity: Oct 19 '11, 04:43 AM
Joined: Mar 17 '08
Location:
-
Hmmmm....lets change gears a little bit. If I manually export the report as a .scp or .pdf can I email it from access 2007/10? -
Adezii, I am running into a small hold up. The database my client has uses Workgroup Authentication. I have the username and password for an administrator, I just need to specify that when it does the appAccess.OpenC urrentDatabase strDBLeave a comment:
-
ADezii, thank you for the quick reply! I do have one concern, will this cause a pop up box to disply when the message sends stating "A program is trying to send mail on your behalf..."?
Thanks
JollyLeave a comment:
-
Send a report from one access database via another access database
I have a client that has all their reports, data, and code in Access 2000...They also have a copy of Access 2007 that they want to copy or somehow trigger a report in access 2000 and email it to 150 employees since emailing in access 2007 is much easier and more robust than it was in access 2000.
Just in case this gets confusing, they are wanting to press a button in access 2007, which emails ReportA from access 2000. Let me know... -
Thank you for the response, can you assist me in forming the code or pointing me in the right direction to export into pdf. If this seems like an arduous task then would it be easier for me to manually export the report with a 3rd party tool (which I have) and then use vba to email that file?Leave a comment:
-
Does Access 2000 support acFormatPDF?
Does Access 2000 support acFormatPDF? I'm getting a Variable not defined error on this line...
Thanks in advance!Code:DoCmd.SendObject [acSendReport], "5141-Consol-IndivRpt", acFormatPDF, !EmailYH, , , "Monthly Trainings Due", "Your Monthly Trainings Due Report is attached"
-
Nevermind I found it
$a = get-content "C:\path\compli st.txt"Leave a comment:
-
Power Shell: Read file into an array
I have a script that gets all the computer names on the network and saves them as compnames.txt. I would like to read or insert all of the names (delineated by new line) into an array or power shell equivalent. How would one go about doing this?
Thanks in advance
Jollywg -
Cisco PVST to MST
I have 3 Cisco switches (catalyst 3600 series I think) that I am wanting to move from PVST to MST. Two of the three switches I can type "spanning-tree mode mst" and it takes it. This last one any time I type that it locks the switch up and I loose my connection, leaving me no choice but to restart it (which of course resets it back to PVST). There are only 2 vlans
1 -disabled and 2 everything is on this vlan.
Let... -
Thank you so much that worked perfectly!!!Leave a comment:
-
worked great...now i have a new issue lol.
when i go to http://www.pc-instructor.com it brings up the "It Works!" page, but if i go to http://www.pc-instructor.com/pc-instructor it brings up the correct page. How do i tell this to point to the pc-instructor folder in Ubuntu?
Thanks again!
MattLeave a comment:
-
Accessing my web server from the outside world
I have successfully installed "LAMP" and can get to my web server by typing 10.0.2.15. How can I make it so that when I type in my domain name it brings up my web server.
Thanks in advance!
Matt -
eh its close, actually it does everything but the computer description :)Leave a comment:
-
Change computer description with command line
I have a network a of about 250 computers, to which some have something in their computer description field and some do not. I would really like to add a computer description remotely from the command line. The only problem is I do not know what the command is. I've done some research and I've seen where some people made registry changes...I would really like to avoid doing this ;-) Any help would be greatly appreciated!
Jolly -
88 mp3's on a CD-R....really good algorithm??
First off this may be the wrong area for this question, and if it is I apologize.
My boss handed me a CD-R with 88 mp3's with full quality. I was skeptical of course, but sure enough there were 88 songs that sounded wonderful. He said he got it from his brother-in-law and we were both wonder how in the world he did this?! I know that MP3's are a "lossy" format, but there must have been some algorithm or special software... -
Thanks for the posts you both are lifesavers!Leave a comment:
-
Thanks for the posts semomaniz and frinny! I'll give them a try and let you know how it works out!Leave a comment:
-
code
I'm pretty sure all my syntax is correct, with the exception of usersRemaining = objCmd.ExecuteN onQuery();Leave a comment:
-
Wow thats weird sorry about that.
...Code:String user = Convert.ToString(Page.User.Identity.Name); String address = Convert.ToString(txtStreet.Text); String name = Convert.ToString(txtName.Text); String city = Convert.ToString(txtCity.Text); String state = Convert.ToString(txtState.Text); int zip = Convert.ToInt32(txtZip.Text); int phone = Convert.ToInt32(txtPhone.Text);Leave a comment:
-
Assign sql query result to variable
I'm trying to make a page where the user can view his/her user info. If they have not entered any info they should be able to click the button and their info is stored in an access table named Users. If they already have data in the table then it should update with what is in the text boxes.
For some reason usersRemaining always stays equal to 0 and never moves to 1 even if there is a user in the database.
Attached...
No activity results to display
Leave a comment: