Recent content by Les Isaacs

Hi - I need the link to be dynamic, so that the data in the accdb updates as the data in the Google sheet is amended.

Hi all - does anyone know how to use a Google sheet as a data source for a local accdb?

Hi All In code I have a recordset rsOrders which includes the field rsOrders!orderID. I need to generate a report for each value of rsOrders!orderID, and then save that report as a PDF with date and the rsOrders!orderID value appended to the filename. So if rsOrders has 15 records I end up with...

Hi Minty I did come across that article from Allen Browne, and tried to implement his suggestions, but still couldn't get it to work! I have to leave the office now, and won't be back until next week - but will check back here then for any further help! Thanks all. Les

Hi Guys Thanks for your replies, but: Minty - the date is acquired via an inputbox. I agree that this doesn't allow for a datepicker, but for the purpose I have a form would not be preferable; Ranman256 - I did wonder whether I'd need to create a function to convert the date, but the problem...

Hi All What do I do with this Dim startdate As Date startdate = InputBox("Please enter the start date:") DoCmd.OpenReport "rpt_OrdersAnalysis5", acViewPreview, , "[InvoiceDate] > #" & startdate & "#"to get access to accept that startdate has been entered in UK format? I've checked that...

Hi No, it's in the right place I think: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.Line50.Height = Me.Text65.Height End Sub

I had tried verticallinecontrolname.height=textboxcontro lname.height which didn't work - and sadly neither does me.verticallinecontrolname.height=me.textboxcontro lname.height I'm sure it must be something like this, but can't quite get it!

Hi All I have a report with a textbox in the detail section that has cangrow = true. The detail section also has two vertical lines, which I need to lengthen as necessary to match the textbox height. I've tried searching for this online and in this forum, but can't seem to find the method -...

Morning Colin (ridders?) Thanks ever so much for this - it obviously works, and - more importantly - I can see how! Glad I wasn't coming across as rude, and I didn't think you were stroppy: so we all happy! Thanks again Les

Okey dokey, here it is.

Plog I'm not sure how I could show you an example of the output I want from the query - unless I create a table that looks like my desired query results? But I though I had explained (sorry for using that word again!) exactly what I wanted by saying value of [CountOfOrderNo] in the first record...

OK, here's the sample data in [tbl_orders]. The expected results should look like the output from qry_OrdersAnalysis3 - in that the query should return 7 rows - BUT the value of [CountOfOrderNo] in the first record (where [packingDate = 05/04/2017) should be 107 (as there are 107 unique values...

No, I don't want one record per order number for each date (don't think I said this before?). What I want is "for each OrderDate ..... a count of each unique [order #] value, " (which I did say in my original post!). I've confused myself a bit with this though, so not surprising if I've confused...

Hi again Colin I don't know if it's me, but I'm now getting a separate record returned by the query for each unique value of [order #]. The code I now have is: SELECT tbl_Orders.[Order #], Count(tbl_Orders.[Order #]) AS TotalOrders, Sum(tbl_Orders.[qty]*tbl_Orders.[Item's Price]) AS...