Hello,
I have a few questions. But first I'll give a little bit of info about my database. I'm creating a issue tracker, in a sense. It will be used to enter calls from customers for upgrades, bugs, reports, ect. There is a main form for information to be entered into the database. Then there is also a search and edit form, so if you need to enter addtional information for a specific product, you would search a continuous form and edit it. I have never done a database in my life, I was given this project to help out a department in my company.
My first question is:
I have a form, with a continuous subform (the search and edit form) in it to display all the current issues. I want to be able to sort that subform, first by client, than by status. How would I do this?
Next, there needs to be an option to "Add additional comments" associated with each record, that will automatically save when information is entered into there add. comments field. This needs to be a pop up box though.
I appreciate anyones help and thank you in advanced.
7  1890  NeoPa 32,578
Recognized Expert Moderator MVP
Ordering of data in a form, any form, can be done either by providing a sorted query as the Record Source, or by setting the Order By property of the form itself.
NeoPa 32,578
Recognized Expert Moderator MVP
For your second question (generally better to post separate questions in separate threads for future reference), it's not very clear how your "Comments" are stored.
In general, you can put some VBA code behind a Command Button which will open a new form if you like. For more specific help the question will need to be more specific I'm afraid.
For the first question regarding the sorting the cont form. I want to have a drop down that will show the products, followed by a drop down that will have the status. Once those are selected, the continuous form will populate the appropriate records.
With regards to the second question, I would need to additional comments to be stored back into the main issue table
NeoPa 32,578
Recognized Expert Moderator MVP
For the first question regarding the sorting the cont form. I want to have a drop down that will show the products, followed by a drop down that will have the status. Once those are selected, the continuous form will populate the appropriate records.
...
I don't see any connection to the first question (which has been answered fully as far as I can see).
...
With regards to the second question, I would need to additional comments to be stored back into the main issue table
This explains nothing. If anything it makes what you're after less clear. It's not even a sentence.
PS. If you can't get your questions to make sense then how can you expect a response.
With regards to the Continuous form....
I have a form with a continuous subform in it. I want to be able to filter the subform. For example, say a customer calls and wants to check the progress on an issue. I want to be able to filter my continuous form first by the customer, than by the status (active). This should then only display the records for that customer that are active.
With regards to the additional comments...
Within the continuous form, I would like to have an "Additional Comments" button. When this button is clicked I need a pop up form so they can enter additional information. Once they enter the additional information, it needs to be saved on the issues table (with all the other information), the only problem I am having is the fact that each issues can have many additional comments. How would I do this so that it can save multiple "Additional comments" per issue
NeoPa 32,578
Recognized Expert Moderator MVP
With regards to the Continuous form....
I have a form with a continuous subform in it. I want to be able to filter the subform. For example, say a customer calls and wants to check the progress on an issue. I want to be able to filter my continuous form first by the customer, than by the status (active). This should then only display the records for that customer that are active.
Well, to filter a subform, set the Filter property of the form within the subform control. How this is executed depends on when you know what you want, and the link between the main form and the subform.
In this case I suspect you want to set the .Filter property within the code directly. Have a look at Referring to Items on a Sub-Form to see how to reference this property from the code of the main form.
NeoPa 32,578
Recognized Expert Moderator MVP
With regards to the additional comments...
Within the continuous form, I would like to have an "Additional Comments" button. When this button is clicked I need a pop up form so they can enter additional information. Once they enter the additional information, it needs to be saved on the issues table (with all the other information), the only problem I am having is the fact that each issues can have many additional comments. How would I do this so that it can save multiple "Additional comments" per issue
It really makes little sense asking this question without first explaining how the data is stored. What is the data structure in your database?
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Keith Shearer |
last post by:
I'm having a bit of trouble, moving between controls, when filtering on a
form.
I'm using a continuous form. At the top I have 2 date fields. I want to
filter the data specified between the two date fields ...
The problem is ... I'm doing my filtering on the afterupdate event. So I
type in a date and press TAB. The filter works and automatically refreshes
the form, then the cursor does not move on to the next control, but comes
back to...
|
by: Richard Hollenbeck |
last post by:
I have the following query in my form's code:
Private Function Get_Data(fieldNum As Integer)
Dim strSQL As String
Dim db As DAO.Database
Dim rs As DAO.Recordset
strSQL = "SELECT & "", "" & AS Student,
activities.activityDescription, studentScores.score FROM groups INNER JOIN
(students INNER JOIN (activities INNER JOIN studentScores ON
|
by: Chantelle |
last post by:
I've got this A2K DB that has a continuous form that lists Suppliers
and their details. The form has a field for each supplier that holds
several Keywords that reflect the suppliers products or services.
I am new to writing VB but managed to create a command button that
filters the form based on a keyword that I type into a text box . The
code I have is :-
Dim strFilter As String
|
by: panwala_bhavesh |
last post by:
Thanks in advance... I have a form displaying the results of a query in
a continuous form style. I want to be able to double-click on the key
field of the form (a textbox, in this case a AssetID) and use this to
populate the AssetID textbox of another form. Any ideas on how to link
these?
Thanks!
Bhavesh
|
by: Katie |
last post by:
I need to store a history of two fields in two seperate tables:
Event - where the key is Event_ID
Stage - where the key is Stage_ID
The joins are:
Main Table
Event Table
Stage Table
My screen has:
| | |
by: Harry Haller |
last post by:
Hello, I want to implement a generic list which will be used to
display 7 columns in a GridView. One should be able to sort, filter
and page each of the 7 columns. Ideally the filter should be
implemented simultaneously for multiple columns - but the data need
only be sorted by a single column at a time. Sorting should be both
ascending and descending.
I'm currently using a DataView but it's far too slow, because there
are a large...
|
by: rpboll |
last post by:
I am looking for the best way to accomplish the following continuous
forms concept.
There are Five Groups: A, B, C, D, E
Each group has eight Members: a, b, c, d, e, f, g, h
Each Member is seen as a row in a continuous form like:
|
by: G04 |
last post by:
Hi All,
I have a continuous form with all records. For each field there is a combo in the form header and the form also contains a Toggle button "Apply Filter".
When clicked, it changes to "Cancel Filter".
Then an SQL string with condition meeting the criteria input in the combo boxes is built.
I have noticed that when certain fields are not filled in (no space, nothing), the record is simply not shown. The empty field is not necessarily...
|
by: Kevin |
last post by:
I want to use a set of check boxes to narrow down entries on a subform. I.e.
a check box for black, red & green to describe the colors of a product. So a
use clicks Black and only black products are shown, the click green and only
black and green products are shown. There will be a large number of choices
that a user can make so I'm wondering...
can I right a bit of code or function and put in a seperate module to call
from an after...
|
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: 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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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: 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...
| |
