473,326 Members | 2,023 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Visual Basic Listbox clickevent

42
--------------------------------------------------------------------------------

Hi guys , have 2 questions if anyone can help me .

first - have a form which displays all the records i have in my database , and a search box for the user to search for a specific one .
On the search button, i run a macro which opens another form with only the records found based on the search. So far so good :).

Now one the second form first record found is displayed ( customer and deatils)
and u can navigate through the rest . But i also have a listbox which holds only a field ( first_name ) so that the user instead of going though all 50 records ,he can select one record from the listbox.

question 1
How do i display on the page " 1 record found out of 50" ?
i know about 50 cose is a count of all records , but what about 1 . how to i make to count those?

question 2
when i select a different customer from the listbox i want to fill up all the textbosex from the from with the details of the selected one .

the form is bounded to the search query , so i dont want to chage that .
any way in vb to bind the textboxes to the selected clikevent of the listbox ,but at the same time i want to keep the other record as well so i can navigate through them .

Thanks
May 19 '09 #1
4 1916
NeoPa
32,556 Expert Mod 16PB
@onyris
You want a way to determine the number of records that match the selected First Name from your ListBox control?
@onyris
I find this too confusing.

I suggest you create a new thread for this question (I would try to explain it more clearly if you can). It doesn't help to have two questions in the same thread anyway. Most people get confused too easily.
May 19 '09 #2
onyris
42
i'll put the second question on a different post to avoid confusing.

for the first question i have already posted a new threat

http://bytes.com/topic/access/answer...-records-found

this is the post and hope u understand what i mean with that
May 19 '09 #3
onyris
42
regarding question 2 i have posted a new threat for that

http://bytes.com/topic/access/answer...ox-click-event

hope u understand now what i mean.
Thanks
May 19 '09 #4
NeoPa
32,556 Expert Mod 16PB
I'll lock this one then, and go and have a look at your new threads.
May 19 '09 #5

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

Similar topics

1
by: MR.T | last post by:
Hello. I'm trying to develop ASP.NET Web Application with Microsoft Visual C# .NET V. 7.0 Framework 1.0, but I have two problems: 1. In the Toolbox I dragged a few object like "TextBox",...
0
by: Ben Rush | last post by:
Greetings, I don't deal too much with the visual side of the framework, so I may be simply doing something quite stupid - but if I am I can't figure it out for the life of me. On my machine...
2
by: GitarJake | last post by:
Hello all, I am somewhat experienced in creating Access forms and would like to learn how to create applications, and convert my Access applications, in Visual Studio .net. Questions: ...
2
by: NTTVTHTA | last post by:
In MFC of Visual C++.Net, is there a way to create: 1) A combobox of all Drives in the current running computer? 2) A listbox of Directory of the current Drive? 3) A listbox of Files of the...
4
by: ApexData | last post by:
I found the following code which allows me to sort on the click event of a labelbutton. The problem occurs when I try to call the function directly from the ClickEvent, instead of having the...
0
by: Cezus | last post by:
Good day, Im a beginner at C# and i use the book Visual C# 2005: How to program from Deitel/Pearson. I want to build a simple Anime (movie) database. It contains a list box with all the anime...
0
by: noobkuku | last post by:
Guys i got this error i don know how to slove it anyone can enlighten me? http://i15.tinypic.com/4ztjzas.jpg Private Sub search_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)...
7
by: MikeB | last post by:
Hello All, I am new to ajax and wanted to start by trying something simple. I have a web form with an updatepanel and then inside the update panel I have a listbox. Then outside of the updatepanel...
1
by: COHENMARVIN | last post by:
I have an array of structures that I'd like to put in a listbox. I'd like to concatenate some of the fields together to display, but I also need one of the fields to be the value of the item. Now...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.