Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

I have Trade Show database will use message boxes in lieu of Colors.  My next question on this DB is?

Posted on 2012-09-08
7
Medium Priority
?
441 Views
Last Modified: 2012-09-08
Hi Everyone,

Please review my Access database now that i have re-done.  I am trying to clear out the Quantity field after the "Order Complete"message Box appears.  What code do i need here to do this?  I tried using Me.Quantity = "", but this is not clearing out the field.  After a person completes one order, I want the Quantity field to become blank so another order for a new quantity is needed for another product for the same vendor or a new vendor.

Any help with this VBA code is very appreciated.

jjc9809
TradeShow-NEW-.accdb
0
Comment
Question by:jjc9809
  • 4
  • 3
7 Comments
 
LVL 29

Accepted Solution

by:
IrogSinta earned 2000 total points
ID: 38380160
It seems to work fine when I add it here:
   
    [ProductOrders subform].Requery
    Product.Requery
    Me.Quantity = ""
    Beep

Open in new window

0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38380166
Also, you should set your NavigationButtons and RecordSelectors properties to NO to tidy up your form a bit.
0
 

Author Comment

by:jjc9809
ID: 38380245
IrogSinta,

Are you speaking about my event buttons?  What property do I set to "no"?
What record selectors properties are you taking about?  I need more specific information here.

Also, Thank you for you help on the other post.  Yes this works for me too.

After answering these questions, I will score you 500 with an "A" for excellent.
0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 
LVL 29

Expert Comment

by:IrogSinta
ID: 38380254
Here you go.  Adjust these properties are for your main form:property sheet
0
 

Author Comment

by:jjc9809
ID: 38380278
IrogSinta,

What does this do to the form to tidy it up?

jjc9809
0
 
LVL 29

Expert Comment

by:IrogSinta
ID: 38380287
These are unnecessary with how your form is set up.  tidy
0
 

Author Comment

by:jjc9809
ID: 38380352
Thanks, IrogSinta,

 I was wondering the other day how to get rid of those.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question