I have a list box which show all the Supplier PO Numbers, on the Right of the list box there is a command button called "Add", If user click the "Add' Button it will create a new PO
DoCmd.OpenForm "frmPO", , , stLinkCriteria, acFormAdd
In the New PO Form, If user decide to undo, user click the Undo button
me.undo
It seem like it cannot be undo, so I issue a delete and undo the current record , this time no complain from Ms Access,
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Me.Undo
DoCmd.Close
But when I return to the listbox, another new PO number was auto created.
What wrong with it ? Iwhich is the better or correct method.
Please Advise
4 3703 PEB 1,418
Expert 1GB
Hi,
Your PO number is it an autonumber, or it is a number that u introduces using append query?
In fact DoCmd.OpenForm "frmPO", , , stLinkCriteria, acFormAdd oppens a new form that is ready for adding information.... I don't see how it is inserted automatically the information about your PO number? It should be introduced automatically or taped manually?
If it is an auto number your PO so there is no Undo command that can restore the previous autonumber!
For more help, can u describe how do u introduce your PO number /auto generation, or user have to introduce it/?
If it is the introduction of This PO number you can do it using a field from your current form without opening a new form destinated to this introduction! Only using an append query!
Marry Cristmas!
I have a list box which show all the Supplier PO Numbers, on the Right of the list box there is a command button called "Add", If user click the "Add' Button it will create a new PO
DoCmd.OpenForm "frmPO", , , stLinkCriteria, acFormAdd
In the New PO Form, If user decide to undo, user click the Undo button
me.undo
It seem like it cannot be undo, so I issue a delete and undo the current record , this time no complain from Ms Access,
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Me.Undo
DoCmd.Close
But when I return to the listbox, another new PO number was auto created.
What wrong with it ? Iwhich is the better or correct method.
Please Advise
Hi,
Your PO number is it an autonumber, or it is a number that u introduces using append query?
In fact DoCmd.OpenForm "frmPO", , , stLinkCriteria, acFormAdd oppens a new form that is ready for adding information.... I don't see how it is inserted automatically the information about your PO number? It should be introduced automatically or taped manually?
If it is an auto number your PO so there is no Undo command that can restore the previous autonumber!
For more help, can u describe how do u introduce your PO number /auto generation, or user have to introduce it/?
If it is the introduction of This PO number you can do it using a field from your current form without opening a new form destinated to this introduction! Only using an append query!
Marry Cristmas!
Hi Merry Christmas to you, The PO is an auto number, so what should I do to overcome this problem, please help
Hi,
Your PO number is it an autonumber, or it is a number that u introduces using append query?
In fact DoCmd.OpenForm "frmPO", , , stLinkCriteria, acFormAdd oppens a new form that is ready for adding information.... I don't see how it is inserted automatically the information about your PO number? It should be introduced automatically or taped manually?
If it is an auto number your PO so there is no Undo command that can restore the previous autonumber!
For more help, can u describe how do u introduce your PO number /auto generation, or user have to introduce it/?
If it is the introduction of This PO number you can do it using a field from your current form without opening a new form destinated to this introduction! Only using an append query!
Marry Cristmas!
It is an auto number, when user click the Add button, it will open up the PO form, (I did not use Query Append), if user enter information in the form, the PO number example 100 will be show, next user click the undo button, so the form is close, to my surprise the listbox that show all PO have generated a PO 101 with blank information.
It is an auto number, when user click the Add button, it will open up the PO form, (I did not use Query Append), if user enter information in the form, the PO number example 100 will be show, next user click the undo button, so the form is close, to my surprise the listbox that show all PO have generated a PO 101 with blank information.
Set one of the other fields to required and the record will not be saved.
Mary
Sign in to post your reply or Sign up for a free account.
Similar topics
by: John |
last post by:
Hi,
I've recently upgraded from Access 97 to Access 2002 & the performance
basically stinks. I have tried the following items listed below but it
has only had a minor impact:
1) Upgraded Jet...
|
by: bobdydd |
last post by:
Access 2000 Windows XP
Hi Everybody
I have got a weird one here.
I have a large form frmTransactions based on a single table
tblTransactions.
There are a lot of fields on the form but...
|
by: DeanL |
last post by:
I know you can convert a database from Access 2003 to 97 easily but is
there anything that I should avoid doing in Access 2003 that might make
my database incompatible with Access 97?
Many...
|
by: raylopez99 |
last post by:
I am trying to program a database from inside C++.NET via Visual
Studio 2005 using the ADO.NET set of classes, but this I believe is a
SQL Server 2005 Express permissions question under Windows XP...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |