Search results

  1. D

    Bypass database password using VBA code

    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...
  2. D

    Problem with null or empty table

    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...
  3. D

    Problem Export Table binary instead of text

    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...
  4. D

    What's wrong with this IIF expression

    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...
  5. D

    Problem with operators

    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...
Back
Top Bottom