Ive read the threads about the command to "add Today's Date/ Prefill" the
current date on a form.  Ive tried serveral things to make this populate
-i.e. default of control = Date() .  Also, i tried it out of v.b.
private sub on_click()

i have a table with a yes/no field call "Edited". i have a button that runs
code to set the "Edited" field of a selected record to "yes". the code also
set the rowsource (using SQL  Update and Set statement) of a combo box to
display only records with the "Edited" field = "No". ...

I have a form where I want the background color to change based on if it's
the most recent record;   If a person has 3 contracts, 200601, 200701,
200801, I want 200801 to be one color and the others to be another color.  
How would I code the on current event to show this.

I have some users who are complaining about a previous filter not displaying
when they go back to the form. Ex. Open a form, Filter By Form, enter
criteria, Apply. Close form, do other stuff, re-open form and the filter
criteria entered is no longer there.

Greetings All,
I wonder if anyone has run across this issue. I am using Stephen
Leban's rich text control, which as I've mentioned in another post, is
fantastic. But I'm having a strange issue when trying to lock the

I have a form that created and upon review due to the large amount of
information on one form it was decided that it was better to use tabs.  I
wanted to know how I would change the grey background color as I can not see
my boxes anymore.

Passing a function argument by value is not doing what I expected it
to (all fields in this code are unboundtext or
combo boxes):
I expect

Good morning,
I am trying to add a progress bar to each record in a continuous form.  Is
this possible?
I have a query that has three fields, Name, Total Hours, Used Hours.

I'm having an issue with an IE explorer message and don't think I'll get any
help from the IE groups.  They don't seem to be too active and I haven't
gotten a response, so I am hoping someone here can help me.
I am suddenly getting this message when I open and do anything at all ...

How can I create a command button that would open or link to a pdf depending
on the Part Number field value?
If Part Number equals abc123 then open abc123.pdf, if no corresponding pdf
exists, then display some text , "not available".  The pdf would be located

I'm using the following with a click command and it works fine.  How can I
make it work when I scroll through the records on my form?  current, dirty,
etc...
What would be the proper way?

on my form i have made an organized layout to comprise of four experiments (a-
d). the resin used for  experiment A, is chosen using a cascading combo box
and automatically fillled in under txt field for experiment A resin.
my question is how to make the resin selection cascading ...

My form was working fine and then after I installed ClickYes, I get an error
message "error in loading dll" when I hit hlep, it states it can not find
VEENLR3.hlp.
This happens when I click on my combo box which opens a pop up calendar.

I have a form with a TAB Control on it.  I have fixed the form so that as I
exit the last field on the first page of the TAB Control it goes to the first
field on the second page of the TAB Control.  When exiting the last field on
the second page of the TAB Control it goes to the ...

Okay here's the issue. On one form I have two search fields set up one to
search by name and another to search by project number. After Update they
work beautifully to move the user to the correct project. the code for these
are as follows: