Search results

David, thank you for the response. I have attached a sample copy of the database I am working on. Its easier to explain. If you open frmRecordSearchform you will see two record 12-0001 (Status=Open) and 12-0002 (Status=Closed). I want the user to be able if they check the checkbox ("Check to...

Yes when the USER check the Closed checkbox (Option Value = 2) in the form (frmdata) the status field (tbldata.status) gets updated. But I need to configure the qryRecordSearch somehow that when the checkbox in frmRecordSearch is checked it will be equivalent as to me going into the query...

Hi, I created a database to eventually replace the paper forms. So each record in the table (tbldata) represent a paper form completed by a USER. Each record in tbldata is represented by a unique number for example 11-0001, 11-0002, etc where the first digit represent the year and the other...

Question, does the PK always has to be an Autonumber, I know its a common practise but I was wondering can I have for example Doc Number as a PK where the Data Type is Text

I am looking at the link right now...lots of databases. I will start from scratch. I will have a couple of many-to-many relations thats for sure

What do you mean by Junction table.... If I had to guess lets say I create a table with EmpID ( from tblEmployee) and DeptID (from tblDepartment) will that table me a Junction table?

Another thing thats driving me crazy and I cant think of way around it. So lets say we have a Department for example "Quality Assurance" and "Quality Control". So "Quality Assurance" Department has the below modules 1. QA General (consist of SOPs/WIs) 2. QA Manger (consist of SOPs/WIs) 3. QA...

Spikepl, I totally agree with you you hit the points. I been looking att he table at the output doesnt make sense. The reason I said that because I have employees in the department and the department has function and certain employees will have to be trained on modules from one or more...

Attached is the image of how i did the relationships. Maybe not the best approach but I am if I open tblFunctionDocument it will show me everything. Huge table since alot of repetition. So if John Doe end up with 3 modules which translates to lets say 30 SOP and 20 WIs then the name will be...

Yes employees are required to take certain training because of the job function they occupy. Its both a company policy and requirement. Example: So John Doe (Quality Manager) He belongs to the Quality Assurance department. Because of his function and department he is required to train on the...

Thanks jdraw, i will read it. The difficultly or complexity I am running into is I currently have 2 buckets of information that I dont know how to relate them. 1. I have tblFunction which links the modules (function) to the appropriate Documents (SOPs/WI). 2. I have tblEmployees and...

jdraw, tblDoc contains the SOP/WI that i keep referring to "Document Number". tblFunctionDocument was my attempt to link the document to the function (modules) as you can see in the relationships. Again I dont if my approach is the right thing I had a relationship DeptId in tblDepartment to...

Attached is the database i have so far. Let me know if the approach is wrong and what I need to change to get what I need to. jdraw i will look at the link you provided

Hi, I am trying to design a database (Access 2003) to use to track training. I just cant get the tables/forms/query to work like I want. I feel I am missing something. As I said the database is mainly used to track training of individuals by being able to print reports and ensuring if all...

Thank you learned something new today.............The way I figured out the Format event is I tried most of the events at lunch break and the "Format event" worked and then I say your response Thank you again

Thanks thats what I actually ended up going with. A question though why the On current event wont work.

Hi, I have a weird issue happening and I cant get aound it because it doesnt make sense. For the sake of simplicity. I have a report with one field (Date type). Also I have to fields on top of each other one is a Label and the other is a textfield My intention is if the Date field has a...

What I did to make it work like i want is I put it behind the DblClick event of the subform. Hence I click on the record of the subform and the second form opens up thank you for guiding me in the right direction

Right now the way i got it to work is I went to the control in the Subform and under the DblClick Event I added this DoCmd.OpenForm "SecondForm", , , "ID = '" & Me.ID & "'" The problem with the above if the User those not choose the ID control and choose another field in the subform and...

pbaldy, I looked at the below DoCmd.OpenForm "SecondFormName", , , "FieldName = '" & Me.ControlName & "'" My question is about the Me.ControlName, the control is not on the form but is on the Subform. Hence will mine look something like that DoCmd.OpenForm "SecondFormName", , ...