Search results for query: *

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...

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...

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...

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...

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...

Hello, I would like to know if I move some textboxes on report, if no data exists, is there any way to move them back to the orginal spots of design other than reassigning the value of position? I am able to hide and then move the controls up but I am wondering if theres a built in function that...

I have a dialog form which passes a filter to a report.The reports control source is a table. When I try to pass a filter with an 'And' in the where statement of the 'Docmd.Openreport' it doesnt filter right. I want the filter to query all devices with the serial num and the date provided. Cant...

I have a dialog form which passes a filter to a report.The reports control source is a table. When I try to pass a filter with an 'And' in the where statement of the 'Docmd.Openreport' it doesnt filter right. I want the filter to query all devices with the serial num and the date provided. Cant...

I built a new machine and before researching I installed win2k3 on different HD ; so basically new machine with salvaged parts from old one that had win2k installed. I am in the process of trying to recover the 2k on the new machine. Placed the old Win2k HD in new machine and as you may suspect...

Hello I am studying for my 70-270 and I am a little confused. Would someone be so kind as to explain the difference between Trusted Roots CA's and Trusted Publishers. I came across a question that basically stated that a user was trying to access a secure site and got a message stating the...

Hello, I have two tables (DeviceHistory{1Table} & Repair History{Manytable}) which are joined by the Serial# field. I have created a form based off a query of these two tables. My user places these devices on repair using a checkbox and runs a report to verify all serial numbers. When my user...