Please Help!
I have read over and over again to go to Allen Browne's website to
filter subforms, but I just don't understand it, and I can't get it to
work in my situation. Any advice is very appreciated.
I have 2 forms. Mainform=Custom ers Subform(linked) =Service
Requests.
The two forms have a one to many relationship (many service requests
per customer) and are related by customer number (auto number that
automatically is filled in subform to match field on mainform). Each
service request has a txtBox for TicketID. I want to be able to
search through all of the TicketIDs in all of the customer's service
requests (TicketID is not an auto number and can't be used as primary
key-it is a number typed from a tablet of paper with a number at the
top-there could be multiple instances of this number if he orders a
new tablet of paper and it starts with the same number-very very small
company). I have created another subform (which may not be needed,
but I thought it might help) that just displays the TicketIDs (all
TicketIDs related to the customer number) from the service request
table on the mainform.
The search button that the wizard creates will not even search the
TicketIDs on the current customer ID's page, none the less searching
through all customer's pages to find the corresponding Ticket IDs. And
when I put the search button in the subform, it will only search for
TicketIDs related to the current customer number (which I like)
Is what I am trying to do possible? I am VERY new to Access (about 2
weeks into it) and just want to make this database for my family's
Clock Shop. Thank you for any help you can provide!
2  1511 
See:
Filter a Form on a Field in a Subform
at: http://allenbrowne.com/ser-28.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Robert Jacobs" <ro************ @gmail.comwrote in message
news:11******** **************@ b75g2000hsg.goo glegroups.com.. .
Please Help!
I have read over and over again to go to Allen Browne's website to
filter subforms, but I just don't understand it, and I can't get it to
work in my situation. Any advice is very appreciated.
I have 2 forms. Mainform=Custom ers Subform(linked) =Service
Requests.
The two forms have a one to many relationship (many service requests
per customer) and are related by customer number (auto number that
automatically is filled in subform to match field on mainform). Each
service request has a txtBox for TicketID. I want to be able to
search through all of the TicketIDs in all of the customer's service
requests (TicketID is not an auto number and can't be used as primary
key-it is a number typed from a tablet of paper with a number at the
top-there could be multiple instances of this number if he orders a
new tablet of paper and it starts with the same number-very very small
company). I have created another subform (which may not be needed,
but I thought it might help) that just displays the TicketIDs (all
TicketIDs related to the customer number) from the service request
table on the mainform.
The search button that the wizard creates will not even search the
TicketIDs on the current customer ID's page, none the less searching
through all customer's pages to find the corresponding Ticket IDs. And
when I put the search button in the subform, it will only search for
TicketIDs related to the current customer number (which I like)
Is what I am trying to do possible? I am VERY new to Access (about 2
weeks into it) and just want to make this database for my family's
Clock Shop. Thank you for any help you can provide!
On Apr 6, 9:28 am, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
See:
Filter a Form on a Field in a Subform
at:
http://allenbrowne.com/ser-28.html
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Robert Jacobs" <robertjacob... @gmail.comwrote in message
news:11******** **************@ b75g2000hsg.goo glegroups.com.. .
Please Help!
I have read over and over again to go to Allen Browne's website to
filter subforms, but I just don't understand it, and I can't get it to
work in my situation. Any advice is very appreciated.
I have 2 forms. Mainform=Custom ers Subform(linked) =Service
Requests.
The two forms have a one to many relationship (many service requests
per customer) and are related by customer number (auto number that
automatically is filled in subform to match field on mainform). Each
service request has a txtBox for TicketID. I want to be able to
search through all of the TicketIDs in all of the customer's service
requests (TicketID is not an auto number and can't be used as primary
key-it is a number typed from a tablet of paper with a number at the
top-there could be multiple instances of this number if he orders a
new tablet of paper and it starts with the same number-very very small
company). I have created another subform (which may not be needed,
but I thought it might help) that just displays the TicketIDs (all
TicketIDs related to the customer number) from the service request
table on the mainform.
The search button that the wizard creates will not even search the
TicketIDs on the current customer ID's page, none the less searching
through all customer's pages to find the corresponding Ticket IDs. And
when I put the search button in the subform, it will only search for
TicketIDs related to the current customer number (which I like)
Is what I am trying to do possible? I am VERY new to Access (about 2
weeks into it) and just want to make this database for my family's
Clock Shop. Thank you for any help you can provide!- Hide quoted text -
- Show quoted text -
Continuing conversation at: http://groups.google.com/group/micro...c2a882649f342e This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: M Wells |
last post by:
Hi All,
I am developing an Access 2003 project application with the back end
in SQL Server 2003.
I have a master form that tracks projects, and several subforms on it
that track various aspects of the project. On the masterform I have
two unbound listboxes that I populate with information regarding the
current record in one of the subforms.
|
by: Christopher Koh |
last post by:
I will make a form which will search the database (just like google
interface) that will look/match for the exact name in the records of a
given fieldname. Any suggestions on how to make the code?
|
by: Jack |
last post by:
Hi all,
I searched the archives and found everyone happy with Stephen's
MouseWheel On/Off code except for those with subforms. Stephen's page
indicates that he has added code to handle subforms ("Bug Fix for
SubForms with ScrollBars. Bug fix for SubForms without visible
ScrollBars.") - BUT I still can't get it to work on my app with my
subforms.
I'm using Access 2000, It works fine on the main forms but not on the
|
by: Jack |
last post by:
Gday everyone,
I'm dearly hoping Stephen Lebans is going to update his masterpeice to
stop the mouse wheel scrolling to work on subforms *he has indicated
this to me but of course beggers can't be choosers here so I have no
idea when this would be done*. I'm just wondering if anyone has gotten
around the problem some other way?
--Original Thread---
|
by: Stu |
last post by:
Hi, I've been looking through the archives but can't find what I'm
looking for, or due to my limited experience with Access97, didn't
recognize it...
I've created a database that is going to be used for updating
procedures at several different sites, and am stumped at creating a
search feature. There is one main form with six subforms linked to it,
and I'm not sure the best way to set up the search parameters. I'm
still learning VB and...
| | |
by: pemigh |
last post by:
I have an almost-ready-to-install database with one problem. Data is
displayed chronologically, and when the user goes to the last record
and searches up to get most recent results, he often encounters a
critical error and the whole thing shuts down, often with no message at
all. (So often that I wasn't able to capture a message before writing
this.)
Testing on my machine doesn't cause a shutdown, but I do notice that
searching up...
|
by: Elainie |
last post by:
I would like to search a form with many fields on it, with out using
the search facility through access. Througth a drop down list if
possible.... How would I go about this? How could I also create this
from a top bar menu option too...?
Elaine
|
by: nchin61 |
last post by:
Hi everyone,
I'm an access advanced-beginner, mainly self taught and I'm building a fairly simple parent/child database. I have a table of companies, and a table of contacts at those companies linked by the CompanyID.
I have a master form displaying company info and then a subform showing all the contacts at that company.
I know how to search the master form for a particular company and display that record, and I presume it would be...
|
by: NMarks |
last post by:
Hello all,
I have created a database for my work that stores information for keys/locks, doors and employees.
Specifically the database contains all the information of our lock system, which doors certain locks are attached to and what employees have keys to certain locks.
The form has 3 subforms, 1 is the Key List which is basically the master subform as the other 2 subforms are a Door List and Staff List both of which are linked to...
|
by: zandiT |
last post by:
Hello everyone
i have a mainform called frmMain and it has 2 subforms. the frmMain consists of 2 combo boxes. i want to create a search form whereby the user can choose an option in combo1 and in combo 2 then the matching record appears in the subforms . i tried using the find button in access but the search form is too confusing for users so i would like to create a form that is more straight forward. your help is greatly appreciated.
|
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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 into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
