Search results

Hey all. I am working on an MP3 player and am having the following problem when i am importing music from a directory. What i am wanting to do is show a openfiledialog box and let the user select which tracks to add to the mp3 player. Now i have a folder of mp3s with over 1133 mp3 files in...

I have used the below function to compact the database when it is over a certain size. Thanks to Ghudson 'Used with setting the status bar message Public vStatusBar As Variant Public Function CompactOnClose() On Error GoTo Err_CompactOnClose If FileLen(CurrentDb.Name) > 5000000 And...

You can format the inputbox with a module. Its a lot of code but it works great. Here is the code '//////////////////////////////////////////////////////////////////// 'Password masked inputbox 'Allows you to hide characters entered in a VBA Inputbox. ' 'Code written by Daniel Klann...

I agree. Although sometimes a good slap on the hand is needed. If someone is asking a question that has been asked like a million times then i see no problem slapping a hand. Also i think you can tell by their question whether they are actually trying to fix a problem or just want to finish...

Holy Hell. That happened within about an hour of my house. lol :) Hooks

I once seen a hockey player take a slap-shot in his ankle shattering it. This happened in the 1st period and he refused to take off his skate because he knew that his ankle would swell and he would not be able to put the skate back on. He finished the game. Ive also seen hockey player play...

You should go to your local dirt track. Hillbilly style. The races last about 15 minutes and you get mud and dirt thrown on you. Very fun, fast and exciting.

I live in the mid-west. My place of work hired a couple of consultants from washington state. One of them had a 750,000.00 dollar house that was 1200 sq feet. lol i couldn't imagine that.

Man you are a Genius. That is hilarious

The arena that i watched the hockey game was the same arena that a 12 year old girl got got hit in the head with a puck and died the next day at the hospital. That is why the NHL now has those large nets above the glass behind the goals. Hockey has always been my favorite sport. Mainly...

She sounded like a keeper.

Yeah, she thinks its funny now. All of the stains came out of the jacket. Yes Rich that is the object. But it is nice to see replays and such on the tv. Actually we had the TV turned off most of the time. Thats what i like about Rich. Always trying to stir it up. The sad thing is that...

Hey all I just got back home from my first NHL game. Very Very good. I have never had this much fun at a sporting event in my life. I really appreciate the skill and the toughness of all of the NHL players. I watched the Columbus Blue Jackets take on the Vancouver Canucks in Columbus...

Another good way to lose weight is to drink lots and lots of water. I am really really out of shape so i am probably not the best one to reply to this thread but i did lose 50 pounds a couple years ago by doing nothing more then drinking lots of water. I still drank soda with meals and ate...

Hey all. Im back with another SQL question I am using the below stored procedure to insert a new order for a customer. It also moved items from the customers shopping cart to the order details table. The procedure is working great with the exception that i am not getting the OrderID return...

Thanks a bunch.

Sorry for not replying. I ended up working around the problem As always thanks for the help.

Hello all. I once again have a SQL statement problem. What Im wanting to do is SUM up the Quantity and price. The SQL statement below does this just fine. SELECT ScripSaleCart.CartID, ScripSaleProductMaster.Description, ScripSaleCart.Quantity, ScripSaleProductMaster.Price...

OK Here is my sql statement SELECT Sum(DepositAmount)-Sum(PaymentAmount) AS Balance " & _ "FROM tCTransactions " & _ "WHERE tCTransactions.AccountName = 1 Im still getting the same error