Is there an alternative to the ‘Conditional Formatting’ facility, the problem
is that I want to use the standard light grey background colour for my text
box (effectively making it invisible. But that particular shade is not
available in the colour picker on this feature. So how ...

How to paste programmatically  a picture (jpg) from the clipboard to an
image field in Access 2003?

My form consists of a main form and two linked, embedded subforms.  The main
form source is the employee master, the first subform ("emply_bal_subform")
source is a by-year summary of allowed absences (vacation, etc), and the
second subform shows current year absences.  I've ...

Maybe I'm putting the Cart before the horse but....Relationships.
I'm using unbound forms with mostly SQL statements behind them, do I still
need to define the relationships between tables, and if so why?
Thanks

One Simple  problem which i was not able to find solution.
In a sub-Form(Deduction_Details), I have three field like
1.Sl.No (Autonumber field)
2.Deduction_Remarks

Hi. I had code to display the number of records using the RecordCount
property in a label but have misplaced it.
The code example in Microsoft Visual Basic help was way more than I needed.
Can someone point me to an example?

In the application I'm using, I enter several numbers in a subform, then
click a Next Button on the main form to move to the next record.  The Next
Button's click event has the code shown below, and all works well:
   DoCmd.GoToRecord , , acNext

I have a form that has 2 subforms on a tab control.  The 2 subforms have
similar record sources.  When I make changes on tab 1 - the information
should reflect on tab 2 if the user is on that record (i.e, the user goes to
tab 2 and uses dropdown to move to John Doe's record.  ...

I have a form that calculates senority. So Start date to Now() gives me a day
rating say 3011 days. How would I extend the below code so the ranking reads
yrs/mnths/days?? Any help would be greatly appreciated!
Here is the code I am using to get it to days;

Does anyone have some code I can use to find the first capital letter in a
string?
I need to split off and show all characters to the left of the Capital
letter.

Hi, is there a way to programmatically retract the dropdown on a combo box
after doing not_in_list event:
    reponse = acDataErrContinue
    me.undo

I have a form that I use for data entry of music composers.  On the form are
fields for FirstName and LastName.  I have successfully added a ComboBox that
populates the form based on the LastName.
Because of families of composers that share the last name (Bach, for one), I

This is what I am trying to do with access: Have the user browse and select a
spreadsheet file, then when they click an execute button, the data on the
spreadsheet file will be queried against the current table of information
that the database has, and then if the ID numbers are ...

I have a form that uses 4 combo boxes to pick items from.  They are all
syncronized together, and for the most part this seems to work.  But I have
added a test to see if there is only one value in the combo box after each
'after_update' event, and if so, set the value of the combo ...

I am using the following for a form's textbox controlSource:
=DCount("[DRef]","[q1Main]",("[q1Main.DRef]">=#06/01/02# And
"[q1Main.DRef]"<=#06/30/06#) And "[q1Main.CaseType]"="CUS")
The count is 0, but I know the count should be larger than 0.  Does anyone