Search results

Here's your reply! Pub undecided as yet but bound to be one of the many hostelries on Sauchiehall St. in Glasgow. If you're in the area, I think i owe you a beer or 10 for all the help!:)

Hi Mile-o Thanks for replying. I actually worked it out already - your reply is right, I had ListBox instead of the correct name which is ListResults for my listbox. Just shows how a careless error can cause so much grief! Thanks as well for the example code that I used off another thread. It...

Hi everyone, Hope some one can help me with this! I am trying to do a wildcard search when the user enters a name into a text box and then presses a search button. I based the code I have on an example from Mile-O-Phile found in a previous thread but when I run it it comes up with a runtime 424...

Thanks for the reply Rob. I could make the text box into a drop down menu with the company ids but i've alread got a drop down menu with the company names in it which works fine and I wanted to have a range of search options, which was why i was trying to do it like this as well. Anyone got any...

Hi Everyone, I have another simple problem! I have a text box that the user inputs a customer id into then when they hit the search button i run a query that should display all of the records for that customer id, however, nothing comes up when i run it! If its a parameterised query with the...

Cheers!

Hi, I've been searching the site for info on Cascading combo boxes as I'm still having major problemos with my combo box/ listbox/ subform situation. I have found references to an example by candace tripp which sounds like just what I need but none of the links to it seem to work. Does anyone...

This one should work

Hi, i've posted a question relating to this before but its still causing me problems, even though I think its probably easy; it would be good if someone could tell me what I'm missing! I have attached part of my database thats giving me the problem. I would be grateful if someone would have a...

I know where you mean now, thanks Kevin but I think what is confusing me is where do I state which attribute is being looked at in the List box as it contains 3 columns......or am am I way off here?!

Sorry if i'm being thick but do you mean add that in the Source Object option for my subform? I tried that as it seems to be the only place to add it but then that obviously changes my subform completely. Thanks (in advance)!

Hi, I am having some problems getting my subform to display the info that I want it to. Any help would be greatfully recieved! I have a list box on the left and a subform to the right which I want to display details of whatever is selected in the list box, however I am completely stumped as to...

Hi everyone I have a form with a listbox on the left hand side and a suform on the right hand side. How do i get the records in the subform to change to the corresponding record when i select an item in the list box. I have got it so that I can open a new form with the correct info in but I...

Yeah, I worked it out. Thanks!!

Hiya, Can anyone tell me how to do this really easy thing. I want my list box to appear as empty when the form it is on is open and only display things when something is selected. I have already got it to display as I want it to, its just the getting it blank thats causing the problem. Also...

Thanks Mile-O, that's definately got me on my way. I appreciate it!

Hi everyone, I'm trying to create a search form for my database and would really be grateful if someone could give me a few pointers as to the best way to go about this! I would like a form with a number of options the user can search by on the left side then have a sub form on the right...

Not sure how to create the field that captures the first three letters of the field that I want. Any clues would be greatly appreciated!

Thanks, emcf. I'll try that.

Hi, I have a problem with creating unique primary keys. I would like each entry to have a unique key made up of 3 letters and then numbers with the first 3 letters used depending on the type of entry it is. The type would first have been selected using a drop down menu I think then the numbers...