for example
table1:
Code Name
GT001  Mike

What would be the equivalent expression for Excel's
Application.ScreenUpdating = False in Access?

i have a database which uses access and users without office who are running
my office application for access. since they don't have office i've
distributed the access 2000 (art2kmin) runtime. everything has worked fine
for them and the switchboard application i created has no ...

Whenever I enter my startup options I always set the program icon to be the
same for the form/report icon. Works fine on my machine, but when I go and
distribute my application the icon only shows up on the START, Programs menu
and the desktop. I also include it in the setup ...

I developed an Access 2002 application for my client. Some users have already
installed Access 2002 full version, some of them have eariler version
installed, while others have nothing installed. Therefore, I have to include
ART in the setup package. Of course, I create shortcut ...

Does anyone have an easy method to pass parameters to the stored proc name in
the DoCmd.OpenQuery?
I know I can use a QueryDef and pass parameters that way but was wondering
if there was an easy way using DoCmd.OpenQuery.

I created a form with a few text boxes. I want to input some data in those
fields and if I click on a button this data will go into the corresponding
table.
I created an append query for this but I always get the same error message:

Dear friends,
for example,I have a database in ACCESS and some forms in it.
In those forms, I will do some query and then I want add one button whose
function is to export the data to a new .xls file.

thank you ~

Good Afternoon, and apologies in advance if this has been covered a hundred
times before.
I'm doing some development work, in Access 03 and distributing the prog with
the runtime version.

I need help.
I am rather new at rdbms like Access 2003, or SQL Server 2005.
Here is the groundwork for my question:
I have a table called 'People'. It has a primary key and the field I chose

Hi;
Have been searching for a "Beginner's Guide" to Autorun.inf without much
luck.
Have read Microsoft's MSDN pages and they explain what can and/or should go

I try to do update to Database through ASP.
There are two textbox in the form, "txtstyID" and "txtstyName".
The code is like that:
<%

Hello --
I will distribute my first application.
My understanding of what I need is:
- Split app into FE and BE

I have a single table that has the following 3 fields
DefectNr      DCINr          DefectType    RebuttalDate
1801         10N11111          715            12/01/2005
1801         10N11111          101