on sql 2005, I've got a view with select permission granted, the view
just "select * from table"
using odbc in access97, I linked this view and I create a query to
retrieve certain fields

I am designing a Housing Database to track rent payments for Non-For-
Profit organization and they calculate/figure the tenant/client's Rent
payment based on how many room mates.  No Problem, Rent is set at apt
#1 for $750/month, 3 people share the apt so $750/3 yields $250 for

In a DB cataloguing journal articles, tblCatalogue links via an M-M
transition table to tblAuthors identifying the article author
name(s).  I wish to extend the DB to cover persons cited in the
articles, thus requiring a new table (e.g. tblPersonsCited).  However,

           apologies in advance if this is the wrong group for this topic.
I have an Access 2003 application of which I need to make elements
"portable". Within the warehouse where this is needed, we have a wireless
network which will allow a connection to the backend via PDTs. ...

I have a report which I filter using the me.filter command in the
OnOpen event.
Me.Filter = "OrderID=" & Forms!variable_form_name![OrderID]
Me.FilterOn = True

Is there a "way around" the size limitation for Access? I'm thinking
of something like spanning a huge table accross multiple databases...
Something simple and that would preserve the integrity of the DB yet
let me overcome the size limitation.

I must be having a bad day because this is so elementary.  I have a
calculated field in a query:
Criteria: IIf([forms]![frmMain]![cboDiscipline]="All","All",[TASK_COMPLETE])
If I run the query without the form and enter the parameters manually it

I am new to Microsoft access 2007 and I have created a new database.
There is a dollar about that I have to change from text to currency
format.
Also, there is a zip code that I have to change from text to number

I created some forms using the "Create form using Wizard".
However, I cannot view the forms I created with Wizard unless I click
on the Design View icon.
I checked the forms' properties to no avail.

I currently use GoDaddy as a host which allows me to create online
Access databases.
Here is what I am trying to do. A client has seven schools which they
want me to create an online application for. They want a separate

Thanks to a posting by fellow MVP Steve Foster
On a computer that is running Windows Vista, Windows Server 2008, or
Windows XP, an incorrect value is returned when an application queries
the identity column value of a newly inserted row in various versions

I am a novice at Access programming but I am flustered by this error and
don't understand what I am doing wrong, any help is appreciated.
Here is my code:
Sub SetFilter()

I have saved an import and it works great. I would like to be able to
start the saved import from a button on a switchboard. I tried using
TransferText and the saved import name but it does not recognize the
saved name as an import specification.

I'm receiving this message when running a query...
This expression is typed incorrectly or is too complex to be
evaluated. For example, a numeric expression may contain too many
complicated elements. Try simplifying the expression by assigning

I have a query which takes data from 3 tables: Errors, Employees on
work stations, Employees. In our company we have a production line and
every employee has one-week assignment- e.g. on station AM, then
another week on station AN etc. Query connects errors with employees