Search results for query: *

Quick Background- I am trying to write a simple checkbook app to keep track of a joint acct my wife and I have. We have a specific amount of money we put in to this joint account every month for our bills and we want to start keeping track of how we're doing in each bill. For example, we budget...

Given the table structures and table data below can anyone help me on writing the query to get the results as below The ultimate goal of this query is so I can have a gridview loaded and an administrator can see a list of users with email and whether they are active, an administrator, and/or a...

Although that might work, I don't want to reinvent the wheel. I've decided to use a Case statement to make sure only "Football", "Basketball", or "Baseball" are being passed as a parameter. Anything else will get kicked out. It isn't 100% what I wanted but it accomplishes my main goal of...

Lightbulb goes on. I'll have to leave it. Unfortunately, my job is to secure our pages and I am not allowed to make any changes except for the usp calls. Although this is one of those times when you read someone else's code and go "Why in the world would they set it up like that?

I posted over in ASP forum with no luck. The problem with the one answer I did get was I'd have to change design of table/logic. My job is solely to secure all queries page by page by parameterizing them. Design/Programming changes are not allowed. Having an issue parameterizing an SQL command...

Having an issue parameterizing an SQL command. Backround- Our website is made up of 3 sections. At any time 0,1,2, or 3 sections could be down for "Maintenance, etc." The 3 sections are "Football", "Baseball", and "Basketball" We keep the site status information in a table with the following...

success! thank you so much for all your help. you truly know your stuff and it's good there are people in the world willing to go above and beyond helping people. I got everything that I wanted, now it's just a matter of tweaking everything to my liking. I'll post my final result for your...

i'm still not able to get the sides of the block to have the wood grain. i followed all your instructions and i still get a cube with the right front but the sides and different shades of grey. i tried to "paint" the tops and sides with my plain grain symbol but it doesnt work. any ideas?

perfect..you pretty much hit the nail on the head. i was on my way after I read your first 2 replies, but got stuck on 1 thing. how do you get your grain to be darker than the face of the cube? basically when i do everything in photoshop and then do the extrude i get the face of the cube and...

im trying to create childrens letter blocks, i've looked up tutorials on cubes and fooled around with extrude but i cant seem to get what i what. i'm trying to make them with all 6 sides of the cube have a border and a letter in the middle quick google image search provided this perfect result...

zameer- that's exactly what i did and it works great, i just wanted to tweak the way boxes were to be entered

I went a different route and added a box table so now i have tblBatch (BatchID) tblBox (BoxID,BoxNumber,BatchID) tblWIdget (BoxID) and made a form Main-TblBatch SubForm-tblBox SubSubform-tblWidget and got it working fine, long story short i wanted to make a combo box where it lists the box...

Thanks Zmr, its those little things that kill me. now for the thing i have no idea how to do. getting the correct box number to insert into the widget(wirelessunits) table. I select the box number from the combo box and begin to enter units but obviously the box number is blank in the table. i...

OK, I went with the Combo Box, wrote the loop to fill it with the correct number of boxes when the form loads now how do I make sure the subform only displays or enters in the correct box number, aka the current value of the combo box willir- i used your strSQL statement but got run time 3251...

Thanks for the tips, I'll try them today

We fix widgets We get as many as 180 widgets in at a time to fix, in as many as 6 different boxes I would like to enter these 180 widgets in as a batch, and be able to separate on forms/reports by Batch Number and the box they came in I am open for suggestions on how to go about entering...