Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Maturi

    Setting up an Array from a table

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

    Setting up an Array from a table

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

    TreeView Control - How to determine the level of a node

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

    Multi Field Keys in a table

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

    Tree View Control - How do I start

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

    Downloadind CSV files in IE 6

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

    Downloadind CSV files in IE 6

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

    IIF Statement - Dealing with Like * and Nulls

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

    IIF Statement - Dealing with Like * and Nulls

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

    Long List (1900 Characters) in a List Box Gives me an error

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

    How to access user Functions in Expression Builder

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

    How to access user Functions in Expression Builder

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

    Finding Max value of 2 fields in a Query

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

    Create / Make Table in VB from existing query

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

    Create / Make Table in VB from existing query

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

    Create / Make Table in VB from existing query

    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?
  17. Maturi

    Create / Make Table in VB from existing query

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

    How to delete records in one table based on list in second table

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

    How to delete records in one table based on list in second table

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

    How to delete records in one table based on list in second table

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

Part and Inventory Search

Back
Top