Search results

first, thank you for answering. It is a text box, not a label. I know all the field should be filled and understand nz. I attached my database so you can see..... Form "otpremnica" text box text142 ....

I created text box and wanted to sum two text boxes values in form (=[Količina bruto:]+[Količina bruto1:]). I receive error #type!... what is the problem...?

Another similar problem...... I added another combo box on that filter form (bombo box connects two fields in table , firstname and surname) but it doesn't filter anything when I run report. It appears that the right informations are in combo box when I click on it.... see picture. I suppose the...

I finally figured it out. I removed ID field from query.. That is it....

I created query. After that created report based on that query. In query I put criteria that will looks for values in form that I created earlier (three values, number and two dates). When I run report filter form appeared. If I just click on OK report returns all record which is ok. But when I...

I now see you edited your post and it is clear to my about changing from lookup to standard text box. Should I create query after that which comboboxes on forms will pull information from ? thanks for help. It was very helpful

Did you see the microsoft table I attached? Table Cases pulls information from others tables via Lookups. I really don't understand now. What is the other way in table Cases to pull that information like \Assigned to, Caller , Opened by etc...

I explored some microsoft databases. For examples this one I attached. Look at the table [B]Cases[B]. There are 5 lookups in that table. This table needs information from others tables. I don't see other way to resolve it but lookups. I suppose that microsoft will use something else if it is...

Thank you for your explanation and help Galaxiom. :)

That is correct, these two combobox should have the same list values. besides that what is the recommedations to use instead of lookups at the table level... thanks for help

and what is the resolution to my problem in my case? Besides that what to use instead of lookups?

I have already done so but the same results....... I uploaded database, look at the form "Monitor-final " and combo box "racunopolagac1". It only displays id's of the racunopolagac...

it seems ok (columncount, boundcolumn...). I need more concrete resolution to the problem.... thanks anyway

I created a form based on my table. There is one column “racunopolagaci” in a table where I used query in order to see names instead of id's ..see picture When I open my table I can choose list of names under that column instead of id’s. But when I create form based on that table and after...

Thank you :)

I am an almost beginner to access. I need to design it help desk database for my school and need to design tables and form for it.Is there any design and form examples that I can see... thank you