Search results

Can you give an example of this?

75,000-member strong Campaign for Real Ale.... Fiercely proud of their centuries-old brewing tradition, Czech beermeisters have reacted angrily to claims by the world's largest consumer advocacy group, the U.K.-based 'Campaign for Real Ale,' that the quality of Czech beer is going down the...

Nice, I was wondering the same thing too. Thanks

I guess thats my point; why does it matter now? I mean, how come she doesn't go down the list and note who is Heterosexual, bi, gay or celibate? Whats so special about knowing that a character in the book is gay?

Rowling Says Dumbledore Is Gay The Harry Potter author breaks big news in New York. I have not read the books but I was wondering if this information enhances the story? If not then WHY in the world is this relevant information.

You could just set the Control to LOCKED. Control Properties > Data > Locked = YES Its right under the Enabled one. Thats how I keep people from changing data.

Thanks for you help and patience pbaldy. I opened your fixed copy up next to mine and I found the only difference was the column count; mine was 1 and yours was 2. I did notice that the Rowsource SQL statement ended with "WITH OWNERACCESS OPTION;" Is that because you opened and saved it? Again...

Ok, I did that and now I have a drop down box with nothing in it. :( :confused:

Thanks for you help pbaldy I really appreciate it. 2 things I have done with your suggestion. ONE: Control Source: CertificationID Row Source Type:Table/Query Row Source: SELECT [CertificationTable].[CertificationID], [CertificationTable].[CertificationName] FROM CertificationTable; Bound...

I can change it to a combo box but the only selection i get is the ID number not the actual text. The subform on my form is linked to the EmployeeCertificate junction table. It seems like I am taking 3 steps back for every step forward on this one. It really should not be this complicated...

A few things I have found and need some clarification on please. A I think my relationship between the Employees Table and the Title table is wrong. It should not be 1 to many. An employee can only have ONE title. Is that right? Do I just drag the relationship between the 2 and don’t click the...

I'm not sure how to do this. Here is my db could you look and see if I am on the right track? The subform in on my form but I need the Certificate Name in a drop down list. Now it just lets me put in the IDnumber. Thanks for your help.

Ok let me ask you this, Did I do everything right up until i tried to put a subform on the Employee form? Are the relationships ok? Do I use the Relationship(EmployeeCertifcates) table as my subform table?

Ok here it is. I hope I did not mess it up to much. Access 2000 btw.

Colin@Toyota thanks for your help. I tried your suggestions but I still get nothing. The departmentID on my form is the exact same ID as in my subform. When I cycle through the records the ID of each one changes and they match. But the CertificateID field is blank and I can’t select or put...

Yes, each employee will have at least one certificate. I just used the SIMPLE QUERY WIZARD and select all from the EmployeeCertificates table.

I have the form with the subform in it but the subform has no information in it. I made the subform from a query from the EmployeeCertificate Table. So as of right now there is no information in the table. How do I get the information to show in the subform? After looking at my picture above...

I am trying to get it to work. I have never done anything like this so and I want to know how to do this. I have a form and I put a sub form on it. But their is no information in the certification column. I would like that column to be a drop-down box so I can select it from the list. Maybe I...

In this thread I got some help on how to do a table(Multikey). http://www.access-programmers.co.uk/forums/showthread.php?t=137668 Now I need some help on how to use this table on a form. I need to be able to select several certificates and an expiration date for each employee. John Doe...

I was trying to make a form so I could enter the relevant information for each employee, but I cant get the auto form to get the information I need. I need a form that has all the info of each employee. I want to select which certificates each employee is certified for and the expiration date...