I want to create a file. I found DoCmd.TransferText which does what I want.
Problem is I need to only take one row at a time from table, so I created sql
to do that but the input area of the TransferText throws error saying Jet
cannot find the object.

I am intercepting the Delete action with KeyPreview and running a process on
the selected records.  How can I release an object (table) having Set the
object to a variable and enumerated the selected records to memory,  I have
Set the variable to Nothing at the end of my code but ...

I have a main form with two subforms (both in datasheet view). Both have the
same columns. I need to compare the data from the two datasheets to catch any
differences between them. The problem is that these subforms can have
hundreds of rows and there are 14 columns in each ...

I have and extensive collection of CD/DVDs of my digital photo archives and
would like to automate extracting the contents to place it into a searchable
database. The only data other than the sequencial file names are folder
names. So instead of naming each of the thousands of ...

I have a form with two datasheets (two subforms in datasheet view). I need to
compare the data between them, they both are based on different queries but
the columns in both are the same. I need to indicate to the user if both
lists are the same. How can I do this?

I am working with a Microsoft Access Database helping a non profit
organization try to figure out how many nights in a month people are staying
in there shelter.  I have two fields a Check In Date and Check Out Date
Field.  Therefore to figure out the nights a person stayed, I ...

I want to be able to verify the value of a custom property for my database. I
have an application that I want to be able to set either as a single or
multi-client version, and to verify which version type it is. I am using
Access2003 and the help shows how to add and delete, but ...

Using KeyPreview I am intercepting the user when he/she keys Delete (KeyCode
46) and running some code to enumerate the records in the dynaset in which
the records are being deleted.  I have to enumerate the records before Access
removes & buffers them during the BeforeDelConfirm ...

When I enter 65 in totalday's field for month 3 I'd like 65 distributed
30,30 and 5 for month 3,2 and 1. formula is so: (65=30+30+5)
Fields:     name   month  totalday   workday
Records:  jack         1                          5

I have a report that I want to only display the records where PerslNme is not
blank. I would also like to know how to display only the records that are
blank. There are other fields in the report so knowing how to filter for the
blank/null value on that field would also be used ...

I need to send a report that is in my Access database as the body of an
email. The following code works to send an attachment but for some reason
when I dim a var for report object nad trying to set the message body to the
report var I am not having any luck. :-(

Hey all.
So I have a procedure I run in access, that in part of it, opens excel, and
runs a macro from excel. However this uses the function 'networkdays' which
is an excel add in. When I run the code from excel directly it works

I'm trying to reference the current Window's user's desktop with some code; I
am using the following:
C:\Documents and Settings\%userprofile%\Desktop
When I run the code I get a "Path not Found" message.  Just to test, I took

How to make validation rule for textbox; min. 8 and max. 10 characters?
I try with Len function but not work...
Len([Text0])<8 And Len([Text0])>10
Thanks!

I have a table with a field defined as "OLE Object" which is populated by
.JPEG images that were pasted into the database, rather than a link to an
external file.
My question is if there is a way I can write code to take that image in the