Search results

Hi Again! Made it work! Had to set tempvars on all the textboxes, and then an apply filter, also on the textbox/combobox Linking several fields to the same textbox was easy, once i figured out that I had to change AND with & Sometimes it`s so much closer than you think! So now all the...

Thanks again for looking at this and sorry for my late reply! I'll try this right away! I can't understand why it should be an obstacel to have more than one filter like this. But I gues getting one to work properly is the first I need to accomplish :) I'll let you know how it goes!

Hello Triplee and thanks for looking at this! Sorry for my late reply! Yeah thats exactly what I'm doing but I cant get the logic right or the textbox macro.. At least it seems as I'm on the right path, only not quite there yet.. KOng_haakon

Hello all of you enlightened! I have a problem with getting a form filtered the way I want.. This is a simple contact-database, with one table, to be published on sharepoint. I have a navigation form with three subforms, one of wich is a Continuous form based on the table of the DB. I've added...

Finally!! It works! Brian offered the solution, wich was to use a LIKE "*" & [Parameter] & "*" as criteria in the query! Thanks for taking the time!!

Aaahhh!! Brian you genius!! That did it!! Thanks so much! Now it works and I'm a happy man! :) Really appreciate the help offered!! Thanks again!

Hi Paul! The query is the issue in the post that Brian links to, but as the query runs as it is supposed to on its own now, I'm thinking the issue here is somewhere else.. Anyway, there is three columns from the table that is relevant in the query. One is called Område (norwegian for area)...

Hi again Brian, and sorry for my late response! Thanks for your percistence!! I`ll try this asap and get back to you!

Hello access Wizards! I have a problem that has ben bugging me quite a bit. I have a simple database for web (access 2010 - one table, just under 20 fields) that is to contain a contactlist. Ive set up the interface so that I can make a quick list of the "appropriate" contacts based on two...

Ok! Thanks for all your help anyway Brian!

Yeah I've tried that. But still the same.. The parameters is collected from a navigation sub form, but i can not for my life make it accept only one of the parameters. And since it works with both parameters, I assume I've done the form references correctly. It is, after all, collecting...

No worries Brian! :) AllRight! Thanks so much! This is moving in the right direction! Cant thank you guys enough for taking the time! So now I've got the query running like it's supposed to on it's own! My next problem now is that the same issue that I had in the query itself, now has "moved"...

Found aworkaround to see the syntax via the debugging window. Heres the syntax that is in use: SELECT KontakterT.Fornavn, KontakterT.Etternavn, KontakterT.Telefon, KontakterT.Epost, KontakterT.Område, KontakterT.Instrument, KontakterT.Instrument2, KontakterT.Status FROM KontakterT WHERE...

Hi again! I would love to post the sql code, but SQL-view is not an option when making webdatabases so im not really shure where to find it.. I`m sorry! I've tried to link the parameters directly to the form as you mentioned Brian, but no luck. If you see the attached photo, thats where I...

Hi Brian and thanks for taking the time! Yes you are right, I was a bit quick on my first post there. What I've entered is [Instrumentparameter] and [Areaparameter]. They were initially called what I first wrote, but I've changed the name of the parameter so that it would not be the same as the...

Actually, I have kind of the opposite problem. If I type just one of the prompted parameters, it works like it`s supposed to. But when I type in both parameters, it just returns all of the databases records. Thanks again for taking the time!

Thanks for your quick response! Shure i can post this if you could tell me where to find it? I've not done any code on any of this, since this is to be published on sharepoint. In the querydesignview i have typed in [area] in the area column, and [instrument] in the instrument column, and...

Hello! Ive just recently started learning a bit of access, so I apologize if my questions is dumb :) Im building a real simple database with one table. It is a database of existing and potentially new employees. I run a musicschool so im often in the need of searching for substitutes and new...