Search results for query: *

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

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

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

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

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

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

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

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

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

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