| Thread | Last Post | Replies |
|
| Import Html Tags from Sharepoint | 14 Sep 2005 05:26 GMT | 3 |
I linked my access project to different Sharepoint Lists. Some fields of the list are Multiple Lines of Text but defined in html. When I retrieve them in Access table, the Html Tags are not rended. How can Access rend them ?
|
| Access Imports from Excel as text, loses decimal when converting b | 13 Sep 2005 22:50 GMT | 2 |
Company recently upgraded to Office 2003. Now when I import from Excel, Access loads numbers as text. When I try to reset to number format I lose my decimal place. Never had problems with Access 2000. Am I missing something here?
|
| Importing From Excel Using Import Spreadsheet Macro | 13 Sep 2005 22:39 GMT | 2 |
I have tried to import data supplied to me in a spreadsheet which contains reference to an employee number ... this is in the main a seven digit numeric value, however there are a number which contain 6 numbers and a letter at the end ... problem appears to occur when Access ...
|
| importing old dbaseIV tables into acces | 13 Sep 2005 22:32 GMT | 2 |
I have at work a lot of old DbaseIV *.dbf files that I would like to convert to Acces type
|
| Importing from excel | 13 Sep 2005 18:29 GMT | 6 |
I have a DB in MS access 2000 with a one-to many relationship, two tables. One Table has employee data, the other has donations. An employee can donate many times. I created a spreadsheet for divisions to enter the data, 5 elements. When I import data into the donations table ...
|
| Importing Excel - "Subscript out of Range" | 13 Sep 2005 15:48 GMT | 3 |
I am trying to begin a new database by importing an excel worksheet. I keep getting an error message "subscript out of range". Nothing imports. Please advise.
|
| ODBC Connection | 12 Sep 2005 19:17 GMT | 3 |
I have a database on which I am writing several reports. These reports are being written as data is being entered so I have a concern on the accuracy of the data which will be presented in my report. For example, I have a general statistics page which lists the amount of data ...
|
| Sending data from Access to Word | 12 Sep 2005 17:52 GMT | 3 |
I need to send certain data from an open form in Access to Word. I need Word to open a new document based on a custom template, and insert the proper information at bookmarked fields. The user will then email the Word document back and forth with other users for additional data. ...
|
| Sending Access data to Excel | 12 Sep 2005 14:02 GMT | 1 |
How do I write the vba code for the following. My query(qryCIO) has a parameter: Enter Start Date and Enter End Date. After the dates are entered by the user I would like to export the the data to Excel using the TransferSpreadsheet method,but need the saveas dialog box
|
| Problems importing from spreadsheet | 12 Sep 2005 13:10 GMT | 7 |
I have a spreadsheet (excel 2000) from which I wish to export to an Access 2000 database table. I have set up a simple macro to try and automate this process. The macro is as below:
|
| how do I seperate information in one row into four columns | 12 Sep 2005 05:30 GMT | 1 |
i use a scanner to scan 4 different codes on one unit. I have thousands of units to scan. I download the scanner into notepad. I then import this into excel.
|
| code referring to sql BE in an adp | 12 Sep 2005 05:05 GMT | 5 |
I've been working with recordsets in access on an access backend and getting by ok but I am now trying to work with some ms-sql tables on a remote server that are linked to an access adp and am having a problem. I can run the following code on access/access but when I try to run ...
|
| Import a columnar report text file into access 2003 | 10 Sep 2005 19:27 GMT | 1 |
I need to import a .txt file with the following format into access 2003 field1: data1a field2: data2a field3: data3a
|
| cannot import text file | 10 Sep 2005 10:03 GMT | 2 |
When I try to import text file, the file type on Microsoft Access 2000 version does not show all files. It only shows specific format like, excel; access, dbIV etc.
|
| how to create an interface for my database | 10 Sep 2005 00:57 GMT | 1 |
Hi, I am totoally new of Access, however, I need to creat a database with an user-friendly interface/panel, people can add new, delete, query or search, and print report from the interface, could any one tell how to start? and need coding? Thanks a lot.
|