Recent content by piano_playr

My mistake. The theoretical upper limit is 2 GB. Here is the cite. https://support.microsoft.com/en-us/office/access-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c#:~:text=2%20gigabytes%2C%20minus%20the%20space,be%20as%20large%20as%202GB. Really, my intention was to contrast the...

@Pat Hartman, you are hard to please. I compliment you and you dump on me. And you're meant to be a friendly moderator. :) I know all about Jet and ACE. They're built into the Access product. Whatever. Been that way for a long time. I was not comparing the two products. Reread my post...

@Pat Hartman is correct in pointing out the benefits of Access development. Having the ability to bind a dataset to forms and reports is a miracle. SQL Server is not a threat to Access. It cannot do what Access does. On the other hand, Access cannot do what SQL Server does. SQL Server is...

I agree with Pat's preference to use null as an indicator that the student had an excused absence on exam day. One can calculate an average of integer values where one of the values in the series is null. As Pat said, that's a better option than giving the person a zero. The zero is going to...

May I propose the solution below? I am not going to attempt to talk you out of this. I assume you know what you're doing and this is what you want to do. Of course, this solution has no warranty of fitness for a particular purpose, an implied warranty of merchantability for products, or an...

I use this procedure to trim "dbo_" from linked SQL Server tables when relinking. Access consists of collections and objects. It helps to review the Access object model. There is a collection called "tabledefs". Looping through it will let you rename tables using the .name property. Public...

It's an example. If the example is expanded to many more records with many more columns, the benefits become clearer. :-) There are so many more development features in SQL Server such as common table expressions, temporary tables, functions, triggers, table variables ... the list goes on...

I am a SQL Server aficionado. I love it. One of the neglected features of using Access as a front end and connecting to a SQL Server database on the back end is the programming available in SQL Server. One can execute SQL Server stored procedures on the server from Access. Most Access...

Matthew, I would like to help you with your issue. I took a look at the sample Access file you posted today. I would like to confirm a few things. I believe we are working with the following objects: Form: Calendar List_F_C Record Source: Calendar_Strata_1Q I need more information to...

Sorry, Gasman for misunderstanding your post. I can relate to you my experience trying to reproduce the OP's issue. When I used his code, which included Me.FilterOff, Me.Filter = <criteria>, and Me.FilterOn, I got parameter prompts all over the place. None of the prompts were appropriate. It...

I agree with Gasman. You're trying to do too much with the filter properties of the form. You don't need to set any property other than Me.Filter. If you mess around with Me.FilterOn, Me.FilterOff, Me.FilterOnLoad, Me.Requery, it will only lead to trouble. Follow the example I posted...

I think I got it to work for you. You are trying to set a filter on your form. The SQL behind the form is fine. You only need to properly set the "Filter" or "where clause". Your event should look something like the code below. I copied your code and commented out what is unnecessary. It...

I like to reset the form's recordset when doing what you're suggesting. This doesn't answer your specific question. Sorry. This is a suggestion to consider as an alternative. I think your form looks something like the below image. There is a button and a text box to hold search data; the...

I’m having a little difficulty visualizing how you have designed this form. You mentioned it is a continuous form. It would be very helpful to look at a screenshot of the form. Would you please forward a screenshot?

Anything you ever did with the organ is way beyond anything I've ever done with a piano. You see, I don't know how to play the piano. The reason for the nickname is I love Harry Truman's famous quote, “My choice early in life was either to be a piano player in a whorehouse or a politician...