472,993 Members | 1,831 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

List, form and a search box

4 Nibble
Hi all,

Can I pick your brains please?

I need to a scan a serial into search box to return it's records of repair into a list box.
There will be more than one record against the same serial.
I want to be able to select a repair job from the list box to view the full details in the form below.
The db is only using 1 table.

What would be the best method of setting this up?

Thanks for your help
Jun 17 '21 #1
3 3374
32,550 Expert Mod 16PB
The way I see it there should be a table for Serials (whatever they are) as well as a table for the repair jobs. I suppose the Serial table would contain items referenced by their Serial Numbers? For now we'll call this [tblSerial].

The other table ([tblRepair] maybe.) would contain records with both a unique reference for themselves, as well as a [SerialNo] field so that each repair can be matched to its parent Serial No.

Once you have a Serial No identified (This can easily be from a ListBox or ComboBox control populated from [tblSerial].) then you can populate the original ListBox of your question from [tblRepair] using a filter for the selected Serial No.

Does all that make sense? Would you need more specific help to get this working?
Jun 18 '21 #2
4 Nibble
Thanks for your reply.

I'm making a basic booking in and logging repair system.
I've been able to get by so far using the one table by using a 'status' field which i can query off - as the record tracks through the possible stages, eg maintenance complete- returned, booked in for repair, decommissioned etc...

What i am trying to do now is just put together a general history screen for any given serial number.

So I have a history query with criteria set to match the serial to a search box.
This works fine and the list box fills with a selected few fields from the correct records.
Now I want the rest/all of the fields to be displayed in a form below , and i'm just struggling to pass this info across.
I need the listbox wizard to give me the option of get values from a query AND find a record based on my selection in the listbox! lol
maybe click on the record in the listbox to bring up the record in a pop up form, i'm playing around with this now.

Do you have any code snippets/examples of how I can acheive this?

Thanks so much for your help and interest
Jun 18 '21 #3
32,550 Expert Mod 16PB
Do you have any code snippets/examples of how I can acheive this?
Not really. We're here to help you do the work as much as anything, and I don't have anything designed the way you seem to be doing it.

I typically avoid ListBox Controls as they take up space and I still have no idea what your objects are even named so you haven't made it easy for me even to knock something up for you quickly. I still know almost nothing relevant about your problem or difficulty. I know you have a single Table which has some Fields and you want to use a Form with a ListBox. Not a great deal to work with without having to invent object names and answers - which you'd struggle to recognise of course.
Jun 18 '21 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

by: Kevin Murphy | last post by:
I receive the error message "Try to compose a less restrictive search query or check spelling" regardless of search term when attempting to search the list "PgSQL - General" via the mailing list...
by: free2cric | last post by:
Hi, I have a single link list which is sorted. structure of which is like typedef struct mylist { int num; struct mylist *next;
by: bobBaker | last post by:
Does anybody know of a good way to get a list of emails from the corporate exchange server from a corporate website?
by: nathbooth | last post by:
Hiya, I am making a system to book plane flights as a University Level 1 project, In the booking form i have, i wish to be able to search for a customers ID number to fill in this field if the...
by: Steven | last post by:
Hi, Would need some thought about using a button of the existing form to search record before deleting it. Any quick help is very appreciated. Steve
by: Jason1983 | last post by:
Hi , I am trying to create an access form with a search on the group name and all the related group IDs on this particular group name must be displayed in the combo box on the form . The group...
by: Kaosu | last post by:
I would like to know how to do a search in a text box on Form X that closes Form X and opens Form Y and looks for the information in Y. The search works perfectly when preformed while on Form Y....
by: Dbar10 | last post by:
I am working on a form in my application for a Worker Profile evrything is working fine except the Search Box. I have to be able to search on two criteria. One is the WorkStatus i.e. Active,...
by: newbie2010 | last post by:
I am currently working on a program in Access 2003. I have a form that consists of five text boxes and a search button. I want the user to be able to put search criteria into the text boxes and...
by: dincanta | last post by:
Hi, I am trying to create a database in Access that will allow the person using it to select types of criteria from different drop down combo-boxes: Department Level Degree Type Major Years...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...
by: SueHopson | last post by:
Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On...

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.