Recent content by mvanbro

select cast(datepart(year, enterdate) as varchar(4)) + cast(datepart(month, enterdate) as varchar(2)) + cast(datepart(day, enterdate) as varchar(2)) from tablename This works but the less than 10 parts of month and day throw off the alignment. maybe a combination of sql and high order laguage...

DL mdac_typ and dcom95 from microsoft or find on office or vbasic disks and load them in the order specified.

I think all you have to do is go to the directory where your renamed file is and from dos prompt type regsvr32 -u newname.dll then rename it back to nsm.dll or whatever.... then type regsvr32 nsm.dll this will deregister the first dll, when deregistered it will not follow the rename. Once...

add a richtextbox to your form, if you will only be doing rtf files. in code when a filename is clicked on set richedtextbox.filename = "the-name-that-was-clicked" and there you are

Suppose the "Line55234123412" is stored in a vaiable called qstring you need only state: Replace(qstring, chr$(34), " ") and the quotes are gone.

use the & instead of the + use vbcrlf instaed of chr$(13)

Store it as S9(03) and define it in report as: IN CODE MOVE IT TO REPORT FIELD PIC --9 WILL FLOAT THE MINUS UP TO THE SIGNIFICANT DIGIT PIC ZZ9 SIGN TRAILING SEPERATE " " " LEADING " PIC ZZ9CR FOR CREDIT ETC...

What do you want to do in bios. I have 3.2 MF Cobol and the documentation for the call's. It employs a call by number scheme with values passed as parameters. Let me know what and I'll give you a chunk.

Place all " ' " protected textboxes in a control array then they share the same keypress subroutine

select avg(fieldname) from tablename or do I misunderstand the dilema

"Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=" & strpath Try this

access the syscolumns table in your database and change what you may. There is a lot of stuff in this table including the column names for all fields.

lose the * DELETE FROM tbl WHERE ID = 'barney'

select * from tblitembyupc where upccode not in (select * from tblexcludedupc where agentid=3) and not in (select * from tblexcludedupcgroup where agentid = 3) this syntax may not be precise but it is close to what will work