Search results

You can´t combine reports that way as far as i know. Why do you need that after all? Use query to combine data and make one report.

Write a criteria to your query so the query won´t give you zero values.

You don´t need an extra table at all to choose a value. I just made it as an example because i didn´t know where to get the list for combobox. Seems to me that you´re trying to create a new project so start normalizing your tables. Right structure is most important or you´ll have to face a lots...

It´s just an example. There´s lots of icons with similar design in access templates (and even databases posted here), i just wonder how to add one in my project, I´m pretty sure they come with Access/Office. When adding picture/logo, the browse window will open starting from My Pictures folder...

Well you had done there something that i didn´t completely understand either :). I added a table there, i´m sure you figure out why. If you get stuck or have any questions post it here or PM. olxx

I´ve no I idea is it that what you wanted but created little something, hope it helps!

Hi! Does anyone know where are located those icons that are used in templates? I took a picture of one for you to understand what i mean. I see them lots in projects but i just wonder how to add on in my own project.

Hi namliam. I didn´t want to create new thread for that but how to use icons/little pictures that (probably) come with access. Where are they located at? I´ve seen them in lots of db-s and templates. They also appear if you use wizard to automatically create form. Thx, olxx.

Check the size of textbox you are using on report. It has to be the size of the text that will be physically on you report.

Maybe i didn´t get it right but why don´t you use pdf printer? http://www.cutepdf.com/products/cutepdf/Writer.asp It´s free, even for commercial use. Set this as default in your report setup and create as many pdf-s as you like. No VBA needed.

Wow, it works!! I don´t understand really how (i don´t know SQL that well). But BIG THANKS Mailman!!! I guess i have to study that IIf clause a bit more and that joining thing. Again Thank You very much for your help.

Ok. here´s the 2002-2003 version.

I have to go offline now. Will be back tomorrow morning or maybe in the evening, thanks for trying to help Mailman!

OK. here´s the file, see if you can get the thing.

I´m making simplified sample db right now in english, i´m almost done, so if you wait i´ll post it soon somehow.

Yep i got it, tried it, but it´s not what i want. With outerjoin query gives me the records that match but i need query to give me all records and an extra field for each record showing "ok" or "not ok". So i can place that extra field to my form. Point is, that my form is not linked directly...

Ok. How do I outer join in it? If i add just that one field from another table to that query and if query won´t find match, it doesn´t result me any fields. I could send you the db, but it´s in foreign language and there are much more tables, forms and queries involved. I´m starting to lose hope..

I still don´t get it. Right now I have form, two tables (tblInvoices, tblInvoiceDetails) and query that binds two tables on the form ( to show total and taxes etc.). I got the idea from Northwind db. It works fine. Now the checking involves the other table that is not (and can´t be) related. I...

Thx, for trying to help! Ok. but how can i get that query value on my form? To run query (e.g using commandbutton) each time to check takes time and is frustrating. What i want is when i scroll through invoices or open just one of them, to see the "ok or not" text next to the invoice nr on my form.

Hi, Here´s my problem: I have working form of Invoices (linked to tblInvoices) and I want the InvoiceNr to be checked if it exists in tblSomeTable. The check should be performed every time i move to next record on form (next invoice). If the invoice exists the text (txtbox or label, not msgbox)...