Recent content by PGM2

Hello all its been a while since I have been here but this site has always been useful. Thanks to all that have helped me in the past. Well I have a new question and I'm hoping I can get some thoughts. I have probably 40 msword documents that I have indexed within access and I would like to...

Thanks KiwiRexxDude, but unfortunately I got an error which read as: "ERROR 43 COMPILING PTAPE, LINE 11: ROUTINE OUTTRAP NOT FOUND". I am new to opsmvs and rexx for that matter. Do you think I got this error becuase the outtrap function is not available on our system? Thanks!

Hello I have created a rule that issues a command in Address OPER. Also I have a DO While Queued loop right after the command is issued. What I want to do is grab this output(that gets displayed) and validate it. Its my understanding that I cannot get this output from the external queue so I...

Hello, I have a folder that gets 97 Excel files dumped into it regulary and I am wondering is there anyway to convert them to 2003 with out having to open each one individually and saving them. I apologies if this is in the wrong area but I thought I would try here first. If there is already an...

Well placed the select statement in string variable ("strSql") and I am getting error "No value given for one or more required parameters". Note also that in order for it to work before I had to change the where statement to "WHERE(((DeviceHistoryTable.[On Repair])= True))". Not sure if that...

OK so I suppose this is getting a little old PHV but I was just informed that there is more information thats needed in the selecet statement you helped me with earlier. I now need to add other fields from the DeviceHistoryTable. Would my solution be to add a alias to the the already created...

Thanks PHV but not sure where you got the M from? Also by stating RepairHistoryTable R...is this creating a alias for repair so that it can be referenced again in the second select statement? Again I must reiterate a thanks as with your help my problem seems to be solved although I need to still...

Thanks to everyone who replied but another problem. How can I include the other fields from the "RepairHistoryTable", such as 'RMA'. Since its not part of the aggregate function I recieve an error. Would I create another recordsset and match up the id field and the datestamp that I got from the...

Ok so when I used this expression I got the right number of records: SELECT tblRepair.id, Max(tblRepair.repairdate) AS MaxOfrepairdate FROM tblRepair INNER JOIN tblDevice ON tblRepair.id = tblDevice.id WHERE (((tblDevice.[on repair])=True)) GROUP BY tblRepair.id; But as soon as I started to...

Hey Jedraw thankyou but I have one more question! If I have other fields that I need to include from the tblRepair can I just place them in the first portion of my select statement? I will give you answer and try but if doesnt work it would be nice to have an answer to fall back on. Thanks!

Can some help with this select statment. Recently I posted an issue and I have been trying to follow the advice but cant get this select string to work. strSql = "SELECT RepairHistoryTable.SerialNum, DeviceHistoryTable.[On Repair] as OnRepair, Max(RepairHistoryTable.SentDate) FROM...

I thank every one for posting to my question . I tried this strSql = "Select ...inner join....etc." & _ " GROUP BY RepairHistoryTable.SerialNum, DeviceHistoryTable.[On Repair]" & _ " HAVING (((DeviceHistoryTable.[On Repair]= True ));" But got syntax error for the "Having" portion. I see there...

Please help I am a newbie and I am stumped. Heres my situation. I have 2 tables that share a common field "SNum". The first one (tblDevices) states whether the SNum is on repair and the second (tblRepairs) holds the repair history of all "SNums". What I need to do is show only the records whose...

Looks like when I dug further (searched net and this forum) I was able to figure out my answer. Just placed a Me.Undo after the error message and it cleared the form and when I closed it it didnt give any errors and no changes took place.

Hello, I am wondering if there is anyway to reset the form to intial load view. I have a form which has a record source of an exsiting query. This forms allows a user to place a device on repair. Also when a user tabs to the second field (SerialNum) and enters a valid serial it populates another...