At first they just wanted to keep a record of who logged in and when.
Then it was if they made changes.
Now its who changed what. BUT since this made no since to them.
WHO put it in and who changed it.

Using A2003. I tried to query for records that contain a trailing '%'
symbol in a certain field but was unable to get this to work.
Knowing % is a wildcard character I tried substituting the ASCII code
equivalent, but

I have a VBA function that I would like to move to SQL Server
The SQL server database contains a table named 'WorkOrders'.
Each work order gets a job header that is derived/concatenated from several
fields in 'WorkOrders'.

I am trying to move a subform onto the next record with:
DoCmd.GoToRecord acForm, "MaintainAssets_edit", acNext
but when I do this I get "The object 'MaintainAssets_edit' is isn't
open". I know I could easily put the controls in the subform itself

I'm using A2003 connected to a SQL 2000 backend.  This is not an adp.
I have a table which I store 0 and -1 for 2 bit fields.  I have a
listbox on a form based on a query of this table.  The listbox is
supposed to display Yes or No and has sucessfully for the last 2

My system tracks orders placed, each record can have up to 6 items on
order, I've set up the following query to locate the price for an
item.  basically once we've been invoiced for the goods i go back
through and enter the exact pricing.  as such i have a checkbox to

I'd like to create a half decent looking form entry and search
database for a few hundred DVDs. I've tried this myself and found
doing it difficult so I'm just using a simple form for the data entry.
Is there a slick search and form entry version online anywhere I could

how to connect a website with database like ms-acess to store the
informations realting to form or anything like that........

Hello,have a problem with the following site
The site link is this http://szenvedelyes.extra.hu
I cant make the video work, its stuck or something, should i download
higher flash? Or whats the prob?

I just started using Access 2003, and I can't link a SQL Server table. I
right-click on the database window; select Link Tables; and select ODBC
Databases from the Files of Type dropdown. As soon as I select ODBC
Databases from the Files of Type dropdown, the entire dialog box ...

Why is our group getting hammered with so much spam?  Is there
something we can collectively do?
Sorry, I needed to ask but to bring it back round to MS Access, I have
worked up an access database for a number of years and would like to

I have a form and a query. I would like to have some control on the
form (check box probably), that when selected will limit the criteria
for a field in a query. Here are the details....
When the checkbox (or whatever control is appropriate on the form) is

Ok, i thought i had this one figured out, apparently not.
Here is my code on my button click event:
   stDocName = "frmInvoice"
   stLinkCriteria = "[InvoiceNum]=" & Me![List13]

I am making a front end mdb so users can enter new members data.
I can then import this into the master database on the backend and erase the
existing info on the front end to keep the data reasonably secure.
( I borrowed the code from