Search results

db If you go to forms, click command button for Classes Taken, Hope appears and I want it to be blank so I can fill in and employee name and all the classes they have taken, then when you click on coarse name it says field cannot be updated

subforms I have a form and I'm using a command button to open the form to enter information and I have the data entry property set to yes and the one text box is still showing the previous entry? Then on some fields it says Field cannot be updated, noone else is in this db so they are not...

Thanks Lightwave, its nice to hear positive words. I will keep trying.

So sorry, I'm so slow at this, its hard to think when people are in and out of the office and I'm trying to self train until my class in march. I will relook at everything, thanks for your time and help.

db New queries

db I want to be able to add a new employee and their title (Add Employee Form) I want to be able to add a new Title in sytem (new employee title) I want to be able to add a new catorgory say Safety, then list the classes that fall under safety(Catergory form) I want to add new service provider...

CraigDolphin, thank you so much for your help and time that helps alot, I will restructure my tables. Ok, I restructed and added alot of tables, after looking at what my boss wants there is alot of repeating fields so I had to add tables to normalize it.

ideas Hello all, I have to create a db for my boss to train training in the plant. He wants a list of required classes for example a die-setter must taken and he wants to be able to search on an employee and see what classes they have taken and which classes they still need to take. I broke...

Does anyone have a sample training db?

I ask because I thought my last DB was normalized and set up correctly, then when I posted it, the forum kept saying I needed to work on it. I have that db up and working fine now with no problem and maybe it isn't perfect but its doing what i need it to do right now. So I ask this time so I...

hello Any thoughts out there on this?

Hello, My last Db the forum was commenting on my table structure so can someone please look at my tables and tell me if they are set up correct so I start off on the right foot. My boss wants me to start creating DB's, I am starting to create a db for him to enter in all the training coarse our...

thank you Thank you again Craig for all your help, I really appreciate it.

Thanks Craig, and I just attached the db whiling you were writing this, and look at the db and you will see what I mean which the line separating the test fields. Most records have to line one for leg and one for center and they enter this at the same time that is why you will see part 12540814...

Problem 1: Report is falling off page, I have blank pages between page numbers. I looked at the width on the page and it looked ok Problem 2: Also on my report I have part number 123, type Leg, Time 10:11 am and part number 123, type Center, Time 10:11 Am and the report groups/keeps entries...

Yeah, again I think my computer is nuts because I didn't put that code in, took it out and were ok. Thanks again Craig for all your help

ok I think Look above previous thread I wrote you first. Craig, I think I am ok now. I entered my dates and part in your fields and opened a command button to run the query and everything looked the way I wanted and worked, after I added a test box for time on frmtest(hid it so the operators...

going nuts Ok, Craig, one sorry I was probaly confusing early when I said what are you trying to show, like I said I think something is wrong with my computer at work, anyways I am at home and I opened your link and I now see your controls on the frmSearch1 as to I couldn't see them earlier...

little slow here today Craig, little confused because I did have my search on frmsearch1 page, but it still isn't pulling in all the info. I will keep looking. You said to have a look at the attached but I didn't see anything different, what did you do? I just want to be able to have a query...

look look at the db? double click on report and startdate type 1/10/08, enddate type 1/10/08 and part type 1001954, then report prints. On that report I want the date and time stamped when the test is taken