I have a search form that is great.  I have modified it in such a way,
that when search results come up I can bring it back to a useful spot,
say an entry form or a report.
Here is my lemon ( hoping someone can help me make lemonade!)

To all:
Here's an interesting one: I have a query that produces 56 (!!) columns
of data.  The first three columns are "to repeat at left", as can be
selected in Excel at File --> Page Setup --> Sheet tab.  That is, the

I need to get hold on when, and more important which user last closed
this Access application (closed the mainform). This way I could have
the user that last time used the application to be the default value in
the combo box where the user is choosen upon next login.

I started in access just a copple of weeks ago, to automise my ecell
DVD database.So I could make forms, ans reports.. Thought it would be
easy, but I'm trying nog for weeks and I think I have a bad base to
start from.

I'm having trouble structuring the data in an investment database. The
basics are:
* Investors invest in Deals
* Investors can be either Individuals or Entities

I am trying to compact and repair my database, however every time I try it
comes up a message saying: Table: "TempMSysAccessObject already exists",
whenever I try to look for this table I cannot find it anywhere... Any
clues...

Hi to all you clever ones, God I wish I didn't have such a misspent
youth....
I currently have a DB that I have placed on a server in my office, both
myself and the wife, (AKA office Slave) are connected to and it seems to

As an ex VB6 programmer, I have now moved on to Access. I understand Forms
and Subforms. But here is what I don't understand: When I create code, I
have to create an ADO connection, a recordset, et al. When I am in code
mode, is there no connection with Access anymore? What am I ...

How do I to create a query (or Datasheet) that has that little plus sign so
you can click it to expands the field to show the sub categories of each
entry?  Is this called a crosstab query?
I've seen some mdb's with this kind of thing but I forget what it's

how can I convince this system to accept more than 100 characters in the
memo fields ?  and how to obtain that it writes left to right.  Please help
!

I am trying to create a recordset where some text fields are matching. The
problem is that some of the text fields contain quotation marks. I have
tried to create the sql string using replace eg.
"SELECT * FROM MYTABLE WHERE REPLACE(MYFIELD,"""",".") = """ &

I get an runtime error w/ this code
If Me!Obj = 5100 Then
runtime error 13
type mismatch

This is not a programming question but a question about how to establish a
connection with a client with the potential of getting future business.
I was asked to fix an MS Access database for a small department in a very
large company. The database was developed by an employee with ...

Pardon my ignorance but is there any easy way to pull information out of a table in Eastern Standard Timen that is currently stored using a different time zone. Any suggestions would be appreciated.
Rd

I have an Access Project as a front end for a SQL DB.  I have a master
copy and distribute copies of it to my other users.
I would like to display a revision count on the first Main Form so that
when looking at the copies on other user's machines I can tell right