Search results for query: *

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'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...

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

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...