Go Back   Access World Forums > Apps and Windows > Visual Basic

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-29-2017, 10:33 AM   #1
Landon38
Newly Registered User
 
Join Date: Mar 2017
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Landon38 is on a distinguished road
Get current value and subtract access



So i have a table and design of this.

in the subinventory if i want to view first the stock input a subinventory on textbox then print on the other textbox w/e itemcode, itemdecs, subinventory, uom and requisition.

now if i want to order on subinventory textbox in the second i will put any numbers that will subtract to the current number in the itemdb and if the stock is lower than 100 it will show a msg box that the current stock is lower than 100, and if the stock is 0 it will show a msg that the stock is out of stock.

tyvm

Landon38 is offline   Reply With Quote
Old 03-29-2017, 02:55 PM   #2
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 8,955
Thanks: 295
Thanked 692 Times in 660 Posts
Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about
Send a message via Skype™ to Uncle Gizmo
Re: Get current value and subtract access

It looks to me like you are asking a question about Microsoft Visual Basic in an MS Access forum. The tentative connection to MS Access is that you are storing information in an MS Access table, probably an *.mdb table. Baring that in mind, I think you are in the wrong forum. You might get a better response in a forum devoted to Visual Basic.
__________________
Tony Hine - My Aspiration --- Finding a better way of Explaining ---
From this YouTube:-

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Uncle Gizmo is online now   Reply With Quote
Old 03-29-2017, 06:17 PM   #3
Uncle Gizmo
Nifty Access Guy
 
Uncle Gizmo's Avatar
 
Join Date: Jul 2003
Location: Newbury Berks UK
Posts: 8,955
Thanks: 295
Thanked 692 Times in 660 Posts
Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about Uncle Gizmo has a spectacular aura about
Send a message via Skype™ to Uncle Gizmo
Re: Get current value and subtract access

Ah! I see... You posted this in a Visual Basic forum in AWF... I missed that! Didn't realise we had a VB forum.

__________________
Tony Hine - My Aspiration --- Finding a better way of Explaining ---
From this YouTube:-

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Uncle Gizmo is online now   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Access Code to Update (add/subtract) value (quanity) on a table/form Vickyy General 8 06-02-2015 08:21 AM
[SOLVED] Subtract totals from 2 subreports in main report of access magickmann Reports 2 12-29-2014 07:49 AM
How to subtract values from two fields in two consecutive rows in Access table? nelpet General 14 01-20-2012 03:53 AM
add n subtract values in access sakanil1 Tables 2 07-10-2011 03:13 AM
[SOLVED] i'm very new to access & need to figure out how to subtract one field form another wi canonge2 Forms 3 04-11-2005 06:25 PM




All times are GMT -8. The time now is 01:09 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World