I have used VBA on TrNo filed as per shown on Code Tag for below following forms open purpose so it is not working properly only open BT_DepositEntryModify form otherwise not working. I think just need to change VBA code so please replay how to give a VBA in this case. I have attached the dB and Screenshot with Explanation.
Thanks for replay
There is no error but in the VBA code two type’s conditions shown for form opening so 1st one is BT_DepositEntryModify form this is working well.
But 2nd one is BT_WithdrawEntryModify form this form is can’t open when I click on TrNo as per screenshot and in this form place also open 1st one BT_DepositEntryModify form.
So I need to open 2nd form also BT_WithdrawEntryModify form as per TrNo field require.
What are the values that you will find in the ID field?
Since your If...Then statement is checking that value, but it never opens the other form, this is where you must start your troubleshooting--which is why I keep asking about it.....
Attached the as per screenshot Bank Transaction Details form in the last 2 rows records is Form: BT_WithdrawEntryModify & first 2 rows records is Form: BT_DepositEntryModify
Both of differences is Withdraws Rs. & Deposits Rs. field amounts so in this case I need to form open If Amount is Withdraws Rs. filed side then will be open the form: BT_WithdrawEntryModify Or Deposits Rs. field side then will be open the form: BT_DepositEntryModify that’s way am using VBA on TrNo filed but can't workout.
I have two forms that both open the same (3rd) form.
The third form does the same thing, but a little differently depending
on which form it is opened from. Is there a way I can check which
form...
I'm trying to use the ErrorProvider in order to validate
my form. This is working well except that in the event of
a failure on my modal dialog, I'd like to keep the dialog
open.
I open the...
Hi,
I have developed an application in MS Access 2000 where I am trying to
highlight a record in the list box in form 2 based on the record
selected in form 1. The form 1 lists all the Document...
Hi there,
As it will be very apparent in a moment, I am very new to Access and learning on the fly. (Much fun, but frustrating at the same time)
I currently am trying to get a Combo Box that I...
Dear Sir/Madam,
I am new vb 6.0 user. I am developing Shop Management Program. I have a main form with buttons and menus. when i click any button then respective form is open. I want to set a...
My form has has seven Text Boxes to receive user input. Users fall into
either of two categories, Current and New. 'Command_Button_New' changes
the visible property of four text Boxes and their...
Two weeks (Well about 8 hours actually) into writing VBA code and I've run up against a problem.
This is the senario;
----
I have a "Main" form in which an entry on a drop down selects one of...
I'm trying to make a dialog box pop up and ask the User for their name when they open a particular form. I then want to set the default value of a text box called "EnteredBy" to their name. However...
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...
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
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...
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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...
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...