Hi Graham

I appreciate your help on this matter. I copied the code in and it says Run time error 3061, too few parameters

At this point, rather than waste to much more of your time, I would like to send you copy of the datbase if you have a little time to look at it. At the minute ts only a model with some test data

What email should I send it to

Bruce

Bruce,

gseach
@
REMOVE THIS LINE
pacificdb
com
au

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia


"Bruce" <(E-Mail Removed)> wrote in message
news:9C408FB4-FAEF-41EE-A480-(E-Mail Removed)...
> Hi Graham,
>
> I appreciate your help on this matter. I copied the code in and it says
Run time error 3061, too few parameters.
>
> At this point, rather than waste to much more of your time, I would like
to send you copy of the datbase if you have a little time to look at it. At
the minute ts only a model with some test data.
>
> What email should I send it to?
>
> Bruce

Bruce,

OK, both [qry_Append_LTD] and [frm_PAF_Maintenence] are corrupt!

I'd recommend re-creating both from scratch. To demonstrate the fact that
they are corrupt, follow this procedure:

1. Open [qry_Append_LTD] in design view, and remove the "Is Not Null"
criteria for LTD_Temp.

2. From the Query menu, select [Select Query].

3. Open [frm_PAF_Maintenence] in design view.

4. Select [txt_StartDate], and remove "Short Date" from its Format
property.

5. Select [txt_EndDate], and remove "Short Date" from its Format property.
Also remove the ValidationRule and ValidationText.

6. Open [frm_PAF_Maintenence] in normal view (without saving it).

7. Set the following values:

Deal = LTD
Business = RT
Category = Bun
Customer = CustomerA
PAF ID = <anything you like>
Start Date = "aaa"
End Date = "bbb"

8. Run [qry_Append_LTD]. You should see a start date and end date of "aaa"
and "bbb", respectively.

9. Change [txt_StartDate] = 1/1/2000, and change [txt_EndDate] = 2/1/2000.

10. Re-run [qry_Append_LTD]. You should see a start date and end date of
1/1/2000 and 2/1/2000, respectively.

10. Open [frm_PAF_Maintenence] in design view, and re-instate "Short Date"
and the validation stuff.

11. Re-run [qry_Append_LTD].

12. Save the form and the query, then when you re-open them both, you'll see
the problem has returned.


This clearly demonstrates that the problem can be resolved, but not using
the existing form/query.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyT...764559036.html


"Graham R Seach" <gseach@NOSPAM_pacificdb.com.au> wrote in message
news:(E-Mail Removed)...
> Bruce,
>
> gseach
> @
> REMOVE THIS LINE
> pacificdb
> com
> au
>
> Graham R Seach
> Microsoft Access MCP, MVP
> Sydney, Australia
>
>
> "Bruce" <(E-Mail Removed)> wrote in message
> news:9C408FB4-FAEF-41EE-A480-(E-Mail Removed)...
> > Hi Graham,
> >
> > I appreciate your help on this matter. I copied the code in and it says
> Run time error 3061, too few parameters.
> >
> > At this point, rather than waste to much more of your time, I would like
> to send you copy of the datbase if you have a little time to look at it.
At
> the minute ts only a model with some test data.
> >
> > What email should I send it to?
> >
> > Bruce
>
>