Search results

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...

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...

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...

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...

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...

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...

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...

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...

Hi, I've have a relationship issue I think. I have a primary key on a customer table which is an autonumber with a lettered prefix. I would like the contents of this column to appear in a combo box in an equipment form but i am not able to do this for some reason. What data type should the combo...

Hi, I have a fairly simple question i think. I want to create a form for the user to input new customer details but how do i get a blank form to come up then transfer the details into my customer table? I think once i get the empty form I know how to put the details into the table but the forms...

I think this is a really stupid question but i'm new to Access, so if I don't ask i'll never know! How do I get my simple parameter query to produce results in a form instead of a table? Any help & other general tips would be greatly appreciated!!