Search results

Great news! Glad you sorted it out :)

The #name? error is caused by the way you referenced the subform controls. Check this out, it will be very handy next time you will be in a similar situation:Refer to Form and Subform properties and controls And, check out this thread regarding the 'return without GoSub' error. It might be the...

LOL...I have to type faster...when I started there were no replies yet :D

When you are in the design view, gaze to the right side of the Access ribbon. You will see a big sigma symbol (∑). Click on it and you will see a new "Total" row in the query design grid. Choose "group by" for MC and "Sum" for the Parts made. Hit "Run" and check out if that is the result you...

Thanks for the reply, Simon, but, as far as I know views can't take parameters. I even tried the silly thing to create a view out of whole tblInvoices and query that view in Access, feeding it the parameter for InvoiceSalesSlip, but it was just as slow as querying the linked table itself. I...

I am doing my first baby steps with SQL Azure backend and Access 2016 as front end. I have used SSMA to migrate two tables, for a start. tblInvoices (140 000 rows, 18 columns) and tblInvoiceDetails (320 000 rows, 24 columns) I use SQL Server Native Client 11.0 ODBC Driver for connection All...

I just wanted to let you know...your code works beautiful! All I had to add was one line to close output query before deleting it. I can't thank you enough! My bags are packed...first really free vacation in ten years - here I come! JHB, write me your physical adress in private message and...

Let's put it in simple words: Simon says...let strMedijNaziv be whatever value written in txtMedijNaziv on the search form. There is nothing written there? Ok, in that case let strMedijNaziv be "Like '*'" To answer your question, as I understand it, the IF statement becomes true if...

But Media name works! If there is value in Me.txtMedijNaziv than strMedijNaziv is that value(exactly, or part of it). If I leave field blank than query shows all records. For the rest of it...you gave me something to think about. I'm new to this VBA stuff, but really determined to learn it...

I'm so thankful for your help...but that is not working either... You know what...damn the code...I'll quit for today and sit in front of TV to watch "Gladiator". Maybe looking at the half naked, muscular, dirty man will help my little grey cells relax and work better afterwards :D

Invalide use of null again... Highlited row is: strNakladaMin = Me.txtNakladaMin I changed it to strNakladaMin = Me.txtNakladaMin.Value, but with no effect. I tried different method: This also gives me Invalid use of null and same highlithed row. Can you think of reason why this is not...

We are almost there :) I did what you suggested and changed last line it the code to this: Now search form works when something is selected in Naklada and Početak fields. But, although there are no empty fields in my underlying query and all data seems valid, If I leave Naklada or Pocetak...

Here it is:

When I delete the query and run search again, it gives me syntax error. I attached PrintScreen of it. And takees me to this line: In the error message it looks like my SQL statement is cut of at the and? I checked names of everything, It seems OK. In immediate window it also looks fine. I'm...

When I click "OK", It gives me message: Object "qryEmailoviOutput" already exisits. ...and takes me to this line of code:

Problem is in my front end called "ADREMAFE-2", form name is "frmEmailovi". Everything worked fine until I added strings for searching between NakladaMin and NakladaMax (number field), and PocetakMin and PocetakMax (date field in format dd/mm/yyyy) Final SQL statement:

No luck :banghead: I think that maybe I'm doing something wrong when building criteria for these last two strings?

Well, after some modifications of your code, JHB, search for part of Media name is working now...jipiiiii :) Thank you! Min/max for Naklada (nuber of copies) also works when values from unbound fields are inserted directly into the SQL statement... What I'm trying to do now is to put these...

Thank you, JHB, thank you very much! I'll try it out and let you know if it works now :)

I'm trying to adapt Martin Green's search form code, making SQL and VBA to work together using ADO. It's no problem when it comes to combo boxes, list boxes and exact matches, but I have been struggling for days with Like and Between. I'm not sure how to build criteria, and how to compose SQL...