I need to strip the dashes and brackets from my fax field for our server to
fax automatically and I am looking for the code for that.

I have a control in an Access 2003 table that is set to text because of
alphanumeric needs. If I change the field to numeric, it breaks too many
other functions to be worth messing with.
Currently, this control [strReviewID] has a standard format that is use,

I have written the code to email from Access. Now I am trying to create a
message for the email in Access and this I can do. Is there anyway to
specifiy within the message type style, size, Bold, underline, etc? I am
using Access 2003.

Is it possible to export a table to another database automatically, say...in
an onclose or onexit event of the source database??
If so, how would I go about doing this?
Thank you!

Hi i have got following problem. I want open from form excel file. I have got
like this :
stAppName = "Excel.exe C:\neco\neco.xls"
Call Shell(stAppName, 1)

Previously, I have used the following code (from a book) successfully. In my
current MDB, however, the call to FindWindow raises the error: "Sub or
Function not defined". I don't remember ever having to explicitly declare Win
API functions from within VB or VBA. Am I missing a ...

Is it possible to refernce and utilize in MS Access a DLL written in Visual
Basic 2005?
Thank you.

I've just built a function that creates a form and populates it with text
boxes, based on the view or query that is passed as an argument. The only
thing I can't seem to do is to make it save the form with a predetermined
name.

Hi all, I have got little problem. I want open excel file from form in
access. I have got button and in VB code i have : this is some from code
stAppName = "Excel.exe C:\DBPrametTOOLS\vzorce.xls"
its absolute path, but i want make relative path because i want in future

Trying to run an Update query immediately after the file import in order to
capture the name of the file associated with the data.  I must have a syntax
problem because I'm getting the word strFileName in the table, instead of the
actual file name.  Where am I going wrong?

I have many records to keep track of members reason for leaving our program.
example: Withdrawn, Volunatry, Out of County.  I have 6 options to choose
from, but I need for the option button to populate it's coresponding name
field with a #1 for counting and I also need for the ...

AccessXP ---
When I try to use the FollowHyperlink method I get the message "Some files
can contain a virus or otherwise be harmful to your computer.........." When
I click OK the file opens just fine. Is there a way to suppress this dialog

I'm trying to run following code and it gives me a compile error of
"Method or data member not found" and highlight
List1.Clear. Can someone tell me where can I find method or data member?
I have Form_load sub that previously load recordset into the list, and then

I want to build a common function that is functioning  when a certain form is
opened and nothing happens when such a form is not opened.I presume I must
use the line If ISOpened but I cannot do it properly.Could you help me ?
Public Function MyBack()

I am trying to write a macro or VBA module that will automatically send a
report tailored to a specific individual to multiple individuals
sequentially. I think I need to use the For Next Loop with a variable that
keeps pulling names and email addresses for the filter and ...