Search results for query: *

Hi everybody, I have to declare a Globale variable in VBA so that I can reuse it in another function (sub). What is the syntax please ? Can I declare it everywhere in my project ? Thank U

Hi everybody, I need to print various Access reports (about 6 reports) in VBA. Does anyone know the function or the syntax to do it ? Thank U

Hi everybody, I would like one field in an Access table be the sum of two others fields in this table. Thank U.

Hi everybody, I would like to refresh , update the data of a table without closing the form linked to this table. Indeed I would like when I open another form from the first form, that It shows the new data I filled in the first form. Is it clear or I must explain better ? Thank U

Hi everybody, I would like in a Access database to make one account able to modify and delete the others users's account password. Is it possible ? So that , only one account or a group manages the security of the databe. Thank U

Hi everybody, I would like to get the date of the last modification in wrod and excell file. Besides, I wouldlike the same things for an access form, I mean, when the user modify datas dispplayed in an Access form, I would like to get the date. Thank U .

Hi everybody, I would like to set the value of a form control but dinamically. Example: Currently I used this syntax: wrd.ActiveDocument.col_eur.Value = "TEST" Is it possible to use this kind of syntax ?: Dim num_control As Variant num_control = 'the value of another field '...

Hi everybody, I would like to open Word and I want to set the value of the textbox within the document, in VBA of course. What is the way ? Thank U

Hi everybody, I need to align at the center the content of an Excel sheet. (Forms control and cells). But the width of the content is not always the same. I would like the code to center automatically before printing in VBA. Thank U.

Hi everybody , I want to delete or hide all cells after one cell: The column below or the line on the right of the specific cell. How Can I do that ? Thank U.

Hi everybody, I use this code to open a Word file from ACCESS: Set wrd = CreateObject(Word.Application) Wrd.visible = true wrd.Documents.open "c:\test_vba\test_vba.doc" It works well the first time, but when I close Word and the document and I click again on my button to execute the...

Hi everybody, I have some troubles to open a word file from ACCESS in VBA. The syntaxI use works only when Word is already opened. Can U give me a code who works even if Word is closed I mean a code that open word and open the file without troubles Thank U

Hi everybody, I would like that my code is executed when the Word document is load, when we open it. Where must I put the code ? What must I do ? Thank U

Hi everybody, I want to create a word document from ACCESS ( when the user click on a button within the ACCESS form ). The code I want to make must create a table in this new document with a number of lines that depend of the value that user putted in the form. By example, if the user put 45...

Hi everybody, I would like to select all "id" in a table ONLY where "raff" is distinct. I think it should be such a thing: SELECT id FROM mytable WHERE (SELECT DISTINCT raff) or SELECT id FROM (SELECT DISTINCT raff FROM mytable) So what is the correct syntax Thnak U...

Hi everybody, I have 3 tables which have the same primary key, I would like to select * (ALL) from these 3 tables in one query where the primary key is the same. This is my current code into only two tables : sqlselect_affaires_clients = " SELECT * FROM CHANTIERS JOIN CLIENT_FINAL...

Hi everybody , I would like with a Stored procedure check if a caracter exists in a sting stored in a SQL server field. Example : My field contains the caracters "ABCDEF" , I would like to check if "C" is in this string. Tank U

Hi everybody I have a variable I would like to increment 1 by 1 in vbscript It looks like '001' untill '999' My problem is when I add "1" to the value "005" (by example) , it don't return '006' but '6' . I would like to keep this syntax '006' So what do you propose...

I really don't understand. I've got an error : Erreur d'exécution Microsoft VBScript error '800a000d' Type incompatible My source field "numaffaire_pro" is bigint My destination field "test" is bigint This is my code : Sub OpenDatabase(ByRef dbConn) Set dbConn =...