Recent content by syntaktik

The only code that I am using is the one I posted, but, I will post my database here: http://dl.dropbox.com/u/1254531/Inventory.accdb I hope this would clarify my problem a bit more. Just try sorting the size colmn and you will see what I mean. p.s. This is an inventory for someone else... ;)

oh, this is part of a split form.

yes, haha. But I don't want to sort it by those numbers, rather by the "SortOrdNum" numbers which are "1,2,3..." not by the "ListValue" which is the 6 1/2 thing.

uh oh. Sorry about that. I was trying to get an answer, so i sort of simplified it because i did not think posting my code would be necessary ;). But yes, the 'actual' values are: ListName: this contains in what category ListValue falls into ListValue: This is the actual information it is...

this is my code: SELECT ListInfo.ListName, ListInfo.ListValue, ListInfo.SortOrdNum FROM ListInfo WHERE (((ListInfo.ListName)="Hat")) ORDER BY ListInfo.[SortOrdNum];

hm, Ii think that is my problem. I am using the built in button to sort with access 2007. But, yes, I am keeping all the information in a big table to manage all my many small lists. But that selected text will be stored in the actual table. I hope that sort of makes sense.

Thank you for all the replies! But yes, I am trying to sort by the priority column. It works properly when the number column contains letters, but when it contains numbers, it sorts by them, which I don't want. Can I somehow change the numbers to text? Or add a letter in front of the text?

I have a field which is a lookup field with three fields attached to it. The actual data is a number, but I don't want to sort it by that number, rather by the other column'd number. But it just wont. Any ideas? :confused: this is how it looks like: Number Priority 6 3/8 1 6...

Actually, this is just what I want to do, but how do i make it append rather than flag it?

I have two listboxes inorder to append a list of names. Then i discovered this pice of working code on this site. However, there are a few problems with it. One, It will create duplicates. (fixable with an index, but I want to set them to hide after selecting them) Two, if I open the form again...

Wow! Youre amazing at this! It works. I bet i could figure out how to make it do the reverse. But my last problem is to prevent duplicates. Just make an index? Actually. haha, I think i am overstaying my welcome with all these questions, but, how come does it not add thme to the other table...

Ok, I took out this part of my database to simplify things. I am still not sure why it isnt working though. Link: http://dl.dropbox.com/u/1254531/Database1.accdb

alright. I had a look at it, but the appending wasnt goign on so i looked a bit further and came across this here. I will change it around to see if it can suit my needs. I will let you know if I need any more help. thanks so far!

wow, you have got me there. I am not sure what to do after that. I mean i know how to delete a selected file. But no matter what I do I can't get thew append query to work properly. It sounds like you seem to have knowlege about VBA judging by you name however haha ;).

maybe this picture helps: