Search results

Hello everybody i have a directory c:\ 123 - AAAAA 45678 - BBBBB How can i rename the files in AAAAA - 123 BBBBB - 45678 without touching the subdirectories Thanks for all and happy new year

Good morning to you all, I would like to copy the entire folder from K: to P: if the folder does not exist. And then copy the existing folders from K to P. I started with the non-existent files but it does not perform creation. Option Compare Database Option Explicit Sub...

My code hangs (Error75) if the folder exists. How to go next Option Compare Database Option Explicit Sub Verifier_Presence_Sous_Dossier() Dim Pth As String Dim i As Integer Dim strSql As String Dim dbs As DAO.Database Dim rst As DAO.Recordset Dim fs As FileSystemObject...

I try to simplify my code using indexes but I have a problem at level MkDir (strPathNl) & newNameA & "\" & newNameA&i Syntax error. Sub RenommerDossier() 'Pr?alable: v?rifier si les r?f?rence n?cessaires au FileSystemObject sont activ?es. Dim objFSO As FileSystemObject Dim...

Good morning to the community I would like to use the value of Numchaine in rematricule but I have an error message "non optional argument". Someone would have an idea where the mistake came from. .... LeMatricule = Left(rst!NomNameMatrK,1, NumChaine) ............ Public Function...

Good morning, everyone, I would like to standardize the labels of my files. So I have a folder c: Staff Eric Lepetit (123) folder1 Folder2 Folderx ABC.txt c: Personnel John Medium 456 folder1 Folder2 Folderx DEF.txt c: Staff Matt Eric Lepetit folder1 Folder2 Folderx GHI.txt And I would like...

Hey the Community, My code blocks at the line level "MkDir ToPath" He don't find the ToPath directory Option Compare Database Function Copy_Some_files() Dim db As DAO.Database Dim rs As DAO.Recordset Dim sSQL As String...

Hello, How can store the total of "DateDiff('m', [debut], [fin])" of a [Nature] by [Matr]. . I have a table with fields debut, fin, Matr, Nature. Matr Nature Debut fin Calculation (DateDiff('m', [debut], [fin])") 3478 Holiday 1/1/2017...

Hi Everybody, Whats wrong with my code ?? newSQL1 = "SELECT CODE, DCOUNT(PERIODE,Maladies,"PERIODE = '01/01/2017'")AS Teller FROM Maladies " Habiler

Hello every, I would wish to know how to put a condition in the property field : valid if . I have 2 fields date [begin] and [end]. I would that [end] cannot be lower or equal at [begin]. I tried >= [begin] but I receive a fault. Thaks Habiler

Hello all, The module below below gives e an error of execution 13, while it worked perfectly in another directory. The error is situated at the level of the line: If Len(Dir(filePath)) > "" ThenWe can help me? Thanks for all Habiler The whole module : Private Sub...

Hello, I created "system" forms beginning with one S but I do not find them any more. How to get back them. Thank you very much Habiler

Good Monday everybody. I am blocked with the code which follows: I would want that the hyperlink link is stored in the field and does not open. Is there a way to reach there. I tried with Gohyperlink but I failed. I work in a form. Thank you in advance Yours Habiler Private Sub...

Good evening to all, In the section detail I would wish that all the line appaers and is printed in blue(by ex) if the value of [klasse] = 1. I have already tried the CF but I crashed Excellent evening and well week end Habiler

Good evening the Community, I would want to create an used directory starting again of sub-directories corresponding to the number of an employee. In brief in an used directory if the sub-directory X (number of the employee) does not exist, this one owes to be created. Thank you in advance...

Hello the Community, I have a field hypertext and one fields number. In my directory C:\ y\ I have a file 123.pdf which 123 corresponds to number 123 in my field X I would want that by clicking on my fields hypertext I would want that it fetches my file 123.pdf in the directory c:\y\ Yours...

Hello to all, I have a table including fields candidate, Chairman, assessor1 and assessor2. By mailing I would want to print (3X) an including document on the one the name of the Chairman, on the second the name of the Assessor 1 and on the third the name of the Assessor 2 with on three...

Hi all of you, That's my problem I have 3 fields Yes/No. A B C To be in order it is necessary that: A , B and C = Yes. I would want to print all differents combinations : A = no et B et C = Yes Then A: Missing Nom, prenom et adresse. ..... ..... A = Yes, B=No and C = No Then B and C...

Hello The community In a form I have fields name, first name in which I would if necessary want to put the first letter of the name and/or the first name in uppercase. I created for it a buttonUPLOW How to synchronize this action. Thanks to you all Habiler Function MiseEnMajuscule(Chaine...

Hi, I have a field email in the table 2015. I woud create a query that sort my mails separated by a comma. E.G. 123@456.com 456@789.fr ... Sorted = 123@456.com,456@789.fr, ... Thanks Habiler