Search results for query: *

Remou Thanks but I am struggling with simply opening the recordset. I've tried Dim rstTable As Recordset Set rstTable = OpenRecordset("SELECT Id, Name FROM t_test") And also Dim dbs as Database (error on this line) Dim rstTable As Recordset Set rstTable = dbs.OpenRecordset("SELECT...

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

bcastner Thanks for this. But the problem is before I use File Explorer. In IE - I want it to allow me to save to file before it opens it IE (an Excel frame in IE) So it is a setting in Internet Explorer and not File Explorer. (The association oyu suggested was already there) Regards, M

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

Remou Fantastic - I've been trying to resolve this problem for ages. I'm using your second soution (but it returns only the Null values when I need all values - but that's OK) It was the line 'Trim([Field1]) & "" AS Expr1' that really helped. Basically it was an easy way to covert all Null...

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

PHV, Sorry I'm a novice. What do you mean 'Standard Code Module' Thanks

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

Pwise Thanks again - It did work. I knew it would be something simple. One final niggle - I want SlectFlag to be a Y/N field rather than the number field that it seems to default to. Or am I asking for too much ?? Thanks guys

KJV Thanks - I'm really sorry but I did not understand the example you gave - it's my inexperience All I want to do is create a new table with 2 fields. - MyIdCopy (Integer - copied from qry1) - SelectFlag (Y/N flag) - default set to zero Can you help me code this? Thank you M

KJV Thanks - I have tried that. I have a SELECT..INTO statement which allows me to create a table populated by an existing field in a query but I can't see how to a new field SelectFlag which has nothing to do with the qry1 Any other suggestions?

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

Pwise Thanks - this worked great. I didn't even know about the IN statement. Thanks once again M

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

George This in Access 2003 - I think I should have posted this in Access VBA coding forum!! I derived the code form the Access Query builder I tried the following.. DELETE tbl_Docs.* FROM tbl_Docs INNER JOIN tbl_DeleteList ON [tbl_Docs].[DocRef]=[tbl_DeleteList].[DocToDelete] and I got the...