Search results for query: *

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

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

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

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

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

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

Hi, Users import their excel sheet into an access db (95 and 2K). Sometimes the whole sheet imports, other times it doesn't and sometimes it adds information (!). If the users reimport, it usually imports correctly. So, the problem can't be duplicated necessarily. I know I sound so vague about...

I'm having mental blocks on this task. Data table looks like this: Estimate Hours: ID TASK Rev Date Hours 1 Analysis 07/01 12 2 Develpmt 07/01 40 * 3 Support 07/01 32 * 4 Analysis 07/02 10 5 Analysis 07/05 15 *...

Currently we have central Word doc that tracks work we do per project. There is a list of tasks that we all do, and as they are completed, we update the document. The problem with this document is that it is quite long and repetitious (each task is a 2-3 row table w/date info). Even if you...

How do I execute a Word macro (to perform a mail merge process) from a batch file? Also, is there a specific way to save the macro? (i.e., "All active templates and documents") Thanks in advance!

I have a timesheet.xls that folks use to import into an MDB. I recently made a change to the XLS - adding a VLookup formulas to 2 columns (checking data on another worksheet). Now Access 97 refuses to acknowledge this as a valid spreadsheet ("External table isn't in expected...

I need a report that would list the following: PROJECT NAME: Desc, Dates, etc. ----------------------------------- Team Member A1 Team Member B1 Team Member A2 Team Member B2 Team Member A3 ------------------------------------ Status: Blah blah I'm having...

Hi, After much thought and reading into this, I decided to split our MDB that sits on the network, which is horribly slow. Figured it'd make it faster to have forms load locally instead of trekking to the server, right? Well, it's actually even slower since it has to go back to the server for...

How can I print out the relationship screen in Access? The Print buttons are invalid. I actually do print-screens and paste into another document, which is painful. Is there anyway around this? Thanks!