Search results

Hi guys, it is very useful to use the treeview or listbox control, let's say with multiply selection property. You can use the CTRL key to select multiply values in them. I have a problem to manage the selection. Do you know the way to refer to the selected values as they were some kind of list...

Hi all, I would like to create the following code: ------------------------------------ sub test() condition= "4=4 and 5=5 and 6=6" result="msgbox("It is ok")" if condition then result end if end sub ------------------------------------ or sub test2() sentence="if 4=4 then msgbox("im...

hi guys, do you know how to call the function "docmd" but in another DB. for example I am working on my.mdb and have the code inside: sub TransferSpreadsheet() set db=opendatabase("C:\another.mdb") with db DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel8, tbl.Name, DirectoryPathMain...

Hi all, i have few tables in *.mdb that are linked to *.xls files. I want to change their path link using VB in MS Access. Do you know how the change table properties to change their link to another path using VB code? (something like "Link Table Manager" but in VB code :) ) Thanks in advance...

Hi everyone, I have huge problem :( I have a *.csv file and a am linking it to my Access DB using this command: sub test() dim db as database set db=currentdb() with db DoCmd.TransferText acLinkDelim, , "Table_Name", "c:\my_file.csv", True end with end test You know that the TransferText...

Hi all, this code links specific file (my.csv) to currentdb. sub links_file() DoCmd.TransferText acLinkDelim, , "My_Name", "c:\my.csv", True end links_file Do you know how to link the same file but to another DB existing somewhere else? Thx in advance for any help. Mathematician

Hi all, I would like to compact the same database I am working with, using VB. It shoul to work like this: sub compact() DBEngine.CompactDatabase "c:\my.mdb", "c:\my.mdb" end compact how to compel VB to compact the same data base where the code is. I don't want to compact to another location...

Hi all, Do You know maybe if there is any function (lets name it: "desired_function") in VB making from any list of characters the one string varriable? I mean: sub dim I_am_text as String I_am_text=desired_function(Here is the " " very different text. With number 444 and stupid things...

Hi, I have procedure: sub test_thirst() msgbox("This is test") end sub and I would like to call this procedure using a variable as a name of the procedure above, I mean sth like this: sub run_variable() My_Variable="test_thirst" Call My_Variable ' Here my procedure test_thirst should to...