| Thread | Last Post | Replies |
|
| Importing from an Intranet Web page | 28 Nov 2004 20:52 GMT | 1 |
,Hi, I would like to import data into a table from an intranet web page. I have tried to set up a web query to import the data, but the file extension on the webpage which contains the data is ".report" and access does not recognise
|
| Problem: link to excel on web | 28 Nov 2004 19:29 GMT | 1 |
I need to link or import an Excel spreadsheet published on web site. The address is like: http://.../.../ExcelName.xls. It is not htm or html type, and not an excel in local drive either. This site doesn't have security log in. I tried to use normal link/import method, but it ...
|
| How do I publish complex data structures in book format in word | 28 Nov 2004 09:44 GMT | 2 |
So far it looks to me that the reporting functions in access are fairly rudamentary. I am working on setting up a complex report writing system. I am looking for a way to use the functions of access for the storage and manipulation of data sets and then link the resultant data ...
|
| How to remove a macro in access when the Data Base does not open | 27 Nov 2004 11:07 GMT | 1 |
I created a macro with "quit" event and embedded the same in a command button attached to form of a data base in MS Access 2002. Now, whenever I open the Access Database, the file does not open. Immediately it closes down. How to solve this problem.
|
| Linking an Access db to tables on the internet | 27 Nov 2004 11:07 GMT | 2 |
I would like to link an Access front-end database on a PC to an Access back-end database stored on a web server on the internet. When I use the File/Get External Data/Link Tables command from the front-end db and navigate to the back-end file I get an Access error message saying ...
|
| How to change access database to sql | 26 Nov 2004 17:00 GMT | 1 |
how can I change access database to sql?
|
| Importing a delimted file that includes the field headings | 26 Nov 2004 16:21 GMT | 1 |
I am trying to import a delimited text file. However I am having trouble in achieveing this as the text string contain the fields that the data needs to be "attached" to. The data is formatted so: #Field1#data1#
|
| Creating a document from a form | 25 Nov 2004 22:34 GMT | 1 |
Does anyone know how to: Have a command button that when pressed will take the data shown on the form and export it to a pre-defined word document and display it before printing or saving it.
|
| query mdb on network into Word. Access.exe not on workstation | 25 Nov 2004 16:14 GMT | 8 |
I have created a Word template that is just loaded with macros and userforms. Users on the network have a menu button in Word, which opens a Userform in Word. The code behind the userform uses ADO to first check for a number of existing text files on their local hard drive. If the ...
|
| how do i export dates prior to 1900 from access to excel | 25 Nov 2004 07:24 GMT | 1 |
all dates in my access database prior to 1900 are lost when exporting to excel, unless i set the field to text not date/time
|
| Sanbox Enabled | 25 Nov 2004 07:17 GMT | 1 |
I am attempting to import an excel file but keep getting the following message The Microsoft Jet database engine could not find the object "filename$". Make sure the object exists and that you spell its name and the path name correctly.
|
| csv file | 25 Nov 2004 07:15 GMT | 1 |
I have a file which is downloaded to my PC everyday in csv format and I would like to automatically import this file exactly as it is field by field into an access database , so I can write queries.
|
| Exporting a list of email addresses from access to outlook | 24 Nov 2004 23:22 GMT | 1 |
We have a database, and in one of the tables there is a column of email addresses. We want to send one email to all of these addresses from outlook 2002. Is it possible to export these email addresses to outlook? Regards
|
| Linking the actual email-adress from an email-message | 24 Nov 2004 23:22 GMT | 1 |
In my Access 2003 database, I have a linked table to my Outlook 2003 Inbox. However, in the "From"-field of the linked table, the actual email-adress is NOT shown. Instead I see the "email-name" which the sender has chosen, for instance:
|
| Find what button was clicked | 24 Nov 2004 14:15 GMT | 2 |
On my form I have 5 choices (each opens a form). The form's display will change according to what was clicked from the previous form. (eg hide, or display controls) What is the code to trap the last button or control clicked.
|