Search results

small correction - I was suggesting the format property which will hide the surplus characters. This would be OK if you are not going to add (such as adding sales values) but you don't add averages - or if you do, the result would be meaningless:) Using the format function, converts the value...

you might find reseting oDb on each interation is a factor in your performance Public Function oDB() As DAO.Database If pCurrentDb Is Nothing Then Set pCurrentDb = CurrentDb End If Set oDB = pCurrentDb End Function Not tested, and perhaps you have already tried it but you...

Use the format property?

Agree that particular value is not indexed as it is effectively a criteria - the field it would be linked to would be (or should be) indexed I have used this method for many years - typically only returning a few hundred records, performance has not been an issue since records are returned as...

The counter is just a range of numbers - you can reset the range as required

Perhaps this old thread will help https://www.access-programmers.co.uk/forums/threads/getdependencyinfo-method.114880/

agree with the comments about locating front ends on the local machine - not only are you bringing across data but also all the forms and other access 'stuff' this suggests to me that your forms are bound to tables for subsequent in-form filtering - you should be using queries with criteria to...

I don’t have a problem filtering but I alias the from part of of the sql as I have found the odd issue by not aliasing try sql = "SELECT * " sql = sql & "FROM (SELECT [Field1] AS OrderNo, " sql = sql & "[Field2] AS DrawingNo, " sql = sql & "[Field3] AS ManufacturingNumber " sql =sql & "FROM...

choose(num"1st") The previous post was copy paste between code tags, this example is typing between code tags. but once the code window is closed, further edits can only be achieved by copying the code only into a new code window Edit for missing comma and new choice choose(num,"1st","2nd")...

choose(num,”1st”,”2nd”,”3rd”,”4th”…..) This is posted in code tags - still retains the smart quotes. perhaps should include a warning

That’s the problem when responding via smart phone

Or the choose function choose(num,”1st”,”2nd”,”3rd”,”4th”…..)

@jdraw , @The_Doc_Man - see post #25 for the solution for 1,234

you don't make it easy for us to help - provide the sql to your 3 queries for context here is an example Q1: SELECT * FROM tableA Q2: SELECT * FROM Q1 Q3: SELECT * FROM Q2 alternative for Q3 with aliased queries SELECT * FROM (SELECT * FROM (SELECT * FROM tableA) AS Q1) AS Q2

You can alias the first two queries into the third query Not sure why you feel the need to ‘run’ the queries in order - sql does that automatically

It wasn’t actually 😊 table is called usysCounter and the query usysCount which you have renamed as Counter (same as the field name) and the second sql, you are using cDate in the criteria when it is not necessary. However I have modified my explanation to be clear about what is called...

The thing about image controls is they don’t have got focus or lost focus events - so the focus remains where it was. If that was a text box it may be certain things can’t be done whilst it has the focus. on the other hand a click event on an image control can reference the text box text...

Make the text box taller but will be the same for all rows if this is a continuous form

If you can’t provide the data per post 35, I can’t help. Good luck with your project but I’m going to leave it to others to see if they understand what you actually require since so far as I can see the result in post 34 meets your requirement

showing what you currently get as a result might be useful down the line, but does not help to resolve your issue since I can't see the source data and still not clear what you actually want to see as a result. If you can't provide what I've asked for, not sure I can provide any more help.