Recent content by Wallie

Hi, I have created a search query with a number of criteria. The thing is I've imported alot of data into my DB and alot of fields are empty in its record. These records aren't shown in the search results. So I'd like to adjust my query so that every record is displayed when no criteria has...

Thanx

Hey, I have a problem which I can't figure out.... I have a form where one can select a company and for that company the website is displayed with some extra info. The problem is, when there are no records in the table (websites) an error occurs: No current record (3021). This is the code in...

Nope....still nuttin'

Still no luck....I think I've tried all possible options here..... [This message has been edited by Wallie (edited 04-10-2002).]

The problem was that in my table the field 'datum' was set to 'text' and not to ShortDate ;-) So that problem is solved.....Thanx. But when no date is entered in the textfield it should return all record nomatter what date. I figured something out like this...

:-( SELECT tbl.*, tbl.datum FROM tbl WHERE (((tbl.datum)>[Froms]![frm]![fieldDate])); Still not right, still no searchresults....but thanx anyways

Hey, I know this question may have been asked billion of times, but I couldn't find the answer I'm looking for. So maybe someone can help me out, because I've been trying a lot of things, without result. On my searchform I'd like to seach on a date > the date given in the form. The date stored...

When I use that Query, it show too many records. Every record AT LEAST 10 times....

They are linked, so what's next ? I've read something about INNER/OUTER JOINS .... but i've no idea what to do with them.... [This message has been edited by Wallie (edited 04-09-2002).]

I've rebuilt my query to this: SELECT [tblActies].[Id], [bedrijven].[bedrijfsnaam], [ContP].[achternaam], [employ].[Voornaam], [tblActies].[datum], [tblSoortActie].[type], [tblActies].[vervolgdatum], [tblActies].[actie] FROM tblActies, tblBedrijven, tblContactpersonen, tblMedewerkers...

This is my query (it's in Dutch ;-)) SELECT * FROM tblActies WHERE ((([tblActies].[WerknemerId])=[Forms]![actieOverzicht]![WerknemerId]) And (([tblActies].[soortActieID])=[Forms]![actieOverzicht]![soortActie])) ORDER BY [tblActies].[WerknemerId], [tblActies].[datum]; number of clumns: 7 Bound...

Hey again, The resuls from a search are listed in a listbox. This listbox has a number of columns with data corresponding with a record (duh). The results also contain values which are selected from a combobox. These values are represented by (id)numbers. Is it possible to get the value...

Hey, I have a question about using a date in a query. I have a searchform inwhich a date can be enterred. The searchresults are the records > given date. The problem is I don't know how to this and another thing is, I'm from Holland so I have the dutch MS Access. The date saved in a record...

Ben inderdaad nederlands, hoe kwam je daar zo ineens bij ;-). Ervan uitgaande dat jij ook nls bent: Wat je me hebt gegeven werkt toch niet helemaal lekker. Als er nu niks wordt geselecteerd haalt ie alle records op (perfect), maar als je wel een waarde selecteerd haalt ie nog steeds alle records...