Results 1 to 5 of 5
  1. #1
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    I want MSN appear when I am out of balance

    Hi,
    Friend I am send two file MBD and note jpg,
    when I want to take output some from stock it must check if i have enough balance ?if i am out of balance MSN must appear.


    thanks

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    A simple bit of code is all you need but it depends on how the balance gets updated as to where you put the code.

    E.g. If the balance only gets updated when you add a new item then put the code on the AfterInsert of the item. The code will be something like this (Note:you will need to edit with your own field/form names)

    Sub On afterInsert..
    If forms!balanceform!balcne < 0 then
    msgbox("Your balance is less than 0")
    end if
    End Sub

  3. #3
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    I try I fail with code

    Hi,
    friend u have in attached my file can plz add ur code to my file
    and send me again that MDB

    thx

  4. #4
    maximus's Avatar
    maximus is offline Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Aug 2009
    Location
    India
    Posts
    931
    hi this is something you requested

  5. #5
    miziri is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Aug 2009
    Posts
    80

    Keep bottom color

    Hi,
    I check ur file,I want to keep color when i close database access file.
    I mean when I click and became red when i close and open again it must give red color

    thx

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 08-19-2011, 01:53 PM
  2. Condiation in balance not less than zero
    By miziri in forum Programming
    Replies: 0
    Last Post: 05-24-2010, 08:21 AM
  3. Replies: 0
    Last Post: 02-15-2009, 09:14 PM
  4. Txt box on form showing 'Balance'
    By wasim_sono in forum Programming
    Replies: 1
    Last Post: 04-25-2006, 05:58 AM
  5. Adding Running Balance from Form to Reports
    By KIDGEO3 in forum Reports
    Replies: 1
    Last Post: 01-18-2006, 08:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums