Recent content by MandyHead1

this is a very cool tool, I have created it and I think it will be very handy.

Oh my goodness, it's actually working now! I didn't take into consideration the data inserted from Months table in the INSERT bit so yes there were 8. I realise that I'm not familiar enough with VBA for this to be a realistic solution so I will now go and create an Append Query as suggest by...

What about a Pivot Table?

Thanks all, you've given me some great advice. I can't believe I have more select fields than insert (or vice versa) - I counted them so mamy times!! Anywho, it's friday night, I don't want to look at the computer now, Ill check it out in morning.

Thanks so much all of you. I have amended my code as suggested by Ridders but it is still giving the same error. This is what it looks like now. Option Compare Database Private Sub btnAddDates_Click() Dim strSQL As String Debug.Print strSQL 'Validate fields are not Null If...

So I have been working on this all afternoon and now it's time to go home. I have mainly worked on CJ_London suggestions, but have read the other ones and will play with them tomorrow. I am starting to wonder though, if am on the right track for getting my button to create multiple date...

Hi there, I am trying to create a forecasting database and I would like a button on my form (frmProjects) to Automatically fill in several records in a table (tblProjForecast) with dates in a date range specified in the form. The form (based on table 'tbl Projects') has the following fields...

Hi there, I'm MandyHead1. Actually that's not my real name but I think it's a good one, don't you? I've been using Access for ages, and I think I'm pretty good, but here I am trying to build a forecasting database for work and I realise I'm not that good at all! I have never dived into the...