I have an access database that is accessed by few users from different
computers. I was requested to change the behavior of the database if it was
opened on one particular computer to do the following:
1) disable the "Alt-Tab", and "Ctrl-Alt-Delete" buttons so that no one on

What is the proper way to write a SQL statement for a Recordset using the
Like Operator and the asterisk wildcard (*)?
Here is the SQL statement from the query (works just fine):
SELECT SOFSN.SERIAL_NUMBER

I have the following tables with the following (simplified) structures:
tblCompany
- autCompanyID
- txtCompanyName

I have an orders form with an order details subform. Allow Filters, Edits,
Deletions, Additions and Data Entry are all Yes.
I have a ListBox on the orders form to select the customer name, and when
the customer is chosen, I want to set the default value for one of the fields

Well, seems like the Microsoft MVPs are not able to answer a simple question,
and according to previous replies are suggesting to blame SP3 of Access 2003.
We are talking here about Access 2007 and the program that was working
fine for nearly half year,- untill this problem.

Does anyone ever met with this problem?
I have a database created in Access 2000. I have 4 users working in Access
2003 environment and 1 user working in Access 2000 environment. The one who
has access 2000 frequently got this error message "couldn't update; currently

I'm using this code to search for records with a form with one field in view
as the search sourse.  Once the find cmdbutton is clicked, the remaining
fields on the form become visible with the data for that record.  I have two
issues, one is the search only brings back one result ...

I have a table with dates (dd/mm/yyyy) and I want to display the dates in a
column on a form, similar to the way MS project displays timescale. The only
difference is that I want to display only 52 weeks for the year on the
columns.

hello.  i've made a simple access 2007 database which has all of 3 linked
tables in it.  i used the developer option to 'package a solution' so i can
put it (along with access runtime) on a cd and get it into the hands of other
users in my company.  i used the code from

I'm using Access 2000.  How can I get the diagonal lines that seperate the
MM/DD/YYYY to appear in a text box before the user enters the date?

Can anyone tell my why the following Dim/Set code produces a 'type mismatch'
error?
Dim frmName As Form
      Set frmName = Forms![Reports Dialog].Combo62

Is there a way to rename a file that is outside of a db?  I have code where I
use .FoundFiles to locate files that match a string name.  I'd like to be
able to rename the files that I find.  These are text files, but the names of
the files do not end in .txt and I need them to in ...

From some strange reason, my code for dynamically formatting multiple tabs
work until I have to "sort" the worksheet.
If I strip out the code for sorting, everything works fine....
HELP!

Need to dynamically change  the visible property for a section on a report.

I've posted a separate issue entitled: "If one value then fill out other
values" so you can refer to that if u want but here is a outline of my
problem:  Basically what I want to do is depending on a value selected in my
first drop down box the possible options in my second drop ...