I have a field which has names imbedded in the field.  There is no standard
format in the place the info is located nor is there a standard format to the
name (ie. C_Smith, C Smith, etc.).  I assume I have to nest several
MidFunctions inside an IIF statement but not sure how to ...

I am facing problem on my access report, now im thinking maybe if i use
crystal report my problem "might" be solved. my problem is i created a
formula inside the Access Report and within that formula i need to get the
grand total of that, i am able to display the result of that ...

How do I pull the defendantID from the tadefendant table and place that value
into the tadefendantsnotes table via sql?  See the sql code I have below and
the basic layout of the tables involved.
What I am trying to do is when I print a letter, to have a note put into the

I have a database with phone numbers stored in it.  I also have a
counterpath softphone installed on my computer.  The counterpath
softphone, by typing sip:12345678 in the internet browser or the run
cmd on the start menu in windows, dials the number 12345678.  What I

i am using Application.FollowHyperlink to open an Excel file.  It does open
however, it always open with the workbook in a restore size (I'd don't even
think it is the true restore size of the workbook either).  This only happens
when I open it this way.  When I go an open the ...

Im desperately trying to run a query with code. I have tried using the Docmd
command which worked but the database Im connecting to has linked tables and
its asking for a password and i dont know how to specify one.
I have tried using ADO ...not many resources on internet I can ...

I wish to Display the User Logged onto the PC in my Access Database Forms and
Reports. There must be a way?

I found some code, adjusted it a little, and although it seems to work, when
I exit the DB and open it next I get "Invalid Operation" (error 3219).  If I
click OK nine times I get a message "Cannot Update.  Database or Object is
read-only."  Clicking OK takes me into the DB and ...

I am new to Access 2007 and I am developing a new application. Everything was
going great until I tried to build a custom ribbon. I have followed the
process shown in the Help file precisely! (under custom ribbon) several
times, with no joy.

I'm packaging an application to be deployed via internet download.
I'm using the Package Wizard and everything is running smoothly, I'm not new
into this.
To avoid users the pain of going through all the scaring windows messages

I have the following code:
format(dblTest,"0.00%")
It works fine except that with a negative number it prints -1.01%. What the
accountants want  to see is (1.01%). Is there any way to get the brackets

In Access 2003, I need to programmatically open a Word doc (invisible) and
spin through it looking for bookmark(s). When I find the bookmark(s), I will
insert text in that spot from a database table. Once that's done, I then need
to print the document and close it UNSAVED (thus ...

I am using Oracle database in Access application. How do I get the unique key
in the Access forms whn I insert data

Has anyone coonected via ADO with Sybase System 11 driver or Sybase ASE
driver?
I think there is a problem with the ODB driver. I got the same error when
using ADO, DAO and a pass through query.

Im desperately trying to run a query with code. I have tried using the Docmd
command which worked but the database Im connecting to has linked tables and
its asking for a password and i dont know how to specify one.
I have tried using ADO ...not many resources on internet I can ...