Search results for query: *

Hi All I have the following code in my Datbase for emailing the access report. DoCmd.OpenReport stDocName, acPreview DoCmd.SendObject acSendReport, , acFormatRTF, _ "graham.millichap@northyorks.gov.uk", , , _ "Test Email", "test", False, False If I export to RTF the report...

Hey All I am having a problem, the code I have here was working last night only it wasnt opening the Excel documents as they are passworded. Now it isnt saying "Cannot use paranthisis when using a sub"?? can anyone help me get this to loop through the folder and open passworded excel documents...

Good Afternoon As part of my job I build / maintain spreadsheets that now use VBA to complete tasks, one of these is emailing a workbook by the pressing of a button to make the user experience easier. The software used is Excel 2002/2003 and the messages are sent across the company email...

Hi All I have been trying to get this simple piece of code working and it is getting on my nerves?? Can any one help. Private Sub CommandButton2_Click() Dim cl As Range 'For Each cl In [D1:D10] If Range("D1") = "Outside NYCC" Then Application.ActiveSheet.EntireRow.Select...

Good Afternoon As part of my job I build / maintain spreadsheets that now use VBA to complete tasks, one of these is emailing a workbook by the pressing of a button to make the user experience easier. The software used is Excel 2002/2003 and the messages are sent across the company email...

Good Afternoon All I have VBA code that copies several sheets froma workbook password protects then emails the document to a specified address. What I need now is the code to tell the new document to break the links with the old one. Original thread here ...

Hi All Hope you can help : I have the following code and although it works first time it will not work after that as it cannot overwrite the file that is already in the temp folder, so I need to be able to let excel choose the filenames or check to see if there is a file in the temp folder...

Hi All I have code that copies selected sheets to a new workbook then emails that file to a specific address. I want to them password protect that workbook. but I cnnot specify the locaion it will be saved as it is attached to an email? I just need it saving with a password in the email for...

Good Morning This is two questions, hope you can help. I am wanting to move a spreadsheet system to Access DB and need to know if somethings can be done before I do it. 1. If I have a table for each area to enter data (there are 5 areas) I can start with a menu form to select the correct...

Hi, hope someone can help. I have got a problem with a site I am building, I have some text in a table row and then a layer attached to it so that when you move mouse over the text in the table row the layer appears which has more links in it, but when i move the mouse across to select things...

Hello Was wondering if anyone could shed any light on this problem. Every so often The wireless part of my Router just doesnt work, My laptop just will not see it neither will the other two wirless computers in the house, yet the light is on on the router to say the WLAN is working. Usually it...

Can anyone help? I have a newsletter signup on my site and it doesnt work please find the code below. mail.php <?php $name=$_POST['name']; $email=$_POST['email']; $to="chiefscomputerclub@hotmail.com"; $message="$name just filled in your News letter form. Their e-mail address was: $email"...

Good Evening I have created a server behaviour in Dreamweaver to check if a username exists when someone registers at the site. When i click submit i get the following errors? Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in...

Hi Can anyone help. Attached is the registration form from a site I am building, the form is validated and the passwords are checked but I now need to check to make sure no-one enters the same username in the database. Can anyone tell me how, as you can see from the function validuser() I have...

Hi Can anyone help. Attached is the registration form from a site I am building, the form is validated and the passwords are checked but I now need to check to make sure no-one enters the same username in the database. Can anyone tell me how, as you can see from the function validuser() I have...

Hi there I was wondering if anyone could help me, I have an order form that has a quantity and cost fields and a total at the bottom i was wondering if anyone would know how to apply formatting to the cost fields and the total field so they can appear as currency. Please see the code below...

Hi, I am new to javascript and i have a table of data that I need to display in a webpage but i dont want it to go of the edge of the page I would like a certain number of records shown and scroll bars down the side to see the rest. Any help would be appriciated. Thanks Columbo1977