Can anyone tell me why this code is not working? It opens the report
fine but does not enforce the filters.
Private Sub btnCost_Click()
   DoCmd.OpenReport "rptCost", acViewPreview

I'd like the table on which my form uses to be sorted by a date field in
descending order whenever it becomes active.
In the form's 'Current' method I've tried this code but the compiler doesn't
like the last line:

Hi. There must be a simple error here but I just can't see it.
I have a table wih two columns, "Diagnosis" and "DiagnosisCode". The
PrimaryKey is the column "Diagnosis".
I'm trying to get the DiagnosisCode associated with a "Diagnosis" using Seek:

I have the API function that gets the Windows login; for every login ID I
have a password.
Can you please tell me what should be in the below code to open the form?/
what am I missing?

I am trying to open a report using the following WHERE Clause that will find
me records over 31 days old but less than 60 days old.
strWhere = "(ReferralDate  + 31 >= #" & Date - 60 & "#)"
DoCmd.OpenReport "CYF IH Cases Open", acViewPreview, , strWhere

I have a form with a command button to open a popup form(modal) the popup
form has a bound text box and label on it. When the user enters text or no
text and hits enter I need the popup form to close and return to code in the
command button.

I'm trying to populate a field with the higher value of two other
fields and am not sure how.
field 1 = [buy rate x 15%]
field 2 = [buy rate + 25]

Does access record the date a record was first created (not looking for when
it  was modified)?  If so, whats the function name, and required arguments?
Or macro method, if there is one. i'm not picky.

Hi
I have a table that containts list of events and prices etc.
I have a form based on this table. However, what i want to do is select the
name of the event from a combo box and then the rest of the fields to

Access03/WinXP
A form allows a sales rep to select a Trade Name and assign it to a specific
company.  When a Trade Name needs to be added to the underlying source table,
an admin person has gone into the database window and opened the table to

I have a continuous form which allows additions and would like the new record
input area to be at the top of the form instead of the bottom.  How can this
be done?

I need to make a form with a button that allows the user to relink tables to
a different Access database on the fly.
can someone help?
thanks

I have some forms with 60 objects which I really want to re-design with Tabs.
Everyone knows that if you create a Tab in your form and copy & paste the
controls then you lose the Event links. They are there in the code module.
You just need to re-select them in the pasted control ...

I read the other posts that are similar to this but can't really seem to find
one that works for me.  I have a continuous subform that has a field called
notes.  This field is a temporary field stored in the main table.  Someone
will type a temporary note into the field then push a ...

Good day,
I'm trying to modify this vba code;
ActiveDocument.InlineShapes.AddPicture
"C:\AAOForms\signatures\amko.jpg",