Recent content by dhookom

This question is cross posted in Access World Forums and the suggestions there are much the same as here The OP has already been informed about the issues we have with cross posting so no need to comment about it. The threads in the other forum are up to 79 posts of advice to use VBA.

Create a small user-defined function that accepts the field values as arguments and returns the appropriate value. You can encapsulate this logic to use anywhere in your application and include comments in the code. It’s easier to debug than a complex expression. When the 25,727 changes, just...

I would change the code to the following which will possibly show no value for dSelectDate Dim rs As DAO.Recordset Dim sql As String Dim numberOfBD As Integer Dim sList As String sql = "Select * from qryBirthdayList Where Birthday = " & Format(dSelectDate, "dd") & " and Birthmonth = " &...

Great!

I would next check to see if an antivirus software is running.

What else did you try?

I’m just throwing stuff at the wall to see if anything sticks. Did you check out the bugs page?

Is there any code running when the application opens? Do you have a default printer identified in Windows? Some developers recommend keeping a table open in the back-end while the application is running. You might want to check the Access Forever page which has the most up-to-date list of...

I don’t do anything else until the compile errors are fixed. I hope your application is split so you can make updates to a copy of the front end file. “Find” error would occur if you are attempting this against a linked table. There also could be an issue with the references and DAO vs ADO. Find...

Does your code compile?

No sample data? No desired output? That's not much to go on. Typically I would create a calculated column that sequentially numbers records within a VERSION and then select all records with the sequence number less than or equal to X.

You would need to provide some unique value to determine which X. Are you looking for random records? If so, you would need to add a random calculation into your query.

I seem to recall a bug but suggest you check out this great site for every Access.

Try set the Windows default printer to Microsoft Print To PDF to see if you get the same delay.

Sometimes you can use a DCount() in your code before opening the recordset. Otherwise I would try the MoveFirst after the RecordCount.