Visual Basic

Richard MacCutchan10-Jun-23 4:51

10-Jun-23 4:51

Your first two lines duplicate each other:

Dim items = ListBox1.SelectedItem() // get a list of the SelectedItem(s)
For Each items In ListBox1.SelectedItems // do the same, but duplicating the variable name

But either way they make little sense as you do not do anything with the item you pull from the ListBox.

You need something like:

' I am making an assumption that the ListBox entries are names of the files to be processed
For Each file As String In ListBox1.SelectedItems ' Extract each file name
    ' So pass this name to a subroutine that will:
    '    Open the file
    '    Process all the tags according to the CheckBox settings
    '    Save and Close the file
Next

Try not to write all your code inline, as it makes it so much more dificult to read and, more importantly, to debug.

Member Alienoiz10-Jun-23 5:15

Member Alienoiz

10-Jun-23 5:15

aaarrggghh...im not able to make it work ...could you be a little more explicit please?

Richard MacCutchan10-Jun-23 5:39

10-Jun-23 5:39

In what sense more explicit?

You know, one of the most frustrating things in these forums is when people keep saying things like, "it doesn't work". We have no way of knowing what that is supposed to mean, even when we can see your code.

So I suggest you start a new question. Make sure you post the code that you are using, and explain, in proper and complete detail what is not working, and why that is so.

Member Alienoiz10-Jun-23 5:42

Member Alienoiz

10-Jun-23 5:42

could you correct my code?

Dim items = ListBox1.SelectedItems()
                For Each items In ListBox1.SelectedItems()

                    If CheckBox1.Checked = True Then
                        myMp3.ID3v2Tag.Title = TextBox1.Text
                        myMp3.Write()
End If
Next

Next

Gerry Schmitz8-Jun-23 5:07

Gerry Schmitz

8-Jun-23 5:07

Unless you know "why" you want to convert a string to "byte" (which makes little sense in your present context) even knowing "how", will only get you a little bit further. And maybe "deeper" in the wrong direction.

"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I

Capturing picture on an Access form by code

jschell8-Jun-23 6:58

jschell

8-Jun-23 6:58

Debugging methodology - there are others though.

Start removing or commenting out code until the error goes away. Obviously you must give some thought to exactly which code you do this to.

Then when the error goes away you have found the problem.

Then you can create a much smaller example code to test that functionality and figure out how to make it work correctly. Then you fix the original code and put everything else back.

Opam Brown28-May-23 12:06

Opam Brown

28-May-23 12:06

I have developed an HR system in MS Access and want to use a camera attached to the computer to capture staff pictures on the form to store in a table with link as staff number of employee.
I asked once and I was directed to a sample code which I copied and used but it does not work.
can someone be of help?

Richard MacCutchan28-May-23 21:05

28-May-23 21:05

Opam Brown wrote:
a sample code which I copied and used but it does not work. can someone be of help?

With what? We have no idea what code you are using or what problems you have encountered.

Andre Oosthuizen2-Jun-23 0:15

Andre Oosthuizen

2-Jun-23 0:15

No code, no errors... no problem. Wink | ;)

jschell29-May-23 6:13

jschell

29-May-23 6:13

Opam Brown wrote:
can someone be of help?

I suspect a paid consultant might be able to fix it. Or perhaps determine that is not even possible as code - thus a process with manual steps might be put in place.

Someone else might be able to help if you reduce the problem to a very small sample and then provided exact details for that.

what is visual basic used for

Gerry Schmitz29-May-23 7:14

Gerry Schmitz

29-May-23 7:14

You mean take a picture without their consent? In any "sane" situation, the user indicates "ready"; which is the same as monitoring the picture folder based on their say so; i.e. "they" push the thing that snaps their picture and signal the app accordingly.

Simon Osabo Asamoah27-May-23 18:33

Simon Osabo Asamoah

27-May-23 18:33

Richard MacCutchan27-May-23 20:53

27-May-23 20:53

Anything you want.

Andre Oosthuizen2-Jun-23 0:17

Andre Oosthuizen

2-Jun-23 0:17

Yes, it can even make coffee. Wink | ;)

Ralf Meier2-Jun-23 10:13

Ralf Meier

2-Jun-23 10:13

sure ???

Andre Oosthuizen5-Jun-23 21:55

Andre Oosthuizen

5-Jun-23 21:55

Maybe I should have stated as a "Tongue In Cheek" remark, used as a backend to control and manage mixing of ingredients etc. it can ensure a great cup of relax. $Shucks | :-\$

Ralf Meier5-Jun-23 22:59

Ralf Meier

5-Jun-23 22:59

It's ok - I understood your comment ... but I can't miss my comment to yours ... Wink | ;)

I have this code which loads some files in a folder. Am using advanceddatagridview to filter out some files as the are alot. Now i need to save back the filtered rows back to another folder. Not as a single file but as multiple files. I was thinking

David Mujica6-Jun-23 3:32

David Mujica

6-Jun-23 3:32

Currently I use VB for
1) Windows services - Processing file messages into database transactions
2) Schedule data extractions - Monthly SQL extracts, reports, Excel, etc

Anything that requires a User Interface, I develop a Web Application, anything that requires background execution I develop in VB.

Java | [Coffee]

Bonnie_Tames27-Apr-23 1:59

Bonnie_Tames

27-Apr-23 1:59

Private Sub OpenFolder_Click(sender As Object, e As EventArgs) Handles OpenFolder.Click
       FolderBrowserDialog1.ShowDialog()
       FolderPath.Text = FolderBrowserDialog1.SelectedPath.ToString()
       loadfiles()
   End Sub
   Private Sub loadfiles()
       Dim filepath As String() = Directory.GetFiles(FolderPath.Text)
       Dim dt As DataTable = New DataTable
       dt.Columns.Add("Product")
       dt.Columns.Add("Serial No")
       dt.Columns.Add("Extension")
       dt.Columns.Add("Size")
       dt.Columns.Add("Creation Time")
       For item As Integer = 0 To filepath.Length - 1
           Dim file As New FileInfo(filepath(item))
           Dim dr As DataRow = dt.NewRow()
           dr(0) = file.Name.Split.Distinct
           dr(1) = file.Name
           dr(2) = file.Extension
           dr(3) = file.Length
           dr(4) = file.LastWriteTime
           dt.Rows.Add(dr)
       Next
       DataGridView1.DataSource = dt

   End Sub

Re: I have this code which loads some files in a folder. Am using advanceddatagridview to filter out some files as the are alot. Now i need to save back the filtered rows back to another folder. Not as a single file but as multiple files. I was think

Richard MacCutchan27-Apr-23 2:44

27-Apr-23 2:44

Quote:
I was thinking

About anything in particular?

Bonnie_Tames27-Apr-23 2:54

Bonnie_Tames

27-Apr-23 2:54

How I can use the datagridview1 results after applying filters and file names to copy from Folder A to Folder B.

Richard MacCutchan27-Apr-23 3:12