Search results

  1. A

    List of queries and tables in a combobox

    If this has been answered before, I'm sorry for the inconvenience. I need to get a list of my tables and queries in a combobox and be able to have a button (or I could just hit enter) near the combobox that will start the approperate table/query. I'm actually using this for both Access 2000...
  2. A

    Macola tables in Access 2000

    I am trying to make a tweaked database that comes out of Macola each night. It is an old version of Macola, so I simply imported the tables into Access. There is a list of parts and their parent assemblies/parts. I need to find the head of several series (automatically) and have the top level...
  3. A

    Module results in a label

    I'm wondering how to set Label139 to display the results from a module. The module displays the date and time a file was modified. I'm sure it's a simple fix, I'm just not sure how to do it. Any thoughts?
  4. A

    Last edited date in a label

    I'd like to have a label that updates everytime the database (forms, tables, queries, etc.) gets update. I'm guessing it'll take code, but I may just be overlooking a property. Any thoughts?
  5. A

    Converting Alphanumeric characters (and spaces) to Numbers

    In working with a database, I need to convert 39,000 text fields (i.e.: 6002.2 , 2723 , 6004.55 (Notice the spaces)(commas denote next line)) to number fields. The number of spaces is random, so I can't say "cut off the last n number of characters." There may also be characters...
  6. A

    VB.NET <=/=> Access database (help)

    Ok, I have this somewhat large number (3800-ish) of, well, numbers (actually project numbers). There is a list of the products (assemblies) that go under project, and some sub products (actual parts or small assemblies) that go under that, and maybe even another level for the extras. I'd like...
  7. A

    One specific error message

    I keep getting the following error message when I try to link to an Access 2000 database: "The .Net Framework OleDb Data Provider requires Microsoft Data Access Components(MDAC) version 2.6 or later. Version 2.53.6307.0 was found currently installed." What does it mean?
  8. A

    EXACTLY how to use a TreeView control

    I'm trying to get a treeview control to work. I'm stumped. Any thoughts? Possibly code... Pictures are always good... (hint hint) I'm just starting to get into Access 2000, so lay it on me easy.
  9. A

    Help with tree-view

    Ok, here's my next assignment. I need to make a hierarchy in a form that looks like the one in Windows Explorer (or with the same functionality) to display a series of products with childern and grand-children even, and maybe great-grand-children. Or maybe add a button to add n amount of levels...
  10. A

    Hierarchy

    Ok, here's my next assignment. I need to make a hierarchy in a form that looks like the one in Windows Explorer (or with the same functionality) to display a series of products with childern and grand-children even, and maybe great-grand-children. Or maybe add a button to add n amount of...
  11. A

    Stupid Question Time!!!

    Ok, I need to get a number off of a form to a form. How do I do that? I'm sure it's a really simple fix, yet it's still beyond me. Please explain in simple terms, as I am new to this stuff. ex. On your main form, you have a project number. I need the details form to have all the items from...
  12. A

    Running a make-table query

    Ok, stupid question time. How do you get a make-table query to make a table each time the macro is run?
  13. A

    Annoying popup messages

    I have no idea wheather this is supposed to go in Queries or Forms, so feel free to move this to either. Here's my problem: I made a query that looks at three text boxes on a form. I'm not sure how to set up the buttons correctly so I just bluffed it (like always :) ). Every time I run the...
Top Bottom