Comments by miguel santos 2021

miguel santos 2021 18-Sep-23 9:13am View

Rows = Sheets("student_list").Range("A1048576").End(x1UP).Row + 1
With ThisWorkbook.Sheets("student_list")
give the error Rows=0 s

I apologize for my English

miguel santos 2021 18-Sep-23 8:39am View

Quando eu executo o código, dá o erro:
Sub, Função ou Propriedade não definida.
não sei se srá de você meu excell estar em português e a semântica é diferente,
worksheet= Folha
ThisWorkSheet = EsteLivro etc, como disse estou a me inciar em vba.
Muito obrigado

miguel santos 2021 18-Sep-23 6:20am View

rivate Sub btnSubmit_Click()

Application.ScreenUpdating = False

Dim Rows As Long
'data base table name and range
Rows = Folha("student_list").Range("A1048576").End(x1UP).Row + 1
'data base table name and total range

With EsteLivro.Folhas("student_list")
'insert fields

.Range("A" & Rows).Value = Rows + 9999 'this row will genetate and insert serial number
.Range("B" & Rows).Value = txtfirstname.Value
.Range("C" & Rows).Value = txtlastname.Value
.Range("D" & Rows).Value = txtemail.Value
.Range("E" & Rows).Value = txtphone.Value
.Range("F" & Rows).Value = cmbgender.Text
.Range("G" & Rows).Value = cmblevel.Text
.Range("H" & Rows).Value = cmbcountry.Text
.Range("I" & Rows).Value = cmbcity.Text
.Range("J" & Rows).Value = txtaddress.Value
.Range("K" & Rows).Value = txtcurrent_address.Value

Unload UserForm2

Application.ScreenUpdating = True
End With

End Sub

miguel santos 2021 18-Sep-23 6:19am View

Private Sub btnSubmit_Click()

Application.ScreenUpdating = False

Dim Rows As Long
'data base table name and range
Rows = Folha("student_list").Range("A1048576").End(x1UP).Row + 1
'data base table name and total range

With EsteLivro.Folhas("student_list")
'insert fields

.Range("A" & Rows).Value = Rows + 9999 'this row will genetate and insert serial number
.Range("B" & Rows).Value = txtfirstname.Value
.Range("C" & Rows).Value = txtlastname.Value
.Range("D" & Rows).Value = txtemail.Value
.Range("E" & Rows).Value = txtphone.Value
.Range("F" & Rows).Value = cmbgender.Text
.Range("G" & Rows).Value = cmblevel.Text
.Range("H" & Rows).Value = cmbcountry.Text
.Range("I" & Rows).Value = cmbcity.Text
.Range("J" & Rows).Value = txtaddress.Value
.Range("K" & Rows).Value = txtcurrent_address.Value

Unload UserForm2

Application.ScreenUpdating = True
End With

End Sub

miguel santos 2021 21-Jul-22 4:55am View

thanks again.
I asked this question because I'm new to sql.
And in a previous topic, I asked for help to create a field calculated with subtraction in a view.
As they couldn't help me, I thought of using view to create and update a table, and make the calculated field in that table

miguel santos 2021 21-Jul-22 4:42am View

Thank bro, but there's ny way i can do this?

miguel santos 2021 21-Jul-22 2:40am View

sorry for the repetition, but it was because of my bad english

miguel santos 2021 20-Jul-22 15:20pm View

Thanks again bro, sorry for my bad SQL and English .
a.[vendas ultimo ano] its the last year sales by produts.
.
b.[vendas ultimo semestre] its the last 6 months sales and gain artigo_2.stkactual its the actual stock by produts.
Thaís os for help when i have to order some produts.
Thanks again i m really bad ar this...

miguel santos 2021 20-Jul-22 15:19pm View

Thanks again bro, sorry for my bad SQL and English .
a.[vendas ultimo ano] its the last year sales by produts.
.
b.[vendas ultimo semestre] its the last 6 months sales and gain artigo_2.stkactual its the actual stock by produts.
Thaís os for help when i have to perder some produts.
Thanks again

miguel santos 2021 20-Jul-22 15:17pm View

Thanks again bro, sorry for my bad SQL and English .
a.[vendas ultimo ano] its the pasta usar sales by produts.
.
b.[vendas ultimo semestre] its the last 6 months sales and gain artigo_2.stkactual its the actual stock by produts.
Thaís os for help when i have to perder some produts.
Thanks again

miguel santos 2021 20-Jul-22 11:54am View

thank' for the tip bro

miguel santos 2021 20-Jul-22 11:47am View

Thanks my friend ,that's why I ask for your help, for starting me in sql

miguel santos 2021 14-Apr-21 9:04am View

so how can i execute the sp? use localdb which does not have sql agent, the application is in C #

miguel santos 2021 14-Apr-21 8:57am View

brother I am very sorry for my ignorance, but where in the code placed "GO"? can you please give me an example? thank you for your patience

miguel santos 2021 14-Apr-21 6:45am View

there's any way i can solve it? thanks

miguel santos 2021 14-Apr-21 6:45am View

where is the GO statement please?

miguel santos 2021 14-Apr-21 5:48am View

The SP makes an update on the EmpAttendance table column SubDiario when the change in the table EmpSalary column SubDiario
and it works, but when I try to trigger the sp "EXEC [dbo]. [sp_SubMensal_update] gives an error" Maximum stored procedure, function, trigger, or view nesting level exceeded (limit 32). "

miguel santos 2021 10-Apr-21 2:48am View

Thank you very much for your help, but will it be possible to give me a practical example? I'm new to this

miguel santos 2021 27-Mar-21 3:25am View

thanks

miguel santos 2021 27-Mar-21 3:24am View

Thank you very much for the comment.
But for other responses I had, what is at issue at this moment is just to get that, when I compile for the project setup, to include the litedb as well as the db, because if you install the litedb and do the restore from the db the project works perfectly on any pc,
if you can teach me how to overcome this, I am immensely grateful.
thanks again for your patience

miguel santos 2021 25-Mar-21 11:24am View

Thank you very much for the information.
As I already mentioned, I am a mere beginner im C # and sql so my request for help.
fi an application in C # in visual studio and for what it is intended it works perfectly with litebd,
litedb has sp, triggers and functions, so sqlLite will not be an option.
But I am tired of walking looking for how to compile the project and he installs the litedb and the backup of the "db" and I can't find anything and moreover some PCs do not accept the installation of the litedb 64 or 86x.
If you can help me or teach me how to overcome this, I am very grateful.

miguel santos 2021 24-Mar-21 8:56am View

you are the man my brother
thank you very, very much, all you need from me, what little I know is just asking, let's keep in touch for sure

miguel santos 2021 24-Mar-21 6:50am View

i think that's the fileName who comes null in sql db
**lblFileName.Text = dataGridView1.SelectedRows[0].Cells["dgFileName"].Value.ToString();**

**pictureBox.Image = Image.FromFile(dataGridView1.SelectedRows[0].Cells["dgFileName"].Value.ToString());

miguel santos 2021 24-Mar-21 6:46am View

if the image is null when I insert the record it gives the error ** System.ArgumentException: 'The path does not have a legal format.' ** in ** pictureBox.Image = Image.FromFile (dataGridView1.SelectedRows [0] .Cells [ "dgFileName"]. Value.ToString ());
insert record with image ** without errors **
if I make changes to the registry and eliminate only the error image ** System.NullReferenceException: 'The object reference was not defined as an instance of an object.'
img was null. ** in ** img.Save (ms, ImageFormat.Jpeg); ** again thank you very much for your help

miguel santos 2021 24-Mar-21 6:20am View

sorry brother but you are always giving the error here ** pictureBox.Image = Image.FromFile (dataGridView1.SelectedRows [0] .Cells ["dgFileName"]. Value.ToString ()); ** when compiling, can I please I give you the code so that you can help me correct the error and I can learn from you? thank you so much again for your patience

miguel santos 2021 24-Mar-21 4:17am View

if the Image is null gives error here
"pictureBox.Image = Image.FromFile(dataGridView1.SelectedRows[0].Cells["dgFileName"].Value.ToString());"

miguel santos 2021 24-Mar-21 3:35am View

thank you so much for your help and sorry for my ignorance but how do i??"(You should cache the default image byte array in a private static readonly field, so that you don't have to create a new array each time.)"many thanks again

miguel santos 2021 24-Mar-21 3:03am View

sorry for my late reply but in my country was hollydy untill today thanks fpo you help brother

miguel santos 2021 20-Mar-21 6:25am View

and if you delete the image in the form it always give tehe same error

miguel santos 2021 20-Mar-21 6:09am View

kkkkkkk ok many thanks; but is it not possible to do this through C #?
Sorry my curiosity

miguel santos 2021 20-Mar-21 5:40am View

Thanks for the solution presented, but this image is part of a field of crystal reports but I can also put a white image with nothing, just blank color

Comments by miguel santos 2021 (Top 31 by date)