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,370
Thanks: 202
Thanked 600 Times in 572 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.
__________________
............
I love doing YouTube Videos demonstrating what you can do with MS Access. I'm always looking for ideas for my next video, so I've set this thread up here:-


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Suggest a topic you think would benefit from video instructions... Looking forward to your ideas!...
Uncle Gizmo is offline   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,370
Thanks: 202
Thanked 600 Times in 572 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.

__________________
............
I love doing YouTube Videos demonstrating what you can do with MS Access. I'm always looking for ideas for my next video, so I've set this thread up here:-


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Suggest a topic you think would benefit from video instructions... Looking forward to your ideas!...
Uncle Gizmo is offline   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
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 05:46 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