Search results for query: *

Hi, I’m struggling with some rather basic ideas. Can you help me do the following I have a table, tab_Main, with fields - ID - Integer - Name – text - Salary2004- Number - Salary2005- Number I want to copy the content into several arrays (so that I can manipulate the data) Dim...

Hi I am using a TreeView Control (MS V6.0) in Access 2000. It works fine. For a given node I want to be able to determine the level of the node (I presume the root is level 0, child nodes under that will be level 1 and so on) The treeview control is called TV1 and I can access vairous...

Hi I have a table with 3 Fields - TableID (Autonumber primary key) - RoleID (Number) - StafID (Number) I want to create an index combining RoleID and StaffID - (called Trevor) I can create a multip field index using the menu item for this. And call it Trevor. But how do I access this key...

I want to display (and select from) an organsiation chart presented in a 'File Explorer' format I guess I need to use MS TreeView Control v6. But I have no idea how to populate it. Can someone point me to some reference where I can learn this? Or can someone give me a sample code to set up...

Hi On my old PC, using Internet Explorer 6.0, I used to download a CSV file. It used to prompt me to OPEN or SAVE. When I saved the file to disk I could open it Excel. On my new PC, again with IE 6.0, I try to download the same CSV file and instead of prompting me to SAVE the file, it opens...

I’m trying to build a query (using query builder) that will change the criteria on a field (Num) depending on the value of text box (TB1) on form (frm1) So if TB1 is left blank (Null) then I want the criteria field to match everything in Num. If the value is non-Null (ie an actual value...

Hi Problem The user selects an item from a list box (LB1) – this is list of files found in a given directory – so it could be a list of 5 or 500. StrPack is a string of filenames separated by ‘;’. This works fine for a small number of files. But if the string is over about 1900 characters I...

Hi, I have a database called SODB I have written a Public Function called - Public Function CheckFileExists (DocID) As String I want to have access to it in a query I am using Query Builder. Using Expression Builder I can see 'Functions' (with sub headings called 'Built-in Functions' and...

Hi, I have a query (qry_ListEmps) that produces the fields - Name (text) - ThisPay (number) - LastPay (number) I want a second query (qry_MaxPay) to generate the following: - Name (as in qry_ListEmps above) - MaxPay (number - that is the maximum of ThisPay and LastPay) I need the...

Hi This should be really easy but.... I have a Query (qry1) which returns several fields including MyID (Integer) At a click of a button I want to create a new table with the fields - MyIdCopy (copied from qry1) - SelectFlag (Y/N flag) - default set to zero I could do the CREATE table to...

Hi, I have 2 tables tbl_Docs with Fields: - ID1 (Autonumber) - DocRef (Integer) - Others (Text) tbl_DeleteList with fields - ID2 (Autonumber) - DocToDelete (Integer) I want to write a query to delete those records in tbl_Docs where the DocRef matches the list in tbl_DeleteList...

Hi, I have 2 tables tbl_Docs with Fields: - ID1 (Autonumber) - DocRef (Integer) - Others (Text) tbl_DeleteList with fields - ID2 (Autonumber) - DocToDelete (Integer) I want to write a query to delete those records in tbl_Docs where the DocRef matches the list in tbl_DeleteList...

Hi, I'm struggling to use DlookUp properly. I've got some VB Dim Flag As Integer StField = "AMC 5". Flag = DLookup("[ProcID]", "tbl_Processes", "[ProcRef] =" & stField) When I run this I get the error message If I try same thing but with stField = "AMC5" I get the message I've also tried...

Hi, I've got a table with field called 'CheckpointDate' . I have a form with a text entry box called 'CheckDate'. Both are formtted as medium date. The user enters a CheckDate and clicks a button which will update the field in the table (amongst other things) The code is: SQLString...

Does anyone have an Dummy's guide to setting up User level security on MS Access I've tried. I've created a Workgroup informaiton file. But when I close the Access app and reopen it I get a messge "You don't have permission to open test.mdb" After this I can't get into the App. Am I doing...

Hi In the old days (pre-Windows ME) the operating system did not allow spaces in the filename. Now with XP, spaces are allowed. So whereas before I would have a file called - 'MyDataFile.doc' now I can call it 'My Data File.doc' I used to use a Dos batch file to rename (or copy) lots of...

Hi I have a form (frmMain) which has -a subForm (called ResultsBox -has a list of ‘Name’ and ‘Address’ and other fields) -a button – when clicked reads the list in ResultsBox and outputs to a file on my C Drive. I want to dump the contents of ResultsBox to a text file So I need to do the...

Hi, I've created a couple of users groups and user accounts. After a user logs in I want to be able to display the user login and his group(s) on reports printed. How do I extract this information? Many thanks

Hi, I'm trying to setup a database with a number of users. I can see how to grant read/write access to tables and forms by user. But is there an easy way to define RW access to individual records in a table ? Thanks

Hi I’m using the GetAttr() function to determine whether the contents of a folder is either a file or another folder using If (GetAttr(stPath & stName) And vbDirectory) = vbDirectory Then The problem is that I’m getting a runtime error when I query some files. I think this is because the...