Search results

I have been testing my database and have found an issue when using one of my append query. Everytime I run the append query (On Close form event) I am ending up with duplicates but I want the append query to be smart and only append those rows that are not equal in tblRecords. Example...

I used this and worked UPDATE tbltest SET tbltest.strProcRev = "90" WHERE (((tbltest.strProcRev)="AA" Or (tbltest.strProcRev)="0"));

I would like to replace in strRev column any "AA" or "0" with "90". How can I go about this. I was thinking to use an Update Query but dont know what to put in the criteria I was thinking to use the IIF function but the problem is I only want to change if the value is "AA" or "0" otherwise...

Pat, Thanks, for some reason I miss read the first part of your response below. I see what you are saying now. I will try it

Thanks plog, I ended up using a regular query just as the one you mentioned below. I guess i was looking at it in the wrong way trying to use Find Unmatched query

Hi, I been looking around the forum but cant get or pinpoint the way I need to go about this. I might be complicating matters but if it is the case I am sure someone will tell me so and guide me in the right path. I have 2 tables tbltest and tbltest1 both have the same field names lets say...

Thanks Pat I figured out the error as you mentioned in your last para. Since I was using the On Open Event it was going to the first record which was empty and thus didnt work. When I moved it to On AfterUpdate Evenet the code worked well but since I cant control every row separately on a...

So I used the above code in the "On After Update event" of the Mainform and also used another vba on the "On After Update event" of strCom1. That worked for me. The issue I still have to get around presuming it is doable and of someone can guide me how is my frmSub is a continuous form...

Hi, I believe I did this before awhile ago but for some reason I keep getting an error. I have a Mainform (frmMain) that has a Subform (frmSub). On frmSub I have 2 comboxes (strCom1 & strCom2) one is set to invisible (strCom2.Visible = No). So using the "On Open Event" of frmMain I want make...

jdraw, I reviewed the attachment and I have a major difference. The organization doesnt want to use JobPositions/Titles as it changes so frequent that the current database wasnt able to keep up and the info is inaccurate. So as part of an improvement effort and to stramline line the process we...

I have a form to allow the User to add new documents (strProcNum) to the database (tblProcedure). After adding the new document (strProcNum) the User must link it to the appropriate Modules (tblRequired). Hence, I created a button on frmDocNew if clicked will open frmDocLinkMod. Below is what...

I am actually trying to build it on the requirements given to me. I am just trying to make sure I have the right tables to capture all the requirements/data.

An update to post#4. I created another table tblModEmp (strEmpNum, strDept) that links the employee to the module. So now the next thing is figure out how to update the document revision (strProcRev) in tblProcedures but keeping track of the older document revision. It seems I will need...

Thank you, i will look at it

So this what I have done so far. I created the following tables: 1. tblDepartments (strDpt (Pk), strDeptHead) 2. tblEmployees( strEmpNum (Pk), strName, strDept, strDpt, dtmHiredate, ysnactive) 3. tblModules (strDept (Pk)) 4. tblProcedures (strPRocName, strProcNum(PK), strProcRev(PK)...

I know I am not the first. I have been searching within the forum and still searching. I was trying to see what is the best approach out there from a relationship design. Is it better to combine the Modules and Procedures under one table or separate them.

Hi, I am working on a training database and I just cant get the logic to work the way I want it. A couple of things that the database need to be able to handle is: There is something called Modules. Each Module consist of certain documents/work instructions. Each employee will be required to...

Yes it worked for the tbltest but never tried it for the live as I got distracted with this I will give it a shot definitely

I have attached the database. Try "6632" or "6632,6633" and you will get the error

I will modify the live database and keep a couple of records that the code is failing and post it maybe if you see the problem that will make it easier to troubleshoot