Search results for query: *

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

I meant to open up a separate thread. This issue with dynamically assigning the sort order is separate from the sort by the running total...however I am looking to store a value in my table to determine the sort order eventually. Reference the 1st post. Thanks

How can I sort by a variable stored in my table without utilizing SQL server commands? Basically I want to store the sort order in the table, have Crystal read this value or values and then sort based upon the variable. Thanks

Can you sort by formula results? If so, how?

Can you sort by formula results? If so, how?

I am tring to have an option available to users so that when a user hits a command button which triggers a long process, a "cancel" button can be available so that they can go back to the main form. I'm having trouble truly exiting out of the routine b/c the routine which sends the...