Search results

I have two queries that collect and join data from different tables. Lets call them qry1 and qry2.Those two queries have no criteria and always return data. Now I have a third query based on that two queries that joins these two queries for a report. Report is launched from a form where user...

I have two queries that collect and join data from different tables. Lets call them qry1 and qry2.Those two queries have no criteria and always return data. Now I have a third query based on that two queries that joins these two queries for a report. Report is launched from a form where user...

Yeah I did. I started using Microsoft Outlook instead of Outlook Express. With that you can easily automate all kinds of stuff. I used VBA to create pdf and save it on HD for archiving reasons. Next sub will open outlook new e-mail message, fills all the fields automatically and attaches the...

Could you share how did "Attach and email the PDF to client" with macro. I´m stuck with it. Using sendobject, the pdf quality is poor and there is no way to tweak it. OutputTo allows to tweak a quality and save pdf, but how can I send it with email? I´m using Outlook Express and there is no...

I have query, with left join, that just checks some values are matching or not and adds one field to query result that contains "match" or "no match" (iif is null expression). Query itself contains other fields too which are editable. Problem is i cannot delete record through this query...

thx Brianwarnock! You got the point. That example is just what i needed, i´ll just have to dig it little further to work my way around. Big thanks, i wasted 2 d, trying to find a solution. Cheers, Olxx

"...I want to find out where each fish is at the start of each week in km.." I don´t get it. Can you be more specific, please.

Its easier to this using query and showing this on subform. Link query criteria to your main form textbox ad there you go. You can even use OnChange event on that textbox instead of using button. Then you´ll have this look like cool live search, which starts filtering as you type in name.

No, no. The user don´t have to fill it, if he don´t want to add that criteria. There are 6 different fields on form and user can choose any of them. The user can make query based different criterias for only one or for any fields he needs. Let say fields are, example: tboInvoiceNr, cboClient...

Thx for reply. Yes, I tried, it works without Like this way, but as i said, the problem will come when user doesn´t enter/choose value to cbo. You, see, there isn´t option "show all values" or "no criteria on that field". If the cbo is left empty the query will search then with Null as criteria...

Hi, Here´s my problem. I have a form that contains unbound textboxes, comboboxes and a button that runs query. The query criteria fields are linked to the textboxes/comboboxes on the form so the user can enter a criteria. In criteria i use -Like "*" & [textbox] & "*"- so if the textbox is left...

since my explanation sucks i posted an example here in excel so it will be more clear what i need. thx olxx

I have two querys with same number of fields and same field names. [BudgetNumber] txt [CostCategoryCode] number [TotalSum] number I need a query that calculates balance between these two querys. It should look like this, BudgetNumber (match with both querys), CostCategoryCode- all codes that...

Try just Me.Refresh on your event. It should do the trick.

OK. I´m pretty sure you can´t do it on report or maybe only with some tricky VBA code. Can´t you do the summing with query? Can you post your db here, maybe if i take a look at it i got some idea.

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