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 derfloh 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: *

  • Users: klyon
  • Order by date
  1. klyon

    Random Numbers

    Hi All - I'm looking for a way to add a random number field to an existing table in Access 2000. I've not been successful with the rand or random functions. Thanks, -Kris
  2. klyon

    BO Sizing and Configuration

    Maiden - Thanks a ton for your post! I'll digest it when I get to work and may have some follow-up Q's, but wanted to send my emaila address so you can send that article. klyon@thinklyon.com Thanks again! -Kris
  3. klyon

    BO Sizing and Configuration

    I'm just starting a BO project and am looking for general guidelines for a small installation. I'm planning at a 2 server solution for 20 thin/thick report developers and 60 WebI users. Also have BCA and Developer to install. I'm looking for guidance on server sizing and configuration (how to...
  4. klyon

    Parameter Query

    Thanks Joe! I was able to create the form and update my queries. Best, -Kris
  5. klyon

    Parameter Query

    I'm kicking it off from a form. I'm getting closer. I've created a table with 2 fields, startdate and enddate and created a form that closes after inputing the 2 dates. I then changed my queries to use the date table. It works. I just need to create a module that opens the form, then kicks off...
  6. klyon

    Parameter Query

    I have 3 parameter queries, but would like to only enter the data (startdate and enddate)once and have it carry through all 3 queries. After the first query runs and produces the result (a count), I want to take that value and pass it to Excel. Then use the same startdate and enddate to run the...
  7. klyon

    Linked Table

    Wow - I just joined this forum today and I am extremely pleased! Thanks again Lonnie - that fix hit the nail on the head. Joe - thanks for the idea - I'll look it up. First thing I do when I start a new DB is turn on the Compact on Close :-) My staff (who are closer to real programmers that I...
  8. klyon

    Linked Table

    Thanks again Lonnie! The link operation worked perfectly! Is there a way to keep the linked table name the same (from day to day - not the same as the text necessary for the new file). It is naming the linked table with the text that I enter. A couple of my labels bombed as well since I haven't...
  9. klyon

    Linked Table

    Thanks for the quick response Lonnie. The file name changes each day 'same text'&'yyyymmdd'.csv, but the linked table name needs to remain static in order for the rest of my processes to run. It is in the same folder each day. I understand the deleteobject action, but am not sure about the...
  10. klyon

    Linked Table

    My question is a two-parter, so here's some context first. I'm trying to automate the process of deleting a linked table, open a network directory and create a new linked table using a .csv file that I select. So, first, can I set up a table definition for a linked table and, second, how do...

Part and Inventory Search

Back
Top