473,322 Members | 1,314 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,322 software developers and data experts.

Delete entry from form, using expression builder or VBA

Hi All,

Right now I have a User Entry form, and it has 4 bounded text boxes form users to enter information. I created an addition combo box for with option "Yes", "Reject", and "Delete". The function I am looking for right now is, when the user entered the 4 entries and click "Delete" then click Enter, the 4 entries will be deleted and they will not be recorded into the bounded table.

The problem is that, I believe because the 4 text boxes are now bounded with the table. Each time the user enters information into 4 text boxes, and click Enter to the combo box, the information has already been entered into the bounded table.

Any Solutions??

I am entirely new to Access, so any help will be appreciated.

Thanks
Nov 6 '15 #1
3 1097
zmbd
5,501 Expert Mod 4TB
Bound textboxes will alter/enter the data in the table as soon as the user "saves" the record either by moving to a new record, a different record, or by explicit save.

Help us to help you by providing a bit more information about what it is that you are attempting to accomplish here.

It will also be very helpful to know:
Operating system (pc/mac - OS version)
Office version
Your level of expertise in developing databases.
Nov 7 '15 #2
I'm working on Microsoft Access 2013 (Office version). I think explicit save that you mentioned will be very helpful.

Right now, I have an interface that allows users to enter "Item ID", "WO#", "WR#", "Category", and a combo box for users to choose whether to accept the job or not (the combo box has "Yes", "Reject", "Delete").

What I want is, when I click "Yes" in the combo box, the 4 information that the user entered (Item ID, WO#, WR#, Category) will be stored in table "L4". When the user click "Reject" in the combo box, the inputted information will be stored in table "Rejected". And when the user click "Delete", the 4 entries that inputted on the form will be deleted and they won't be store in any table.

The problem now is, the 4 entries (text boxes) are now bounded with table "L4". And I have no idea how to link it to table "Rejected" and how to clear the entry.

By the way, I have never used Access before this project. So I am very new in developing databases.
Nov 10 '15 #3
zmbd
5,501 Expert Mod 4TB
I've PM'd you a copy of my new-developers helpful hints and tutorials. I'd start with this before you go much farther in the design of your database. Hopefully, it will help you avoid many of the common pitfalls.

-z
Nov 10 '15 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Fran Zablocki | last post by:
I am trying to write an expression that converts one set of values to another. There are two fields, STAGE and ADMIT_TYPE, which are used as input criteria, and the final converted values are...
1
by: Grant Hammond | last post by:
I assume I'm not alone in my frustration that the expression builder that comes (in part) with Access XP that dosnt wrap text when you open it on an exisitng expression in a query or form. I's...
1
by: tnt | last post by:
I have set up a table and a form initially when i use these without modifications the data transfers fine. However when i use the expression builder to create a calculation in one of the form...
2
by: Mike Turco | last post by:
I like using the expression builder for a lot of different things but it isn't always available when I want to use it, for example in the code window, or in all of the control properties. I am...
2
by: shahla.saeed | last post by:
wat i want is to insert the calculated values(simple addition or subtraction) in fields of my table by using expression builders in my forms..i have made that feild in the table but still it...
3
by: Nigel C | last post by:
My problem is best explained by way of tables and examples... I am using Access 2000 (in case this is relevant) and I have a table with the following fields... Field names ------------ Code ...
2
by: Darren Carter | last post by:
Does anyone know if it's possible to format data stored in an appSetting node when it's bound to a form control? I would like to format a date stored in appSettings, and I bind to it as follows: ...
1
Shazam68
by: Shazam68 | last post by:
Greetings all. I am trying to call a form from expression builder in design view of a query. The target form has one field, a list box that let's the user select a category, and then click the OK...
1
by: KerryA | last post by:
Hi, I am trying to create a report on a table I have set up called ‘Outcomes’. I need to be able to do a count of all fields that have said ‘1’ ‘2’ or ‘3’ within a field name called ‘All outcomes’. I...
14
Fspinelli
by: Fspinelli | last post by:
Good morning! I looked through my Access bible but I'm baffled. I have a table and it was made into a query and then used in a form. The end user enters the information (and/or chooses...
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...
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...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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...
0
isladogs
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 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.