I have a problem with my function.
This function cut my variable StringIn on 255 long char.
But  variable value StringIn is as memo type. For examle 800 long char...
Function ReplaceText(StringIn As String) As String

I'm trying to create a VBA script that will allow a search feature in a
dialog box.  Basically I want to be able to search for any field and then
apply a filter so that only the records that contain the inputted text.  
Example:  I want to search for a record that has "dog" ...

I want my users to be able to safe a link to other documents in the access
database.
Any ideas?

Want code to execute:
File, Get External Data, Import, H:\Inventor\ (So I want this to open dialog
box in this directory so user can pick file to Import), Files of Type -
Microsoft Excel (Again, would like this to be the default)

I am sending information from and Excel Spreadsheet to Access 2003. The
connection is fine, the recordset opens fine. When there are no rows in
the table, the scripting fails stating Either EOF or BOF is true or a
current record is required.

In Microsoft Access, we need a macro for comparing the lesser value of 2
values in separate fields and for the results to populate in one field.

I'm using the filesearch in Access VBA to determine if a specified Excel file
exists within a specified subdirectory using the following:
With Application.FileSearch
               .NewSearch

I have a database that has a table, tblDBUpdateInfo, that stores
details about when the database was last updated.  One of the fields in
that table is AdminLocked, a yes/no field, used to indicate if someone
else is updating the database.

I'm a newbie to VB coding so any help is great!  I have a form with six
checkboxes.  I need some VB code where if the first five boxes are checked,
it will automatically check the sixth box.  
I can get it to work where if a single box is checked, it will check the

I've almost got the answer to my question by reading previous posts, but
still need a little help.  I have learned that the best way to  assign a
record source,on the fly,  for reports is with the report's Open Event with
code such as below:

I have a "Date Sent" field and "Date Due" field.  I want to have the "Date
Due" field automatically set 15 days from the "Date Due" field.   So if I
enter 09/18/06 in the Date Sent field the Date Due will automatically state
10/02/06.  Any Ideas???

Group:
I am using Access 2002. I want to add a column to a table (MasterData) in
the backend database and then specify that it be an integer with a default
value of zero.  I am using the following statement to add a column to the

Here's a weird one. The code
   Set qy = CurrentDb.QueryDefs(strSourceQuery)
   strSQL = qy.SQL
   Set qy = CurrentDb.QueryDefs("Kits Found Special")

I have written some code that I want to step through.  From my limited
knowledge of Access there is no other way of running this code without using
a button (on click) to kick it off.
The reason I want to do this is to get the following code to run.

I notice that Application.References. … is available in VBA.  What are the
uses of this?  Can this be used upon application startup to make sure certain
reference libraries are loaded for a particular application, such as "MS DAO
3.6 Object Library" for instance?  If so, how do ...