I've got a form (frmViewRequest s) that has the DefaultView set to
Continuous (that's how I want it ... so far, so good)
On this form, I've got a "Create New Request" Button that opens another
form (frmCreateReque st).
When the request has been created, the frmCreateReques t form is closed,
bringing me back to frmViewRequests .
Here's the problem ... the number of "individual forms" never changes,
therefore, if I had 2 records in my table, the form would have given me
2 "individual forms" within my "continuous " form. If I add a record,
there are still only 2 "individual forms". If I close my form and open
it again, it opens with 3 "individual forms". If I delete one, the
"individual form" of the record I deleted is still there with "#Deleted"
in the fields for that "individual form".
I want the frmViewRequests to instantaneously reflect the new entry ...
just as the underlying table does.
Any and all help is appreciated.
Sorry about the bad sentence construction (I was never schooled in
English)
1  5212 
Requery frmViewRequests .
Refresh (if that's what you're doing now) just updates existing records, but
doesn't take account of deleted or inserted records.
HTH, Mike MacSween
"Lauzon, Robert: IHAB" <La***********@ ic.gc.ca> wrote in message
news:3E******** *************** *************** @pubgate-01.ic.gc.ca... I've got a form (frmViewRequest s) that has the DefaultView set to
Continuous (that's how I want it ... so far, so good)
On this form, I've got a "Create New Request" Button that opens another
form (frmCreateReque st).
When the request has been created, the frmCreateReques t form is closed,
bringing me back to frmViewRequests .
Here's the problem ... the number of "individual forms" never changes,
therefore, if I had 2 records in my table, the form would have given me
2 "individual forms" within my "continuous " form. If I add a record,
there are still only 2 "individual forms". If I close my form and open
it again, it opens with 3 "individual forms". If I delete one, the
"individual form" of the record I deleted is still there with "#Deleted"
in the fields for that "individual form".
I want the frmViewRequests to instantaneously reflect the new entry ...
just as the underlying table does.
Any and all help is appreciated.
Sorry about the bad sentence construction (I was never schooled in
English)
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Damian |
last post by:
Hi.
Is there a way to programatically populate a continuous form?
I have an array of descriptions that I want to display in the
continuous form and I have a textbox on the form called
'txtDescription'
I can populate the text box using this code:
Me.txtDescription.Value = myArray(1)
Trouble is, I can't figure out how to get more than 1 row to display
|
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: debbie |
last post by:
Well I'm finally trying out class modules...I have a great book I'm
using but its ADO and I use DAO so it's a challenge for me...I've
looked most of today, in my book and here but can not find an answer.
Is it possible to use the class I've created to fill a continuous form?
Not finding any information leads me to believe that it can't be
done...
I have a continuous form that shows all invoices with a balance
due...I'm hoping to use the...
|
by: Jeremy Wallace |
last post by:
Folks,
Here's a write-up I did for our developer wiki. I don't know if the
whole rest of the world has already figured out how to do this, but I
hadn't ever seen it implemented, and had spent a lot of time trying to
figure it out, over the years. It finally dawned on me a couple of
weeks ago how to do this.
A couple of notes:
1) This is written for a different audience than CDMA; it's written for
|
by: Welie |
last post by:
I am having a problem an it's driving me crazy, I hope someone can
correct my technique. I can't find a pattern and don't know where to
look to debug this. The problem is on a continuous form, the rows seem
to become unsynchronized. From lack of experience I am probably doing
something wrong. Let me explain...
I have a select query which joins 2 tables, an Appointment table and
Payments table and presents the data as rows on the bound...
| | |
by: Michael R |
last post by:
Searching the net I've found a simple technique to add row numbers and alternate colors (for the even and the uneven row) to a continuous form.
1st step: Create a textbox, send it to background and select the first color.
.ControlSouce =fRowNum(False)
.Name = RowNum
2nd step: Add the following function to the form module: (for row numbers)
Public Function fRowNum(Reset As Boolean) As Long
Static I As Integer
|
by: virtualgreek |
last post by:
Dear all,
I have a scenario that is driving me nuts. (MS Access 2003)
I have a form/subform (Continuous form) where it gets its data from tables Order and Order_Details.
In the footer section of the subform I have a hidden textbox named txtOrder_Total_Amount which displays the total of the whole order. On the main form I have a bound contol from the Order table, namely Order.Order_Total_Amount_Euro
On the subform I have fields such...
|
by: Jollywg |
last post by:
I have a continuous form with 5 columns (Qty, PartNum, Desc, ItemCost, TotalCos). At the bottom of the form i have a field labeled Invoice Total. Right now the Invoice Total is totaling everything in my tblInvoice. I need it to only total what rows that begin with the same InvoiceNumber. Here is what i have so far.
Private Sub UpdateInvoice()
Dim rsItemMaster As ADODB.Recordset
Dim rsInvoice As ADODB.Recordset
Set...
|
by: bkberg05 |
last post by:
Hi - I have a field called Sequence on a continuous subform. The Sequence field belongs to a table called Project_Draw. This table has many 'Draw' records for each 'Project' record. So then the subform is tied to the main form by Project_ID.
I want the Sequence field to automatically increment each time I add a new record. I can't use the autonumber as I need to start a new sequence for each new Project_ID.
I've tried putting a max()...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: 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: 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: 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: 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...
| |
