vb 2005 express > querry table in access and put contents into array

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi all,

I've got some general VB experience, but i'm not sure how to approach
the problem at hand. here is what i've got:

I have a database that holds employee data (access database). I want
to make vb 2005 express look in a table (called 'EmpData') and extract
the phone login ID's for all of the agents in the table who are still
employed or who have not left the company yet (but may have a future
end date). i want to store each of those phone logins in an array,
which is used by another procedure to extract phone usage statistics.

so the SQL statement would look like this:

(SELECT EmpData.PhoneLogin FROM EmpData WHERE (((EmpData.EndDate) Is
Null Or (EmpData.EndDate)>Now()));)

i just don't know how to make VB execute this statement and store the
results in an array??? also, will i need a 1 dimensional or 2
dimensional array for this (since i want to store 'PhoneLogin', but i'm
using 'EndDate' to get the desired results)?

Any help is greatly appreciated.

TIA

AR

.

Relevant Pages

  • Re: vb 2005 express > querry table in access and put contents into array
    ... the phone login ID's for all of the agents in the table who are still ... i want to store each of those phone logins in an array, ... i just don't know how to make VB execute this statement and store the ... dimensional array for this (since i want to store 'PhoneLogin', ...
    (microsoft.public.dotnet.languages.vb)
  • Re: need some help with this solution...
    ... the whole file in a similar way as when fetching rows from the database (see ... You can choose to process the rows at the same time you fgetit or store ... uploaded file is a big one, then you will use more RAM if you store it in an ... Once I get the array ...
    (alt.php)
  • Re: pause processing
    ... I'd like to give the user an opportunity to examine the print_rof that array before continuing. ... When the user submits the form, store the data in the database. ... If the data's not too big, you can store it in the $_SESSION array. ... if variable-pass1 is not set ...
    (comp.lang.php)
  • Re: Beginners Question on binary arrays and storage
    ... > I would like to store a bit array of 96 bits in a SQL record. ... opaque set of bits that does not mean anything to the database, ... a row in a table should have any array data. ...
    (microsoft.public.sqlserver.programming)
  • Re: vb 2005 express > querry table in access and put contents into array
    ... Rather than store the results in an array, you want to use a datareader ... Dim ocmd As OleDbCommand ... the phone login ID's for all of the agents in the table who are still ...
    (microsoft.public.dotnet.languages.vb)