Heres the situation: I currently have an excel file with approximately 3500
project entries
with fields such as job number, management, address, project description,
type, etc.,
Is there a way to make a gui program where a typical user can search the
database (excel file) and display the results in a textbox?,
Generally as follows:
1) User enters text in combobox to search for number, address, name, etc.,
then hits go button,
2) program reads excel file
3) user info is displayed in textbox ( display shows all fields based on
input, such as job number, address, descript, etc)
so if I type washington, it will display all the projects with washington in
it 2 1865
"sympatico" schrieb Heres the situation: I currently have an excel file with approximately 3500 project entries with fields such as job number, management, address, project description, type, etc.,
Is there a way to make a gui program where a typical user can search the database (excel file) and display the results in a textbox?,
Generally as follows: 1) User enters text in combobox to search for number, address, name, etc., then hits go button, 2) program reads excel file 3) user info is displayed in textbox ( display shows all fields based on input, such as job number, address, descript, etc)
so if I type washington, it will display all the projects with washington in it
HOWTO: Use ADO.NET to Retrieve and Modify Records in Excel http://support.microsoft.com/?id=316934
Cheers
Arne Janning http://www.codeproject.com/dotnet/ExportExcelData.asp http://www.dotnet247.com/247referenc...37/186640.aspx http://www.knowdotnet.com/articles/exceldatasource.html
Bill Ryan wrote this article and is one of the greatest authorities on
this subject you will find.
"sympatico" <fe******@a1vbcode.com> wrote in message
news:Br*********************@news20.bellglobal.com : Heres the situation: I currently have an excel file with approximately 3500 project entries with fields such as job number, management, address, project description, type, etc.,
Is there a way to make a gui program where a typical user can search the database (excel file) and display the results in a textbox?,
Generally as follows: 1) User enters text in combobox to search for number, address, name, etc., then hits go button, 2) program reads excel file 3) user info is displayed in textbox ( display shows all fields based on input, such as job number, address, descript, etc)
so if I type washington, it will display all the projects with washington in it This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: middletree |
last post by:
I read through Curt's sample code for using ASP to create a spreadsheet
(.xls). I think I understand the basics, but am still running into problems.
I'm doing this on an Intranet app, so I saved...
|
by: Roland Hall |
last post by:
I have two(2) issues.
I'm experiencing a little difficulty and having to resort to a work around.
I already found one bug, although stated the bug was only in ODBC, which I'm
not using. It...
|
by: Mike Knight |
last post by:
(I've also posted this problem on microsoft.public.excel.programming)
I have a MS Access 2003 Database named "AS400 Fields.mdb". This
database contains links to tables on an AS400.
In MS...
|
by: Jae |
last post by:
I'm writing a web application that exports and imports excel files.
The application gets a list of users and their info and displays it in
a datagrid .The user then selects to save the file as a...
|
by: garry.oxnard |
last post by:
Can anyone help me to solve a problem which involves switching from
Access to Excel (then back to Access) programatically please?
I have an Excel template which, on open, also opens an Access...
|
by: baling |
last post by:
Hi....
Hi everybody, i have a code that i make in VBA and know I want to use this code in to VB6. But i don't know how to use that code in to VB 6.0
Please correct this code so i can use it in VB...
|
by: Sport Girl |
last post by:
Hi everybody ,
i have the task of developing in Perl a script that retrieves data from 3 tables ( bugs, profiles, products) from a MySQL database called bugs and display them in an excel sheet...
|
by: CoolFactor |
last post by:
MY CODE IS NEAR THE BOTTOM
I want to export this Access query into Excel using a command button on an Access form in the following way I describe below.
Below you will find the simple query I am...
|
by: Phil Stanton |
last post by:
I have a form with a button which is supposed to open an Excel file (With
lots of Macros /VBA) in it. The Excel file gets it's data from the Access
program
Here is the code
Private Sub...
|
by: maryanncanor |
last post by:
Hi, I have an input excel file that needs to be imported to Table1. However, the fieldnames or header in the excel file doesnt match the fieldnames in the database. The fieldnames in the excel file...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |