Is it possible to change the startup-icon of a .mde-file? I know I can
change it in a shortcutfile, but I want it also be changed in the .mde-file.
Thanks in advance

Older query has parameter prompt popping up.  How do I get rid of the
prompts?  If I wanted to keep one parameter prompt how do I learn what
needs to be keyed in?

I have two fields, "Item" and "Information" in the same table.
"Information" contains three items from a seperate table created by a
lookup. I would like to substring out the first item and place it in
the "Item" field. Is there an easy way to do this? I would like the

I use the instr function frequently to find particular characters
within a string and manipulate them eg all characters to the left of a
particular character.
If I understand correctly, Instr finds the first occurence of the

?InStr(1,MyString,vbNewLine & vbNewLine)
5
?InStr(1,MyString,vbCRLF & vbCRLF)
5

Ok I have a table [TblItems]- it lists items with a unique reference
code; lets say there are 4 items [RefCode]:
Item           RefCode
1                ABC1

A macro question.
I have action:Transfer Text
with the following settings:
------------------------------------

The company I work for has seen an inordinate amount of Access
database corruption with those users using one or more Vista
computers.  We always host the database files on an XP machine, so I
know this could not be the result of the IP v 6 bug.  In browsing

I have two tables which currently have Autonumber fields which are
used to create a unique number to identify an invoice for each table.
Instead of having two unique numbers I'm after only one.
My thinking behind this is to

I have a bounded form and after I click the button to update/save. THe
fields are still there. Is there a way to clear off the fields in the
bounded form.
Thanks,

I've converted my Access 2007 database to an accde format as I don't
want users to be able to modify it. The only problem is that all the
code has stopped working. I have split the database and the backend is
on a server and the location is in my trusted locations setting.

I save radio button information as number in my database
1 = blue
2 = red
3 = yellow

I have deleted a lot of imformation from a database that has gotten
large.  After deleting the data, I did a compact and repair thinking
it would reduce the size of the database.  It doesn't change the size
at all.  Any help would be appreciated.

I have a website that uses an Access 2003 database. I have controls on
my pages that are bound to SqlDataSources that pull data from this
database. In a couple of them, I need to use the replace function to
replace some text in the results. Access' REPLACE function is only

In A2003 one can create a linked table using
File/GetExternalData/Link/Exchange().  It's a nice feature but by and
large fairly useless if I am reading the table structure correctly.
The From & SenderName columns may contain data like joeblow@test.com or