Hello evryone
i have a listbox where i populate with some date.
Number        
Name

I am trying to use a
with Reports!"Report name"
.property
end with

I am trying to filter records by searching for a date. However when the date
starts with a zero eg. 01/10/2006 for some reason it can't find the date. It
will find any other date with no problem. eg. 11/10/2006
Below is the code I am using.

Good evening
i have a query where i identify 4 fields.
one of them is a date( 25-11-2007)
i want to retrieve the date in my query that matchs the date with today

I have a combo box that selects a name of a department.  Once this has been
updated I want to add to the same form a unique work reference ID into a
unbound column.  I have a query working out the unique reference and I have
manged tio run this after the update.  Here is the code ...

Having a heck of a time googling this...
Is there some quick code to test
if backend is in readonly state?
Thanks,

Access03/WinXP
I am using the function IsFileOpen(filename as string) to determine if the
file "c:\datafiles\TextExport.xls" is open before continuing with a process.  
If I use the following in my routine, the function performs properly.

Using Office 2003 and Windows XP;
Is it possible to store a text file or a MS-Word file in an Access table?
If so, I'm thinking I would build an interface that allows a user to point
to the file, then have the code upload it. If possible, could someone please

I'm trying to add a new feature to my workorder database (2003.) I want to
track Vendor Invoices by Customer. I created a form where I can enter each
Vendor's contact information and a subform for each Vendor to enter the items
we would pay for.

Help Please.  I have the following code and need help figuring out what I'm
missing.  I need to find the Highest Number and add 1 looping thru the
remaining fields that are Not Null.
Private Sub Close_Form_Click()

I got this erro when I was trying to update a ado recordset in access. Can
somebody help please?  Thanks in advance!

I have a DB that creates a report and outputs that reprot as an rtf file.
What I would like my app to be able to do is open that report, copy what is
in there and then close the report.
Here is what I have so far:

I just developed a multiuser database in Access 2003.  I am new to the
programming side.   Currently our users are making notes on clients in a
table memo field (called Client Notes).   Most of this information should be
entered in subform records, check boxes, drop down lists, ...

I have a form that has a lot of ORDER information combined from various
tables.  I want to use a query to run a report that summarizes the ORDER.  I
want to pass the ORDER# from the form to a report that is based on a query.  
I don't want to use a parameter query that asks the ...

Helo all,  I crated a word template with some custom doc properties.  my form
has a memo field,   my code converts the value to the memo field to a string
but when i assign the memo field to  the doc property it gets truncated after
255 characters. any help would be appreciated. the ...