With the code below I'm looping through my form's txtBox controls and tags.
If the control is a txtBox and has the tag of GrpA then I want those controls
to not be enabled. problem is, it doesn't work.
How can I test for multiple conditions and then change the control's

I am trying to redesign an old database. I have three forms start, entry,
edit forms. Start form is like a switch board to enter into the forms. An
audit is entered into the database through "Entry" form which has around 50
controls. All these controls gets stored in the main ...

I'm having a problem with the TransferSpreadsheet method in Access 2007. The
TransferSpreadsheet method is exporting a query to Excel, and it has been
working fine under Access 2002. Under 2007, however, Access seems to
truncate up some of the query column names, with the result ...

I was wondering if anyone knew how to get a form or report to pop-up
automatically, or whether or not Microsoft Aceess even has this
capability?  I really appreciate any help you guys can offer, thanks.

I am building a subform for order details and pricing with Acces 2003. There
are unit prices and prices based on square meter in the product table. How
can I get the price both ways into the price field in the subform? The square
meter calculation works very well. Either one of ...

Hi all,
I have a form that displays various metrics for all the different units
within the org.
It looks like below:

I would like some information as to how I can get the following to happen.  I
have a database where I have the table Switchboard Items (created using the
Switchboard Manager in Access).   I would like to create a new Switchboard
form using the treeview control, and having it ...

I have a form with a date control which has as it's default value =Date().  
How can I, using VBA, dirty the record using the default value if a user
enter a value in the subform without entering any other info in the main form?
Normally, the default value appears but doesn't get ...

Morning All
I am wanting to change the backcolor of a text box based on the ID of a
field on the form.  I am using a continuous form and cannot use conditional
formatting as there will be more than 3 colors.

The following code works very well except that the user has to keep clicking the
end of the string in the text box in order to add to it.
What I am really after is that after each entry into the text box, the list
(it's a continuous forms type of view) is progressively narrowed down ...

Purpose:
I have couple of form in different databases  I need to make a menu to
operate those forms.
Question:

When I export a date column to a csv file I always get the date followed by
"0:00:00", is there any way to get rid of this time portion withiout using
the local settings which may vary from machine to machine. I looked in Access
Help but it gave no examples forthe Format function ...

  I'm trying to find a calendar database that I got from someone in this
group. The thing I remember is the calendar could show one month or show all
twelve months. If anyone knows were this database is please post the link.
Thank-you.

       I want to use Stephen Lebans' custom scroll bar control to scroll a
FlexGrid control.  Within my application, I'll have a few different forms
using his control this way.
       Desiring to reduce repeated code, I know I can create a module with all

Is there a work around to the allowAdditions = False problem where the screen
goes blank?
I want the user to open a form and only be able to work on the record if
they have clicked on the edit button. But with allow additions set to False,