Replies

While the database is open… Select the Tools menu and go to Database Utilities -> Compact Database… Try that…

While the database is open… Select the Tools menu and go to Database Utilities -> Compact Database… Try that…

Did you compact the database after deleting everything that wasn’t needed? …Delete most of the records in the tables involved??

Did you compact the database after deleting everything that wasn’t needed? …Delete most of the records in the tables involved??

Noooo, I didn’t mean start the whole form or database over!
I meant this particular procedure… The command button code… That’s all…

Okay… but I’ll probably have more questions… Hang in there…

Noooo, I didn’t mean start the whole form or database over!
I meant this particular procedure… The command button code… That’s all…

Okay… but I’ll probably have more questions… Hang in there…

Well that solves the first mystery… You’re getting errors because I told you to put single quotes around “Project Classification” and “Y1Sum”… If these are field names then you need to put square brackets around them… The report’s recordsource is looking for those two Values in a field called SortBy…

Let me look through this and see if I can help… Can I have the names of the recordsources for both reports?

Well that solves the first mystery… You’re getting errors because I told you to put single quotes around “Project Classification” and “Y1Sum”… If these are field names then you need to put square brackets around them… The report’s recordsource is looking for those two Values in a field called SortBy…

Let me look through this and see if I can help… Can I have the names of the recordsources for both reports?

I keep looking at the code you have there and it’s really making no sense to me… Why are you doing a Do While Loop through it?… and you’re not incrementing intCount anywhere that I can see… Aren’t you going into an endless loop there?? …

Could you post a small sample of the database?… I think maybe we should start from scratch… …This should not be so difficult…
What do you want to do… in every day terms… ?

I keep looking at the code you have there and it’s really making no sense to me… Why are you doing a Do While Loop through it?… and you’re not incrementing intCount anywhere that I can see… Aren’t you going into an endless loop there?? …

Could you post a small sample of the database?… I think maybe we should start from scratch… …This should not be so difficult…
What do you want to do… in every day terms… ?

Okay… Let’s try get this working…

To relieve my confusion, I need you to confirm a bit of information before I start writing this code… Me.Criteria and Me.grpSortBy… Criteria and grpSortBy are the names of controls on the form?? or?? … Could you possibly give me a few sample records from the data so that I can see what the field names are and the kind of data?

Okay… Let’s try get this working…

To relieve my confusion, I need you to confirm a bit of information before I start writing this code… Me.Criteria and Me.grpSortBy… Criteria and grpSortBy are the names of controls on the form?? or?? … Could you possibly give me a few sample records from the data so that I can see what the field names are and the kind of data?

I’m a little confused, but I believe that your problem is that you need single quotes around the string values for the sortby…

strWhereS = “[SortBy] = ‘Y1Sum'”
strWhereS = “[SortBy] = ‘Project Classification'”

HTH

I’m a little confused, but I believe that your problem is that you need single quotes around the string values for the sortby…

strWhereS = “[SortBy] = ‘Y1Sum'”
strWhereS = “[SortBy] = ‘Project Classification'”

HTH

Hi Gene…

I don’t think Wendell’s around at the moment, so I’ll jump in…
You don’t “create” that capability… It just is… It’s part of Access itself… Put your cursor on almost any field in any table of the database and hit Shift-F2… It’ll Zoom…