I need to set up a form that will sort a report in different ways
Maybe use command buttons for each sort.
I am open and any Ideas
Thanks

How do you turn off that warning message that pops up everytime the database
is opened which says "Thses scripts could be harmful are you sure you want
to open this?" , or words to that effect.
Access 2003

I am pretty new and I would like to concatenate two strings in an Access
report with some text in between. Would it go: [Field1] & "Text" & [Field2]
in the control source for a text box? It does not seem to work and I was just
wondering if I was doing something wrong?

Guys,
Past few days I'm Struggling with Calculation of Total,  based on the Type of
Holder.
formula as follows

i'm opening up a recordset using the following code. it's an Aggregate
query. how do i call
the resultant value? The SQL code runs ok, i don't get any errors.
Dim TotalPaidIndem

I have a listbox with maybe 5 things in it.  The user will select from 1 to 5
of those things, and then click a button.
When the button is clicked, I want to go through every item in the listbox,
create a corresponding record in TableA for every selected item, and create a

I want to set all my number fields to have a default value of 0. Bredan
Reynolds was good enough to provide me with this code
Public Sub SetDefaultFieldValues( _
   ByVal FieldDataType As DAO.DataTypeEnum, _

Users are complaining that using page up / down keys doesn't change the
current record when they are done with data entry, as the fields they are
required to fill are in subforms in a tab control. Clicking anywhere on the
main form works, of course, but they don't want to have to ...

Hello there;
I have been working on a form that incorporates one of three search fields
as well as a to and From Date fields to display records within these search
parameters. However, I have been having a problem with getting the coding

I have a button (btnNew) with a label (lable01) next to it. I wrote a code
to bold the text in the label when mouse move over it.
Private Sub Command0_MouseDown(Button As Integer, Shift As Integer, X As
Single, Y As Single)

I have a database with a table called "loans". This table lists loans with
collateral insurance that is about to expire. The database also has two
queries. "Officers_With_Loans" creates a list of officers who have loans in
the "loans" table whose collateral insurance will expire ...

On a form B I have this code to close the current form, and reopen it with
the Edit_B_values_Click macro. The Click macro is run when a button on
form_frmA is clicked, but can be adressed by code.
DoCmd.Close

I tried converting a text box to a DTPicker but now I can't drag and drop to
any control in the form.
So I tried a test; I created a new form and put a text box in it. I did not
change any properties of either the form or the text box except size and

New to access.  Trying to have a parameter qry based on user selection from a
combo box, but the table referenced is a link table for a many-to-many
relationship.  I'm struggling to figure out what the row source should be for
the cbo.

I have been struggling to create a Form to be able to search the
employee database but unfortunately havn't been successful so far,
reason being I do not know coding. I believer this group is my last
resource and would really appreciate if someone could help me with