DCount problem...
Sat, 2 Aug 2008 22:09:00 -0700
I am importing a spreadsheet into a table in my database, however I need to
check the data that's in the table prior to importing the spreadsheet. I
can't seem to get the DCount function to work for me. Can anyone spot what
my problem may be? Here's the code:
'Check to see if this monthly is already in t ...
|
Output query data to a Word document to mail merge for address lab
Sat, 2 Aug 2008 19:20:00 -0700
Can't get a query to merge into a word document that is already set up as
address labels using a macro to complete the process. ...
|
Does anyone know how to automate the collect data via email wizar.
Sat, 2 Aug 2008 13:19:00 -0700
I am trying to automate sending of emails from Access 2007. Each time I use
CollectDataViaEmail, it forces me through a 6-step wizard and I would like to
atomate that process. My selections on each of the 6-steps or screens are
always the same. Does any one know how this can be done? Thank you in advance. ...
|
How to connect to oracle odbc data source
Sat, 2 Aug 2008 13:34:56 -0400
I need to connect to an oracle data source via ODBC.
Using conventional ODBC setup forces the user to enter user id and password
when the application opens.
Can someone provide the access code that will connect to the data source
instead of the user?
I have the values I just don't know how to set up the VB ...
|
IMPORTING A SINGLE EXCEL FIELD
Fri, 1 Aug 2008 13:44:02 -0700
I have a field in an access field named ALLOCATIONS. I want to overwrite
this field with new data from a field in an excel file (same number of rows).
I can't seem to find the combination of linking or getting external data to
make this work. Can anyone give some guidance?
Thanks,
--
William ...
|
Validate File before imort
Fri, 1 Aug 2008 11:20:09 -0700
I have an "import" button on a form that prompts the user to select a file to
import. The file must be an Excel file that contains the proper data. The
import works great, but now I am trying to "idiot proof" the code. How is
this best done? I need to check the type of file they selected (IE: type =
XLS) ...
|
Automate update linked table & export query results to Excel
Fri, 1 Aug 2008 07:49:04 -0700
Hello all.
I'm pretty new to Access, so I'm not sure how to go about this...
I have a query that I run using a table and a linked table. The table and
linked table have a relationship between them. I want to be able to have the
linked table automatically update before the query actually runs and then
h ...
|
|
|
How do I import data from 'My Mail List' (MySoftware) to Access?
Fri, 1 Aug 2008 07:38:25 -0700
How do I import data from 'My Mail List' (MySoftware) to Access?
Thanks for any information you can provide. ...
|
Export query to excel - autorefresh
Fri, 1 Aug 2008 06:29:00 -0700
Hi all
I am working on some management accounts but the end user has poor
excel/access skills so I need to automate everything.
The current set up is a query in access that is exported manually to excel
and then used to create a pivot table.
Every month the data is exported again and the pivot table ran ...
|
Anuncios Gratis www.AnunciosGratis.de
Fri, 1 Aug 2008 12:13:25 +0200
Vendo coche seat ibiza, 1999 . en buen estado, color plata, Precio ,4900 euros. Precio 4566 Euros.
Tfno: 91452123334
Puedes ver mi anuncio gratis en:
www.AnunciosGratis.de Anuncios Gratis
www.AnunciosGratis.de Anuncios Gratis
www.AnunciosGratis.de Anuncios Gratis
www.AnunciosGratis.de Anuncios Gratis
ww ...
|
