Search results for query: *

Hello TSSTechie, Yes but can i in code say for example: if(NumberOfRows>5) Then MsgBox "Message" End if - Tom

I think this is an easy question for all experts her on the Access forum. Can I count the number of rows in a db? - Tom

Thanks a lot!, of course! ;) - Tom

If I want to run a sql query from a dropdown list that says a number, in this case a employee id, and I want the result to show in a textbox. How do I implement it? I have the the sql query (Is a SUM query so itr only return one answer) ready but I dont know how to return the value to show up...

Ohh, I mean the importing image dialog that appears on the screen when an JGP is loading. How do I remove it, I can think that i must be some code. - Tom

Hello, Is it possible to remove the "loading image window" in a form when the JPG file is loading? - Tom

In C++ you can store values in an array like: str[3] = hello; Can I do the same thing in Access? I want to store a customer number and later generate a report. - Tom

Thanks Daniel!!, that helped me a lot. I´m well understod with SQL but when I changed the jointype in SQL view it all went wrong - Tom

Hello all, How do I create a query at runtime and open a form with the result. Example the SQL statement "SELECT Name FROM Persons" open a form frmPersons and show all the names. (The textfield that contain the name can be static in the form). - Tom

Thanks for you help, now I got the IIF to work: Private Sub Report_Open(Cancel As Integer) Dim test test = IIf(checkbox, "match", "no match") MsgBox test End Sub (returns match if checked) But now a second problem arise. I can´t give the textfield...

can´t I do it in the controlsource of the textfield? - Tom

Access doesn´t like the "=" in the begining of the string. And if I remove it Access generates a error like the one above (with the 'First...) - Tom

Doesn't work either. Is my problem that i´m using a textfield in a report? - Tom

I get a error message like this. "syntaxerror in queryexpression 'First([IIF(([Forms]]![F_Order]![[payment]),[[sum]/3),"4000")])'" What means with "First" and all these "[" and "]", excause me for my lack of experience with access but I´m...

I have a subform that should be printed in each page, with a header and a footer. You could say that the result should be three pages instead of one. That is three pages that are the same. Does it clearify the problem, thanks for helping!! - Tom

I even get a error message with this one. =iif(3<5,2,3) &quot;The expression contains a non number&quot; (my translation) - Tom

Is still says &quot;wrong syntax&quot;, could it be that it´s in a report? - Tom

Hello all, please help me with this one. Whats wrong with this IIF. (Form!F_Order.payment is a checkbox, [sum] is av value from database) =IIF((Form!F_Order.payment),([sum]/3),4000) This is placed in the controlsource of a textfield. - Tom

How do I generate three pages in a report instead of just one?. I want to change a value in each page. - Tom

Yes, It says that the expression doesn´t contain a value. I use this if. If (getText = &quot;Topic&quot; And Forms!Formname!optionName.Value)... - Tom