Recent content by cassandra

If your tables currently have data then you can't drop them but you can modify. Try this: ALTER TABLE (TABLE1 MODIFY(COLUMN DATATYPE CONSTRAINT CONSTRAINT_NAME));

Sunaj, Yes this is a known bug. Microsoft has a tendency of not reporting bugs until the problem has been fixed. Eli, let us know if what Norris suggested worked for you. Cassandra

Check your seupt.lst file and make sure the tlb is TLBRegister not dllselfRegister. Update your setup.lst file and re-install. Make sure you also check the setup.lst in your support folder. Cassandra

Here is a snippet of my code where I generate a serail number using the Date as part of the number. Dim leftside As String Dim rightside As String Dim tmprecno As String Dim tmprecno2 As String Sub nxtrec() mstrcriteria = "" mrs.MoveFirst leftside = Month(Date) & Day(Date) &...

Make sure that your project references to Lotus Domino object. Good luck! Cassandra

Try this Dim appDc As NotesDocumentCollection Dim ws As Object Dim notes As Object Dim db As Object Dim domsession As New NotesSession Private Sub cmdOPEN_click() Dim notesdata Dim R5 Dim domdir Set ws = CreateObject("notes.notesUIWorkspace") Set notes =...

My connection code for the connection is: Set mcnAP = New Connection mcnAP.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Source=c:\LABELS.mdb" The program runs fine on PC's with VB installed but does not find the provider after I install it on...

Thanks Craig. That worked fine but I still get error 3706 - "can't find the specified provider". I am using a data environment for my connection and the provider is Microsoft Jet 4.0 OLE DB. Cassandra

I am sorry if I gave the impression that I am just moving the .exe because I am actually trying to install the app using the setup.exe which I created using the Package and deployment wizard. I also tried just running the application after ignoring the installation errors and I get another...

Hi guys, I have a small labels project that executes fine on my PC, but when I try and install in on a different workstation I get an error that "can't register appwiz.ocx". If I ignore this error, when I try and run the app I get error 68 - Device unavailable. I am using a network...

Woyler All I needed is another brain....Thank you very much.

Woyler, Great job! One more question. My text file is a fixed file, now is there a way I can tweak it in VB instead of using Excel file import wizard? Thanks

Thanks Hardkor1001110. It works now. I changed my DUT and forced the CR when I opened the files.

Can anyone point me in the right direction on how I can save a text file into a cvs file from VB. Thanks for your help. Cassandra

Sashi You can use the Input function to read one character at a time from a file.