In a macro I have a select statement
SELECT AVAILABILITY.BookingDate, AVAILABILITY.Period,
AVAILABILITY.Room, AVAILABILITY.Day, AVAILABILITY.BookingID
WHERE AVAILABILITY.BookingDate >= EndDate

I am using Access2002, I have listbox on my form and trying too add items on
listbox programatically. But some times I get this message "The setting for
this property is too long."
The code where I get this message is:

I anm joining two text fields with a concatination, ie =[text1]&" "&[text2]
but when viewed they run straight on after each other. I would like to have
a line break or new paragraph between the two text field. How can this be
achieved please.

How can i arrange the info that is populating my report in a decending
order. The report shows payments made by a person in increment starting from
the initial amount to the last amount paid. The query that runs the report
is set to decending within the 'sort' and when run display ...

I would like to be able to have the date and time that each record is
entered recorded automatically in my database. It is only a simple one table
database (basically just names and addresses) and I have a data input form
as a user interface. I don't want the date and time to appear ...

How do I post the same message to 2 forums? If someone
replies in one does it then show up in the other? I was
told I had to put something like:
microsoft.public.access.gettingstarted;

I was wondering if anyone from the group could please offer me some
help with a database I have developed with MS Access 2002.
Here is the deal
Within this database I have a form named frmPreStart that I use to add

Trying to make a browse routine and cannot find the proper
code.  Please advise.
Thanks,
Burt

Please help me,
I am running access 97
I have a piece of code which sends email(s) to various addresses.  It used
to ork perfectly but since I upgraded to XP I get the following error

I am currently trying to create a way of opening a report so that only the
details are displayed from selection i made whilst in my locating form. I
can do this if i wish to locate the details in a form format by using the
wizard, so i am guessing it is possible to be it for a ...

I am trying to write a query that would prompt the
operator to enter a year "YYYY" in order to retrieve the
records. The date field is fomated as "MM/DD/YYYY", how
would I set up the parameter so that only the year can be

I'm writing a program and would like to create a new
folder while still in my program without using Windows
Explorer.  
Something like, but not the same as, when you are

I'm new to Access!!!
Can someone tell me how cam I put in a Form a button like those from the Webpages? I have a picture"a.gif" and when the mouse goes over this I want the picture to be changed with another "b.gif" and when clicked "c.gif", in fact, I want "b.gif" to apear over ...

would like to design a report that looks
similar to the Calendar control, in that each square for each day i
capable of displaying a field from a record that has a date that i
related to that day/date square. The report would display the mont

I get the message Microsoft Access can't append all the
records in the append query.
Microsoft Access set 1 field to Null due to a type
conversion failure, didn't add 0 records to the table due