Recent content by Rohdester

Thanks for your input. It helped and fixed it! ;) ;) This was what fixed it: stLink = "[Company] = '" & Me!List3.Column(1) & "'"

I'm an Access newb in need of some help! :cool: I have a list box which lists names of companies. I'd like to be able to double click a name and then the event handler should open up the correct form for the company. The event handler of the list box is (I know the naming is bad but this is...

Hey thanks a lot for the input. I considered doing that but I've tried something else. I wrote a function which returns a number based on the string passed to it and then I sorted ascending by that function in the query. And it works. :cool: I'm wondering if there's a downside to that -...

Hi, I'm making a query. I have a field called "Status". It's a look-up with the following values: "Not interested", "Possible Subject", "Agreement under neogtiation", "Agreement negotiated" and "Company contacted". I would like to have the query sorted like this: Subject Company contacted...

Thanks Thanks a lot for your posts. They helped a lot. :)

Hi! I need some help with a list box on a form. I'm new to Access which accounts for some of my difficulties I'm sure. Any hints, pointers etc. would be appreciated. Anyway here goes. I'm doing a database used for management of sponsorships etc. I have four tables: Companies, Contact Persons...