Search results for query: *

Hi, hoping that someone may be ableto help me with an example of sending DPL formatted text file to LPT1 via VB6. Ideally I will be creating the entire label from VB6 but am stuck at the moment with sending corrctly formatted DPL. Anyone Please If you love your job you never have to work again.

Hi there, we have used PPLB to create txt files and send to a printer via parallel port but now the printers are attached via a print server and I cannot use the same VB6 code to send the text file. Has anyone done this or have any ideas. For some reason the port is seen as Ne00: instead of the...

Hi there, we have used PPLB to create txt files and send to a printer via parallel port but now the printers are attached via a print server and I cannot use the same VB6 code to send the text file. Has anyone done this or have any ideas. For some reason the port is seen as Ne00: instead of the...

Hi Guys, I have several apps that send a .txt file directly to a local port ie comm1.(Thermal label printers) This works well but I now have a requiremnet to send the same file to a printserver. It doesnt matter what I try I cant seem to get this to work. Another strnge occurence is the...

I have a reasonable amount of experience printing EAN barcodes but now have a problem reducing the total width of a PPLB generated barcode. The following is the code used in VB6 to generate the barcode. Print #1, ("B20,165,0,1E,2,2,160,N," & Chr$(34) & "01" & Trim$(sEanNo) & msvarPG &...

hoping someone can help me to execute a *.dts file from vb6. I have used a small vbp written by Josef Finsel called DTS Packager which creates a dtspackage that will recreate a database when run, it also copies data from all tables into .bcp files. i can't figure out how to execute the .dts file...

Here's a link http://www.devx.com/assets/zip/8097.zip If you love your job you never have to work again.

Do a search for an Addin called HelpGen. It creates HTML help files for an entire project. Then use a compiler to edit it as required, create TOC etc. I did this just the other day. Works great, it even creates screen shots of every form and control. If you love your job you never have to work...

Thanks strongm, thats it exactly. I opened the vbp in notepad and had a wee look. Should be reasonably simple to open and enumerate each line of the vbp, compare new exe references to a list of original EXE references then install and register any ocx,dll files that were not part of the original...

Thanks for all the help, but the initial question remains un-answered. How to write a sub that will list all ocx,dll files referenced by the project that need registered. It must be able to be done because I have seen small apps that list all project files, including ocx,dlls that need...

Not quite correct, a program will contiue to run after providing 479(I think) error. This error could be trapped, the name of the offending ocx\dll provided to a var which then could be used to provide info to software provider. We hsve a constantly evolvong app distributed to a large number of...

Just wondering if anyone knows how to list all ocx and dll files in project.What I would like to do is be able to intercept the error that occurs when a dll,ocx is missing. Then use the name to search for and register the control from code. If you love your job you never have to work again.

why is it the obvious eludes us. Thanks If you love your job you never have to work again.

Thanks donutman, have created 2 UDFS each works to return either alpha or numeric, now the hard part. In order to be able to sort the numeric I need to either cast or convert the derived column as indicated by the example below, but it dont work SELECT DISTINCT dbo.alphaonly(Run.Run)as alpharun...

update example DECLARE @mystring varchar(15) declare @tempstring varchar(1) declare @charString varchar(15) declare @intString varchar(15) declare @itsAnumber int set @mystring='a12345' declare @i int set @i=1 begin while @i < Len(@mystring)+1 begin select @tempstring =...

i have a field of type varchar Example values: a1234, 123b,c963,1122,1235 etc I need a way of seeing if there is a char(a-zA-Z)in each record and if so strip it out so I can have two derived fields for sorting on, One of type int and one char. ie derived field 1 contains a b c derived field 2...

Is there a way that I can raise an event of my own from the class initialise event. Ie My class is named Util, I need to have a Util_initialise event of my own that is raised when the class initialise event is raised.

Magic, hmmmm, what if one of the database's hasn't been updated at all for 2 or 3 weeks,(which happens with our clients), not a great deal of sense in backing it up every 15 min's is it.

Cheers for the responses guys. Am also looking at using scheduling agent but this leaves posibilities for error which is not acceptable. Like SQLBill said, alot of work to set up, but foolproof after that.

Yes it will hapen every day. Our clients have multiple databases all of which are mission critical. I plan to do a db backup Monday, incremental backup once daily and logfile backup after x(100) changes to the db. From what I have been able to understand the only way to schedule backups by time...