Search results

Doc, Thanks for your response. Forgive me for being slow to understand. I have explained the best I could and I am still new to this. Let me try to explain better what I was trying to do: My intention was to put all applicants, employee or not in one table. That way I only have one...

I'm afraid I don't understand... here is a picture of my relationships. I think I've got that figured out, at least. (I hope) Isn't your plan going back to the one table for all employees and non-employees? What I've got is a table with employees and a different table with applicants...

RichMh, ( :D ) Should I use a lookup from the tblApplicants to the tblEmployees to fill in a TDNo? Then if there is a TDNo, can I get it to fill in the LastName and FrstName fields? And if there isn't a TDNo, the user can fill in the LastName and FrstName fields? So there would be some of...

Thanks again, RichM. The problem is, I kind of wanted to keep the two tables separate... Is that really bad? Is there a major downfall to doing it the way I posted originally? I've already done so much with the relationships as they are now, and changing that all around would really...

PS I can post a picture of my relationships if you'd like to see them... Oh, and I'm using Access97 --Sara

RichM, Thanks for the reply! Applicants do not have to be employees, but they become one if they are selected to an open position. I currently have two separate tables for applicants and employees, though there can be duplicates if an employee applies for a job. What I want is for an...

Hi (again)! All right, I have something more I'd like to do that I think will make my users' lives easier (and allow for fewer mistakes, hopefully.) Problem is, I'm not sure how to do this... I've got a database which holds all the employees in the agency, plus information on their positions...

Thanks, Dave Only I don't think that's what I want. I want to change the text color, not the background color. And the text I want to change is already bound to its own field, so can't be bound to the option buttons. Thanks anyway. :) I guess this just isn't something that Access97 can...

Okay, I've done a search (I did one before I posted, too...) and I'm still having trouble. I've gone into the design mode of the subform and I've written this code: Private Sub Form_Open(Cancel As Integer) Select Case Me.CertifyID Case 1 Me.PositionNo.ForeColor = 0...

Hi. I have a form with a subform laid out tabularly (is that a word?) so you can view multiple records in the subform for each record in the main form. Is it possible to take one of the fields on the subform (a lookup field with three options) and color the text the record is in according to...

Thanks, all! It works great. --Sara

all right, i think i see that... but how does it determine the difference between case 1, case 2, etc. I mean, i have three options in this group... 1, 2, and 3. How do I tell it that Case 1 is equal to option 1? Does it just know? Thanks again. This is really helpful. (Woo hoo! I'm...

thanks boblarson! I'm not clear, however, on how to create a select case statement. How do I write it exactly? Do you think you could give me an example? Thanks. :) --Sara

I'm trying to use it on a form. Certified is the name of an option group. I want to disable/enable parts of the form based on the selection in the option group. There are three options in the group. Is that enough info? I can tell you as much as you need to know. Thanks, Rich --Sara

If Else (*Wicked* easy question!!) Hi. I'm totally new at VBA so please bear with me... I'm working on an IF Else statement that has three different options. I've tried a few different things... I'm not sure how I would do this. If Certified = 1 then Do this Else If Certified = 2...

duh... Thanks, Pat. I knew it was something basic. :rolleyes: Works great now! --Sara

I have made a form from a query. The query has no calculations in it or anything, but still the recordset is not updatable. I've tried using different types of joins for this, but the query doesn't work with outer joins. Here's my SQL. I'm probably missing something pretty basic, but I'm...

Thanks, Col! I'll let you know. --Sara Oh the racy comments I could make...

I have a couple radio buttons on my form. Is it possible to enable or disable other fields on my form based on what the user has selected as an option? I've done a search of the forum, but I don't think I found what I was looking for... just a lot of Code talk... Which I'm not too good...

I'm very glad! :D Thanks for letting me know! --Sara