Recent content by NoMAd

you can actually.. list57 = CCur(list29) + CCur(list33) + CCur(list35) :P

how do u do the sum of list boxes added together?

how do u add prices in a query? e.g [ product , name , price ] if i had a bunch of products, how do i add all their prices together?

if i had a table structure like this: [ user , active (yes/no field) , product , qty ] for a shopping cart kinda thing, how do i insert a product into that table where the user = yes, or active?

yeah thats mad.. but is there ne way to make it like its just been clicked?

hey thanks that works.. i have another problem now.. how do you make a list box automatically select the top row once it's run its query?

Thanks WayneRyan It worked for a second but then something happened. DoCmd.RunSQL "Insert Into cartcontent( User, qty, product) " & _ "Values(" & Me.CurrentUser & ", " & _ Me.text2 & ", " & _ Me.list24 & ");" i used that, but it gave...

ok.. but that doesnt answer my question.. i want to know how to add to their "cart" when they are active... like it finds which user is active and puts it in their cart.. thanks anyway

Sorry if this has already popped up.. Umm.. i need help with an insert query, but i have to use vb for it.. STORY... I SPOSE.. Its a computer part shopping cart basically.. when a user logs in, a column in the user table called 'active' is set to YES, since its a yes/no field. When a user goes...

i cant take credit for this.. but there was a bug, so i fixed it.. shows login with pass and user.. http://www.thegamingelement.com/logging_on.zip i have upload troubles :P good luck m8

i am trying to insert info from a form into a table.. but thats not my problem.. The info I want insert has to be inserted to the User that is currently "active" in that table. My table structure: User: [ userid , username , password ..... active ] Product: [ product , name, .... ] CartOwner...

im pretty sure you can change the heights of the form... i know you can at least change the width, its under the format tab under the forms properties.. and try subdatasheet height.. im not sure if that will work tho.. just browse the formats of the form and see if you can find nething...

try putting it as a macro..

i dont quite understand.. why dont you just edit your table.. and do an insert if thats what you need to do.. you cant "split" fields through a query.. umm yeah.. i dont really understand though.. explain more..

ummm.... it is under the format tab.. its "Record Selectors" and "Navigation Buttons"... if you cant find them make sure you checkl that your not under the properties of an object on the form.. other than that im not sure.. unless you've got a screwed version of access or your form is...