thanx so so so so much
it worked like a dream, for a moment i thought i was imagining thing but no....
i was able to change it to fit my needs......
thanx again
spider1916...
User Profile
Collapse
-
no, not the way i wanted to.........but i used the clipboard.sette xt function
to copy the number to the clipboard and then my users, after fax machine has been selected, click in the txt box where the number is requested and press
ctrl + v or r-click and paste......
good luck
spider1916...Leave a comment:
-
*****
hi nickwright
why don't you use a select case structure? if you have arange of if statements
that are the same except for the value you set it to or that it already has then
a select case statement will save you a lot of time and work...it also makes
your code more readable.
something like this (note: i have not tested this. this is only an example)
Code:if Range("G13")
Leave a comment:
-
hi
well, it's hard to give any advise without some info..........
copy the code and post it so everyone can atleast take a look.
someone is bound to spot the problem and reply with a selution.
but........from the top of my head i would suggest husing a counter and a loop.
counter is intiger set to 0
begin a loop checking the counter
*****
counter = 0...Leave a comment:
-
Hi Sashi
Thanks 4 the reply and code....
Ok, so basically once the user has chosen a printer it should be set as the
default. Then I Print the report to that printer (which is now default).
Is it somehow possible to record the default printer devicename before the user
makes a selection and then after the report has printed reset the default printer
to that recorded devicename??...Leave a comment:
-
Print to user selected printer without changing it to default???
I am using the common dialog control to allow my users to select any printer
available to them. The code I am using keeps changing the selected printer
to the default printer........ ....I don't want that.
I can't find anything with a propar salution to my problem.
I JUST WANT TO PRINT A REPORT!!!!!!!
No setting needs to be changed, ever. I only want to get the selected printer
from the dialog and... -
Convert MSaccess db to sql2005 db.....pls help!!!
pls help!!!
i need to write (or if someone knows of existing code) a vb6 application that will convert an ms access db to a sql2005 db. i have done some research and have found variase applications enabaling one to do exactly this. but none to my liking/needs. i am realy stuck on this one......pls help!!!
thanks
spider1916 -
Select multiple files to add to listview?????
hi there,
i need some help on hou to add multiple files selected in an ShowOpen dialog box to my listview. i am using my listview to display all the attached files for an email. i can add a single file at a time but need to add multiple files too. pls help. -
Send fax number from vb6 app. to printer dialog?
hi all
i am working on a application writen in vb6 (winXP PRO). in this appl. my users pull reports from an MS access db into a MSflexGrid. if they click on a supplier in the supplier column, a purchase order form appears. this form must be sent by fax. the supplier's details (fax number, contact person ets.) are read from the db and inserted into textboxes.
the fax will be sent to a RICOH Africio 2018D RPCS printer...
No activity results to display
Show More
Leave a comment: