Comments by KitsunePhoenix (Top 37 by date)

the code I posted in the question is where the problem is. The only other thing the code does when PokedexList is changed is to post the new pokemons name in a textbox. I'll add that just in case it helps but i can't see how it would.

I tried. I don't come here until i've exhausted every possibility, all the debugger will tell me is that there's nothing there, and I can't figure out why. It works for the first item I select, but when I try to change the selection it seems to be running the code before the new item is selected.

'Option' must be followed by 'Compare', 'Explicit', 'Infer', or 'Strict'.

it accepts either/or. I'm not sure which is the preferred method, but the SQL builder in MS Access defaults to ! over . Either way, I tried changing it and got no different result.

i thought the question was obvious but okay, any ideas where i'm going wrong in the code?

it stops at the data adapter and says one or more required parameters has no value

i've tried multiple connection strings, when it's in the "\bin\Debug" folder I use

"Provider = Microsoft.ACE.OLEDB.12.0;Data Source=" &
Environment.CurrentDirectory & "\Pokedex.accdb"

but when I move it somewhere else I change the Data Source to point directly at it.

it's definitely visual studios fault because the problem occurs when I attempt to make a connection. Tools --> Connect to Database --> Database File Name --> Browse and here is where I believe the problem to lay because it automatically opens to to "\bin\Debug" where the database used to be, it's not there anymore but for some reason the Visual Studio's browser pulls it up as if it were there.

okay this needs to be said for anyone else who can't figure out why this wasn't working. I followed the usual instructions to change the active solution platform, and there it said I was on x86. However, I went to Project ---> [Insert Project Name] Properties ---> Compile and even though the active platform was x86, the Target CPU was set to x64. Changing that to x86 fixed my problem.

wasn't quite the correct answer (my fault, I didn't provide the info you would need for the correct solution) but it did help me find the problem. The problem was with the SQL statement, I had the wrong field names in the wrong places. I guess sometimes you just need an outside eye to point out the obvious lolz. Thank you for your time.

that did it! Thank you so much! and thank you for being patient with me. Edit your solution and I'll mark it as answered

either the solution isn't there or I just can't see it. Using item.Text didn't work either, though it didn't give an error. it didn't give any effect either. I clicked the button and got nothing.

I also tried item.Text(0) and item.Text(1) with the same result.

it says "Failed to convert parameter value from a ListViewSubItem to a String."

The problem is, the point where I supply the value is the earliest I can (I supply the values in the inner For Each statement). I've done similar code before and it worked, but I can't figure out why it's not working now. If I supply a value for the parameters before the For Each statement, then it tries to use that value instead of the value I supply in the For Each.

updated though all I changed was to make the named parameters into ?

that was good information to know but doesn't help with my specific problem. My problem is with giving it a value. I tried giving the parameter a placeholder value, figuring that when the code ran it would give it a new value but that didn't work either.

is there something more I don't know about that word? If by debugger you mean F5 then I am using it, that's how I know there's a problem. There's no errors with the code, but it's not giving the expected values. With the code the way it is, it should be setting the numupdown values as listed here:

PlayHP.Value = 580 (initial HP is 500, the helmet gives 80)
PlaySP.Value = 380 (initial SP is 300, the helmet gives 80)
PlaySTR.Value = 2 (base STR is 0, the helmet gives 2)
PlayAGI.Value = 2 (base AGI is 0, the helmet gives 2)
PlayLUC.Value = 3 (base LUC is 0, the helmet gives 3)

Instead it gives a value of 0 for all of these stats (except HP and SP which are given their initial values of 500 and 300 respectively). The program is set up to save these values in a separate database and when the program loads it pulls the values from the database, so I tried setting the values to 10 to see if it made a difference and it's definitely trying to make the calculations because what should have been shown as 10 came out as 0.

Thank you so much! I learned a lot from this, answers aren't usually so in depth. Solved my problem and then some. With any luck I should be able to finish the program and debug any loopholes within the next few hours.

omg I feel stupid. I spent two days trying to find a solution and it was right there in front of me lmao. Thank you

none. The error comes in the first iteration of For... Each... Next.

Thank you, this advanced to my next problem :P

Thank you, that got me past my problem. I'll have to remember that for next time.

The output in the event log is:

- System

- Provider

[ Name] SideBySide

- EventID 10

[ Qualifiers] 49409

Level 2

Task 0

Keywords 0x80000000000000

- TimeCreated

[ SystemTime] 2015-05-21T11:29:08.000000000Z

EventRecordID 1493

Channel Application

Computer WIN-I1KMUN8JT8V

Security


- EventData











C:\Users\gwenk\OneDrive\Documents\Visual Studio 2010\Projects\PDod EV Tracker 2.1\PDod EV Tracker 2.1\bin\Debug\PDod EV Tracker 2.1.exe
C:\Users\gwenk\OneDrive\Documents\Visual Studio 2010\Projects\PDod EV Tracker 2.1\PDod EV Tracker 2.1\bin\Debug\PDod EV Tracker 2.1.exe.Config
1

I can't think of anything else that would help. The code listed at my link is everything that has to do with the database. The reason it doesn't load is because the program is designed to create and access the database immediately, but since it can't connect to the database it doesn't load, it just gives an error immediately after clicking Debug. The only difference between my database code and the one at the link is that everywhere you see the word "Cloud" I changed it to Pokemon.

EDIT: So I tried running the exe in the bin/Debug folder and got the following error:

"This application has failed to start because the application configuration is incorrect. Review the manifest file for possible errors. Reinstalling the application may fix this problem. For more details, please see the application event log."

What is the manifest file?

that won't work because the app doesn't load. If I knew where it was going to place it then I would know what to put but I don't have a clue.

Okay I have one last question (hopefully lolz). In the CloudAppSettings I've encountered only one problem I couldn't handle.

Public Shared Function GetConfigAppSettingsByName(ByVal AppSettingsName As String) As String
Dim result As String = ""
If ConfigurationManager.AppSettings.AllKeys.Contains(AppSettingsName) = True Then
result = System.Configuration.ConfigurationManager.AppSettings(AppSettingsName.Trim)
End If
Return result
End Function

The above code shows two errors and I'm not sure how to resolve them. the first error is that ConfigurationManager is not declared. The second error says that "ConfigurationManager is not a member of Configuration."

Once these two problems are resolved it should be a simple matter to edit my code to fit the new database. Thank you for all your help. :)

lol I didn't even see that download linking hiding at the top. Thank you

it went a long way to helping but there are three variables mentioned in the code it gives that it never declares, so I don't know what they are or what purpose they serve. Maybe you can help? CloudAppSettings, ConnSettings, and AccessCreateDB are the missing variables. And it mentions the code

CloudAccessDatabase.CreateNewDatabase(CloudAccessDatabase.DatabaseType.sample1)

but never says where it belongs, and when I put it into form1 it highlights CloudAccessDatabase and says a declaration is expected. This is why I posted the question, is because every tutorial I have found so far has had a problem like this where it gives most of the information but leaves out important bits that are impossible to figure out on your own.