I would like to have code, that if an image exists in a directory, access
should save the image in three different sizes, and then upload it to an ftp,
I already found that there is available code to upload to an ftp, but what I
can't find so far is the save and resize images.

This is a two part question regarding Access 2002.
First, I tried setting a reference from one .mdb file to another. The only
thing that was exposed was public code in regular modules, not class modules,
which pretty much negates the value of the reference. Is there something

The following sequence causes a total Access app failure:
(1) develop Access app with Excel automation on machine with Excel
(2) deploy app to machine without Excel installed
(3) launch app - FAILURE

I have a simple piece of code I am starting with, to just open a test.xls
file.  It appears to launch excel, but then stops and prompts me to run a
macro.  I will not want to run a macro, so what piece of code do I add the
the below code to disable whatever is causing Excel to ...

 I am very familar with excel and I use the for each loop to step through a
range quite often but here is my issue...  
I have loaded data into a temp table in access and I want to step through
the records one at a time and then append the data to another table once i

When editing the border lines of an excel workbook through Access I got
error message. Here are the codes in Access 2000:
   Dim xlApp As Object 'New Excel.Application
   Dim wb As Object  'workbook

I have a main form with 3 subforms that I am using
DoCmd.Requery "SubformName"
For each of them. This works fine as long as the main form has the focus. If
it does not have the focus then the I get Runtime Error 2109 Stating that

I’m looking for a way to avoid duplicate contacts in an Access Project.  In a
MDB I would use a parameter query.  I’m a newbie to ADP and can’t seem to
find much documentation.  Any suggestions are greatly appreciated.  
Sincerely,

Testing Please Ignore

I have a command button in "start form" that opens a
form "Equip Form".  Equip Form has a drop down menu, and I
would like to have the drop down default to the first item
in the list [cntrl.itemdata(0)]

Hi - I have a table with a field that stores date value.
What do i do if i want to get a list of the dates from January1st to today
that are not in this date field.
Thanks a lot!!

I was wondering if one of you brilliant code-guys would take a look at this
little statement and let me know how to add a second join (i guess?) so that
it works.
table looks like this...

Can anyone help with this one? I have a subroutine, shown below. It should
delete the linkes to tables in a back end Access DB, leaving one table (not
linked) "version" in the front end Access program. It does this BUT will not
delete any tables with names beginning with O or ...

I have searched many of the discussions but have not found a solution, so I
apologize if this is an easy solution, but would appreciate any direction.
I have a form with fields for every day of the week.  I want to have the
users enter Monday's date and then the other fields fill ...

Need some help creating a routine in access that looks for a specific string
in a file name in a specific folder and moves that file to another folder,
somethig like: file as the string "report" in the midle of it's name and is
located in MyDocuments folder, and I need it to be ...