Hello. I am using Access 2003 and I when I am adding a new record on a form I
need a field to autopopulate with a default value based upon another field.
"Position Stmnt Due D" needs to be autopopulated based upon what I enter in
"State Hearing Date" minus 5 days.

This code works.
Private Sub AllIssuesRole_Click()
If Me!AllIssuesRole = True Then
DoCmd.RunSQL "INSERT INTO dbo_UsersRoles (Role,UserName) _

I have form and subform both working fine,
i just discovered that when i add a new item in the header, the detail
"subform" populate the values automatically, but when i retrieve the record
in order to change the invoice number which the key between both forms , it

I have the following code behind a simple form:
----
Option Compare Database
Private Sub B_Clear_Click()

I read some articles about the Access 2007; it said the Access 2007 will
provide the ability that the pictures can be displayed in the Continuous
Forms based on the record. However, After I added pictures in the Continuous
Form, and view at Form View, the pictures did not show as ...

I have a main form with a listbox on it that displays the date of entries.  
Also on the mainform is a subform that is continuous that the entries are
made.  There will be at least one entry per day.  The listbox is to select
the date and have the subform go to that date's entry.  ...

I have a following problem:
I have a form with a dropdown menu. The user of the database is able to
choose the company they want to review a report for. I have bound the form
into a table which stores the selected company ID temporarily. A report is

I have a combo box that selects a type of document, and then I have the
following select case code to determine how the doucment number input mask is
shown:
Select Case Me.[Document Type].Value

I am having a problem with one of my databases.  I posted previously that
when i was using code to sendobject from a query in excel format i was
receiving the error back from my info security :virus detected
(CVE-2006-1309) Action: quarantine.  After some thinking some of the ...

I have a Customer Record Form called "FRM_FireytechCustomers"
I have a New Ticket Data Entry Form called "DataEntry-Fireytech"
I currently have the following code which is the onclick event of a
button called "FireytechTicket" which takes us to the Data Entry Form

Help...
I have a Microsoft Access DB that somehow has deleted the menus.  I am
unable to restore the menus to display the View option.  As a result,
I can't modify the code, etc.  Right-clicking on the toolbar doesn't

In a database I inherited, there is separate Edit form and Add form for
single record adds or edits.  Since the forms are similar, I assume the
better way to do this would be with a single form and use the DataMode in the
OpenForm Method.

Hi - In a continuous “summary” form, data on student misbehavior
incidents are currently summarized in the following columns:
StudentName     ContactInfo     IncidentDetails     Staff
IncidentDateTime     and then in a DCount field that has this control

I was wondering if it possible to sort a datasheet in a subform based on
dates in a column.  For example, I have a subform that lists milestones
related to a task. On occasion a milestone is added that is dated before
some of the other milestones already associated with the task. ...

I have a query name [qryProgressRptResearcherFinal].  The query has the
following fields: [Item#],[Fund Number],[Account Number],[Date Received],
[Researcher],[Email].  I want to push a bottom and if there is a record for a
researchers I want the information to email to the ...