I have an employee name field with text data type, the employee name get
entered by all type of users so the field format is very different for
example:
John (blank) Smith

I have a computer client who is establishing an additional business of
house-sitting.
He wants to have the ability to have his staf fill out a form after an
inspection and have the form emailed to the client. The program would also

I have a report that needs to be saved as PDF. But I need to create a separe
PDF file for each group with file name that I keep in [FileName] in group
table. I think I need to loop thrugh report for each [GroupName] in group
table, save it as PDF and pick up [FileName] on a way ...

I am applying a filter to a subform (object name = subfrmKitComps) based on a
field in the current record of another subform:
   Me.Parent.subfrmKitComps.Form.Filter = "KitItem = '" & StrCurrentKit & "'"
where StrCurrentKit was obtained from the Current event of the other subform.

Could anybody tell me how to create an OLAP cube through Access VBA?
Thanks a lot!

Suppose you have a string of text like this:
650  0 $a Authors, American
650  0 $a Frontier and pioneer life
650  0 $a Children's stories

I've been converting my RunSQL methods to db.Execute to trap errors.  I'm
generating a Type Mismatch error on the 2nd strSQL assignment statement
below.  Can anyone identify where I'm erring?
Thank you.

I had a heck of a time trying to figure out why this error occurred, and now
that I have a work around solution, I have to ask: Why did this happen in the
first place?
Following is the situation: I had a simple crosstab query saved in an Access

Im using some code that I picked up from a previous posting to retrieve a
file location but was wondering if there is someway to have the search
function start at a specific folder each time. The code I have now is:
strFilter = ahtAddFilterItem(strFilter, "All Files (*.jpg)","* ...

Background:
I have a database that records responses to a survey.
Most questions have multiple responses.
The responses are True or False (with False the default) only.

I'm wondering, is there some way to manipulate ALL the contents of the
Immediate window?
I've got some code that processes a sizeable table and prints text into the
Immediate window that indicates how the execution of the code is going.

I want to be able to secure a record once I have completed it. Once closed
and then re-opened I want it to be read only and only able to change the data
through password control or an alert pop up or similar. I don't need to
password protect the whole database, just the ...

I'm able to disable almost every menu items in commandbars like so...
'disable database property from file menu
Dim cbc As CommandBarControl
Set cbc = CommandBars("Menu Bar").FindControl(ID:=2939, recursive:=True)

I have Access database that contains column of type “OLE Object”. This column
can store any OLE object including images, word doc, excel sheet etc.
My task is to read this OLE data from “OLE Object” column & store it into a
temp file say data.tmp so that the OLE data can be ...

I have created an SQL string which is fed into a query.  I then want to
change the "Format" and "DecimalPlaces" properties of the field "Downloads".
However for some reason this field doesn't contain these properties.  If I
run the follwing code it shows that I only have these ...