Recent content by DanSmith

Hello, Thanks for your answer. I figured it out. Actually, I use another db to open the password protected database bypassing the database password. I wanted to have it in the same db in order to avoid to have 2 db but it is not possible to have code before the database password is asked...

Hello, The situation is as follow: I have a database where I put a database password. When you open it you have this little box where you have to enter the password. I made my own login from with user name and password that open up as popup maximise when the database is open. What I would...

Hello, I have the following problem: I have a make table query that sum a total amount in order to have only the total in the table field. However, when the total is 0.00, the make table query says "you are about to pos 0 rows" instead of postin 1 row with 0.00. How can I set the query in...

Hello, I do have a problem when I try to export a table as text. In fact, I have a field where the data come from a text box in the form. I have a make table query and for this field, the data are made in binary code instead of text. Also when I try to export as text file, I have this field in...

Hi Jon K, PERFECT :D :D :D It is working like a charme...... thank you very very much Have a nice day Cheers! Dan

Hello, I have added this IIF expression in the criteria in a query: IIf([Forms]![Open_Form]![CLAMT_BET] Is Null;[Tbl_MainWeekly]![Credit limit]; Between [Forms]![Open_Form]![CLAMT_BET] And [Forms]![Open_Form]![CLAMT_and]) When the field CLAMT_BET is empty I get all the data which is what I...

Hi, I have tried the following: >[Forms]![Open_Form]![CL_Amt]) in the criteria and it works fine. However, when I type the following, it returns all data equal to 0 IIf([Forms]![Open_Form]![Sign CL AMT]=">";>[Forms]![Open_Form]![CL_Amt]) Any idea ? Thnak you very much Dan

Hi Neileg, Thanks for the answer.....but now I have another problem....is how to build the SQL in VBA....good question.... I'm not an Access expert but I will try to get the info that way.. If you have an idea it would be very appreciated. Thank you Cheers! Dan

Hello Nobdy else has a solution to my problem ???? Thank you very much in advance Cheers! Dan

Hello Neil, Thank you very much for your answer. However I have tried with the Eval() but I still get the same error message. It is strange because when I type <500000 in the criteria it works. It seems that the sign is not recognise as such. Cheers Dan

Hello, I'm gonna try to explain my problem. In fact, I have a form where I have a list where the user can select the following signs : <, >, >=, <=, = (greater than, less than etc...) Also, the user has the possibility to set the value that will be go with the operator above. I tried the...