Search results for query: *

Hello! I am drawing a heart on illustrator and have already made it look nice. Now I want the heart to be 100% simetric and for that I would like to know how to make the handles direction and lenght simetric to each other? Please see picture in attachment. What about if I wanted to have...

Hello! I have a problem with an IIF Statement in a query, that I would like to ask for help solving it: I have something like this: Table A: Field AX: A1 A2 A3 Table B: Field BX: B1 B2 B3 I have a form-based query. I have a list box in the FORMX with option1 and option2. One of the...

Hello! I have a form with a list box that contains 4 values. I want all the values to be "pre-selected". Can anyone tell me how to do that? Thank you!

It's not working...

I have a table field with the following records: Table A aaaaa bbbbb (empty field) ccccc I want to run a parameter query that returns all the records when I leave the Parameter box empty. It's something like this: Like IIF([Parameter A] is Null,"*",[Parameter A]) However, when I run...

I have no idea why but changing to: Between IIF([PDA] is Null;#1-1-1000#;[PDA]) AND IIF([PDB] is Null;#1-1-3000#;[PDB]) ...works just fine! What does the # do?

Hello! I want to make a query that searches between Parameter Date A (PDA) and Parameter Date B (PDB). However, I want to leave the option to leave one of the parameters empty, and the query should run it either to minus infinitive or plus infinitive. Since I don't know how to run the...

I've been able to solve the problem with: Like IIF([Parameter A] is Null,"*",[Parameter A])

Hello! Thank you, but it is still not functioning. I've placed a printscreen here: http://upload2.postimage.org/29403/photo_hosting.html What am I doing wrong?

Hello! I'm sure this has been answerd before but I can't find any thread with this information: I have a query with two criterias, wich are obtained from dialog boxes. The queria gives me the result of Criteria A AND Criteria B. However, sometimes I want to leave one of the criterias blank...

Thanks!

Sorry? I didn't understand that. Thank you!

I have built a Cancel Button for a Data Entry Form, that closes the form without saving the record in the respective table, as I wanted. However, the Primary Key increases a step. How do I avoid this? Thank you!

Hello! I have a data form (FORM1), which gives me the main information about employees. Something like this: Name Age WorkerID Maria 27 100025 Carlos 54 023548 Ted 41 802354 Ok, when I double click in "Maria" or "27" or "100025", I want it to open a new form...

Hello! I have a basic question, which I'll explain with an example: I have a table with 3 fields: ID Full Name Birth Date How do I build a query that searches all the records that contain the word "Maria" in the Full Name field? Thank you!