473,326 Members | 2,168 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Buttons in continuous foms

I have a save button in a continuous form called Purchase Order. The button
contains several conditional statements which make sure that all mandatory
fields are properly filled out by the user. When the button in clicked it
only applies the statement to the record the cursor is currently working on.
I would like the button to apply to all the records. I tried a Do/Loop
statement sending the focus to the next record, but once it gets to the end
I get an error message saying: "Cannot find specific record." I also have
tried a Do Until Loop and again it stops only at one record.

Any suggestions???

Thanks in advance...

Paolo
Nov 13 '05 #1
7 2006
Paolo wrote:
I have a save button in a continuous form called Purchase Order. The
button contains several conditional statements which make sure that
all mandatory fields are properly filled out by the user. When the
button in clicked it only applies the statement to the record the
cursor is currently working on. I would like the button to apply to
all the records. I tried a Do/Loop statement sending the focus to the
next record, but once it gets to the end I get an error message
saying: "Cannot find specific record." I also have tried a Do Until
Loop and again it stops only at one record.
Any suggestions???

Thanks in advance...

Paolo


I fail to see the need for this. Your validation should be applied before a
record is allowed to be saved and all of the other rows on a continuous form
have already been saved so why any need to check them?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:34*************@individual.net...
Paolo wrote:
I have a save button in a continuous form called Purchase Order. The
button contains several conditional statements which make sure that
all mandatory fields are properly filled out by the user. When the
button in clicked it only applies the statement to the record the
cursor is currently working on. I would like the button to apply to
all the records. I tried a Do/Loop statement sending the focus to the
next record, but once it gets to the end I get an error message
saying: "Cannot find specific record." I also have tried a Do Until
Loop and again it stops only at one record.
Any suggestions???

Thanks in advance...

Paolo


I fail to see the need for this. Your validation should be applied before
a record is allowed to be saved and all of the other rows on a continuous
form have already been saved so why any need to check them?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


This is what the form is for: it reports details of a specific purchase
order against the details of the supplier invoice and the details of a form
that the warehouse needs to fill out manually (count of physical stock). The
data entered has to equal from Qty Received to Qty Order and Qty Invoiced.
The same has to happen for Cost Order and Cost Invoiced. The form has 3
Variance columns that compare the details above. When the user click on the
"Save" button this button should check that every variance for each record
equals to 0.00, if it doesn't it gives a warning message and does not allow
the user to save.
Unfortunately I can't make the button check every record (or every line) it
just stops at the one where the cursor is flashing...
I hope I made a little more sense this time....
Thanks again for your help
Nov 13 '05 #3
I go along with what Rick said. When you go from one record to another in a
continuous form, the first record gets saved. It's too late to go back and
check the first record.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Paolo" <pr*****@netspace.net.au> wrote in message
news:cr***********@otis.netspace.net.au...

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:34*************@individual.net...
Paolo wrote:
I have a save button in a continuous form called Purchase Order. The
button contains several conditional statements which make sure that
all mandatory fields are properly filled out by the user. When the
button in clicked it only applies the statement to the record the
cursor is currently working on. I would like the button to apply to
all the records. I tried a Do/Loop statement sending the focus to the
next record, but once it gets to the end I get an error message
saying: "Cannot find specific record." I also have tried a Do Until
Loop and again it stops only at one record.
Any suggestions???

Thanks in advance...

Paolo
I fail to see the need for this. Your validation should be applied before a record is allowed to be saved and all of the other rows on a continuous form have already been saved so why any need to check them?

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com


This is what the form is for: it reports details of a specific purchase
order against the details of the supplier invoice and the details of a

form that the warehouse needs to fill out manually (count of physical stock). The data entered has to equal from Qty Received to Qty Order and Qty Invoiced.
The same has to happen for Cost Order and Cost Invoiced. The form has 3
Variance columns that compare the details above. When the user click on the "Save" button this button should check that every variance for each record
equals to 0.00, if it doesn't it gives a warning message and does not allow the user to save.
Unfortunately I can't make the button check every record (or every line) it just stops at the one where the cursor is flashing...
I hope I made a little more sense this time....
Thanks again for your help

Nov 13 '05 #4
Paolo wrote:
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:34*************@individual.net...
I fail to see the need for this. Your validation should be applied
before a record is allowed to be saved and all of the other rows on
a continuous form have already been saved so why any need to check
them?

This is what the form is for: it reports details of a specific
purchase order against the details of the supplier invoice and the
details of a form that the warehouse needs to fill out manually
(count of physical stock). The data entered has to equal from Qty
Received to Qty Order and Qty Invoiced. The same has to happen for
Cost Order and Cost Invoiced. The form has 3 Variance columns that
compare the details above. When the user click on the "Save" button
this button should check that every variance for each record equals
to 0.00, if it doesn't it gives a warning message and does not allow
the user to save. Unfortunately I can't make the button check every record (or
every
line) it just stops at the one where the cursor is flashing...
I hope I made a little more sense this time....
Thanks again for your help


I still don't fully understand your situation, but I can see where you might be
performing this validation after-the-fact and would need to examine all records.
However; in that scenario you do not want to use the Save event for this and
prevent saving the currenmt record if there is a problem found because the
problem might exist on a different record than the current one. Now the user
needs to fix record 3, but he is stuck on record 4 because you won't let him
save it due to the problems in record 3.

Basically you would need to use the RecordSetClone of the form and then loop
through that testing each record in sequence. Then you could display a message
box when problems are found, but again I think you still have to let the current
record be saved unless the problem found is ON the current record.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Nov 13 '05 #5

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:34*************@individual.net...
Paolo wrote:
"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:34*************@individual.net...
I fail to see the need for this. Your validation should be applied
before a record is allowed to be saved and all of the other rows on
a continuous form have already been saved so why any need to check
them? This is what the form is for: it reports details of a specific
purchase order against the details of the supplier invoice and the
details of a form that the warehouse needs to fill out manually
(count of physical stock). The data entered has to equal from Qty
Received to Qty Order and Qty Invoiced. The same has to happen for
Cost Order and Cost Invoiced. The form has 3 Variance columns that
compare the details above. When the user click on the "Save" button
this button should check that every variance for each record equals
to 0.00, if it doesn't it gives a warning message and does not allow
the user to save. Unfortunately I can't make the button check every
record (or every
line) it just stops at the one where the cursor is flashing...
I hope I made a little more sense this time....
Thanks again for your help


I still don't fully understand your situation, but I can see where you
might be performing this validation after-the-fact and would need to
examine all records. However; in that scenario you do not want to use the
Save event for this and prevent saving the currenmt record if there is a
problem found because the problem might exist on a different record than
the current one. Now the user needs to fix record 3, but he is stuck on
record 4 because you won't let him save it due to the problems in record
3.

Basically you would need to use the RecordSetClone of the form and then
loop through that testing each record in sequence. Then you could display
a message box when problems are found, but again I think you still have to
let the current record be saved unless the problem found is ON the current
record.
Actually I want to prevent the user from saving a specific record unless
every line on the order is correct, that's why it's important for me that
the user cannot just save one line and close the form. Every line of the
invoice must match every line of the order 100% otherwise I don't want to
allow the user to go forward....


How do you use the RecordSetClose could you give me an example?

Thank you again for your patience...I am just starting to write VBA
statement and really really struggling with them...

Paolo

Nov 13 '05 #6
Paolo wrote:

Actually I want to prevent the user from saving a specific record
unless every line on the order is correct, that's why it's important
for me that the user cannot just save one line and close the form.
Every line of the invoice must match every line of the order 100%
otherwise I don't want to allow the user to go forward....


How do you use the RecordSetClose could you give me an example?

Thank you again for your patience...I am just starting to write VBA
statement and really really struggling with them...


Ok, now we're back to what I originally said. In a continuous form each line is
saved to disk as soon as you move to a different line. So there is no need to
check line1 when you are finished entering line2 because line1 was already
checked when it was entered.

IOW if you check each line as it is entered, then there is no need to check any
line except for the one you are currently working on.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #7

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:34*************@individual.net...
Paolo wrote:

Actually I want to prevent the user from saving a specific record
unless every line on the order is correct, that's why it's important
for me that the user cannot just save one line and close the form.
Every line of the invoice must match every line of the order 100%
otherwise I don't want to allow the user to go forward....


How do you use the RecordSetClose could you give me an example?

Thank you again for your patience...I am just starting to write VBA
statement and really really struggling with them...


Ok, now we're back to what I originally said. In a continuous form each
line is saved to disk as soon as you move to a different line. So there
is no need to check line1 when you are finished entering line2 because
line1 was already checked when it was entered.

IOW if you check each line as it is entered, then there is no need to
check any line except for the one you are currently working on.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

No I have to make sure that the user has typed the right data on each line
the then the access can resave the record I am aware of the fact that each
record is saved once the user goes to the next line but I need to make sure
the used do type the details from the Invoice and from the count form before
they can close the form. Therefore I need Access to check that every line
has all the relevant fields filled out and that the no variances between
Invoice and Orders are reported...
Nov 13 '05 #8

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Karl Roes | last post by:
Hi All, I would like some advice on Next / Previous record buttons. I have a main form for the client, and a continuous subform listing client transactions. If I open one of these transactions...
4
by: Kathy | last post by:
What is the standard technique for handling the fields in the following scenario on a continuous form? Multiple Divisions. Each Division has multiple Buildings. Each Building has a Supervisor. ...
5
by: Axel | last post by:
An Access 2000 question Hi is is possible to have (as a subform) a continous form with 0..n buttons which have different images in each row. (Personally I would have preferred a button...
2
by: ghadley_00 | last post by:
Hi, I have a database with a main table and a lookup table of customers, and reports for each of the customers listing each transaction they have listed. I have a form that has buttons for...
2
by: alomrani | last post by:
Hi all , I'd appreciate anyone insight on this I have created a form that fetched rows from a query. On each row I have added buttons to execute command for that relevant row only. The Form...
14
by: ApexData | last post by:
In my database, I uniformly handle records on a Record by Record basis, in a single form that contains New/Edit/Del buttons. Because I'm dealing with records one at a time, I can easily manage my...
1
by: Kevin | last post by:
I'm using a series of command buttons A - Z to filter a list of contacts. I'd like to change the functionality so that by pressing one of the buttons, access will jump to the first entry beginning...
2
by: Steve | last post by:
I have a continuous form showing Product Code and Product Name. Product Code is five digits and is sequential. I have a textbox in the form header. What is the code to scroll the continuous form so...
2
by: 6afraidbecause789 | last post by:
Hi - Has anyone ever used toggle buttons to select items in a listbox? I'd like to put about 24 toggle buttons on an unbound form that select or deselect items in a multiple select listbox. I've...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.