Recent content by pitou

Hello Sueviolet Well, in fact concerning to Jon K, you do not have to create an update query but to use VBA. Just re-read the previous message he wrote. jean-Pierre

Thanks in advance for both of you to have helped me but my mastery of the English language is not strong enough. What is an append query ? I do not understand either the Ritchieroo's remark about to test Test your function on it's own... Well in fact, should it be possible to give a short...

crosstab query Hello JFKeagle I read your question. I can give you neither a solution with SQL nor with VBA, but what seems to me possible is to resort to EXCEL. The outcome of your crosstab query could be exported directly to EXCEL (tools/ office links) then, after to re-integrate the tab of...

hello I m trying to find the solution of a problem. I wrote in a module this function : ------------------- Function sql_action_ajout(ByVal NameTable As String, _ ByVal Namequery As String, ByVal ConditionWhere As String) As String Dim SQL As String, SQLIns As String, SQLSel As...

max size database Hello Fuga Perheaps the informations, I gave you last time confused you, I m sorry. The sizes I gave you was also to deal with the speed of the SQL queries. It was also the result of questions I asked to many access-users, about this topic. Pitou

report to word hello pauly Yes, I think there is a may not to export all your records with the report. Your report has to be based on one query Create first the query that filters the records you want to see printed (select field1, field2 from where etc.....) then after, build your report...

your database hello timeh I think I fixed the problem. The application that I send, works. In fact, you will remark that I destroyed the query "query1" and pasted it's code into the code of the dropdownlistbox (have a look at it). One thing that might cause troubles is that I have the...

your question hello Timeh I read your question and hope to answer wholly to it Sometimes I fear to answer because technical terms are a bit ambiguous and making a fool of oneself is not so far away .... Well I created a database with two tables inside (cf previous Alexandre's idea) the first...

ref:Front end/back end with different versions of access hello Fuga ! Nice to "read" somebody from Sweden. I do not know exactly the answer to your question, but if I had been faced with the same problem I would have chosen, without hesitation, the same version of Access for the front end...

max size for a database. hello Rogdool ! happy to read your question. On this site, I already asked the same question, that i think is very important. Some kind people (thanks Doc_man) answered my question. In the meantime, i have been gathering some informations that I hope will be useful...

transferdatabase Excuse me Dinah name the dropdownlistbox "tag" and not "tag1" it should not be in accordance with the code i gave you

transferdatabase hello Dinah I would like perheaps to answer to your question. I read carefuly your message and the other answers. My knowledge in ACCESS are not enough to give you a "click magical solution" for your transferdatabase. What i propose to you, if it suits you, is to create a...

database ms Access at Lafourche et Terrebonne hello Doc_man Happy to read you once again. All what you mentionned is true and the Englishmen did the deportation of the former Cajun people. I think it is a part of history and we have to forget it, as we have to forget that the fact to sell...

langues et langages Bonjour Colin et Alexandre Votre discussion est intéressante. yes obviously automatic translation technologies will have to improve. When I tried last time to translate an E-site about jazz, the name of a famous singer "fats waller" was translated into "graisses Waller"...

your answer hello doc_man Congratulation, your first french sentence was perfect, all but the word "hereux" which is written "heureux". Phonetically, it could have been perfectly understandable ! I think that the Cajun land was a part of the former Louisiana, sold by Napoleon at the beginning...