Recent content by jack1234

Hi, i wish to check the user C drive remaining spaces using vba, how to do this?

For the following code chk is a check box, ischecked is a yes/no field. Dim sSQL as string sSQL = "Select [ischecked] from tbluser where userId='abc'" chk.ControlSource = sSQL chk.Requery But when I run the following vba code, no matter ischecked is yes or no, it always shows me the checkbox...

I have a listbox call lst with two columns, what I want to do is to populate this two column with "firstdata" and "seconddata" respectively. What I do is: Me.lst.RowSource = """firstdata""; ""seconddata""" But I see nothing appear, what is the corect way to achieve in vba?

What is table level lookups?

1)How to set show or not show key column for list box in propeties windows? 2)For list box, after doing lstListBox.rowsource="select field1, field2 from tbl" lstListBox.requery How to a)Set show keycolumn; b)make the first item in the listbox selected?A

I have a table with 3 tables, which is orderID, Detail and price. I write a Query SELECT * FROM [tbl]; in the result table it shows me orderID, Field0 and price(Notice Detail has changed to Field0) How do I show Detail as it is without changing it to Field0? Something to note: 1. I don't have...

Thanks for the comment. I just need a pointer for starting. To share with you, I just know Dim obj as AccessObject For Each obj In CurrentData.AllTables//AllForms etc,etc If obj.IsLoaded Then DoCmd.Close acTable, obj.Name End If Next obj can do the job.

I have two table which is c:\db1.mdb; c:\db2.mdb The user is currently using c:\main.mdb In main.mdb, I have a form, and have a combobox with two value, which is db1.mdb and db2.mdb. If the user choose db2.mdb, delete all the current db1.mdb link tables(if there is any), and import all the...

I wish to detect is there any opened tables, queries, forms, reports, pages(item that may potentially locked the table), and close them automatically using VBA. How to do this?

1. Am I right that if a user open the database in exclusive mode, meaning no other user can open it? 2. Is it possible to use vba to a)Check for how many user are using the database, if I am the only one b)Reopen the access database in exslusive mode?

I wish to prompt user to backup their access file before perform certain operation. And the prompt has a check box "Don't remind me again", if the user checked, means that next time the warning won't be prompt. But where is the best place to store the information of this "Don't remind me...

I have a button in the form of the current access file. What I want to do is when the user click on the button, triggered the vba to backup current access file. But since the file is currently open, is this possible? If yes, may I know how to do it with vba? I have tried two methods but...

I have a table called table1,table2 And I have a form called form1 And I have a dropdownlist that populate all the tables Now what I want to do is, when the user select the table name of dropdownlist, the table should shown in the form just below the drop down list. How the table shown is...

I wish to delete all the tables from the database using code and import the other set of database from the other file. Now the focus is on delete the tables, following code does the job: For intLoop = intTableCount To 0 Step -1 Dim strTable as String strTable =...

Let me input some more details. Each of the database that used by each of the users is not relevant to each other. Each user has their own database file. Those users has used the database for quite awhile, and we should not change the schema of their database. To upload and download the data...