Recent content by wusinik

In Access in the File name: box, type *.dbf

Thanks - I tried this but I get an error: Run time error '3265' Item not found in this collection. Do I have to change some properties for the data object?

I can execute the following code fine, but the value in FIELD is a variable...is there any way to dynamically assign this value in the recordset? datFirst.RecordSource = "SELECT DISTINCT " & field & " FROM table order by " & field & ";" While datFirst.Recordset.EOF...

I get an error - Compile error: Expected: end of statement on the line - cnn.ConnectionString = "ODBC;DBQ="MDBFile.mdb" & ";UID=;PWD=;Driver={Microsoft Access Driver (*.mdb)}" Then the cursor highlights the quotation mark where MDBFile.mdb is referenced. Do I need...

OK, now here's the last step, I want to fill this new table with the contents of a dbgrid...I have the contents of the dbgrid saved into a table named template. I want to save the contents of template/dbgrid as NEW_Table and then clear the contents of template so that I can repeat this process.

That dbText did the trick - thanks so much!

I have implemented the code but I get a run time error when the code hits the line: dbsNew.TableDefs.Append tdfNew 'add the table to the DB the eroor is : Run time error '3259': Invalid field data type Any ideas why this is occuring? The only real change I made to this code is I referenced a...

I'm looking to allow users to create a custom table by editing an existing table or creating a new table from scratch. Can VB allow for a createTable - like property? Thanks

I am looking to allow users to create a custom table. What I want to do is have a dbGrid based on a table called TEMPLATE. Then I want to allow users to enter data in the 2 rows: VALCODE, VALDESC. When they are done and click the DONE command button, I prompt them for the new table name. My...

I am working on a project which includes several AVI's which add up to more than 740 MB of space...I think I am going to have to store the files on 2 cd's but I'm not sure how I can go about doing this so that users will not get too confused. I was thinking I could run a setup program which...

I am trying to compact my local databse every time data is written there(initiated by pressing a command button)...the problem is that I get a message saying that the database is already opened for exclusive use by myself. There are DAO's on the form. Can I execute the compact command even if...

Both of these code bits were very helpful...thanks!

Also, I only need to check the C:\ Drive on clients' machines because that is the only drive where my program writes to. Thanks so much for your assistance!

This code will be very helpful...however I need to read the amount of AVAILABLE/FREE memory, not total (used + unused) RAM.

I am looking to check the amount of RAM available on client machines before a command can be executed...I think I need to utilize sysinfo but I am not sure exactly what functions to call. Thanks