Recent content by arickards

Something like this: SELECT date, Sum(amount) AS TotalAmount FROM tablename GROUP BY date HTH

Make sure the field types for the joined fields are the same.

It's possible their local PC system date time format is causing this. Check the Control Panel and Regional settings. HTH

JJT, I think your best alternative would be my suggestion on your original post of 9-17. If your not sure how I can give more detail.

If you want to execute a series of queries use a macro. That should work if I'm understanding you correctly.

Go into the properties of your form and change 'Data Entry' Yes. Create a macro to run the maximize command and assign it to the 'on open' event of form. HTH

Try doing this: Copy the structure of current table into a new table and make the case number the primary key. Append the data from old to new. This will keep first record and drop all dups. [This message has been edited by arickards (edited 09-20-2001).]

Hi Tom, Got your email. Try this on the on open event of the form: 'Function Macro1() On Error GoTo Macro1_Err DoCmd.RunCommand acCmdRecordsGoToNew Macro1_Exit: Exit Function Macro1_Err: MsgBox Error$ Resume Macro1_Exit End Function HTH, ASH~

In the form properties make the form data entry.

Could I get a copy too in A2K? Thanks.

Insert the subforms into your main form. In the properties of the subform use the link master and link child property and type in the field name you want to link by. HTH

I have a large form and currerntly with all the subforms and other info it is slow. What I would like to do is have buttons that will only load and dislay the related info of the current form. TIA ASH~

Sure is. Use the open query in the first row. In the second use the msgbox. HTH ASH~

Try this. Create a query and add both tables select the fields etc.. Create an inner join, assuming you have a field in both tables that link the records. Then on the control source of the form use the query. HTH ASH~

Try this. Create a query and add both tables select the fields etc.. Create an inner join, assuming you have a field in both tables that link the records. Then on the control source of the form use the query. HTH ASH~