Search results

I'm starting over on my data base. What I am tracking is personnel and training tasks. I have apx 35 people and apx 75 training tasks, everything from weapons training to drivers training to carrer progression. My first question is with tables and their relationships. Do I even need...

Here's what I'm thinking........... This is/was my first attempt at major data base and I'm just getting confussed looking at some of my relationships and queries. I think I may just start the whole thing over but attack it from a more logical angle. I've started writing down the tables I want...

Okay thinking of clearifying. The relationships are for a form that joins the personnel table to two tables (drivers training, carrer progression) and a query (training tasks). The query is the one I'm having the problem with, anyfield I try and enter data into just gives me a "dong". Hope that...

I tried all that, I have the SSAN as the primay on the personnel side and ID as the PK on the training side and SSAN is the join. Thanks Pat, Tim

I'm stuck again. Here's the deal............ I have a data base to track training. I use three sets of forms to enter data Personnel info, training tasks, and carrer progression. I start out buy putting a new hire into the personnel info then update training through the other two forms. The...

once again, you guys have brought me through.....LOL. Now I feel really dumb, I tried changing those, but I think I was changing one and looking at another. I just went through and changed ALL the queries. Now it works. You did how ever present an interesting point. I don't want people entering...

Sorry, I'm getting very flustered. Try this........... Still to big. 844kb as a zip and 2.4meg regular

Okay, I'll give that a try!!!! I keep getting a to large file message, even as a zip file

I can't post the whole thing, it has SSNs in it. is there any portion in particular that you would like to see that would not hold that information? Thanks, Tim

Nope, still not updating to the other forms. Tim

I'm not sure where this should actually go, so in to general. Here's the problem. I have three forms, they they are all based on queries. when I add a person into my "Personnel Info" form, it puts the info into the table that holds that info. However, the other two forms that draw information...

All I can say is WOW!! I had to play around with it but it worked like a charm. I even went back and put a conditional format on it to turn "OVERDUE" red. Thanks to both of you for the help I really appriciate it. Tim

Hi Pat, Thanks for spelling it out, I'm afraid your getting too deep for me to follow. Your explanation did show me to use my queiry, But after that I tried it and I'm getting Syntax errors. So I've played with it to no avail. I just went to the last colunm in my queiry, I think I'll try it in...

Hello, At the end of a report I would like to count all the people who are trained(as a date) and divide that by the total number of people. =([countoffieldhygiene]/30) and then formate that to percent. The problem I'm having is that I have a conditional format that turns the date red if their...

Okay, I'm working this one, but I still seem to be having trouble.Select IIf(IsNull(yourfieldname), "somevalue", yourfieldname) as NewField, First, is "Select" part of the expresion? "as NewField", what does that mean/do? Should "yourfieldname" be in brackets[]??? That's it for now, I'm sure...

This stuff is driving me nuts!!! More on conditional formating. Now I want "literal text to show up in a null field. What I have tried is, iif(Is Null, "OVERDUE") and several veriations. and I've tried Is Null ("OVERDUE") and several veriations of this one too. Any Ideas???? Thanks again, Tim

Thanks everyone, it is as mresann mentioned, just for form controls. I didn't use the * because a couple of the tables did have the same info. I'm almost on to reports now :) Later, Tim

This is more a general question for my own piece of mind. I've combined three tables into one query so I can use all the information on a tabbed form (I just discvered tabbed forms and I love them!!). I'm just concerned that the query is too big?? Am I just worrying over nothing??? There is...

Sooooooooo, somehow I used the properies for the report, added the quiery that had my data and am now building a report using the drag and drop from the quiery window. Next question, can I add a query or Table after I've started in on the report and if I creat a report using a wizard can I add...

Good morning, I'll start out simple. I'm experimenting with creating a report in design veiw and have already encountered a problem. I put a text box control on it and have been trying to get it to show the "LASTNAME" field from the "PERSONNELINFO" table. I used the expression builder and I'm...