I added all the tables, forms, reports and cmd buttons concerning an
addition to a database.
I entered data for Q1 in order to produce a report but received no
output on my report.

I have one simple query joining two tables with left outer join on 3
fields and using MIN on two fields. These two tables have lot of data
about 3 mil in total. I am trying to migrate db from MS Access to SQL
2005. I get about 689000 rows in SQL Server, vs 863000 rows in MS

I have created a file DSN on my PC, and am using it to provide one of
the two connections required for an Access query.
(The other connection uses the PostGRE SQL connection and works as
expected.)

So I have a form showing my data items with a selection tick box to
indicate when an item is active.
I want to save the record automatically when someone clicks in the
tick box.

TRYING TO USE SHORT NAMES might make more since.
I have a main form and its tied to tblmain
subform1 and it is tied to tbl1
subsubformA on subform1 tied to tbl2

Typically, Microsoft Access reports have default 'Page Setup' settings, and
every time you restart Access, the reports always return to the default
Report margins.
I've built a routine that remembers the last used 'Page Setup' printer

My problem is updating Subform filter by onchange event in one of
main form field
I've got following:
Me![NOTAWY Podformularz].Form.Filter = "[zamkniecie] = "" N ""

I have many applications (DOTNET. Connected using OleDB) that all
write data to the same table in a Access database file.
But sometimes I get the error "Could not update; currently
locked" ??!!!!!

I have been asked to change a combo box display to sort in
alphabetical order.  This is in an app I did not write, but it should
be simple enough!
The combo box is based on a table (and I've put in SQL and a query -

I wish to create a temporary table that on closing will tranfer data to a
main table. My problem is that on a network if more than one person opens the
tempory table, CONFUSION. I would like to use a time stamp in the name of the
temp table to eleviate this problem. could some one ...

Neighbour has got a new `puter which came with Office 2007 (without Access )
He needs Access to run an app for his business.
He still has a copy of Office 2000 Pro.
Are there any issues with installing Access 2000 alongside Office 2007. ?

I have an opinion question relating to deleting important records in a
human resources database. Any "best practices" papers or "white
papers" anyone know of would help tremendously.
Here is the scenario: A new employee is hired and goes through unpaid

Quick and easy question, I hope.....
Without using a text fieldtype, how can I get Access to store and
display the number 12.1.2 or 1.3.9 ?

I've used Dbase/Clipper for years & Access for a little while now but
Access doesn't seem to have any elegant solution to limiting the size
of a text box ... i.e. the max number of characters that can be
entered into a text box.

I've just been informed that an Access 2003 based system in use at one
of my customers now needs to send data in the form of an XML file to a
webservice. They told me it was simple - but I don't know anything
about it and a googling session yesterday made it look very