Search results

You could use Grouping in your report to show the detail based on whatever you consider a record and base the reports record source on your top 6 query.

What is it that you are updating on the subform? You might be able to use an Update Query.

Use Master/Child linking for the primary key/foreign key for all forms. If your not familiar, open the main form in design view, select the subform (just the control itself, don't select into the form) and in the properties under Data you will see Link Master Field and Link Child Field. Enter...

With PassThrough queries you need to pass exact data as the server does not understand references to forms etc. For the actual control names, surround them with ` (accent mark, not appostrophy, the character that is the upper left key on your keyboard). For the values, use apostrophe...

If your just doing it one time, you can copy and paste. If over and over, you can create a link to the spreadsheet and use an append query.

Your equation contains single quotes but should be double quotes: DateAdd("m",3,Date())

Password protect the DB.

If (no pun intended) you are only resolving one If ... Then statement you don't need the End If. End If is only needed if you have multiple steps to carry out, i.e, If IsNumeric(Me.Text18) The Me.Text145 = Me.Text18 Me.Another = Me.Text145 * 2 End If Otherwise your code looks good. If that...

Here is the filter form Custom3.

You can add the WHERE directly to your query: SELECT qry_2800_Package_Rollup.*, qry_5000_Selected_Product_Codes.* FROM qry_2800_Package_Rollup INNER JOIN qry_5000_Selected_Product_Codes ON qry_2800_Package_Rollup.PFC = qry_5000_Selected_Product_Codes.PFC_CODE WHERE...

I'm thinking that you place basically the same Where statement your using for the report directly as the Criteria for that column in your query. Have you worked with query Criteria in the past? If not, if you could post your query used as the record source for your report along with your...

Your welcome.

You should set the criteria of your query and export that to your spreadsheet. You don't need the report.

Place a command button on the form and in the On Click event add the code: Me.Payment = Me.Rent Me.PaymentDate = date()

If [forms]![Patients]![Text119] is an unbound textbox, use Format property and choose a number format.

Either Reactions or [forms]![Patients]![Text119] is not a number. Could it be that [forms]![Patients]![Text119] is null or contains other than a number? Have you tried using CDbl() instead of Val()?

Thanks Pat.

I think visually it would be great if the form showed 16 CUBE shaped unbound and locked(not for data entry) text box controls large enough to fit the name of the person reserving the space. It would help if the control names match the Space names in your Space table, i,e., Space1, Space2 like...

In the On Current event and the After Update for your date control (may not fire after using date picker, may need to move to another field first) you can test to determine if the cubical is taken and changed the color of the button accordingly: If determine is space is booked Then...

Yes, it works the same.