Click here to Skip to main content
15,848,261 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: VBApp with a Crystal Report in it. Where do I find it when published. Pin
Richard Deeming27-Oct-22 22:09
mveRichard Deeming27-Oct-22 22:09 
QuestionUpdate Parent and Child Table Pin
EngrImad27-Oct-22 1:37
EngrImad27-Oct-22 1:37 
AnswerRe: Update Parent and Child Table Pin
Richard MacCutchan27-Oct-22 2:36
mveRichard MacCutchan27-Oct-22 2:36 
GeneralRe: Update Parent and Child Table Pin
EngrImad27-Oct-22 2:41
EngrImad27-Oct-22 2:41 
Questionhow to do Scheduled task settings in conditions Tab "wake the computer to run this task" Pin
Member 1578241728-Sep-22 22:17
Member 1578241728-Sep-22 22:17 
QuestionVB.NET Pin
traore noor22-Sep-22 14:50
traore noor22-Sep-22 14:50 
AnswerRe: VB.NET Pin
Dave Kreskowiak22-Sep-22 16:10
mveDave Kreskowiak22-Sep-22 16:10 
AnswerRe: VB.NET Pin
Richard Deeming22-Sep-22 22:35
mveRichard Deeming22-Sep-22 22:35 
Google translate:
Hello dear forum members, I have a concern that is related to updating my table.

Indeed I designed a vb.net application for the management of cash operations for the account
of a structure and everything works correctly until the level of the modification of the table where I have a problem.

The thing is that an operation is either a receipt or an expense from which I created a variable
balance = revenue - expenditure (revenue or expenditure is nil depending on the nature of the operation) which represents the balance
of each operation performed.
As for the part of the cash balance from an op2 operation, we have:

E: balance_caisse_op2 = balance_op2 + balance_caisse_op1 (equal to balance_op1) and it works well in insertion.

My problem is that on for example 10 operations carried out we decide to modify the 5th operation,
how to readjust cash register balance from changed row to last item in table
cash_balance, since the different lines are dependent for the calculation of the different balances
of the body according to equation E.
I have already thought of a solution but that gives me a FatalError. I actually did the following:

[CODE]

In summary, the GetMaxId() method when called returns the id_max of the operation table and this value will be used
stop condition in the loop.
Then the GetBalanceCaisse() method, for its part, calculates the balance of the cashbox during a given operation.
Finally, the UpdateBalance() method which will be called just after the one which will modify the line
concerned, we recalculate the balance of the cash register from the modified line to the last element of the column
because all related. The for loop defines the start and end of changes.

I am counting on everyone to resolve this difficulty. Thanks…
From your description, it sounds like you're trying to build some sort of running total. But looking at your code, it's not clear how you're doing that, nor what the problem is.

Start by describing your table structure and providing some sample data. Then explain what you're updating, and what you want to happen when you update it.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

AnswerRe: VB.NET Pin
Eddy Vluggen25-Sep-22 6:44
professionalEddy Vluggen25-Sep-22 6:44 
QuestionCREATE DNS SERVER SOFTWARE Pin
Os.kamal22-Sep-22 9:02
Os.kamal22-Sep-22 9:02 
AnswerRe: CREATE DNS SERVER SOFTWARE Pin
Dave Kreskowiak22-Sep-22 16:07
mveDave Kreskowiak22-Sep-22 16:07 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
trønderen22-Sep-22 16:22
trønderen22-Sep-22 16:22 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Dave Kreskowiak23-Sep-22 4:02
mveDave Kreskowiak23-Sep-22 4:02 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Os.kamal25-Sep-22 5:21
Os.kamal25-Sep-22 5:21 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Gerry Schmitz23-Sep-22 6:48
mveGerry Schmitz23-Sep-22 6:48 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Os.kamal25-Sep-22 5:22
Os.kamal25-Sep-22 5:22 
GeneralRe: CREATE DNS SERVER SOFTWARE Pin
Os.kamal25-Sep-22 5:19
Os.kamal25-Sep-22 5:19 
QuestionInserting button name into the txt.text box (VB) Pin
GamerzfanArcade10-Sep-22 15:16
GamerzfanArcade10-Sep-22 15:16 
AnswerRe: Inserting button name into the txt.text box (VB) Pin
Richard MacCutchan10-Sep-22 22:17
mveRichard MacCutchan10-Sep-22 22:17 
GeneralRe: Inserting button name into the txt.text box (VB) Pin
GamerzfanArcade11-Sep-22 8:21
GamerzfanArcade11-Sep-22 8:21 
GeneralRe: Inserting button name into the txt.text box (VB) Pin
Richard Andrew x6411-Sep-22 10:12
professionalRichard Andrew x6411-Sep-22 10:12 
QuestionService to Logoff/Disconnect/Reboot Computer Pin
Member 1462398916-Aug-22 17:41
Member 1462398916-Aug-22 17:41 
AnswerRe: Service to Logoff/Disconnect/Reboot Computer Pin
Member 1462398917-Aug-22 7:56
Member 1462398917-Aug-22 7:56 
QuestionVisual Studio List Box with 1,000,000 entries / Who else noticed this capacity? Pin
Member 150787168-Jul-22 14:36
Member 150787168-Jul-22 14:36 
AnswerRe: Visual Studio List Box with 1,000,000 entries / Who else noticed this capacity? Pin
Dave Kreskowiak8-Jul-22 16:52
mveDave Kreskowiak8-Jul-22 16:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.