Hello It's me again with another painstaking question. I am still working on the same database (In Access 2000) and am now trying to import an excel file. My problem is that the excel file has some special formating and extra crap I don't need and do not know how to get around, so it doesn't import. If need be I can email the excel file to anyone willing to help me. This excel file is updated by a third party every week so it will be an on going import and I would like to make it as easy as possible to do. I'm sorry I'm not to detailed it's a bit hard to explain without one seeing what I am trying to do. If you would like me to email you the excel file please email me @ ri p@ gh os tm ai l .net Sorry just trying to prevent spam bots. Thank you in advance

Where do I put this code? I am trying to get it to update the field (if it needs to be updated) when the form is open. Or if I can make a macro that would do it.

I'm am working on a database in MS Access 2000. I have imported data from a text file. Their are now two fields that imported in to a table: Title and Subtitle I want to make a macro or query (anything that is automatic) to combine the two values (Title and Subtitle) into one (MyTitle) for all the records (about 2,953). Thank you in advance. -Peace

I want to download information from a website and put it into a database (access, sql, ect.) The website layout is in list format. Amazon's layout is a good example. http://www.amazon.com/exec/obidos/tg/feature/-/153446/ref=ed_cp_1_8_b/002-2621321-1999263 I only want certain information from the site downloaded. If someone could point me in the right direction then I would greatly appreciate it. Thanks, JD

I want to assign objects to the array. However I need to do this dynamically as they type information in. I can't get the code right for the program to add the new string to the end of the array. :(

I am programing a windows app (much like my console app talked about earlier in the forums) such as this. User inputs number Number is stored into an array there are commands the user can use to print sort and other such things. I do not want to use the arraylist function. I want to do this using just using array as such: Dim array1(3) as string I'm not sure how to add items to the array. In all my searching I only found information on the Arraylist. If anyone can Point me in the right direction. "Doko ni datte, hito wa tsunagatte iru." -Lain

I had this problem once. I moved my code to another machine and it worked fine. In the end I reinstalled VB and all was fine. Also make sure you have all Services packs (for windows and VB). I ask myself what did I do today? I don't like the answer!

I'm writing a console app that when the user types in a number it gets stored into an arraylist. When they type in certain commands it does misc. things, therefore the input is set to string. However if they type an invalid string that is not one of the preset commands or an integer I want to give them an error message. The issue I'm running into is checking wether the string is an integer or not. If someone can point me into the right direction I would appreciate it. Thanks in advance. :> To see one's self from another's point of view is an opportunity not to be passed up.

RageInTheMachine9532 wrote: OK. Why are you using two strings? Why not just use the one: shell("c:\program files\d-tools\daemon.exe -unmount 0") :doh: My bad that was the way I had to do it in my batch file My head is NOT screwed on right.

My dumb mistake I was trying to mount the image without having the user type in the location. Thanks RageInTheMachine9532 wrote: BTW: What's with the '&' your using right after the daemon.exe? You don't need it there. Just to make the code a little more readable, you might want to take those out, but keep the one in front of 'FileName'. In VB.Net it requires some sort of connector when writting a string. If you just type: shell("c:\program files\d-tools\daemon.exe" "-unmount 0") it will error out at "-unmount 0" Therefore I put the "&" sign in.

I am trying to parse the quotation marks from a string that is returned from an inputbox and then "shell" to the console. Here is my code. Dim FileName As String = InputBox("Please enter the file name here") Shell("c:\program files\d-tools\daemon.exe" & " -unmount 0 ") Shell("c:\program files\d-tools\daemon.exe" & " -mount 0," & FileName) End Sub Just to clarify this is a console app. Any help would be great! Thank I'm just a simple man with complex issues.