Is there any way to convert an excel template to an access form? I have a complex excel template which I would like to transform into a form without manually redesigning the form. The template wiza...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_101...
Zones:
MS OfficeDate Answered: 08/03/1999 Rating: 8.6 Views: 0
In Access you can use the OutputTo command to output the contents of a Table/Query to the designated format, in my case Excel. This creates an Excel Workbook and puts the data into a Worksheet with...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10222989.html
Zones:
MS AccessDate Answered: 03/02/2002 Rating: 6.6 Views: 0
In Asp,I want to save the opened recordset data to text file,Excel or Access format.How can I do that?
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_10319368.htm...
Zones:
ASPDate Answered: 03/30/2000 Rating: 8.2 Views: 0
I have a flat text file which Im' importing from code using a pre-defined spec , the problem is not all the records (one per line) are bieng imported. The file imports fine into Excel. If I use the...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_10354790.html
Zones:
MS AccessDate Answered: 05/23/2000 Rating: 8.6 Views: 0
i am running Microsoft Office 2000 -SP1 on a Dell 400 mhz machine and been so for about 3 years safely. Recently when i open Excel it now opens ALL files in the (C:\) root directly even if not a e...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_201...
Zones:
MS OfficeDate Answered: 11/01/2001 Rating: 2.6 Views: 0
We have dozens of users, and are setting up a database so that when a tech arrives to troubleshoot a user issue, he/she can then write up a brief report on the problem in the database.
However, ...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20234184.html
Zones:
MS AccessDate Answered: 12/03/2001 Rating: 7.6 Views: 0
I have an access database which contains 3 fields:
Field Name Datatype
1) Id as Text
2) Obj as OleObject
3) Pic as Longbinarydata ( to st...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20249636.html
Zones:
MS AccessDate Answered: 05/24/2002 Rating: 7.2 Views: 0
Hi, I hope you Experts will be able to help me with the following problem.
I want to export a report from my database (I use both Access 2000 & XP), to Excel. I want this to either be on the cli...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20259930.html
Zones:
MS AccessDate Answered: 03/21/2002 Rating: 9.4 Views: 0
Hi, i have an access subform (datasheet view) with around 25 columns. One of my users has requested that the first 5 columns be frozen when she scrolls to the right in order to view column 25 (whic...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20465658.html
Zones:
MS AccessDate Answered: 01/20/2003 Rating: 7.6 Views: 0
Hi,
I found a code to export data from Excel to Access. The code is exceuted through a command button in the Excel worksheet. It works fine for new records, but if a field in an existing record...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_206...
Zones:
MS OfficeDate Answered: 07/25/2003 Rating: 5.4 Views: 0
