I have setup a field on a form to do a calculation in the control source of
a field. Now I need to have that data saved to the correct field in the DB.
Could you help please.
Thanks

I am learning about Visual Basic.Net.  The exercise currently is to
programaticically open an OLEconnection to an existent database.  I have
checked the code and it is correct.  The database is on my home machine, an
MDB file I made myself.  When I attempt to connect I get the ...

Please let me know if this function is working with Access 2003 and if "yes"
is there any changes to it. Thanks

Have a client who wants "To"/"From" directions with mileage on his service
order reports, generated by an Access DB front end.  Is there any way to
automate a query to MAPQUEST using fields on an open data entry form as
inputs for "To" and "From" addresses, and return the output ...

I hardly ever use VBA, so I'm not sure on the syntax, and I'm sure
everything else I'm doing is wrong also (but it works, so I'm not
worried about that for now).
I use Open to open a binary file.  I then use Input to read in 1024

Please Help!  I have been running cirlcles with this one for 2 days!
My code below opens an existing spreadsheet (from an access 2002 form
button), does some formatting on two different tabs, then closes and saves
the spreadsheet.

hi, im trying to remove the non numerical chars from a phone num. im using
this:
fax = Format((rstlist!PhoneNum), "##########")
and that takes out the dashes but not the () .  how can i remove the

I'm using the MS Date and Time Picker Control 6.0.
Is any way to check if it's registered (MSCOMCT2.OCX) on a user machine and
if not to copy and register it programmatically (VB) during the form or app
downloading?

hello, i have an access database that finds an outlook contact alias. (ex.
ABCDE)  Is there any way i can have access search the contacts and return the
contact full name?   I don't know if there is a way to open outlook, open
address book, search by alias and return contact full ...

The following code is ruinning from an Access 2003 application:
Function callStoredProcLogin() As Boolean
   Dim db As DAO.Database
   Dim qdf As DAO.QueryDef

I would like to know if it is possible to capture a picture to be stored in
a OLE object field in my ACCESS database. I mean, that you are able to
capture the picture directly into the field from the camera. Not making the
picture first and after make the link or embedding the ...

When I select 'debug' the set con=Application.CurrentProject.Connection is
highlighted in yellow.
 ' Open the table of Switchboard Items, and find
   ' the first item for this Switchboard Page.

I get a "Invalid Data Format" on a replicated DB.  It appears to effect my
modules mostly.  Does anyone know what could be causing this or what possible
solution there is.  I can not change or edit my Reference Libraries when this
happens either.

I have 20 labels that I update with DLookup and DCount functions.  I have
used a naming scheme to where I start with "stat1" and end on "stat20".  I
have a line of code for each box to update the field:
Me!stat1.Caption = DLookup("[status]", "tbl_tourstatus", "[index] = 1")

I've written the code at bottom to open certain forms in my db.  It all works
fine on my computer, where I created the db.  But when users at other
stations use the database, the click event that should execute the code
doesn't seem to do anything.  Do I need to specify the ...