Search results for query: *

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.

hi folks, I need your expertise...I am trying to maintain a text file using a random file access. I have a project with 2 forms. A main form and a data form. I have a list box on the main form where the package ids are displayed. My problem is I need to open the file and display the records...

Hi all, I have an inventory table which has the following fields: Date; Code; Beginning_inventory; Qty received; qtyShipped; then I have a query which calculates the ending inventory. It follows that today's ending inventory for a particular code will be tomorrow's beginning inventory. My...

Patty answer to question 2 and 3. You certainly can leave the dll files and your application will still launch provided that your users have these files. If any of your users fail to run setup you will simply have to copy the dlls onto their systems. I still have to confirm a response to...

Swilliams and Chrissine, Thanks a lot guys. Betwen your responses I got a solution for my project. Cassandra

Simon Thanks for your help, but I think I need to make myself clearer. I do not have want to use a database table, but two-dimensional array to look up the correct weight-coefficient. I added my list contents at design time because they will never change. My problem is that I can't figure out...