Search results

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...

Hi Colin Thanks for your reply. I am aware of the horrendous field names - but it's not my fault, I inherited them, and am working on amending them - but there are other systems involved so it's not trivial! So the code I now have is SELECT DISTINCT tbl_Orders.[Order #], Count(tbl_Orders.[Order...

Hi All I thought I knew how to use Count/Select distinct, but apparently not! I have this: SELECT DISTINCT Count([Order #]) AS [CountOfOrder #], Sum([qty]*[Item's Price]) AS [Value], OrderDate FROM tbl_orders GROUP BY OrderDate; The query runs, but the value shown in the 1st column...

Good point! Public Sub SearchInQueryDefs2(ParamArray arrSearch()) 'Search for all strings in the paramarray in all queries. 'Run from intermediate window. ' 'Example: SearchInQueryDefs2 "INT", "OUT", "DO" ' Dim qdf As QueryDef Dim qdfS As QueryDefs Dim blnFound As Boolean...

Sounds like you need a field in the "New Orders" table to record whether the record has been added to the "Orders" table: either a boolean field (say, blAdded), or perhaps a date/time field (say, dtAdded) if it would be useful to know when the record was added. Use an update query to populate...

Hi All I have been using the 'SearchInQueryDefs2' code from Guus2005 in the Code Repository, and it's excellent - thank you Guus2005 :) I was hoping to use it to help me amend some joins, because I'm replacing some text key fields with numeric key fields. I can use the 'SearchInQueryDefs2'...