I have a Access VBA code and I like to remove the a Excel tab.
Can anyone help?
Thanks

I am killing myself trying to determine what is wrong with my app. I have a
fairly large Access program that I sell to the public. I am using Office XP
Dev and distribute the app as an MDE with the Access Runtime which is
insatlled using the Sagekey MSI installation scripts.

I get an invalid argument error when I try to open a recordset from the
current database table named dbo_CardHolder using this code:
   Dim rs As Recordset
   Set rs = CurrentDb.OpenRecordset("dbo_CardHolder", dbOpenTable)

Is there a way to show some part of the text as highlighted or bold in a
text box thru VBA code?
Thanks for your help
Krishna

Is possible to import data from a other software program like QuickBooks?
Has any one every done this before? I would like to import bank deposit data
so I can run queries on money deposited and money than my database show’s I
collected.

How can I make this work in a query:
PARAMETERS [tblname] TEXT;
INSERT into [tblname] . . .
I know I could build SQL in the VBA and go from there, but this seems more

Why doesn't this work?
the query produces results with one of the fieldnames as DateDone and whose
values are dates. I'm trying to get a fieldname that looks like the dates in
the DateDone field (I'll use in a create table SQL later).

How would I rework this code so that I can use variables with it?
DoCmd.OpenForm "frmReportsMenu", acDesign
Forms!frmReportsMenu.cmdClose.Picture = "I:\Bid Administration\bids.ico"
DoCmd.Close acForm, "frmReportsMenu", acSaveYes

Hi can someone tell me what I am doing wrong.
I am calling a function from within a form. The function is located in
module2.
The values pass to the function fine but the returned value from test2 is

I am trying to use a very sloppy telephone list. My table is set up
(aaa)nnn-nnnn but the list I'm trying to use is horrible. Some entries have
area codes, some don't. Some have extensions some don't. Some are missing the
area codes but have the empty parentheses. Some have ...

SUMMARY: I have created an extremely simple VB6 app that uses ADO 2.8 to
query a Access DB through OLEDB. Problem is that memory IS NOT RELEASE even
after Close & Set to Nothing both Recordset & Connection ADO objects. It is
so simple and straighforward that I can not believe ...

I have 2 Access apps that send mails using the Outlook object, works fine,
except one thing: everytime the mail is about to be sent by the app, a dialog
box related to Outlook appears warning me that my app wants to send a mail
and is that all right, etc.

Dlookup("field","SAVED_QUERY","Criteria='string'")
I think it's not liking either using a saved query as a table, or it's not
liking that my string/date/number is a calculated expression in the query.
Thanks for your help.

I'm trying to develope an application that can track attendance at various
classes of varying times and dates.  So, looking for some ideas.
I've got the tables for the classes and their dates (start/stop, and dates
for each meeting, which can change, be added to or removed from the ...

I have a subform based on a query, In design mode I have column headings in
the form header. However it shows my information with the column headings
with the table column names and does not show the form header column names.
any help would be appreciated. Arnold