Search results

  1. O

    DMax with more criterias

    Hi Everybody. I'm trying to build a Dmax function that include more criteria. But I have some problems. Here I post the 2 DMax function: DMax("age", "data", "[id_name] = " & Me.ccName) DMax("age", "data", "[id_address] = " & Me.ccAddress) I need that the 2 are together so I will receive as...
  2. O

    Function Max

    Ah ok. I will try tomorrow with the 2 queries, but, as you said, I will probably have a problem cause in my data there are a lot of "same number"... Thanks for the suggestions. Greetings Omar!
  3. O

    Function Max

    It works. Thanks. Greetings.
  4. O

    Function Max

    Hallo everybody. I have a problem with a query. I need to select the max value of a field in a table and after I want to show all the record (the max value and the other field). For exemple: 200 CH1 CAT 220 CH3 DOG Output --> 220 CH3 DOG So I write this query: select max(value)...
  5. O

    Dlookup with more values

    Thx I find another solution, working with query... Thx for you help, greetings!
  6. O

    Dlookup with more values

    Hi my friends. I have a little problem using Dlookup. In my form I have 1 textbox (with date and hour ex. 2009-10-30 11:00:00), and 3 dropdownlist. I want that when I choose the date and the first ddl, the third will be enable and show only the value with the other 2 (date + 1st ddl). After that...
  7. O

    TextBox with maximum number of character and textbox to count the remaining

    Thx a lot David. Greetings
  8. O

    TextBox with maximum number of character and textbox to count the remaining

    @PeterF Only one question. In the code the select case call 8,46. What does this numbers rappresent for? Do you know a link where could I find all this "numbers"? thx, greetings
  9. O

    TextBox with maximum number of character and textbox to count the remaining

    @DCrake Thx for your help. Greetings
  10. O

    TextBox with maximum number of character and textbox to count the remaining

    @PeterF Thx a lot. Works greatly. Greetings
  11. O

    TextBox with maximum number of character and textbox to count the remaining

    Sorry David but I think I had explain bad my problem. I want only that when the string I write in the textbox, arrive of a length of 255, it will be impossible to write any other char. I want to do that cause the field is a varchar(255) and I don't want access cut the string... do you...
  12. O

    TextBox with maximum number of character and textbox to count the remaining

    Hi Everyone. I have a problem with my Project. I have 2 textbox. In the first one is possible to write a string of maximum 255 characters. I want that when I arrive at the 255nd char, it's impossible to write anymore. In the second I want that we have a "countdown" of possible writable...
  13. O

    Create a txt from a table db with VBA

    thx works greatly now! have a good night! greetings!
  14. O

    Create a txt from a table db with VBA

    Thx, works fine with Docmd.transfertext. Now I tried to do the "restore" (import from txt) but I have some problems... My code: DoCmd.TransferText acImportDelim, , "tableName", "c:\test.txt" The error said that a value "F1" is not in my table... :(
  15. O

    Create a txt from a table db with VBA

    Hi Everyone. In my project I tried when I clicked on a button, to create a file.txt with all the informations that contains a table of my db. Here my code: Private Sub bBackup_Click() Dim SQL_query As String Dim Path As String Path = "c:/test.txt" SQL_query = "select * from...
  16. O

    Backup and Restore a MySQL DB

    Thx I tried the "outfile" and goes well! Thanks for the suggestions... In fact I use MySQL 5.1.37... Greetings
  17. O

    Backup and Restore a MySQL DB

    At the moment I work on my computer but at the end of my project it will be on a local server... Greetings
  18. O

    Backup and Restore a MySQL DB

    Yes, with PHPMyAdmin I don't have problems to backup but for my project I need to use VBA and make this backup automatically when I click on a button... Thx for your help. Any other suggestions? UP...
  19. O

    Backup and Restore a MySQL DB

    Yes I have PHPMyAdmin...
  20. O

    Backup and Restore a MySQL DB

    Hi everyone. I search in the forum but I didn't find anything really "perfect" for my problem... In my project in Access 2007 I use a MySQL database. In a form there are 2 buttons (one is backup and the other restore). I want with the help of VBA to do a complete backup of all tables in my...
Back
Top Bottom