Recent content by AJD10

Getting something new or having them move is not an option. This is important, but not THAT important. I have another utility we could pass it through, but I was hoping we could get around including one more step. Thanks for your input - I appreciate it.

Hello, I am exporting a data file from Access and it's going to someone else's system. This is what I've been told: When the fields are processed on our side and loaded to our database there are 11 positions for the amount and 9 for the count. On the file they would be send in the packed...

Thanks everyone for your comments! I ended up doing the following: - imported the table (as is) into Access. - Created a routine to loop through the records and as long as Name/Address were the same, concatenate each field into one string, separated by a "*"...

It's going to be used as input to create letters.. want one letter recipient with multiple orders in one record. I've tried cross-tab queries in Access, but I'm having a mental block on this one.

I know this can be done, but just not sure how to do it. Have an excel sheet with names, address and order info with names appearing as many times as there are orders. Number of orders vary, anywhere from 1-20 or more. Name1 Order1 Name1 Order2 Name1 Order3 Name2 Order1 Name3 Order1...

I'm used to developing code in Access with GUI with real users. Now I need a few things done automatically 1. Check Folder A for files. 2. Move those files to Folder B. 3. Get a list of all those files (I used a quick batch) 4. Run functions to import files (set up in Modules) 5. run...

There are a number of watched folders set up in Distiller on a shared PC. Now, if someone else uses Adobe Acrobat Prof to Print to PDF or distill a PS to a PDF, those watched folders are overwritten. Those original folders need to be recreated. Is there a setting somewhere that needs to be...

Thanks so much - this definitely works! Question back: Is there a way to save this Batch routine and kick it off through Windows Scheduler? Thanks

We have PDF's that are produced from a document composition software. The file size is 50MB because it includes a lot of resources. We open it in Acrobat Prof'l and print to Adobe PDF Printer. The new PDF is 2MB. Each PDF file needs to retain its original filename. How can we do this through...

Hopefully this is easy. I have hyperlinks on Sheet1 that will take the person to Sheet2, Sheet3, etc. When I add the hyperlink, the URL is "file://C:\My Documents\Status.xls\Sheet2!A1". The challenge is that I will be emailing this spreadsheet daily to multiple users (including client...

Oh great! this worked - I never tried the Indirect feature before. Thanks so much!! [thumbsup2]

I have data validation for a drop down list with a condition with the named ranges to populate the dropdown: IF(A2 = "1", List1, IF(A2="2", List2, ListAll)) This was great while we had limited number of lists. Now I have 10 lists and there is a limit in the Data Validation source box. What...

Hi, I have a text field in Access (long file name plus misc letters and numbers). I parse 35 characters from there and need to export my query to Excel. However, when I put it into Excel, it changes from "1233439482344089" to "123E+34". Then if I reformat it, it becomes "1230000000000". So, my...

Is there a function to change "1" to "one"? I'm using this for a different application, which uses VBA for formulas. Thanks,

Hi, I'm creating a database model and would like to input details in the properties (PK, definitions, notes). This way, I can turn this over to a developer. However, I'm unable to print these out. I used Tools/Report/Database - new and the properties listed on there do not match the ones I...