I have a input box as follows:
Public ClientNumber As String
ClientNumber = Application.InputBox("Enter A/R Client
Number in 4 digits (ex: 0195): ")
What is the proper syntax to get the ClientNumber entered in the input box to work in a file name to be retrieved?
(the following will not...
WHEN I ENTER THE FOLLOWING IN CELL C1,
=IF(AND(A1>0,A1-B1,"")
THEN IN CELL C10 I ENTER
=C1*5.10, I GET #VALUE! RATHER THAN ZERO.
THE REASON I AM USING "" IN THE FORMULA IS I WANT C1 TO SHOW AS BLANK NOT WITH 0 (ZERO) AS 0 WOULD DO. BUT THE "" IN THE FORMULA CAUSES THE #VALUE!.
HOW CAN I GET...
How do you set a macro to run when a word document is word document is opened? The macro is only for that particular document.
I know how in excell, I merely name the macro auto_open. Doing so is not working in MS Word.
Mike
mikeburg@gower.net
How do you e-mail a .pdf document as the e-mail message itself instead of as a .pdf attachment?
In other words, when the receiver opens the e-mail, they see the document as the message rather than having to open an attachement which requires Adobe Reader to open it.
New to Adobe Acrobat.
Mike...
Thanks for your help. It appears we get the out of memory error when printing to the HP 4300 which we just purchased & set up starting January 01, 2004. I do not get the error when printing the the HP IIIsi. We are using Windows 2000 professional. Any ideas?
Mike
mikeburg@gower.net
Trying to print to laser printers a mail merge a letter with a data base. However, I get the error even if merging only one record or letter.
Thanks,
Mike
mikeburg@gower.net
Thanks for the response. No I am not running out of disk space or memory. I have a 35 GB hard drive with only 6.5 GB used. My computer has 1GB memory.
Any other ideas?
Thanks,
Mike
mikeburg@gower.net
Thanks LesNicholls. I have been doing this but in My Computer the network drive shows as
c$ on 'server2001'(Z:).
I need it to merely show as Local Disk (Z:)
Thank you.
mikeburg@gower.net
Is there a way to set a network drive so it shows as merely a local drive letter rather than as Network Drive c$ on'server2001'(z:)?
mikeburg@gower.net
My computer has Windows 2000 Professional. I have it set to where "Users must enter a user name and password to use this computer".
When another user logs on they have their own desktop.
How do I prevent other users from being able to use the internet from my computer?
I tried...
I am having trouble creating a macro for MSWord to fax a document using control + F.
I do use application.sendfax in the macro, but I have to click thru a series of screens. I need it more automated where after control + F, it will prompt for the fax number. After entering the fax number, I...
I am needing a business contact mailing list data entry program written in ActiveX Data Objects (ADO).
The access data base fields are:
PHONE (primary key)
BUS_NAME
OWNER_MGR
ADDRESS
CITY_STATE
ZIP_CD
CATEG (category code)
UPDA (update code)
CNTC (contact code)
PHONE_2
PHONE_3...
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.