| Thread | Last Post | Replies |
|
| expressions parentheses do they calculate first | 13 Dec 2005 00:41 GMT | 1 |
if you add parentheses to an expression does that calculate it first?
|
| Importing Fixed Width Text File | 12 Dec 2005 21:34 GMT | 2 |
I have a file that is text and I wish to use the Import wizrd, the file is of a fixed width type, once I have defined that number of characters per column once, is it possible to automate this so I can import further files without having to set out the widths again. Thanks
|
| Need to convert multiple tables into a flat file for Word merge | 12 Dec 2005 17:31 GMT | 3 |
I am a student working for a university library in the production of a directory of private foundations in our state. We need to generate a large directory of these foundations using MS Word (2003). However, the data for the foundations has been stored in multiple tables in ...
|
| Export query results | 12 Dec 2005 17:03 GMT | 2 |
i'd like to export the query results in an excel file in a give spreadsheet. I'd like to have a prompt that asks me where to put the file and what name to give to it. Now I'm working with
|
| Importing csv files | 12 Dec 2005 04:23 GMT | 2 |
I have a method for the simple job of importing a csv file, however on occassion one column starts with numeric values and other times alphanumeric data It there a way to force Access to see all columns as text values as a pose
|
| Bug? Export to text file drops numeric data right of the decimal | 10 Dec 2005 21:52 GMT | 3 |
I am trying to do a simple table export to a text file in Access 2003. The data has numeric values with multiple digits to the right of the decimal point (ex: 25.2687). The data is stored as a number / double. When I do the export to a comma demitted file the digits after the ...
|
| exporting to text | 10 Dec 2005 01:14 GMT | 1 |
When exporting a query or a table to text and using file extension of csv dates get converted wtih format of date/time. Example: 12/19/2005 0:00:00. Currently I have to find and replace to correct the csv file. Is there a way to automate the export to the correct format?
|
| Linked Table Error | 09 Dec 2005 21:16 GMT | 5 |
I am linking an Excel sheet with a table in Access. When I link it, it creates an error table. When I look up the table, it has 3 fields: Error, Field and Row. Under the Error column, it has "Type Conversion Failure"; the Field column has F2, F3, etc; and the Row column has a ...
|
| Importing numbers from text file | 09 Dec 2005 17:16 GMT | 2 |
I have a text file in which one column contains number in the following format: 1.000,00. My regional settings are US (1,000.00). When I am importing the file, the numbers >1000 will not be imported. (I have changed the importing
|
| Error exporting data to text file | 09 Dec 2005 04:23 GMT | 1 |
I am trying to utilized the Export Wizard to export a large dataset (over 100k records) to a text file. I have stored specifications that appear to work fine, but at the last step, I get the following error: The MicroSoft Jet Engine could not find the object ". Make sure the ...
|
| Retrieving table information from Test Director | 09 Dec 2005 04:18 GMT | 1 |
I am trying to retrieve some data from Test Director 7.6 and import into an Access database. How can I set this process and how would I purge the data each time I do an import?
|
| Importing Date from a remote user | 09 Dec 2005 04:17 GMT | 1 |
Is there a way in Access to create a questionnaire for use by a person at a remote site, wherein that user could filling a key field (ID) along with various pieces of information and have that feed into a main database? How would the person access this questionnaire, as we want it ...
|
| Change color of font on envelope | 09 Dec 2005 04:12 GMT | 1 |
Every envelope prints in pink. I want it in black. It went to printing pink and I don't know why and I can't get it to print in any other color. What do I need to do to correct this.
|
| Make a Calendar | 09 Dec 2005 04:11 GMT | 1 |
I have a simple database in Access with function booking dates, names, numbers, prices, etc. and want to present and print this data in a calendar format so I can see at a glance what dates are booked and what are free. Can I do this in Access or export to Outlook? & how please?
|
| Changing an AutoIncrement Field to a Long Integer Field and Back | 09 Dec 2005 03:23 GMT | 3 |
I realize this is a bit unorthodox and reflects a questionable table design, but I am coming in on the end of this saga....... We need to massage a small set of data to get to coincide with an old system. In short, the new system uses an AutoIncrement field to assign an
|