| Thread | Last Post | Replies |
|
| Unicode error | 22 Sep 2005 17:23 GMT | 1 |
I created ODBC linked tables in Access and I can view almost all the tables but one (the one I need of course) gives me this error message: The width of a unicode text column must be an even number of bytes And because of this, when the table opens, a third of the text is normal and
|
| Microsoft Money to Microsoft Small Business Accounting | 22 Sep 2005 02:46 GMT | 1 |
Can I import from Microsoft Money to Microsoft Small Business Accounting?
|
| Import from Excel..Field names in rows not columns | 22 Sep 2005 00:49 GMT | 2 |
Is it possible to import a spreadsheet from Excel where the field names are in column A, rows 1-45 and the records are stored in columns B...Z? Each column represents 1 record.
|
| Exportxml - I can't get it to work | 21 Sep 2005 22:51 GMT | 4 |
Private Sub Command93_Click() Application.ExportXML ObjectType = acExportForm "PORTABLES DATA ENTRY PAGE" DataSource = "PORTABLES DATA ENTRY PAGE"
|
| export inserted images from an access 2000 database | 21 Sep 2005 22:27 GMT | 1 |
I just have the database on access 2000, a file from 1.2 gigabytes. I want to export all files or convert the database, so I can set a folder with all images and the name to export the files will be another field, eg, ID.
|
| export a query to excel, but seperate fields by pages | 21 Sep 2005 20:32 GMT | 9 |
Hi I need to export a query into excel , in the query i am ordering by the agencyID field and i need to put each agency on its own page so when an agencyID changes it should export the upcoming data to a new page in excel- does anybody know if thats even possible- im using a ...
|
| Import txt file with multiple rows for each record | 21 Sep 2005 19:40 GMT | 6 |
I have a royalty report from SAP that I need to bring into Access. It includes check number, payment date, amount, and check recipient. The problem is the "check recipient" information comes in on either 1,2,3, or 4 lines in the report. But the rest of the record information is ...
|
| Access 2003 | 20 Sep 2005 22:14 GMT | 3 |
I'm having problems importing .xls spreadsheets into access 2003. I tried to re-register the .dll file, but I'm still having the same problem. Which is: File N/path was not imported successfully. No other error messages.
|
| Date data not Text ? | 20 Sep 2005 18:13 GMT | 1 |
I am linking an Excel worksheet to my MS Access database. Excel Table Name ExpiryDate *******************
|
| Opening Database | 20 Sep 2005 14:22 GMT | 2 |
When I open my database it never maximizes my 'Entry Page Form'. How do I make this maximize??
|
| Pass-Thorugh/select data source? | 20 Sep 2005 12:35 GMT | 2 |
I have a backend database. I use a pass-through query to retrive the data from the backend. The problem that I have is that is asks for me to select the data source every time the queries are excuted. Is there a way around this?
|
| How do I append data? | 20 Sep 2005 08:55 GMT | 3 |
I have five same Access database programs in five different locations. These places will then send their data to a central location and dump their data where it needs to be stored until all the information stored is sent back to these five places.
|
| Use Access to Connect to SQL Server | 20 Sep 2005 02:19 GMT | 1 |
I recently purchased the SQL Server 2000 Developer Edition. How would I configure Access to be able to connect to the Northwind database which exists in SQL Server ?
|
| Access can't export data correctly | 19 Sep 2005 21:59 GMT | 1 |
My company uses a product code scheme that is 2 digits, a dash and then 2 more digits (i.e. 02-05). When this data is exported from Access into Excel, it converts it the 1900 serial date (i.e. 36851) thinking that the digits are actually some sort of date. I have the field set ...
|