Search results for query: *

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

...- 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 "*". (Name*Add*City*State*Order1*Order2) - When name/address changed, then write out the string into a text file. - Open up the file in XLS as...

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

Ah ha! I changed the order of my columns and it works! Thank you so much!! [thumbsup2]

I've gone through all the posts where people are trying to look up by numbers and have problems where it's a text field and should be reformatted to a number. Here's my issue: I have a text field (B2052AG1-JOB00187) that needs to be run against column 2 in my range. Upon a match, I need column...

Resolved! I checked my Relationships and there was Referential Integrity to my Week End Date Table. I kept the link, but broke the ref. integrity and now it flies. (Still doesn't make sense to me b/c the Week End Date table feeds the drop down for the date field on the insert. So, it's not as...

You're right, but there are no restrictions on the Week End Date field. It's not linked to anything, not "Required" or "Indexed" or a primary key (The only PK on the table is an auto-id) I'm still testing the Insert (changing dates and other values). Dont know if I'm barking...

Great way to start the new year. When importing a timesheet with a week end date of 2003, all is fine. When doing a timesheet with week end date of 2004, nothing happens. When I try to run a query to update the table with 2004 records, I get the message that "Set 0 fields to Null due to a...