Recent content by Solipcyst

No, it doesn't. I also tried adding a field to OrderBy.

Right you are, sir. It didn't work until after I re-opened the database for me, though. Strange. Anyway, it doesn't matter anymore because I've come up with a fix for the problem on my end. I added the following to the load event of the form: Me.OrderBy = "[AnyField]" Me.OrderByOn = True...

Ok, here is a sample with the problem. Again, I suspect I'm missing something very rudimentary. I admit that I'm very new to all this, and I don't normally even bother with bound controls. Attached is a zipped accdb. Please open "frmOpenMeFirst", and thanks for looking in to this for me! As...

Ok, I will try and duplicate the problem in a sample DB and upload it here in a few (if I'm allowed to upload files). Thanks for all your help thus far, by the way.

Not in code. In the form properties.

Ok, I appear to be missing something extremely fundamental. I've noticed that if I click the sort Ascending or sort Descending button in the filter tab of the ribbon (I suppose I should have mentioned this is Access 2007), suddenly all the records are populated. Does this provide any clues as...

Actually, I'm back to square one now, it seems. This is so confusing.... I was trying to set up the OpenForm command with the where clause and now form doesn't seem to want to load any records from the query even without a where clause. Form.RecordSource = "SELECT field1, field2, field3 FROM...

Ok, that last reply gave me an idea, and I seem to have gotten the filter to work properly. The RecordSource of the form is now hard-coded as the entire table without any where clause. I have AllowFilters=Yes but FilterOnLoad=No. I then set the Filter for the form during the load event as...

Yes, I've tried the where condition with OpenForm. No good. For trying the Filter, I've set the form to FilterOnLoad=Yes and AllowFilters=Yes. In the Load event of the form, I then set Me.Filter = "[Field]='Value'" (single quotes used because this particular field is a string). More...

Yes, I have. That doesn't seem to work either. I've also tried hard-coding the SQL statement without a where clause to the form and passing the where clause in the DoCmd.OpenForm call. Absolutely confounded. EDIT: Furthermore, even if I was able to get this to work using a filter, I admit...

Hello, and thanks for your reply. Yes, the Timer is unnecessary. I only used it to illustrate a point that I don't have any code anywhere that could potentially be altering the RecordSource of the Form after it has opened at any point. I'l try to be more concise with my problem. I have a SQL...

The RecordSource is a simple "SELECT field1, field2, field3 FROM table WHERE field1=value". I am not passing a WHERE clause in my DoCmd.OpenForm statement. The where clause is set programmatically in the Open even of the form (I make sure to Requery) with the value of the where clause being...

Thank you for the reply. I was expecting this suggestion, but I forgot to mention that I'm taking over development of this app from someone else who did not use late binding and I really don't have the time to go through all of this poorly documented code to correct it.

Hello, I've created a dummy form that remains hidden while my front end app is open. I am attempting to execute a function during the Close event of this form which, it is my understanding, should take place when a user closes the app. However, it doesn't seem to work that way in all cases...