473,569 Members | 2,752 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help linking ListBox to Memo DataType in database

I hoping you might be able to help me with a small problem. I have
made an application that links a VB.NET program to a database. After
many failed attempts and reading I can add, delete, navigate records
and update the actual database. I have a simple database with two
tables that form a car maintenance tracking program. One table holds
the information on the car with a secondary table that holds service
information. One of the fields in the service table in the database is
type Memo so I can have long description of what was done in the
service. I have used bound controls for all of the input boxes. I
wanted to be able to type information into a list box and then load
that into my DataSet then update that to the actual database. RIght
now I can do it using a text box but it doesn't look that nice & it's
hard to see what you have typed. I am using a OleDb connection for
connecting to my database. Thanks for any input to this problem.

Cheers, Dennis
Nov 20 '05 #1
2 1601
Cor
Hi Dennis,

Did you already look to the datagrid, it sounds if you just wanted to use
that?

I think that will be good to set the next step?
(Although I think it will not be the last).

Cor

I hoping you might be able to help me with a small problem. I have
made an application that links a VB.NET program to a database. After
many failed attempts and reading I can add, delete, navigate records
and update the actual database. I have a simple database with two
tables that form a car maintenance tracking program. One table holds
the information on the car with a secondary table that holds service
information. One of the fields in the service table in the database is
type Memo so I can have long description of what was done in the
service. I have used bound controls for all of the input boxes. I
wanted to be able to type information into a list box and then load
that into my DataSet then update that to the actual database. RIght
now I can do it using a text box but it doesn't look that nice & it's
hard to see what you have typed. I am using a OleDb connection for
connecting to my database. Thanks for any input to this problem.


Nov 20 '05 #2
Sorry I didn't make that clear enough, I don't want to use the data
grid because it doesn't look good and I don't think a user wan'ts to
type 300 words on a single line. This program uses bound controls and
no data grids. I wanted to use a List box and have that update the
data into the database. Oh well, I guess I keep trying. Thanks for the
help though.

Cheers, Dennis

On Tue, 2 Dec 2003 09:26:10 +0100, "Cor" <no*@non.com> wrote:
Hi Dennis,

Did you already look to the datagrid, it sounds if you just wanted to use
that?

I think that will be good to set the next step?
(Although I think it will not be the last).

Cor

I hoping you might be able to help me with a small problem. I have
made an application that links a VB.NET program to a database. After
many failed attempts and reading I can add, delete, navigate records
and update the actual database. I have a simple database with two
tables that form a car maintenance tracking program. One table holds
the information on the car with a secondary table that holds service
information. One of the fields in the service table in the database is
type Memo so I can have long description of what was done in the
service. I have used bound controls for all of the input boxes. I
wanted to be able to type information into a list box and then load
that into my DataSet then update that to the actual database. RIght
now I can do it using a text box but it doesn't look that nice & it's
hard to see what you have typed. I am using a OleDb connection for
connecting to my database. Thanks for any input to this problem.



Nov 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
6171
by: Fernando Flores Prior | last post by:
Hi all, Is there a way to "cast" the text datatype fields in order to not be interpreted as Memo fields in some Delphi data-aware components? specifically DbGrids ? Should I tweak the ODBC driver config ? or it is something related to the client side programming tool? (delphi in this case). regards
1
2391
by: KePaS | last post by:
I,ve got the following Script to Use on MS Access. So far it works just fine, but I want to set "Auto-Increment" to the field "test16_auto_long", but I don't know the expression Access wants to have. The same problem I have with the datatype "OLE-Object". So here my question: how are these two datatypes called in Access-SQL? Hope it's...
6
1289
by: Sam A Ruos | last post by:
Is there any settings in Acces200, which I can set the Memo data type to take more than 255 chars? Thanks Anyone! /Sam
1
1540
by: Beacher | last post by:
is there a way to add an item to a subform just like it were a listbox? I dont want it bound to anything, I just want to show data in it like a datagrid, because i really dont feel like formatting a listbox, just wondering if there was a item.add function...something like it
0
1558
by: mathewbutler | last post by:
Access 2000 SR-1 I've spent some time investigating this, and researching both here and on the MS support site. Briefly; Problem Description: ------------------------------- I have the following query which I am using to export data into CSV format;
3
1997
by: juliehg | last post by:
Hi, I'm currently using MS Access 2000 to keep all my actors measurements, resumes and personal details on a database. To upload their details onto our website, I have built an event so when I run the query, only certain data is selected and exported onto a separate database that I can easily upload onto our ftp server. It has been...
3
3144
by: ARC | last post by:
I'm having trouble here with Access 2007 and connecting to a different database. The code below works great IF the previous back-end database connection is still present and you are trying to connect to a new location (ie: datapath variable below). However, if you remove or even rename the old database, then launch your program, the code...
1
1813
by: mcolson | last post by:
I tables in Sql, which I am linking to in Access. I have a couple of fields which are using the data type "text". Why are these appearing as the data type "Memo" in Access.
3
9374
by: Kunal Desale | last post by:
Hi, How to insert/update data in foxpro table field having datatype MEMO using Linked Server? I have written sql insert queries in which i have used linked server to insert data into foxpro tables. Some fields have datatype Memo and in these fields my data is not getting inserted/updated. My queries contains local tables & dbf tables...
0
7694
marktang
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7609
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7921
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
6278
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5504
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5217
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
2107
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1208
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
936
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.