I have a text file dumped in my db that contains a date field in month-year
format. It's a string like "Apr-08" for April, 2008. If I use the cdate
function it comes out "08-Apr-2006". I'd like to end up with "Apr-2008" if
possible. I would settle for "01-Apr-2008" if necessary.

Is there a way in VBA to open a recordset, and count the number of dots in a
text field?  For example a value of 1 would return 0, but a value of 1.4.2.1
would return 3.  I am trying to determine at what level of a hierarchy a
particular record falls.  Thanks.

Hi Every Body,
I want to make a custom function which looks for full is stop(.) or number
in the text matter.Whenever it find it breaks the line.
As i want to display every sentence in seperate line.

I have a word document with fields which i need to unprotect /edit/re-protect.
The code below always works okay from within Word.
In Access I get a message "Variable not defined" pointing at the '
WdNoProtection' enum (it's an enum right?)

I am exporting a recordset of data into a word  template which works great.
However i want to sign the word document using a path/file name within my
recordset.  
I've tried several ways of writing the code. Basically, this imports the

Having the a problem with the below function. I am parsing data below:
  CC,4.5x5x7,C2
  CC,4x5x7,C2
  PB,5.5x5.5x8,C2,ModelName

I have 2 tables
tblresult(ResultID,ParameterID,ResultValue,ResultISPass) and
tblParameter(parameterID,ParameterName,P_HIghLimit,P_LowLimit)
Now when i enter the resultvalue in tblResult or frmResult I want that

I've recieved some vb code from the interent and it has a Private Declare
Auto Function, which wont complie. Is this function normal?

I developed an Acc2000 DB. Now some users moved to Office 2003 while other
are still on 2000, and certain code in Acc2000 doesn't work anymore. I want
to be able to tell what Access version a user has and then uses different
code. How can I do that? Thanks.

I am trying to open a recordset using a SQL statement that contains a value
from an open form in the WHERE clause. I am getting an error "expecting 2
parameters".
strSQL = "SELECT [USER_CODE] FROM SYSADM_APP_SECURITY WHERE ([USER_CODE] >=

I have a .ASPX page that contains information that i need. What i'd like to
do is to create a table with the information contained on that page.
Is it possible to link or import information contained on a .ASPX page ?
Thanks

Thank you for any help that this community can provide.
I am using a telephony ActiveX to monitor incoming calls and capture the
Caller ID.
With my form open, when the phone rings the ActiveX delivers the Caller

Is there a way to get name of the control that triggered a MouseMove event,
without explicitly passing the name?
The solutions recommended in Subject: Get name of a control,  5/16/2006 1:40
PM PST By:    ScottH---  ,

How do you put a hyperlink into an access table that is an excel file?

I was wondering if someone could help or point me in the right direction; I
searched but am not even sure of what search terms apply.
I had several string variables declared like this:
   Dim strAlreadyAdded, strErrorMessage, strCannotAdd as String