How do I programatically:
1. disable the shift key when the database is opened
2. disable the F11 key to keep the the database window hidden
Thanks for your help!

I've got a thread started in the multiuser section, but I wanted to post this
question in the meantime.
Can an open DB pass it's filename to another DB it opens with code? If so,
how? I'm guessing I'll need a local table to store that data.

I inherited an Access 2000 database that numerous tables, queries, forms,
reports, and modules with VBA code.  I opened the Access database with and
without the shift key. I am unable to Step Into (PF8) the VBA code from the
Access

I have a form that is bound to a table. On that form I have text fields for
various fields from the table. In some cases if the user tries to update a
field with an invalid value, I want to cancel their update. I call a function
in the field's Before update event proc that checks ...

I have a db that uses a small amount of dao code. I am in the process of
migrating the application to a sql server 2005 backend. I'm not too familiar
with ado and was wondering if there any resources to help me convert my dao
to ado.

I have 15 sheets in a workbook and I want to set the column widths
individually but all seem to be re-adjusted by the code I have recorded.  Any
clues why this is so? Here is a sample of my code:
   Columns("L:L").Select

When running code in Access I open an excel workbook to eventually be
exported to a pdf file.  Upon completion of this, I wnat to close the excel
workbook and it indeed appears to be closed and I am returned to Access
application.  However, when I attempt to repeat the process I ...

I need to filter some of the data from one Access table which is updated once
every 3mins by adding 12-14 rows to the table. Once the new data is in the
table, only the data from 3rd row should be selected and pasted in a row in
another table. Can anybody have a solution to solve ...

I have an ADP, parts of which go back to 1995.  Recently I recompiled it
after making minor changes to a form, and after opening the code window and
saving the changes, a function that had previously worked for years stopped
working.

I have tried all efforts but all is unsuccesful. My question is it a
requrement that we should compile our code first than we do maing MDE?
When I tried to compile there are many error message/comping error, if I
delete it I am affraid some of my forms won't work.

I have a parent form and subform. The parent form displays details for a
'process'. Each process has a unique ID called QRID. The subform displays the
'tasks' that make up the process. The user is required to list the 'tasks'
and give each task a number that indicates the ...

Is it possible to run an INSERT INTO table command and pass over a recordset?
Now I must write all field-names:
INSERT INTO tbl_test([Field1], [Field2]......) VALUES ( .. rs ! Field1 .... )
this works fine but it is hard work if columns are deleted or added.

I have got table "Material" with 2 types of materials A and B
my second table "Material_INFO_A"
my third table "Material_INFO_B"
how can I make my SQL query with condition?

I have an access application (XP) that I run.  Part of this app creates an
XL workbook and puts the results of a query into it, then formats it all (XL
XP).
I have a couple users that have Access 2007 on their machines and they

Hello,
I have used the transferspreadsheet to transfer the data from the query I
want to excel.  That works fine.
The problem is, I want the data from excel to be placed into a template