Search results for query: *

You never said why you think the expression didn’t seem to work or provide examples. Most of us recommend three separate fields for City, State, and Zip. Maybe you have no control over this.

I won't begin to try understand your queries but can suggest you make sure you have the significant fields indexed.

I would first check if a printer has been designated as the default in Windows and that printer is on line. Next I would try another printer such as the MS print to PDF. Then try temporarily disabling your antivirus software.

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.

Can I ask the purpose of this post? Are you asking for assistance or providing something useful?

I rarely delete records but if I did, I wouldn’t leave records with only the primary key. That makes no sense to me.