In the properties of a desktop icon on the ShortCut tab there is a (Target)
line and a (Start in) line.
Is there a way to hide these two lines so that no one can see the Target and
Start in paths

I would like to automatically change the first letter to upper case and keep
the rest intact of each sentence on a control of a form, i.e., i am going to
school.  see you in the afternoon. -> I am going to school.  See you in the
afternoon.  Is there any functions to do this job?

what I am trying to do is this:
I have this:
Family Names ¦ First Names
_______________________

I have used Allen Brown's technique for filling a listbox on a form with the
names of files in a certain disc folder.
It works well.
I am now giving the user the option to print the form contents in a report

I have a very basic database two tables that have a relationship and
that works well on my form, my issue is i have  another table that is
just a list of locations, what  i cant do is add a selection from that
list onto my form and make it be unique to that record. any one got any

Anyone know what a feeder file is or have a good defintion online which
I can read more about them? Help much appreciated.

i want to locate the small image loaded to image control in the center
of the form.
whenever form is opend, the size of form is randomized.

I'm having trouble locating code to change the names/locations of
linked tables. For example, App1.mdb is linked to tblA in
w:\server1\data. I want the code to enable App1.mdb to relink to tblA
in e:\server1\data, without having to use the Linked Table Manager. Is

Hi I have a text field called FName.
Records looks like this
8 Kingston
10 Wilston

Why do you think a create table query doesn't create table from the
following code?
Set myQuery = myDB.QueryDefs("qryCON absent adults previous day log")
myQuery.Execute

I have an Access app running in our system which manages our intranet
and access details for users.
I want to add a button to individual users to enable us to open the
login page and login as if it was the user, with their own login codes.

Hi, I made an access application. And in some cases, it gives me error.
And when I tried step by step execution, it worked fine. And every time
afterwards. But it gave me the wrong answer before I do the debug.  Is
it possible that some code gets skipped?

For some reason I'm blanking on how to do this...
I have a table with people:
Person1
Person2

I have this code written that lets me relink my SQL server links to a
specific SQL server (via a different DSN). The problem I have is that I
have to enter the password when I run it. Can any one show me how to
code the password in so the user doesn't have to deal wtih that?

Take the following SQL:
DELETE tblPreliminaryVINs.*
FROM tblPreliminaryVINs INNER JOIN tblVehicleJobs ON
tblPreliminaryVINs.PVIN = tblVehicleJobs.SerialNum;