Search results

...And by I .. I mean.. "i" Thanks again CJ! Legend!

Getting there! I sorted out the 31/12/1899 by adding the following to the SQL Statement... and formatted the date correct to UK using ... ... HowMany," & Format(DateAdd(Interval, i - 1, StartDate), "\#mm\/dd\/yyyy\#") & "... Yes, and I admit defeat... it was "I" as I wanted to add One... not...

Hi CJ. Thanks for you reply (And Patience)!! Ran into a problem where I run it, and I get all the number of occurrences, but... All dates are "31/12/1899". I also noticed in the Immediate Window that (in this instance) Interval "M", is Empty?) Here's the code... Dim strSQL As String Dim db...

Apologies for the lateness in replying. I had to make a small amendment to the structure of this. The main table [tblBillInfo] holds the details of the Regular Payments, and I've created another table [tblBillSeries] to hold each record according to the number of payments etc, and will use the...

Thanks guys. Appreciated. This will give me a bit to work on. Will let you know the outcome.

Hi everyone. Is it possible to copy a record 'n' number of times, incrementing the date by either days, months, weeks etc? I have a regular payments table that will need to be edited at some point should either dates, or amounts change, but... regardless of the size of the table, it's not a...

Here's what I managed, and it's working (at this stage of learning, I have no idea how):confused: Me.TransDate.DefaultValue = Format(args(1), "\#mm\/dd\/yyyy#\") Many thanks for you help vb. It really is appreciated.

Not far off tbh.:cool: I've been having a mooch round for correctly formatting it after it's been pulled by the openargs. I'll let you know how I get on. Thanks again.:)

one thing... Do I need to do something with the date format? From the tables to the forms, everything is formatted to Short Date, but this happened.... I need a beer! 30/12/1899

Ah... the simplest things... I will get this one day... - hopefully!! Thanks vb

Hi all. I know this has been covered many many times before, but... I can't seem to find the answer I'm looking for in my particular situation. Form... and Popup form. So I want to pass some data from a Main Form to a continuous popup form, where I am ADDING data. the openargs from the main...

Sometimes, its the most obvious things that's right in front of you. Thank you.:)

Hi Everyone. I've been using Allen Browns method http://allenbrowne.com/ser-57.html to copy form and sub form data, and it works perfectly after some adaptation. It changes dates to today from whatever the date 'was'.. perfect.... however, as I'm still learning SQL, is there a way, to make the...

Hi all. Is it possible to have the control tip show related records from another table? I've been looking around the internet, and I've seen many examples for showing concatenated fields on current record, but had no luck with what I'm trying to do. For example. I have a continuous form...

Sorted. In the end, I did use UNION ALL, but modified the aggregate in the nested query as thus... SELECT Q1.Category, Q1.SubCategory, Sum(Q1.Credit) AS SumOfCredit, Sum(Q1.Debit) AS SumofDebit FROM (SELECT TransDate, Category, SubCategory, Credit, Debit FROM TblTopLines UNION ALL SELECT...

Sadly not. Think I jumped the gun a little bit there. I'm working on it still :) I will post my resolution when I have it. I shall not be beaten!!

here's what I'm getting.. So perhaps take out the totals query, and do this separately? I'll do some investigating...

I didn't know that but do now, but the duplicate is still there :( I did say SQL wasn't my strong point:rolleyes:

Hello All. I once again seek your knowledge... This time with SQL (Honestly, not one of my strong points, but getting there) I have two tables, joined together with a Union query, and what I'd like out of it is a Sum of Categories & Sub Categories, based on all days this year. When run on...

I'd go... but I'm no Access expert:( And working the 30th