Yes, Something is going wrong in my database. I did copy and past both Forms and tables into a new database and tested the debug then it is working well!
Also, I tried as you posted code and my code, both are executing as well!
Thanks for your suggestions and help!
Sandhya1988
Last Activity: Jun 10 '20, 05:54 PM
Joined: Oct 24 '14
Location:
-
Yes, I need to place validations before adding the data. Before set the validations I should check the code execution if once it works well, I will set all validations.
Mostly, I'm using only bound subforms in this type of cases. But this is the deferent requirement.
And Sure, the code is even not executing and did not hit the breakpoint when I'm trying to debug.
Is it not possible to go with the only...Leave a comment:
-
Yes, I know about the bound form process, It's a better process of inserting the data as directly into table. But I have some validations and other requirements. That's the reason I'm trying to thru Listbox.
Please help!Leave a comment:
-
@twinnyfo, thanks for replay.
When I tried as of my code, the records are not inserting into the table and did not get any message and also not works debug.
I just tried as you posted code, but getting the only message as per the attached screenshot, records are not inserted into the table and getting same problem no error message and no debug works....Leave a comment:
-
Issue with Insert data from listbox to table
Hi Guys!
Please can anyone help on the following code
As an attached Invoice form screenshot, I'm trying to Insert the product details from Listbox to the table with a loop as per below VBA, but it is not working.
Please help where I'm going wrong.
Also, I have attached Db, If it requires more details.
Backend table fields & datatypes:
ID: AutoNumber... -
Data Passing from one form to another form
Hello, Can anyone solve my issue
Form: SB_1
Form: Add_NewRelation s
I have used a VBA code in Form: SB_1 on a cmd (Button) for Data passing from one form to another form of Add_NewRelation s for New Customer details are needed to update into Form: Add_NewRelation s.
So that VBA code is working well. But some of exist customer details are no need to update into Form: Add_NewRelation s and only allow... -
Thanks for suggestion... i will try thisLeave a comment:
-
Cursor moving on multi Subforms in a form
Thanks for replay twinnyfo & Stevan,
Yes, Just I was checked again the main form tab order it’s shown correct. And I need to begin on the main form to Subform1 & 2 and finally come to main form. Once Attached the Main & Subform’s Tab Order screenshots… if any wrong in Tab order.
I’ve tried following VBA code in the first subform,...Last edited by Rabbit; Mar 6 '15, 08:57 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.Leave a comment:
-
Cursor moving on multi Subforms in a form
Issue with Cursor moving on multi Subforms in a form
I have two Subforms in a main form as per screenshot. So Cursor moving from Main form to 1st Subform working is good. After can’t move the cursor from 1st subform to 2nd subform with tabbing or entering and still there in 1st Subform in the last entered filed. I’ve checked on tab orders they are shown correct and checked the subform Property Cycle & tried also (All Records,... -
Thanks for suggestions.. I will change the structure and after will try to other sources.Leave a comment:
-
VBA for form open
Attached the as per screenshot Bank Transaction Details form in the last 2 rows records is Form: BT_WithdrawEntr yModify & first 2 rows records is Form: BT_DepositEntry Modify
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_WithdrawEntr yModify Or Deposits Rs. field side then will...Leave a comment:
-
DoCmd.OpenForm "BT_WithdrawEnt ryModify", acNormal, "BT_WDrawQr y", "TrNo= " & Val(Me!TrNo)
this is the problem so any chance to changes VBA ? for second form also need to be open ?Leave a comment:
-
ID filed value is AutoNumber & format is start with (D1, D2, D3 )
TrNo filed Value is Serial number & format is start with (1,2,3)Leave a comment:
-
Yes, I’m not sure that code is correct or wrong just i tried. Forms & Query fields as per below following details
Form: BT_DepositEntry Modify (Query: BT_DepQry also same fileds)
Fields:
ID
TrNo
TranDate
Particulars
ChqTNo
ChqPassedReject ed
Deposits
Form: BT_WithdrawEntr yModify (Query: BT_WDrawQry also same fileds)
Fields:
ID
TrNo
TranDate...Leave a comment:
-
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_DepositEntry Modify form this is working well.
But 2nd one is BT_WithdrawEntr yModify 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_DepositEntry Modify form.
So I need to open 2nd form also BT_WithdrawEntr yModify form as per TrNo field require.Leave a comment:
-
VBA for form open
Hello friends, please can anyone solve my issue
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_DepositEntry Modify 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.
Forms:
BT_DepositEntry Modify
BT_WithdrawEntr yModify... -
Thank you so much dear its working perfectly. I just used backslashLeave a comment:
-
How to set a number format in Union Query
Hello friends,
How to set a serial number format with text in union query?
I was tried to some of number formats in union query so some formats is working good some of formats is not working in union query but all number formats are working in tables, forms & reports also.
I have merged 3 query’s in union query. So they have 3 different number formats like a serial number start with (A0001, B0001, R0001)... -
Temporarily am using folder hidden process... so i will try to front-end/back-end process... anyway thanks to everyone for your best suggestions.Leave a comment:
-
ok got it and thanks for suggestionLeave a comment:
No activity results to display
Leave a comment: