I have a replaceall function which works on my machine. But on the client
side it gives me an error "ActiveX can't create object". Any help on this
would be appreciated.
Thanks,

I creating a database design and also I would like to know how do I find
program oh ready written in visual basic

I'm using the TAB control and the onCurrent event to update the page info
when a new record is selected.  Tab 2 & 3 have a flicker problem.  How can I
stop it from refreshing when the mouse is moved around?  thx

I have a form which runs a process to check if any data has come back from a
server.    When there is data present, it runs a procedure.  This procedure
processes the data and then pauses for a set amount of time before checking
again if there is data present.

Hi.  I'm pretty new at this -- can someone help me out?
Here's my VBA module argument:
  If ((.[Planet Number].Column(1) = "Moon" Or .[Planet Number].Column(1) =
"Saturn") And .[Aspect Number].Column(1) = "Conjunct" And (.[Aspected Planet

My name is Tim.
I am currently working an internship with a department with little help from
my professors.  I am currently trying to set up a validation rule for two
fields.  The two feilds are "Lock" which has a yes/no opion to it and the

We can have data source an sql query, a query name or a table name by sorted.
But in case I want grouping, without using 'sorting and Grouping' provided in
the report. Need to pass grouping variable thru code?

Hi, sorry to be lazy!
Can anyone put their hands on a Function that transposes values in a
recordset into a variable i.e.
Last Name:

What am I doing wrong?
Want to look up field [DeviceAAT] in table tblDevices where field [DCode]
from that table = MyDevice
Dim MyDevice as string

I don't know how to run a public function from a command bar, so I've called
a Macro which does it.
But the function has a cancel button which makes the macro burp with that
disgusting HALT dialogue.

What is the code for incrementing an integer field in a table by pushing a
button on a form?  I'm drawing a blank.  thanks in advance

I create a form and a button on the form. When  I click the button, the code
would send information to the report to be printed out. However, data show up
on the report only when I debug line-by-line (there are no erro at all. I
open connection to the database and recordsets). ...

I have a table which has some columns hidden and others not. I wanted the
appearance of a second table to look like this table because the two tables
sit one above the other as child objects on a form. I figured out how to
loop through fields and set the ColumnHidden property of ...

I have cmdbegin and cmdend controls in my form.  In a button on the same form
I need to write code that will check to make sure that the difference between
cmdbegin and cmdend is not greater then 6 months.  The code below seems to be
working, but I'm not sure why >5 works instead ...

I have a form (frmHouse) with a subform (Options) that also has a subform
(Materials).  I need to add default records (read from a query) to the
Materials sub-subform.  I can read the query into a recordset and get the
first record on the sub-subform populated properly.  The ...