I have a main form and a subform. On the main form I have a text box called
txtSearch. I want to be able to using this text box to search for a record in
the subform. As you type in txtSearch the subform should change to only
display records that match whats been typed in ...

In an alphanumeric field (Invnr) I have data like "J1", J2" "J100” etc.
Since the result when sorting on this field is somewhat “peculiar”
(J1, J100, J2 etc) I would like to separate the numbers from the “J”
and sort on the number (can be up to 10000). I have tried the following

I have a form for training courses that allows the person creating the
course to select the course documents, say the course outline.
At the moment i have them browse to the location of the file and pick the
file, this then gets embedded into the form as an OLE object. I've just

I am using a SQL statement that fills a subform on a form with matching
records from a table where the criteria uses Like *criteria* functionality.
As an example, please refer to the following code:
Dim db As Database

I am trying to set the interior vertical borders for a range. The range has
links to a pivot table above it on the same sheet. Depending on the column
and the value in the cell, different formatting will take place. If the cell
doesn't contain the string, "Total", then it should ...

I am trying to figure out how I can handle multiple criterias for a While
... Wend loop (maybe a Do ... Loop While would be better?). I am creating a
query in VBA which shall return SQL statements which are stored in a table
called "test1" with the field name "Code".

Hi, I would like to take a value from an access report and put it into a cell
in a spreadsheet. I have found various bits of code that half work, but
nothing that does what I want. I really would appreciate it if someone could
give me the full code for this problem, as I am a ...

I have on Continuos Form where i m entering Quantity from invoices, Sometime
I  add 2 or 3 quantities and I want to avoid calculator, how i can do with
EVAl function please help me, I tried like this but error is coming:
after update ot TotalQty :

I am use to working with Windows XP and Office XP, but started new job and I
am running Window 2000 and Office 2003.  Which means I had to convert each
MDB from Access 2000.  I then split the MDB successfully and created the MDE
successfully.  However, under the View menu, I can ...

I wrote a database for Access 2003 that utilizes the vba FileDialog so the
user can select a file.   Now the company wants to distribute the database to
more users.  However, some of them are still using Access 2000, and upgrading
will not be possible.  And of course, FileDialog ...

This security fix has replaced the  core VBA DLL VBE6.dll. This dll has all
the major VBA function like log. Core functions like the log functions are
behaving differently now.
For example   Int(log(128)/log(2)) now  returns  6 now instead of 7.How did

Hi Thanks in advance
Big Problem
strText = "39404D2"                 6 char = D for dog
lngval = isnumeric(strText)

I have the following:
If Not IsNull(rs.Fields("INS2")) Or rs.Fields("INS2") = "" Then
***rest of program***
I added rs.Fields("INS2")  because the field in the recordset is blank, but

I have the following code on a forms On Current property:
Private Sub Form_Current()
If [STATUS] = "Bronze" Then Me.Bronze.Visible = True Else Me.Bronze.Visible
= False

How do you capture this variable from SQL Server?
Example of T-SQL code:
declare @strVariable varchar(20)
set @strVariable = 'This was a success...'