Search results

Hi, This question pertains to Access 2010, though I'm familiar with 2007 as well. I'm trying to set up validation rules in one of my forms so that the combination of two fields is not duplicated. More specifically, I want to avoid the following scenario: Student Program Subject EntryDate...

Thank you for your reply! I had been using the Where Method to filter the ID. I tried setting up the ID and the inactive criteria but I needed it to toggle between both the ID and inactive criteria and just the ID. I came close a few times, but was never able to get exactly what I wanted. I...

Hi, I am using Access 2010 for this particular project, though I am familiar with Access 2007. In my database I have a form that acts like a subform but is not embedded in my main form. I have a command button on my main form that opens the quasi-subform, which I'll call qs from now on, to...

Sorry this is such a late reply. Things have been crazy, but I just wanted to make sure I said thank you for all the help you've given me. I have a much clearer understanding about how to proceed, and the knowledge will serve me well for future projects. Thank you for what you do on this forum!

Thank you for the links! I'm kind of the self-appointed tech person/database builder in my department, and I want to do it right and learn as much as I can. You're so kind to help me out the way you have. I'm glad you think my normalization process is coming along. I just remembered that my...

I've taken a class in SQL, though I'm by no means a wizard. Here is my attempt at renormalizing according what you've taught me. Am I at least on the right track? tblCompany CompanyID (autonumber, primary key) Companyname Companyaddress Companycity Companystate Companyzip tblPeople PeopleID...

In my opinion Normalizing the design of a database is an art. Like any art you only get better with lots and lots of practice. I wish I knew where to start. I practice and get it wrong, then end up not sure where to go. It seems like unless the normalization/table structure is right nothing...

HiTechCoach, Thank you for this honest critique. I have such a problem with normalization. I’ve gotten better with it, but still have a hard time and tend to either over normalize or not normalize at all. Is normalization something you either get or you don't, or can it be learned? I know this...

Thank you so much for your reply. I'm attaching a copy of my database with one sample record. I've been trying to figure out the best way to tie client and supervisor information. Right now, I have an option to add/view client. Then once the name has been added I want to be able to find the...

Hi All, I'm running Access 2010, though I'm very familiar with 2007 as well. At my job I've been tasked with creating an Employer Database. The database is supposed to provide the name and address of the employer, as well as accomodate multiple supervisors tied to each employer. I think I've...

I'm sorry it took me so long to reply. It actually took me a few days to process my task and be mentally ready to tackle it (if that makes any sense :o). Thank you AccessBlaster I did start with the duplicate query wizard, and thank you Jeanette for helping me understand where to begin. I did...

Hi, I'm working with Access 2010, though I'm sure advice from Access 2007 would be applicable. Basically, I have three tables: tblStudent tblService tblStudentService (junction table between tblStudent and tblStudentService) My tblService has almost 3,000 records. Most of these records...

Thank you John, I looked at the sample database and it looks like a really useful tool. It's a bit above my skill level, but I'll be able practice until I completely understand. Would I be able to adapt the tool for a report rather than a form? Right now, I have 26 buttons on my report, all...

Hi, I'm trying to set up a simple filter button in an access report. For example, my report might have 2000 services, and I don't want my users to have to go through them all to find the one they want. I wanted them to be able to narrow the results down by the first letter of the service. I...

The list box works like a dream. You've saved me weeks worth of banging my head against the wall!

Thank you so much for your reply! I downloaded the sample database and looked at it, and it seems like a great way to do this. I just have one question though. Would there be a way to filter the records that go in the list boxes. For example, we might have 800 students in the database. Instead...

Hi, This question is in regards to Access 2007, but I'm sure advice would be applicable for all versions. I hope so anyway :). I have three main tables I'm working with: Student, Service, and StudentService (which is a junction table for Student and Service). Here is the structure: Student...

Hi Galaxiom, That's a great idea. I hadn't thought of it. Would you recommend this approach for duplicates as well?

Hi, I'm running Access 2007. My database has four main tables: tblStudent tblAPR tblService tblStudentService tblStudentService is a junction table between tblStudent and tblService. It has tblStudentServiceID as a PK and StudentID(pk of tblStudent) and ServiceID (pk of tblService) as...

With your help, I think I have a good handle on this. Thank you so much for your time!