Search results

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...

I guess I am over thinking some of this. Instead of using EmployeeID I wanted to use DepartmentID. Each employee has a number specific to them, that is the department number. Joe Smith ID# is 301(DepartmentID) I wanted to use the department ID # as the PK field. I did not want to use an...

Thanks for the info. Something like this?

I have always had trouble with this and no matter how much I read I cannot get a visual picture of how to do this. So if any of you could show me how this can be done. It would be appreciated more than you can ever know. A company has many employees. Each employee can have many certificates...

ColinEssex, I have seen this in several of your anti-US threads. You insinuate that all Americans act a certain way because you 'ARE LEAD TO BELIEVE'. Maybe you should do some research since you are so misinformed? Until you have traveled to all 50 states and at least 20 towns in each state...