Recent content by JIMR

So I was thinking that the count was making more sense for what I am trying to accomplish and then something occurred to me. there is a standard metric used in my field for the number of times a Preventive Maintenance Work Order is performed. This may be the best way but would like to see what...

Not sure I am understanding how you can "allow duplicates in general" then check "where you don't want duplicates". Assuming your meaning in a single table, doesn't it have to be either one or the other?

Hmmm, I have been tossing around the idea of using the date. Any other possibilities?

Using Windows XP MS Access 2003 using 2000 format I have a Maintenance Management database I am attempting to create and at the point of generating Work Orders using an append query I have searched the forum and found a few similar threads but they don't (I think) address my specific issue...

RG, you did get all of it thanks. You created a second qry "qryRawWorkOrders" is this what it took to stop the requery loop or was it necessary to get the txtlink to work. Could it have been to solve both issues. I also see the name of 2 forms were changed, I suspect this was done to...

Sorry, I left that out. It is the record source for "sfrmWorkOrders" and when I remove "qryWorkOrders" it stops what I think is a loop somewhere with a requery but it also stops the transfer of the selected WorkOrderID to the Work Order Details Tab.

RG, Here is a file share link if there is a problem with the .zip file. http://www.4shared.com/file/101466775/6e372340/SAMS.html You can get to the file by clicking Work Orders on the switchboard. The 2 tabs in question are tab:"Work Orders" and tab: "Work Order Details" Thanks

RuralGuy, I have made some changes to my forms and have ran into a couple of problems with my text link and record souce. Problems started when I changed a form to a form and subform. I have gotten most of the items to work that I need but with some exceptions. I am sure items 1 & 2 listed...

Your are right I am attempting to get this to work on a tabbed form and I did not explain that well enough. This is a form build using a query then I inserted the form into the tab. So since I am very green in access I am assuming this is a subform and I need to properly write the path and...

I have been able to get most of the combo boxes to work but on a form out side of the tabbed form that I need them to work in. I am positive that its due to the criteria that I am placing in the qry for the combo box. I am not sure how to get to the page index of the tabctl0. it is page index 4...

If I am understanding you correctly it appears to me that I can not filter my form using the combo box method? I would likely use up to 6 Different combo boxes to filter 6 fields but populate all of the remaining fields. I only have 1 combo box that I am working with, is that part of the...

With the exception of the AssetID all other FK's may not accually be FK's. I placed them in the WorkOrders table and set the to lookup to their primary table via a combo box. I am mentioning this because I am not sure if it changes the way the Select statement should be written.

Hi Mike Gurman, You probably have this solved but I was looking to do the same thing when switching tabs. Using the information in this thead I was able to requery a form by using "me.yourqryname.requery" in the on change event. no other code was needed.

Uncle Gizmo, I am having difficulty preparing a good select distinctrow/union statment for the form that I would like to filter using a series of combo boxes. This is my latest Sql statement (not a code guy) which is generating an error messege that states the number of columns do not match...

Thanks for posting the hosted site. It too is blocked so I will have to get this from my home PC.