I have a form which consists of 2 listboxes and a combo box. the combo box
allows the user to select a table name. When the Table is selected in
Listbox1 the fields for that Table Appear.
I have a button that when pressed moves the contents of listbox 1 to list

I have adapted a Document Manager database to gather file names from a
certain server folder and all sub-folders.  To update this information an
update button is pushed, and it then collects data on over 20 thousand
records looking for changes, additions and deletions in the file ...

Okay I have a database that contains records of billing information. I have
created the queries I need to display the information but my issue is, is
there a way to take the total values that are being produced from the query
and separating them depending on amount for instance 0-30 ...

  I've tried the below code to send a e-mail with an attached .xls file
from VBA code in Access. (Access has the e-mail address to send each file to)
And I'm running to a authorization problem. Wonder if someone on here is also
a notes guru

0I am running Access 200 and after a few changes to my programme I keep getting
Error accessing file. Network connection may have been lost
It seems to occur when I add the primary key field to a sub form. I have
tried to rebuild the table but to no avail. Any suggestions please

I am trying to get a dcount function to work and I can not seem to get it to
work
Cards = DCount("[Look]", "Daily_Check", "Y")
the table name is Daily_Check, and the Field in the table is named Look.

I am trying to import an Excel spreadsheet into an Access table.  All the
names in Column A of the spreadsheet are preceded by a space, and this is
really screwing up one of my queries!!  Ideally, I would like to trim out the
space during the import process.  Can this be done?  I ...

How can I delete a form in Access from the Forms collection using vba code?
Thanks,
Ben
--

I have a query with two columns
VendorID and FileName
Look like this
9287 C:\myfilename.txt

I have a text box and I want to set the contects from a select statment like
this:
txtBox = select * from table where...
Is this possible and how would I accomplish this?

I need the Filter by Selection feature to create a Filter string based on a
Combo Box using the bound column which is not visible. That is, it needs to
use the field and value from the bound column (a long integer ID field) and
NOT the text is the first visible column.

Hello All! I have an access db that is comprised of many tables which are
linked to flat files located in a static disk location. I then have a union
query which stacks the data from each linked table. The problem is that
should one of the underlying linked files not exist the ...

Since indexes dont have to be named after the field they contain, how do I
programatically determine if a field in the fields collection of a table's
index is based on a field in the fields collection of that table? IOW, if I
loop thru the fields of an index, what properties of ...

I have the following set up
Between [From Date] And [To Date]
What I want it to do is automatically fill in the from and two dates based
off the following...

i have a quick question about the timing of the shiftkey bypass and the
running of code.
when you run code on the start up form, does it come first, or does the
shift key bypass happen before that? my semi educated guess is the shift key