I'm looking for and can't find a way to select a item form a combobox when a
txt field is changed.
The other way around is me.Debnr = me.cboClient.column(2)
The content of the combobox is

I'm trying to format the cell widths for a query that I export into excel and
I'm getting an "Object required" error.  The file saves but the fields are
not autofit like they're supposed to be.  I figure either I have the code
typed incorrectly or that the file is not created ...

I have a form with an Image control containing a FirmLogo. How can I insert
this picture into a table, that has a field with type OLE Object? Thank's for
helping

Hi. I need to hide the Exit Button (upper right-corner X) in Access 2007.  
Everything I've read thusfar details how to do this in pre-2007.
Can someone please advise how to hide the Exit Button in 2007?
Thanks!

Dim Cnxn As ADODB.ConnectionDim strCnxn As String
   Dim strSQL As String
   Dim intEventID As Integer
   Dim str2 As String

OK, I have what is hopefully a very basic question.
What is the best practice for deciding which sub procedures go into which
modules?
For example, if a particular procedure B is only called by procedure A, is

Is there anyway I can hide a table in the database window like system objects
can be hidden?  I'm using Access 2000

I have inherited several mdb and adp front ends that work with a SQL
Server backend.
I need to get a form from an mdb to work in an adp.
The properties for the MDB form are as follows:

I'm using Access 2002. I have the following code:
Option Compare Database
' Declare for call to mpr.dll.
  Declare Function WNetGetUser Lib "mpr.dll" _

Greeting,
I put the following code in command button and it gives me an error"Type
mismatch"
this code for search as part of name:

I have a combo box (Name = cboProjectStatus) that is used to define the
WhereCondition of a OpenReport command when a button is pressed (Name =
cmdOpenReportByStatus) with the below code.  This part works.  What I am now
trying to do is create a WhereCondition that is NOT what is ...

I have two Sharepoint tables linked to my Access 2007 DB.  I have found that
changes made to the tables on the sharepoint side do not always propagate to
the Access table, unless I "manually" refresh the link through the UI.
I am wondering if there is a way to programattically ...

In my table there are fields for startmonth, startday, starthour,
startminute, startsecond, along with several other fields that do not pertain
to this thread.
In a report I have grouped by startday and starthour, and that much is

I get a runtime error 13 type mismatch, when I run the following:
VarExisting = DCount("[event_date]", "event", "[event_date]= " &
Format(Me.event_date, "\#mm\/dd\/yyyy#") And "[event_sessionid]= " &
Me.event_sessionid)

#1 Wrote in Access 2003, About Calibration Tools. I have a calibration date
that i would like to know in color. 30 days before it happens and also 15
days before. And past due calibration date turn let say RED. Hope would any
of you would write this? Thanks Lonnie *