| Thread | Last Post | Replies |
|
| How do I export Excel to Vista? | 01 May 2008 00:07 GMT | 1 |
I need to export some spreadsheets that were begun when I was using Excel in XP. I now have a computer with Vista and want to export those spreadsheets to Microsoft Works Task Launcher's Works Spreadsheet. I have tried all of Vista's "Helps" and find nothing concerning this ...
|
| Create .txt File from unbound Field | 30 Apr 2008 22:38 GMT | 2 |
I want to create a .txt file from an unbound filed on my form. Any ideas?
|
| Counting # Of days on a report | 30 Apr 2008 16:58 GMT | 1 |
I reciieve an e-mail daily that is an excel spreadsheet. I have a linked table that updates my table in access then I use an append query to append any new data. What I need to know is if there is anyway I can caculate the # of days a record is on that report and the date it ...
|
| Import Excel db and splitting table cells | 29 Apr 2008 22:31 GMT | 11 |
I was pointed to a discussion in this forum about splitting tables, but I don't think that a code solution is what I need, although I would be willing to entertain it some more. I searched this group and I don't see anything that sounds like it would work for me.
|
| Import Multiple Text Files | 29 Apr 2008 02:35 GMT | 3 |
Thank you for helping me with the following issue! I have a large amount of *.txt files (60+)that I need to import and process in Access. Each file has a different name. Here is what I'd like to do... Run code that will import the file onto the table using a saved Spec... run
|
| error importing excel data to access table | 29 Apr 2008 02:10 GMT | 2 |
When I try to import excel data to access table, I receive "Import error file is not ....". I do not know how to detect what is wrong with the format in the excel file. Even when I save the file as csv or txt, I receive error file indicating
|
| Email automation of a Report to many people | 29 Apr 2008 01:41 GMT | 1 |
I currently have a button that once pressed, does the following: (1) Selects a company (2) Generates a report listing all the company's products (3) Generates an email that places the company's email address in the TO
|
| Error 3626 | 28 Apr 2008 15:10 GMT | 5 |
I can no longer link to my physical file on the AS/400. I keep getting an error 3626 "too many indexes". I do know recent changes were made to the file in question, but I need to find a way around this for the users of my application. I do not feel comfortable using any of the ...
|
| Creating a new db by Importing Excel Spreadsheet | 27 Apr 2008 20:16 GMT | 1 |
What would the best way to design a db based off of a excel spreadsheet? The spreadsheet has two columns : First Column has all the questions Second has all the answers with some of them being drop down boxes.
|
| get rid of decimal point | 25 Apr 2008 22:31 GMT | 11 |
I am doing it manually. the export query joined to a link table and I am using export specifications. The funny thing is that when I export the query, the decimal point does not show up in the resulting text file. But when I add the query to the final query, it is there. If I ...
|
| Help with merging data and duplicate fields that need to not be re | 25 Apr 2008 15:53 GMT | 1 |
I have 3 offices entering data into an access table that I am linking with a database and I have duplicate values in the tables, they can't be merged and I don't want the duplicate values removed what do I do now? I have a primary ID and 4 data fields, 3 of which will be ...
|
| Export 65k+ file | 24 Apr 2008 22:15 GMT | 9 |
Does anyone have code to export a query which returns over 65k rows of data? I keep getting an error message that I cannot copy more that 65k onto the clipboard. I have tried exporting in all formats but cannot get it to take.
|
| Mail Merge Wizard | 24 Apr 2008 19:03 GMT | 1 |
I run a Dell Dimension 8300 with XP and Office Suite Pro 2003 I keep names and addresses in tables in Access but when I try to use the Mail Merge facility to produce addressed envelopes the Wizard shows an error message
|
| DDE link in Access 2003 | 24 Apr 2008 05:38 GMT | 3 |
Hi! I am a newbee. I have a online trading software which allows DDE links. I usually make DDE links in my Excel and analyze the data. I am wondering if I can make DDE links in Access 2003 and can analyze
|
| exporting as text cutting off significant digits | 23 Apr 2008 21:46 GMT | 2 |
I am exporting a query as delimited text. This query has lots of numbers with lots of decimal places (for example, 0.02323733). When I am in the export wizard, all looks fine--the value above reads as an exponent (2.323733E-02). But when I open it in notepad, or Excel, or the ...
|