| Thread | Last Post | Replies |
|
| export to quickbooks | 30 Jun 2006 21:55 GMT | 1 |
When I try to export an IIF text file, access shows an "read-only" error message maybe because of the extension "IIF". Do you know how to work this around? Thank you!
|
| Exporting data from access to excel | 30 Jun 2006 21:37 GMT | 3 |
A report I use to export to excel from Access using "DoCmd.OutputTo acReport, ReportName" is now providing me with different values. Data like 12-1369 is returning a value of -193607. Note: not all the values are changed. It is very inconsistent. Thanks!
|
| Linking to a link table | 30 Jun 2006 20:21 GMT | 1 |
I need a linked table going to another linked table that goes to a master table. All within Access. I have not been able to get this to work but I am not sure if I am missing something or not. Does anyone know if this is possible?
|
| Import Export translators for data unavailable; can't create new d | 30 Jun 2006 14:35 GMT | 4 |
If I try to import or export data from any application in Office 2003, an error appears stating that the required translators are not available. If I launch Windows repair utility, it fails to install or repair anything. Does anyone know if the original CD is required for this, ...
|
| How do I auto transfer one record of a form in access to word? | 30 Jun 2006 10:52 GMT | 5 |
I am looking to transfer one record at a time out of access in to a word template (fax template). I would like to be able to do this by pressing only one button on the form - how do I do this?
|
| Importing a file becomes out of sequence | 29 Jun 2006 18:47 GMT | 3 |
I am processing MS/Access 2000. Ocassionally when I import a file that has a sequence numbers in it the (output) file becomes OUT of sequence after the IMPORT Any ideas??? Appreciate any feedback
|
| Argghhh NOVICE Pulling hair out | 29 Jun 2006 15:54 GMT | 3 |
As access cannot create a radar chart of more than 5 fields i created a excel template ( with radar chart ove 35 fields) with the expectation for the range cells to be populated by creating a link from a access query. Is this possible, as I am now struggling.
|
| format of .txt files converted from Word forms | 29 Jun 2006 14:31 GMT | 2 |
I want to convert multiple (100's) of forms containing many types of data into .txt files acceptable to Access 2003. The import function converts the data into .txt in a notepad file, in a single column, that Access reads as "fixed width" (without formatting and form field names) ...
|
| values in an exported file | 29 Jun 2006 08:32 GMT | 10 |
I've exported a file from access using transferspreadsheet. One field in access which has a data type of "Number" with a field size of "Single" is populated by an update query to be 0.04. When I export the spreadsheet to excel the value becomes: 0.0399999991059303 which rounds ...
|
| ODBC and 'real time' | 29 Jun 2006 01:45 GMT | 1 |
Good Day! i have a db that connects to an SQL Server, and the ODBC should be real time. I have a form with fields that track info that is not currently being tracked in the SQL system, so I created an Access db to be an 'extension'. the
|
| Use data field in Access with email address as list in Outlook | 29 Jun 2006 00:18 GMT | 2 |
I have created a database in Access to manage registrations to a conference. One of the fields is a contact email address. I want to use the data in this field as a contact list in Outlook to send updates, confirm registration etc. I would like to have changes in the database be ...
|
| formatted excel into access report | 29 Jun 2006 00:08 GMT | 2 |
For reasons unknown at this time, my supervisor wants to see the output from a very detailed and highly formatted (style and color) Excel spreadsheet as an Access report. I have no trouble using TransferSpreadsheet to get the data from Excel into Access in table form, but does ...
|
| Moving a newly designed database table and for to another system | 28 Jun 2006 22:37 GMT | 1 |
I have recently designe a new database table and form on my Windows XP system using Access 2003. I would like to move these objects to another similar system and use them there. I attempted simply to "copy" the database to a CD and open it on the other system but was given an ...
|
| iAcces 2007 creating relationship after linking contacts from Outl | 28 Jun 2006 21:05 GMT | 3 |
I tried to link contact information from outlook 2007 with an Acees 2007 database. This operation seems to go well and in Acces a new table is created with a primairy index field called Normalized Subject. However if I establish a
|
| Turning off import errors | 28 Jun 2006 20:51 GMT | 4 |
I have a tab-delimited file where the first 4 fields are data that is specific to a single account. Fields 5 thru 20+ are the account balances at month end through a time series of many months. The problem I'm having is if there is no balance in a month, instead of having a ...
|