To the best newsgroups
I'm small developer (beginner) if you answer me please give me solution in
steps
I have (startup) form but (small)

I'm about to go crazy here.  I have records showing in a listbox
(lstShortGoals).  I set the double click event to...
   Dim Crit As String
   Crit = "[GoalID] = " & Me.lstShortGoals

I would like to add a textbox on my control that is not linked to a
database (like the other textboxes are, which are linked to fields in
the database), that takes the sum of all the textboxes in the form.
How to do this using "Expression Builder"? (Or otherwise?).  I'm

Question:  how can I modify my code to utilize the textname selected,
cross-reference it to its associated codenumber, and GOTO the MSG2027F:
Background:
On a subform, when the focus leaves the combobox assessment, I want the code

   I currently have a database that keeps track of patients. Before a
new patient is added as a record, I want to check and make sure there
is no other person in the database with the same first and last name.
Obviously, one or the other is fine, but I don't want 2 people with

Ok, So the subject sounds silly, but read on:
I have a form with a multiselect listbox of student ID's which is used to
launch various reports. There is one report which requires only one student
be selected. Is there a way to prevent a user from making multiple selections

Hi... This is my first post and I want to know if there is somewhere a code
to write to the registry.  I have one from someone in the past but I try to
use it on Windows Vista and instead of putting the key in the local
machine/software it is adding to some virtual folder.  Does ...

This should be very easy, but isn't working right.
I have a form in continous view (which seems to be the problem).
For each record, there are 2 comboboxes.  The boxes are both tied to data in
a table and the user won't necessarily touch the first combobox prior to the

i know how to active an exe file by Shell() function, but if i want to open
the file has the directory like "c:\my document\001.jpg ", which function
should i use, i try shell() too, but it does not work, and tell me the
argument is wrong.

i just start a test programe with access 2003, and in one form, i want to
make a button to open an open file dialog to choose one file, but i can not
find the right way to do that.
any help will be appreciate, thanks

My app has a listbox that displays a huge number of rows (several thousand)
for multi-selection. I'd like some way to position based on the first letter.
Is there a good way to do this?
Thanks.

I'm using Access 2007 on Vista.  I am about to start sharing my database
with others in my company so I'm trying to get it polished up a bit.  My
database is split into two parts (application and data).  I have created an
installation file that stores the application side of the ...

Need help and not sure where to start.  I have an input form with several
tabs. On the first tab is where the general vendor and customer info is
entered.  I added a fourth tab to 'monitor' two of the vendor’s decisions.
Tab one has an option group with 5 programs.  Tab 4 has an ...

I'm puzzled by something that I'm sure will be obvious to others.
I have a form (frmTask) with a textbox (txtTitle) having control source...  
=Forms!frmMainMenu!txtTitle
Really, I'm just stealing the title from another open form.   when it first

I had a field named created by that would pull in the network user name, then
date and time record was created as shown below:
sbingaman 12/27/2007 7:42:15 AM
what do i need to do to get this to repopulate automatically again?  i can't