Is it possible to have different selection choices (text) in different colors
in same list-box??
suppose I wanted western sub-regions selections colored Green and eastern
sub-regions colored Orange in the selection list of a listbox

The statements below work fine in Access 2000 to 2003, but not in 2007.  Were
these statements removed ?  Does any application which references toolbars
have to be rewritten ?  What is the solution ?  Thank you.
DoCmd.ShowToolbar "Page View", acToolbarNo

I need to be able to round a number either up or down in .5 increments.   The
number is in the Currency Format in Access.  So, if the  number is 18.3, I
need to be able to either round down to 18 or round up to 18.5.
I found the Fix and Int functions which will truncate to value ...

I've been able to accomplish this before but now I'm having trouble figuring
out the problem.  Can you help?
I have vba code in Access that updates a spreadsheet in Excel and then saves
it to a new name.  After this has been done, I use the following code:

How can i use dmax to get the latest field in a table?
I tried the code below but i get the autonumber field.
dmax("AutoFieldName","TableName")

SELECT
Count(RISK_TBL_OFFERSLOT.FLOORAMOUNT)/2 AS Hours,
Avg([CAPAMOUNT]*1000) AS [Price ($/MWh)],
Avg(Abs([KW])/1000) AS [Capacity (MW)]

Project field,a primary key, contains 2-5 numbers with a 2 letter suffix, the
users initials. When the user clicks a form control to add a new record, I'm
trying to find the last record with their initials to help increment the
project number for the new record. I can get the ...

I have Dlookup:
That WORKS:(this has single quotes around the criteria)
myRequireItemNo = DLookup("[RequireItemNo]", "V$Pamphlets", "[Pamphlet] = '"
& Forms![#10 Pamphlets]![subform #10B PamphletOrdersDetails]!Combo7 & "'") '

I have a table which has index on id and Amount field (table 1). The table1
has more than 20,000 records and will keep increasing. There is another table
table2 which is related to table1 by id.
I have created a form based on the query which links table1 and table2 by id

I have a subform on a tab control that's on a form and I can not get it to
display its record source.  I have set the subform record source, removed all
filters from the subform, and set its data entry property to no.  The parent
record souce is different than the subform's ...

We are a professional Store, we supply Runescape gold, someone may
call it Runescape Money, or RS GP.
We strive to offer the fastest and most Reliable service on the web
for all your gaming needs. We are here for 24 hours a day 7 days a

How do I check this Function in the Immediate Window?
Option Compare Database
Option Explicit
Public Function REDACT()

I'm old to Access and new to access programming.
An event procedure never seems to recognize the new names of renamed fields.
In fact, it does recognize and access renamed fields by their previous
names.   (So, this isn't the usual error of failing to update the code to

I'm trying to use the DoCmd.open query statement to run a Select query.  The
query has a function which captures input from a form.  The query and the
code executed properly as long as the input is simple, but I run into
problems when the input is a composite one.  The same thing ...

I have a database that is used to track production on several thousand
records in a second database.  The production database is all I am dealing
with here so really you dont have to worry about the second.  Anyhow, every
month each office has to supply metrics on how much ...