|
well you are already putting these lines in to an array correct? Try to remove the line from the array then write all the elements from the array as the new content.
|
|
|
|
|
I have a vb6 activex control to print PDF and an HTML page one after the other.
ActiveX control uses webbrowser control to print html page.
I use the following Code to print html in vb form containing web browser control:
Private Sub wbrPrintHTML_NavigateComplete2(ByVal pDisp As Object, URL As Variant)
wbrPrintHTML.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_DONTPROMPTUSER
End Sub
This control is accessed from asp.net application using javascript.
Application needs to print multiple PDF documents and html pages in the sequence pdf1,html1,pdf2,html2...
When this code is executed , in win XP ,it follows the right sequence (pdf1,html1,pdf2,html2...)
in the print queue.
In win 2000 sp4 and sp3 machines, the print queue changes to PDF1,PDF2,Html1...
Please suggest as how to resolve this.Is there any way to get information when the html printing is completed?
How to get the proper print queue sequence in win 2000 sp4 and sp3 machines?
Ravi
|
|
|
|
|
This question belongs in the web development forum. This would have to be done entirely client-side in JavaScript, though I have no idea how to do it.
Also, code running inside a browser session has no permissions to get any information about the machine it's running on. I'm guessing that the print queue configuration would be off-limits to your JavaScript code.
|
|
|
|
|
Hello,
Im basically just trying to find a way to fade in and out a button in VB.net - i just can't find anything on the internet to tell me how i could do this so I haven't even attempted myself.
I was wondering if anyone knew anything to start me going? or any URLs?
Any help would be amazing! thanks!
|
|
|
|
|
Just use a timer and set the opacity of the control.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
The controls don't have an Opacity property. Only the Form class does.
He'd have to put the controls in a Form container, set it's BorderStyle to None, create an instance of it at runtime, set it's TopLevel property to False, and then treat it like a Panel control. Follow??
|
|
|
|
|
And a quick test shows that little "cheat" doesn't work either. It looks like it's the entire form or nothing, using standard .NET properties.
He's probably have to go as far as creating his own "Layered Window" implementation of Control, then building his controls on top of that class.
Or, just do it the easy way and use WPF...
|
|
|
|
|
I have two databases I open. The first is a list of customer numbers I have to open in an oledb connection. The second is the master customer table with customer number and address info--this is opened with a sqldb connection. The fields in both are the same in respects to the data I'll be accessing. I need to somehow add the address info to the first table from the second. I'm wondering if there is anyway to do something like:
update oletable
set oletable.street=sqltable.street
set oletable.city=sqltable.city
set oletable.state=sqltable.state
set oletable.zip=sqltable.zip
where oletable.cust_no=sqltable.cust_no
doubt my syntax is correct but you see what I wish to do.
I'm just not sure if this is even possible since the two tables resite in different databases and the first can only be opened via oledb connection.
Can anyone help?
|
|
|
|
|
What is your first data source, the one you are accessing via an OLEDB connection? You might be able to set it up as a linked server in your SQL Server, allowing you to run queries that directly reference both databases.
Have a look at this article[^].
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
I toyed with that for a couple hours this AM. It didn't like the name of the sheet in excel but after fixing that I have the table excel sheet added just like the article. Now if only I could get my command to work.
update amyexcel...allanis$
set street=addrlist.street
set city=addrlist.city
set state=addrlist.state
set zip=addrlist.zip
from masterdb.addrlist
where allanis$.phone=addrlist.phone
I wish to update the street, city, state and zip fields in the excel spreadsheet/table allanis$ with the same fields from the addrlist table which is in the masterdb database. Matching them up by the phone field. I'm not a sql expert either and if you could help with this I'd appreciate it.
select top 5 * from amyexcel...allanis$ works from where I'm sitting in SQL query analyzer. I'm not sure how to specify that addrlist is in the master db and I think this is why I'm not getting things to work. How do I get it to understand that allanis$ and addrlist are in different databases?
Thanks.
|
|
|
|
|
Your update query syntax isn't correct. Your query should look something like this
update amyexcel...allanis$
set street=addresslist.street,
city=addresslist.city,
state=addresslist.state,
zip=addresslist.zip
from masterdb.dbo.addrlist addresslist
where amyexcel...allanis$.phone=addresslist.phone
I have assumed that dbo is the owner of the addrlist table.
Try this and let me know how you get on.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
First I got:
Server: Msg 117, Level 15, State 2, Line 8
The number name 'amyexcel...allanis$' contains more than the maximum number of prefixes. The maximum is 3.
So I changed it to:
update amyexcel...allanis$
set street=addresslist.street,
city=addresslist.city,
state=addresslist.state,
zip=addresslist.zip
from masterdb.dbo.addresslist addresslist
where allanis$.phone=addresslist.phone
but now it gives me:
Server: Msg 107, Level 16, State 2, Line 1
The column prefix 'allanis$' does not match with a table name or alias name used in the query.
|
|
|
|
|
Change your query to
update allanis
set street=addresslist.street,
city=addresslist.city,
state=addresslist.state,
zip=addresslist.zip
from amyexcel...allanis$ allanis
inner join masterdb.dbo.addresslist addresslist
on allanis.phone = addresslist.phone
Does this work?
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Yes, Thanks! I was afraid it'd come to joins. Tomorrow maybe I can figure out exactly how that works.
Next I think I'll send the results to the person who requested them. I'm sure they will not be happy as only 135 of the 4,000 records had matches. Hey, I can only work with the data I'm given.
|
|
|
|
|
JABOSL wrote: Next I think I'll send the results to the person who requested them. I'm sure they will not be happy as only 135 of the 4,000 records had matches. Hey, I can only work with the data I'm given.
Unfortunately, GIGO is a fact of life for those of us who have to deal with data from end users
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Yes, I also noticed some of the phone numbers they gave me to match up had letters in them! I don't know how they got that--must have been watching to much HeeHaw (BR549). I didn't say anything just let it go.
Thanks for all your help.
|
|
|
|
|
This is only possible when you are having both table in sql server.
Regards
Pankaj Joshi
|
|
|
|
|
|
Is there a way to do a week day time picker with VB.NET?
I dont want to do the date, just time. I want the user to be able to select from a range of times such as 8:00 AM - 10:00 PM on a certain day of the week like Monday or Tuesday. I figured I could do it using a combo box, but if there is a function that will use a time and day picker id use it.
I know there is a date time picker, will that do it?
|
|
|
|
|
There is a date picker, there is no time picker. You'll have to write one, or look for a third party one ( for example in the articles on this site )
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
wouldn't the datetime picker be enough for this?
If you set the format property to time you get a timepicker you will have to put the showupdown property to true so that you don't see the dropdown calender.
if you set it to custom and insert 'dddd' into the customformat property you get the weekday but the only way to change this is with the dropdown calender so it might be better to use a combobox for this.
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
I have a button that when clicked the total of set of figures in a listbox is displayed in a textbox. How can I disable that button so that if there is nothing in the listbox and it is clicked, my program does not crash, and it is enabled again when there are contents in the listbox.
|
|
|
|
|
listbox.Items.Count will give you the number of items in the listbox.
button.Enabled enables/disables the button.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
index = listbox1.SelectedIndex
listbox1.Items.RemoveAt(index)
The above code is used to remove an item from the listbox. I have tried listbox1.items.count but program still crashed when button was clicked and there were no items in the listbox
|
|
|
|
|
It's pretty obvious that this code isn't going to work if there are no items in the listbox.
listbox1.SelectedIndex will be -1 if there are no items in the list. Don't execute the second line of code if this is the case.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|