Search results

Hi - did you manage to get rid of the wider title bar? If so how? I have seen the solution online as below but I don't understand where you find the 'Coming Soon' section and how you turn it off? Thanks...

Yes, I had also found this but do not really understand what they are referring too or where you find the coming soon section? They refer to a megaphone but the only one I can find is here and that doesn't give you any options to turn anything off? Any thoughts on this? As you started we are...

Hi, Does anyone else have the issue where the Access application title bar at the top of the screen has changed width? A number of forms in my DB were sized exactly to an HD screen running 100% font sizes and now because the application title bar has increased in width by 4mm I am losing 4mm of...

Yer that is what I was trying to do, I presume you mean just have one SQL string and then add the additional criteria? But I couldn’t get my head round getting that to work….?

Hi yes I have, unfortunately that didn't work either. I have found a solution of sorts which is to create two SQL strings as below and perform the IF statement out of the SQL string. This works but obviously slightly more code..... This is the working code: 'Calculate and populate the earliest...

Yep, the dates definitely work as written, I know what you mean re # in query criteria

Hi, no the date part of the string works fine, it only errors when I add the IIF statement back into the WHERE clause

Hi, I have the following working SQL which I need to convert to VBA which I have done. When I run my VBA I get a syntax error which through a process of elimination relates to the embedded IIF statement. Can anyone see where I have gone wrong with this? SELECT Min(tblVisits.VisitDate) AS...

Yer, I am just messing with the data at the mo but will store in tables once I've got it all sorted, thanks

OK thanks. That's a real shame as its very limiting. As you can see from the screenshot example below I need to present a meaningful list of quotes to the users so they can quickly and easily see all the quotes on the system, filter as necessary and then tick the check boxes on the end of all...

Thanks for this - Yes they are all in but still not updateable

Hi, I have a fairly basic query based on a single main table 'Quotations'. The query has a join to a subquery which contains 2 further subqueries which are 'Totals' queries which enable the sum cost of all products in one and labour hours in another which are then combined to give the 'Quote...

Hi All, I'm either missing something obvious or just have total brain block! I have a series of complex queries which collate a load of data together into a single query which is then shown on the report as per below. In the footer of the report I would like to perform some simple calculations...

OK, so I have a cmd button that runs a report which uses the criteria I want as above. I have added the following code onto the cmd button and adjusted the criteria as below but still no luck, any ideas? Private Sub Command284_Click() DoCmd.RunCommand acCmdRefresh Dim strFormName As String...

Hi, Does anyone know if you can use the IsLoaded function in a query criteria? I have tried: IIf(IsLoaded([Forms]![Purchase Orders]),[Forms]![Purchase Orders]![OrderID],[Forms]![Purchase Orders NEW]![OrderID]) But I keep getting an error......!?

Emmm, sorry still struggling with this as follows: foldername = "F:\SFA 2021\Running projects\SSE Contracting Ltd\J32944 Centenary House Crawley (WSCC)\" foldernamenew = "F:\SFA 2021\Running projects\SSE Contracting Ltd\J32944 Centenary House Crawley (WSCCXX)\" The above are my two folder...

Thankyou. I will sleep easy after all! Appreciated