Search results

Patrick: In the CLASS NAME group footer I put =count([Class Name]) it should always give me a count of 1 since there will be one CLASS NAME per group, but, it brings back a count of the total number of records. The same is true when I count START TIMES in each CLASS NAME group. The count I get...

Record Count Not Working Patrick: I tried what you suggested but all it does is bring back a count of ALL the records. For simplicity's sake each record contains "Class Name", "Start Date", & "Student's Name". I want a count of number of times "Class Name" breaks and the number of times...

I have a report showing classes offered, dates classes held and students attending each class, ie., Class: Computer Basics 10 May - 25 May Joe Jones Mary Smith Etc 25 July - 15 Aug Paul Albert Marty Cruz etc Class: Word Processing 02 Jan - 26...

Thanks. I am doing so much by rote and never really understanding completely what Access is doing. Your explanation helps.

Thanks for your reply. I added an autofield and regenerated the unbound combo box and all works well. When I get a few spare moments I will try out your code on another similar table with hopes of better understanding how this all works. Again, thanks.

I have a table of Organizations. The primary key is the Organization Name. In a form I use an unbound combo box to look up the Organization Name. It works great unless there is an apostrophe in the organization name and then it gives me an error. Here is the code the Wizard generated...

Thanks. I also am working with our local Senior Center and amdeveloping a small tracking system for their computer class students. I am having the same problem here. They are running Win98 and Access 2000. I tried what you suggested regarding the calendar and that is working now. In a couple...

Thanks for the quick response. I won't be able to get to the clients PC until after the holidays. In the meantime, lets see if I understand this. I looked at my references and it shows the following as checked: -Visual Basic For Applications -MS Access 10.0 object library -MS DAO 2.5/3.5...

As a volunteer, I developed an application on my home PC using XP and Access 2000. I copied the application to CD and then loaded it on my clients PC (Office 2000). The application copied as read-only which I changed. I can not seem to get the applicaton to work. The first error message I get...

Thanks to both for reply. Works as advertised!:D

Hi Folks... I have been browsing this wonderful site for a couple of weeks and have gotten tons of helpful information. But now I am stuck. I have some knowledge of ACCESS but minimal VB smarts. I am self teaching myself as I (as a non-paid volunteer) build a membership data base application...