Greetings,
I have a form, frmProgressRepo rts, with qryProgressRepo rts as the
recordsource. A field in the query is named 'Select" and is yes/no,
with criteria set to true. This filters the form so that only
students who are in a teacher's class are available in the form.
At the top of the form is an unbound combobox, cboStudents, used to
quickly navigate to a student's records. The reason it is unbound is
because there are a couple of label events that change the rowsource
of the combo to sort by FirstName or LastName.
The 2 different rowsources (queries) of cboStudents also contain the
field 'Select' = true, showing only the students that a teacher
selects.
An event from cboStudents opens an frmAddStudent form, which is also
based off of qryProgressRepo rts. If a teacher wants to add a student
using this form, the frmProgressRepo rts will not update properly. The
default setting for the 'Select' field is true for new records. But,
the entire form must be closed and reopened before the newly-added
student appears.
I have seen posts with similar problems, but they do not solve this
problem. Requerying, refreshing, and toggling recordsources do not
fix the problem. Any insights would be greatly appreciated.
Thanks,
Arnold
1  1576 
well, requerying *should* work, as long as you are requerying both
frmProgressRepo rts AND cboStudents. you could try running the requery
commands on frmProgressRepo rts' Close event, as
If Me.Dirty Then Me.Dirty = False
DoCmd.Close , , acSaveNo
With Forms!frmProgre ssReports
.Requery
!cboStudents.Re query
End With
hth
"Arnold" <er*********@ya hoo.comwrote in message
news:11******** **************@ l22g2000prc.goo glegroups.com.. .
Greetings,
I have a form, frmProgressRepo rts, with qryProgressRepo rts as the
recordsource. A field in the query is named 'Select" and is yes/no,
with criteria set to true. This filters the form so that only
students who are in a teacher's class are available in the form.
At the top of the form is an unbound combobox, cboStudents, used to
quickly navigate to a student's records. The reason it is unbound is
because there are a couple of label events that change the rowsource
of the combo to sort by FirstName or LastName.
The 2 different rowsources (queries) of cboStudents also contain the
field 'Select' = true, showing only the students that a teacher
selects.
An event from cboStudents opens an frmAddStudent form, which is also
based off of qryProgressRepo rts. If a teacher wants to add a student
using this form, the frmProgressRepo rts will not update properly. The
default setting for the 'Select' field is true for new records. But,
the entire form must be closed and reopened before the newly-added
student appears.
I have seen posts with similar problems, but they do not solve this
problem. Requerying, refreshing, and toggling recordsources do not
fix the problem. Any insights would be greatly appreciated.
Thanks,
Arnold
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: AAVF |
last post by:
Hi
We have a problem with a query.
An Access database links via ODBC to a UNIX server. To speed things, we use
the ODBC to load the relevant tables to the local PC that runs Access so
that all querying is done locally.
One of the reports we run allows the user to list all invoices within a
period. They are also allowed to select a customer code and a product set on
|
by: William Wisnieski |
last post by:
Hello Everyone,
I have a main form with a datasheet subform that I use to query by form.
After the user selects two criteria on the main form and clicks the
cmdShowResults button on the main form, the subform returns the records
based on the two criteria. The criteria used on the main form are values
selected in two list boxes. When the user clicks on the first list box
(lstCollege), it returns values in the second list box...
|
by: S. van Beek |
last post by:
Dear reader,
How can I filter a numeric field with Like as criteria in a query.
To filter a numeric field with <10 as criteria this will com back with the
result of those records for which the value is smaller as teen.
But in case this value is variable and you prefer to work with "Like
|
by: DW |
last post by:
I have a query in Access 2003 that has the following criteria
SELECT tblOrder.SessionDate, tblMenus.Item_Name, tblOrder.Type,
Format$(tblorder!SessionDate,"Short Time") AS SessionTime,
Sum(tblMenus.Item_Quantity) AS MenuCount INTO tblSessionQuery
FROM tblOrder, tblMenus
WHERE (((tblOrder.Order_ID)=.) AND
((Format$(!,"mm/dd/yyyy")) Between
Format$(!!,"mm/dd/yyyy") And
Format$(!!,"mm/dd/yyyy")))
|
by: rreitsma |
last post by:
I want to create a form that will allow the user to select from a list of
available reports and based on a filter limit the records displayed in the
report. I have figured out how to access the reports collection to populate
a list box containing the report names. The filter I currently have lists
some key fields that I think the user may want to filter on. A WHERE string
is constructed based on the feilds that the user inputs values into....
| | |
by: Col |
last post by:
I have a query with criteria that comes from a combo box on a form. I'd
like to set the query up so the user can either limit the criteria to
the selection in the combo box or the user can pull all records. Can't
figure out a way for the query to pull all records. Currently uses the
criteria !!. I've tried a couple of things
to allow for the option of all records, but without any luck. Any
suggestions?
|
by: davidevan |
last post by:
What I'm trying to do is set a players division according to their age.
So if age is 8, update division to junior, if age is 9, update division
to medium, if age is 10, update division to pee wee, and etc.
I'm trying to accomplish this in a single query, and be able to run
this query and verify that players are in the right division.
Is it possible to update multiple records in a table with a single
query while having criteria?
|
by: Mark Roughton |
last post by:
I have a form where the users need to view records for various
criteria, one of which is a date field on which they may wish to view
all related data for the selected date, for all dates upto and icluding
the selected date or all records on or after the selected date
The user selects either "=", >=" or "<=" from a combo box and then a
date from another combobox. The combination of thse two choices is
then set in an unbound textbox so...
|
by: sfrvn |
last post by:
I have searched high and low and cannot find an answer to my problem.
So now I turn to the collective genius of this newsgroup.
Over-simplified examples
This query criteria for field works:
IIf(1=1,#3/12/2007#,#3/12/2007#)
1=1 will be replaced by actual 'test'; I just want to make sure
expression evaluates 'true'
Query returns all records where field equals
3/12/2007date
|
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: 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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
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
| |
