No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
Hi, how can I simply read the excel data using vb 6.0? |
|
how can i display the last insert id into a textbox on my web form? here is the code i have so far... [COLOR=#0000ff]Protected[/COLOR] [COLOR=#0000ff]Sub[/COLOR] Button1_Click([COLOR=#0000ff]ByVal[/COLOR] sender [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]Object[/COLOR], [COLOR=#0000ff]ByVal[/COLOR] e [COLOR=#0000ff]As[/COLOR] System.EventArgs) [COLOR=#0000ff]Handles[/COLOR] Button1.Click [COLOR=#0000ff]Dim[/COLOR] MyConnection [COLOR=#0000ff]As[/COLOR] SqlConnection MyConnection = [COLOR=#0000ff]New[/COLOR] SqlConnection() [COLOR=#008000]'declare new connection object [/COLOR]MyConnection.ConnectionString = [COLOR=#800000]"Data … |
|
I want you to develop a Refresh mechanism. The grids on various tabs does not refresh automatically when some data is changed due to changes on other pages. For example, if I add some data in detail section and attach a document of personal details the grid on the personal … |
|
Hi all Im developing one application where i need Ms Exell as my database and vb as fornt end i dont know how to use exel as data base? Plz help me out..... thnx regards.. Pgmer |
|
I am developing an excel solution and so need a little help with VBA. I have developed 2 macros that run on the spreadsheet "Sheet1" and have linked them to buttons on the "Menu" Sheet. The macros run with no errors on the "sheet1" sheet however have no effect if … |
|
[ICODE]['5 command buttons: 'cmdRestart; cmdLogOff; cmdForceLogOff; cmdShutdown; cmdForceShutdown Option Explicit Private Const EWX_LogOff As Long = 0 Private Const EWX_SHUTDOWN As Long = 1 Private Const EWX_REBOOT As Long = 2 Private Const EWX_FORCE As Long = 4 Private Const EWX_POWEROFF As Long = 8 Private Declare Function ExitWindowsEx Lib … |
|
// sorry i accidentally posted this in VB.Net earlier.. in case you saw it before. thought i'd make a program for fun.. although to be safe im cutting it up into many forms to save room. Anyway doing this means im going to have to get alot of the variables … |
|
elow, can any1 tell me whats the code for deleting a record in a database?? or deleting a row? my table is consist of fields.. lecID arlNumber arlLec arlPart thx in advance to, |
|
how to declare dynamic 2 dimensional array in vb with one of the bounds variable .. [code] dim x(1 to i,1 to 4) as variant 'i is a variable [/code] |
|
hi, i am a newbie... would anybody please to tell me, how is the codes, to directly changing windows default printer, from within visualbasic code, without poping: windows select printer dialog box best regards ndutz |
|
examples of code or syntax for the option button,any example will help.thanks! |
|
[I][B]Hi To all,i used progress bar control of 7 array i.e 0 to 7 ProgressBar(PB) with same name pb1 ,but how to write code for each .My code is working if i select 1 PB and there is any other event for pb that i should not click on pb … |
|
Hi all, first post. I am working with excel files which get their data from htm files on the same folder location. Every time I open the xls file I get a prompt "Some of the files in this web page arent in the expected location. Do you want to … |
|
I'm trying to create an overwrite save command within MS Excel 2003. I'm saving the active work book as a new file: ActiveWorkbook.SaveAs FileName:="c:\Test\testfile.csv" I need to run this macro on a regular basis and sometimes the file will be already held in the location above and sometimes it won't … |
|
Hi everyone! i am developing a application that has 2 areas- admin & user respectively. admin app is on server while clients are users.there is a form in user screen that uses a frame which needs to be enabled on button click present on admin screen. in short admin will … |
|
can any body help me? how can i use reguler expression in vb code? i want a reguler expression program that maintain the ip address. plz send me full code of ip addressing with reguler expression. |
|
I hope this is the correct forum to post this. Wondering if anyone could help... On a form a continuous record list is displayed as results of running a QUERY. While this QUERY is displayed, I’d like to filter it. QUERY would display on a FORM showing: (customer: being the … |
|
I am processing word documents and would like to move the files to a new location after processing. What code do I use to move file from one directory to another. |
|
Hi Can you help with amending this code, so it no longer looks at the boot ini, but will look at apx 200 separate texts files called "textfile1.txt" "textfile2.txt" etc etc consecutively for the line of text "Max100" and remove and replace with "max200" This is a piece of code … |