Search results

Ahhh, I got it working. All I had to do remove the "Order By" from Record Source and add Jet_Seq,Clean_Seq to OrderBy control in the form. Thanks again... SKK

I'll try that tommorrow. I'm a bit leary to modify the code that much because this routine is actually used for numerous other functions (originally written by others). I was hoping I could do it without separate querries but this probably will work. I'll keep you posted... Thanks again for...

If i code in the IIF command, I see nothing. An error returns stating "The record source does no exist" (see attached). If [system]="SAN" i want to sort on JET_SEQ, if [system]="STO", i want to sort on CLEAN_SEQ. SKK

We have a database that tracks sanitary and storm sewer maintenance. There is a form that I want to order based on the sewer type field (SYSTEM = san or sto). I can do this with a query but this code was written by others so I’m a bit nervous about changing it too much. Currently the form’s...

Will try... Thanks again, SKK

I'm not sure this is possible but. We have an Access2003 database tracking sewer cleaning. The input form has an INSPECT_DATE, DEBRIS_DEPTH, CLEAN_DATE, and a calculated PERCENT_DEBRIS field (plus a few other incidentals). The form returns only records needed to be field verified. After...

I've got the form created however, when it opens it does not limit the data to the result of the QBF (all records are available). How do I limit the second form to just those records selected via the QBF? Thanks, SKK

I have QueryByForm with a command button that opens one of two application based on the values returned by the QBF. Currently I have a MsgBox vbYesNo code to open the proper application. However, rather than having the buttons read Yes/No I’d wish them to read Option1/Option2. If I click...

Thanks CodeMaster...

Thanks George - I'll try and let you know how it worked out. I don't need to change the attribute - that happens via our CAD program. All I have to do is copy the files that have been modified since the last update. These files are being copied to a laptop so our inspectors in the field have...

George, I'm not trying to recode the batch file but rather what would the code be if I was to include it in the module? FileCopy "z:\map\base.dgn", "c:\cad_files\*.*" /M SKK

I have a batch file I shell to which copies files. Rather than shelling out, I’d like to code the "copy" operation directly in my VBA routine. I’m aware of the FileCopy command but was wondering if it’s possible to copy only newer files similar to the /d/y switch in my batch code? Also, does...

Yes all are configured the same. I hear you - I'm out of ideas myself... Thanks for your time, SKK

Everyone has same CAD program, same mapped drives, same network permissions. SKK

Already tried that (\\city_server\cad_files\plans\) with same results. - works on my machine, not theirs. SKK

Not sure if this is a database question or general PC concern – We have a DB tracking engineering drawings. It includes a QueryByForm which lists appropriate files. It has a command button that opens the corresponding file with our CAD program. I did all the testing on my machine and it...

Yup, I belive I found my problem. Some of us are still using Personal Address book rather than Contacts. When I placed the Distribution List in Contacts, it worked fine. Why it worked in Win2K - who knows. Thanks for your time, SKK

I have a form with a command button that runs a SendObject macro which automatically sends a report via email to select recipients via an Outlook Distribution List. It works great on Win2K but bombs on WinXP with an Action Failed box. The only option is Halt - pressing halt, returns “Unknown...

I ran Compile and didn't see any errors. Does it sound possible that would only happen on XP machines? Not bing a programmer, this may be more than I can handle. I was hoping this was a simple fix but may be wishfull thinking. SKK

How do I run a compile? SKK