Search results

Hi, yes this looks good. I tried to run the code. I pasted it in a module and clicked run (play button) and I get and error on: TempSet1!OrdinalPosition = fldLoop.OrdinalPosition Method or data meber not found on ".OrdinalPosition". I included the DAO 3.6 lib since I saw that the script is...

Hi, thanks for the reply. I tried the function. It dumbed all the data of all my tables in text files. Realy cool script btw, but no descriptive information was included in the txt file. I read the description of the script and from what you wrote in the other post, it is supposed to do so...

No that's what I want to avoid, but thanks

Hi I am looking for an equivalent for the DESC command in Access. I need to extract the table definitions: name of each fields (at least). I know I can print that from the menu in Access, but it's not what I want. (and it does not print the comments section of the fields) I need to be able to...

Yes I was putting the mm/dd/yyyy in the Format field. I found the problem: I use Access in french therefor I need to use the format in french: mm/jj/aaaa instead of mm/dd/yyyy m= mois (month) j= jours (day) a= année (year) It is working now. Sorry about that. Thanks a lot for the support and...

Ok, I got the point, no functions in the Source property. I tried to put the format mask mm/dd/yyyy which bring us to the reason why I used a function instead of the Format property. (in a field bound to a date column) When I put mm/dd/yyyy and then leave the field / press enter. Access 2000...

Sorry for the delay, I don't usualy work on the weekends ;) It is a Text Field, bound to a column, in a form. Yes I am talking about the control source. I want to avoid the Format property, since it will use Regional Settings from windows to format the date. My app has to run on 10...

Hi Thanks for the reply. I tried =Format([datefield],"mm/dd/yyyy") before. But if I type that in the source field, access seems to try to filter the special caracters. So it automaticly transform it to something like: =Format([datefield],""mm"/dd"/yyyy"") Maybe it must be specified...

Hi I am looking for a way to format a date in a textfield troughtout my application. I created a module containing a Function that receive a Date as parameter and returns a string. I put : =formatCustomDate([dbColumnName]) in the source field. Everything works fine when the date is not null...