Recent content by Ankie

Thanks! Now it's solved :)

Hello everyone, I've made a form where the user can fill in a field ID... and than by clicking on a button another form will be opened with the data of that person (with that ID that's filled in). But if the user fill in an ID that is not currently in the database, there will be also shown...

I just thought that was a good idea... you think it's better in a function or something like that?? I'm not so known in visual basic,.. but maybe that's better.. I don't know... What do you proceed??

If I do that, the query wouldn't show anything at all..

Well I have made a database with a report based on a query. Now I don't want to show the empty field in the report.. how can I do this? I want all the fields that are not empty show in the report, with no blank spaces... here the database .. Thanks for help! Ankie

Hi, I have 2 tables... one with 'answers' (on questions) and one with these 'questions'. Now I want to show the questions with their answers on a rapport (based on a query) .. but only these whereby the answer-field is NOT NULL.. So I have already: ansques1: IIf([answers.1] Is...

it's already done...

Can maybe someone help me with this? Or has someone a better suggestion how to do this? Hope to hear from you soon... Thanks, Ankie

Hi people, I have made a form, with the fields 'age' and 'score' (and other fields, but these are not relevant for my problem). The 'age' is automatically filled in, and the 'score' has to be entered. Now I want if you have entered the 'score' to get the right value in an other field in the...

I just solved my problem, thanks for the code!

Well if I use that code, then the report will be printed. I just want to open and show the report... how can I do that... I'm not so known in Visual Basis... Thanks

Hi people, I have made a form. By giving an ID up firstly this form of the concerning person appears. Now I want to make a link to a report on this form. The intention is then that only those data are shown in the report of the concerning person (therefore with the ID that is reflected in the...

Thanks all!

thanks! But can I use more query's in one form? And can I add a query later to the form?

Hi everyone, I have made a form using the wizard, the form is based on some tables. Now I have to add one new table to the form, how can I do this? If I change the recordsource, it wouldn't work, I can't even write anything in the form. Is it possible to add a new table or query to a form that...