Sorting a results set in datasheet view, installs the field header as the new
order by clause in design view (though it doesn't show up in SQL view as an
order by clause for some reason).
This is such an amazingly counter productive 'feature'.  I'm using Access

I have several databases that I have created that are used throughout the
office.  I am having issues involving the use of two different platforms
Windows XP and Vista.  As well as some users having Access 2007 and some
having Access 2003.

I have a report that has multiple sub reports. Can I add in a page
break after the sub report so the next record goes on the next page?
Ryan

I have Access 2003 and we run SBS 2003, so we have SQL server installed as
well.  Just a general question.  I'm working on my first database for our
office, a customer tracking database, and I downloaded a template from Office
online that kind of does what I need, and I have the ...

On a form named FrmMenu  I have a multiple selected list box names
ListProjets
As I wanted to print selected items on a report I made a search in
this forum

I have set up an Access 2002 FE/BE database for multiple remote users
mostly using runtime. I have a form that filters a record directly out
of a table, and when the form tries to save, if anyone else has the
form open, it says it can't save and shuts down the database. Would it

I made a query to calculates employees monthly workdays, which uses two
separate dates to do it with dateserial function. Is it possible to make it
check actual starting date or ending date of employee, if it's past that
month's first or before month's last?

hi, i have another question! i am doing a query which goes through the
Appointments table, to search for a specific property address which the user
types in.  however, if i type in the text of address, nothing comes up; but
if i type in the SiteId, then the data is displayed.  in ...

I have a database that is storing operational data on a daily basis.
It is a split db with the backend residing on a server and the front
end on various desktops.
Users pick from a list of dates to see the data for that day.  One of

Would great appreciate any pointers on how to generate PO and Invoices from
database.  thanks

I created a database that the office uses to manage ongoing projects.  In
addition, I use the hyperlink feature which allows the user to access the
project folder which resides on the network.  However, when I have the
database open, I am unable to open any Adobe file.  As soon ...

I have a user who is receiving the following error: "there isn't enough free
memory to update the display.  Close unneeded programs and try again."
This only seems to happen while the laptop is docked from startup, if she
undocks, pulls up the database, then redocks, the error ...

I have a database that was setup by someone else... when opening the database
which has a main swichboard, I get seven mgs saying that you to not have
exclusive access to the database  at this time and if you proceed to make
changes you may not be able to safe them later. I know ...

I know this is a MS Access forum but does anyone know anything about this
software?
I am interested in using Access (2007) and having some web connectivity to
use it. All posts here seem to indicate that it is possible with limitations

for my project i am doing a database and interfaces for a surveying company.
in the form header i have got some data fields such as report number,
address, staff ID etc.  on my form in the detail section i have got a tab
control which has different data on each tab such as room ...