Search results
-
A
user select ID and get the form with data by that ID, but what if the ID not exists??
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... -
A
leave empty field out of report
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 -
A
leave fields that are NULL out of query
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... -
A
get value out of referencetable
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... -
A
open rapport (by ID) with button in form
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... -
A
add new field after using wizard 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...