I have the below expression within a Text Box on an Access 2000 form in order
to hide the text if one of the fields is blank.
It works well except where the fields in the Table are in a currency format
which results in #Error

I have the following codes in my command button in a Main Form. When
cmdbutton is click, nothing happens. It works when the subform is navigated
first before clicking the cmdbutton. I tried to insert a "setfocus" command
before the "rst.MoveFirst", it works but on the second ...

I am using Access 2002 and in my form I have these text boxes:
 Delivered        Faxed         Mailed         Hand Carried
Only one of the text box must be populated,  the problem is that my user
populates (input a two digit letter AB) two or more of the text box.  I want

need to check a condition if less than 2 months 'rejected' or approved
and if more than 8 yeas 'rejected' or approved
done above as below
agecal = IIf([age] >= 0.16, "OK, NOT BELOW 2 MONTHS", "BELOW 1 MONTHS NOT

I am using MS Access 2002 and in my form I am using Access standard add
command button, but unfortunately I can't seem to get the first text box
focused.  All I want is the user to press the command button add and have
the first text box focus.  Any tips or help will be ...

If I have 2 option buttons (mos, weeks), 2 fields=term and start date, and
enddate=the field I want to calculate, do I put the Event procedure to calc
the enddate using the results of the 2 option buttons, and the 2 fields in an
After Update event procedure or do I put it all ...

hi, good day.
i have made 2 toggle buttons toggling each other when clicked respectively.
here is its newbie code:
Private Sub Toggle20_Click()

I have a combo box on my data base that is used to change the status of a
loan application. Is there a way to have a pop up box ask the user if it is
ok to go to "X" status (Yes/No)???
If user selects Yes, then staus is changed, if user selects no, then does

How can I tell the macro to not format a word if it is already capitalized?
This macro works create if I enter a simple street name, however, if I want
and enter, say US Hwy 32, it will format it as Us Hwy 32.  Would this maybe
require an if then statement or something?

I have a subform with a listbox of Codes and description field that does a
dlookup to get the associate description from the codes table.  If the user
changes the value in the listbox, a macro runs to put control on the
description field and then requery it.  It works fine when the ...

How do I create a procedure to convert a field values to proper case?
(Capitalize the first letter of each word, and convert all others to lower
case) I.E. Nova Scotia, Prince Edward Island ..etc.

I have a public variable set up so that I close one form, enter dat
and then go back to the original, and be able to load the sort an
filter from previously, but I have to close the form, not minimiz
it. I can set the values fine right before the DoCmd.Close, but in m

I have a report form with the following parameters: fromdate, todate,
assignedto, companyname.
All my reports are created so that when the user picks the from and to date
on the form and clicks on a report button, they get the report filtered for

I have the following code in a command buttons On Click event. The form that
it sits on has a control sorce showing two tables in a one-to-many
relationship. When the button is clicked, the many sided record is deleted,
which is what I want. I added the Me.Requery line to get the ...

I knew this is a very 'popular' question but I could not find the proper
answer to solve it.
I have a line of code
sqlstr = "INSERT INTO [table] VALUES (Date,'" + Comments.value + "');"