I have a combo box that changes its options based on another combobox on the
main form.  I can get it to work fine with I manually go into the records
dropdown and hit refresh, but can't get the selections to update otherwise.
I have tried using refresh and requary on the OnEnter ...

hi,
Is there any function to fetch the last record in a table?
I have a table which has data with the data type of primary key being text.
The column value has data in the following format:

I Have the following code for a command button to open up multiple instances
of a form
Does any one know how I can set the name of the new multiple insatnce of the
form .

Using a Access2003 database in WinXP I am trying to shell over to a third
party software to run it. I am using the code line.
Dim Test
Test = Shell("C:\Directory\File.EXE Config1.XXX")

I'm looking for the best design for a database I'm creating.
I have a table that has 60 fields.  The User wants to be able to bring up
client records that only use certain fields that pertain to that client.
One Client may only use 12 fields were another Client may only use 4 fields

I have an MVP-provided fnction I use to determine the number of workdays
taken for several phases of an order.  The code is below (as you can see, I
use a Table called Holidays to exclude holiday dates as well):
Public Function WorkingDays(StartDate As Date, EndDate As Date) As ...

I can't seem to figure this out even after trying answers in other threads.
I have a subform datasheet.
When I click on a cell in a particular column, I would like the background
color

When I use CopyObject to copy a form, the associated vb code does not get
copied with the form:
DoCmd.CopyObject , "myform2", acForm, "myform1"
The form looks fine after the copy but no code is present. Any suggestions

I am building a device tracking database for the international business of
our department using Access 2003.  The manager would like to keep track of
any change made to a field "Number of Devices" after the initial entry.  I
would like to know how can I color code it in a way ...

G'Day ppl,
I would like the following to happen using an AfterUpdate code. I have 3
fields in question that I need to extract specific info from and combine it
into 1 field, eg.

My work has a MSAccess application that works fine at work but needs some
adjustment - which I would like to do at home.  But when I run the
application at home I get an error msg 'Missing or broken reference to
DomObj.tlb' and simple VBA functions such as 'Mid()' no longer work. ...

Again, I'm getting this error simply from making a minor
change to the form. It works fine in all other forms.
Can this form get corrupted so often that I can't
make design changes to it? I've replaced the form

Hi, I am a novice to access and facing a problem while updated a text field.
I have three text boxes on a form; start and end times of an event and
another text box which shows the time difference in minutes. I am trying to
compute the time difference in minutes automatically ...