I have a tabular column form.  Let's say ColumnA is "ActionDate" for
date-records, ColumnB is "NumberRecord" for a number relevant to a date in
the "ActionDate" field and some more columns on the form.  Yet I only want to
set a combo box on the top of these 2 columns, one is used ...

Perhaps Microsoft will see this?
It would really be a great service to MS-Access users if Microsoft could
develop a tool, perhaps something like a bat file or exe that allows you to
point to a disconnected ldb and trash it.

I can't explain why, but the following code has developed an error.
Dim strFormParent As String
strFormParent = Me.txbParent
   Dim frmParent As Form

Using Office 2003 and Windows XP.
I've seen the example code that Microsoft has in help for timing out a DB,
but it seems rather basic; e.g. no warning before closing, no token "grace"
period (like 30 seconds) for the user to reactivate the screen and cancel the

I upgraded my application from Acc 2002 and Win Xp to Acc 2007 and Vista
Business.
My app is connected through ODBC to SQL server (2000 or 2005).
It works well on my laptop (Win Vista Business and Off 2007) only if the SQL

I've a table (tblMasterList_RV) with 60 fields and the field names are named
Field1, Field2, ..., Field60. I'm trying to write a loop (using VB6) to
retrieve the fields into a series of text boxes, but only the text
"grstMasterList_RV![Field1]" is displayed. Is there a correct ...

I have created a database with access2000, it has given me error 3343, formed
database not recognized, i have tried to restore it, but when I open the  
database comes me this message:  
The form of management of database Microsoft Jet has not succeeded in

Whats the best way to take the records from a table into a recordset,
mess about with them (remove brackets from the front of the first
field if a condition is true etc), create a new field which adds two
of the fields together, then put it into a new table and delete your

I've found that you can enumerate all modules of an access db using the
AllModules collection, but what if I want to enumerate all properties of a
particular module?
In particular, I'm using the Web Service References add-in, and want to use

All,
I'm trying to open Outlook 2007 (Vista) but unfortunately I can't seem to get it to work. I have found different variations of the following:
        Dim Olook As Outlook.Application
        Set Olook = CreateObject("Outlook.Application")

I am attaching a document to an email in access 97 using Outlook Automation.  
My code works fine attaching the document located at strDocumentLocation.  
However, I want to rename the attachment something else (strDocumentName) but
I can't seem to get that to work.  An abbreviated ...

Thanks in advance.
Need a function that just returs the number (Don't want minus sign)
ie
  Function(45897)  = 45897

I have a form that has a listbox that when I click on an item in the list
box, I want the back color to change to yellow.  Can anyone help me...

I am not a programmer but have written code to calculate registration fee
based upon several variables.  I need the code to apply to all queries and
resulting forms and reports so created a "findregfee" function in a module.  
Now I can't figure out how to make it run when the ...

I'm selecting a DISTINCT column, but I want the rest of my columns to appear
in the result.
Right now, only my distinct column is appearing.
Thanks