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...

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.

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.

I have been assigned the task of automating backups without the use of SQL Server Agent. To date I have been able to create and successfully call a VB app( using xp_cmdshell) which can do the backups with SQLDMO. Now I need to create some kind of trigger which will run only when more than 100...

is it possible to use "Primary Key" as a reference to the field to be searched as in dao. IE My ADO code tTable.Open sTable, cnxnCroppak, adOpenDynamic, adLockOptimistic tTable.Fields(0).Properties("OPtimize") = True tTable.Find "[Primary Key] = " & lTableKey Original DAO code Set...

Hi there, I have been working on a stored procedure to return a value based on a number of variables, including table name. This was posted earlier. The advice recieved was great but as I only need a single value returned noy a recordset I thought I might ask more advice. heres the sp CREATE...

I have tried running this for three days with no success,any ideas anyone?? CREATE PROCEDURE spGetThisTableField --@ReturnVal as int output, @strTableName sysname, --Recipes @strCompareFld as char(50), --RecipeKey @strSearchValue as int, --9 @strFieldToReturn as char(50) --PackCodeKey...

My db has a table with two fields ClientKey(Pk) and ClientType(char). By providing the ClientType variable I need to return the ClientKey(integer), as this is a single value I see no reason to return a rs, a simple int value should be less resource intensive?. I'm developing in vb6, example of...

I was hoping someone can help me with a rather unique problem. I would like to use a variable names as control names to print value of variable. To clarify I have a form with multiple controls that is used as a template to print a label(form). As there are multiple label confiurations each...

How can I add an Integer value, "Runtime", to a full date field in a VB6 query. StartAt is stored as a full date/time field in an access 2000 db. What I need is to end up with 2 fields 1: StartAt 2: FinishAt FinishAt is StartAt + RunTime, this is what I have tried so far. 'Set...

This works if I take out either the > or the = parameter but will not work with both, what have I done wrong. Set recset2 = cnDataBaseConnection.Execute("SELECT * from Screening WHERE Screening.CinemaNumber= '" & Cine & "' AND Format$(Screening.StartAt, 'DD/MM/YYYY') > =...

This works if I take out either the > or the = parameter but will not work with both, what have I done wrong. Set recset2 = cnDataBaseConnection.Execute("SELECT * from Screening WHERE Screening.CinemaNumber= '" & Cine & "' AND Format$(Screening.StartAt, 'DD/MM/YYYY') > =...

For visual effect I am using three datalists to show different fields from a recordset. I'd like to know if there's a way to set the selected item position in the 3rd datalist to match the selected item in the first datalist. i.e. If the user selects the second item in dtlist1(the 2nd record)...

The array is declared as dynamic and i is set to 0 via a cmdButton that is used before this sub is activated. Iwant the array to increment each time this click event is fired, storing the result each time. Can anyone see whats wrong please, I'm a newbie. Private Sub lblSeat_Click(Index As...