I'm trying to code my program so that if no picture is there to be saved (its blank) then insert a "-" into the field in the databaseI've tried many different ways including the code below but it doesn't work so how do I say 'if theres no image in the PicUpload box then...'...

hi everyone. I am going to learn Visual Basic(VB) soon. as far as i am concerned, VB is strongly related to Excel. I had previously learn java but not very good in it and in fact i am abit scared of programming. So may i know is VB easier than java and any suggestion on how to start learning VB as i...

I figured it would simply be "...If x = 1 Then End Sub", but apparently that's not it.

Hi AllI have written a little sample program to show you my problem (see attachment) and all works well but I have one problem...I would like the ChildId, TeacherId and SubjectId numbers to always match but I have no idea how as they are three auto numbers from three tables and spread over three for...

Hey there everyone. I have written this little application that is loading an RTF document into an RTF text box on my application. Now it I have set it to be locked so people cannot play around with the RTF document when it is loaded in the RTF text box in my application BUT if I have an image in th...

HiI was wanting to make a program where I type a name of a piece of code e.g "How to create arrays" then in a text box I paste the code. From there I would click add and in future when I need this code I would click on "How to create arrays" and I could select the code for use. Basicaly I want to ma...

Hi, can someone tell me if there is a way to add a checkbox control to a form that has a database that when you click the checkbox control it will remember your location in the recordset so that when you log back on you can resume from the location where you were at before you closed the program.Kin...

hello, i have to create a program that checks lottery results, with an additional program generating random numbers for the following weeks draw. To make it simple in this first attempt im not going to check the bonus ball. anyway, i have created the randomizer, that was fairly easy.where im stuck i...

Hey there guys. I have seen a few little applications on the internet where once you open them, they will have a little 2d character that walks across the taskbar and other windows. Say for instance it is on a window, it is able to fall off onto windows or the taskbar below, as well as being able to...

Hai all,<br/>Is it obligatory to put $ sign when using string functions ? i.e. Chr$()<br/>Also waht is the advantage of using it?

hi there! i just wanna ask..how can i make my controls resizable at run-time? please help me..i really need this one..an example would really help a lot.<br/>-jkcpineda

HelloI'd like to have a server register a new NetBIOS name on a LAN so that clients can locate it by broadcasting a query (this LAN has no DNS, and no WINS). Once it is located, clients will connect to its named pipe to tx/rx data.Using the following VB Classic code, I can successfully register...

I want to copy all files in a folder and sub folder to a different location. The code below works for files.Private Sub cmdCopyFile_Click() Dim Src$, Dst$ Dim Fname As String Fname = Text1.Text Dir1.Path = "c:\" Dir2.Path = "d:\_sa" Src = Dir1.Path & Fname Dst = Dir2.Path & "\" & Fname La...

The caption of a label in my program is forever being expanded and is now getting to the point where not all of the text can be seen, so a scroll bar needs to be added. I have drawn the scroll bar on the form, but how do I associate it with the label? Thanks in advance.

Ok here it goesIn a table called 'Members' I have a field called 'MembersEmail' and a filed called 'MembersCounty'What I'm trying to do is build a string that pulls up ALL of the email addresses in ALL of the counties selectedI was thinking something along the line...

a few months ago when i was developing my program i was sure to test it under Limited accounts, and even the Guest account, and i had no problems. now, i'm not sure what has changed, but my program is unable to even update settings files in it's folder because Windows is denying it permiss...

hi friends, is there any option to keep the Dll file other than system directory ? our application is running from the shared folder of an application server and client installation is carried out on each enduser system. and whenever any changes come i will carry out those changes to app...

hello,I have a textbox (text1) which I want to always have 6 digits..for example:User enters 1234 in the textbox, and I want it when the user clicks the a command button (command1) I want it to Auto put '00' at the start of the number..however, if they enter a 6 digit number '123456&#...

hi guys...<br/>i want my company logo to get appeared on the screen after setup process is completed...can anybudy help me out...<br/>the project is appearing in start menu...<br/>absolutely ....

I've added a datagrid to a database before using the old data contols to set the link (i.e. data1 and data2) and search through files but seeing as this way is no longer used and I'm now using ADO I have no idea what so ever of our to connect the datagrid to display the data Is there a &#...

I have an application where I was using a class module to read and write to ini files. I then discovered the WinAPI's GetPrivateProfileString and WritePrivateProfileString.I added a module to my project and put the following code in there;Public Declare Function GetPrivateProfileString Lib "ker...

I am trying to find out if it is possible to create a macro in an excel workbook that will open another workbook saved on the computer, perform a find, copy the data, and paste it in the opened/active workbook.I have been banging my head on the wall for several days trying to figure this out, and I...

HeyI know that I can get the current directory with VB using the CurDir command. Does anybody know how to get the current filename? or complete filepath?If it helps, I'm looking to make this program run with a particular filetype (off of the right click menu). So the file I want to pass would...

Im a newbie to VB programming. Some part of this code is from dev-archive . I want to use three buttons to copy cut and paste . I am getting this error "Name 'ActiveDocument' is not declared. " Please help me ... if possible can you correct this code. Public Class Form1 ' Three sim...

I have a large MS Word document that is created from another program. It creates a table on one page that needs to be modified everytime. This might be the 10th or 20th table in the file. I want to have a macro look for the word "Work" and when it is found go to the next table and take the 3 righ...

I am trying to allow a user to select a printer to print out a crystal designer report without changing the default printer setting. The code below works great for the print job but it changes the default printer to what is selected. I tried various approaches mentioned here at dev-archive but none...

Hey there guys, I have 200-220 computers on this network that I am working on and I was looking for a quick solution to automatically register files such as OCX files on the machines. Now we have a login script that can shell applications, map drives, etc so I can shell the VB app whenever the user...

Hi all,I am new to VBA/Excel, and am just starting to work on some macro's. I have made a macro to create a listbox, filled with information from another worksheet/workbook. Not that hard. The problem is this:I need to get every entry in column D, until I see a cell with Backgroundcolor 3 (red)...

hiI am trying to find out specific word from word document through my vb 6.0 application.I also need to replace that with multiline words.ex.To,{name}{address}other word content here..................Now when i replace the {address} with my address text coming from database.It puts additional spaces...

I am new to vb. I want code for displaying data in datagrid through ADO Connection.<br/>Thanks in Advanc

Hello<br/>I have created shortcut menus for my prog group. Now how do I add diff icon for each menu say appln will have icon1, uninstall will have icon2...:wave:

HelloI would like to control the gain of the PC sound card in VB6. More precisely, I want to play a wav file with speech and noise in it (speech on one output channel and noise on the other) and I want to be able to vary the signal to noise ratio (SNR) of speech/noise in an adaptive way. For example...

hello there...i'm new here n new with vb also...hehe...i use sstab...but then i don't know how to code if i click command button and it's true then it will automatically appear to the tab2...can you help me please...thanks a lot :D

Ok now I've had the brainwave to auto generate a poster using a set template and the information about the event previously entered by the user - (This part is almost done)I then want to email the poster to all the sporting clubs who's email address I have stored in the database so that th...

I have a word document that I writing a macro for and I go from one document to another to get some infomation and then I need to post it back into the prior document. The problem is that the prior document the one that I am starting from has a different name each time the macro is run. Is there a...

Could someone plz tell me what I need to change?When I put this function in my program it causes any reference to a global variable to return a "variable not defined" error.Option ExplicitPublic Function Rand(ByVal Low As Long, _ ByVal High As Long) As Long Rand = Int((High - Low + 1) * Rnd) +...

Hello,<br/> I have two VB EXE applications, one calling the other. I would like to know if there is any way to prevent going back to the first EXE when this one started the second one, meaning, the second EXE shall not loose focus.<br/>Thanks a lot,<br/>Wagner

Hello,<br/> http://vbnet.mvps.org/index.html?code/disk/smartide.htm<br/>I was using the code at the link above for getting hard disk serial number for all windows versions up to now but it is not working for Vista now? <br/>How can we fix this?<br/> <br/>Thanks,<br/>Best regards,

Hello, is anyone who have an idea in making the text twist game. I can't find any .ocx or dll in checking the word and how may words are thier in that word given. Its my study in thesis and its needed on the second wek of September<br/>Thanks a lot guys!

A loop in my program runs too fast. But if I add "Sleep 1" it runs too slowly. I can't put "Sleep 0.2" because that rounds down to 0, and acts like Sleep isn't even there. It must get rounded, because "Sleep .49" is too fast, and "Sleep .51" is too slow.

I have written a program and would like to save it onto a CD such that anyone can be able to run it directly from the CD. I have used package and deployment wizard and saved the program onto a CD, however this requires the user to download the program onto their computer. My question is: "Is it poss...

Hi,I have a question regarding two workbooks in Excel. One workbook contains data and a lot of macro's and formula's, that are executed in each cell. I made a new workbook myself, containing a User Interface, to deal with all the data in the other workbook.If I try to remove a record (cont...

Hi everyone<br/>Can anybody tell me how to convert Convert VB code from DAO to ADO<br/>thanks

Hi every one <br/> Can anyone send me a sample for Add ADO functionality to VB code allowing access to both a SQL Server and Access data

Can someone please take a look at this code for me and give me some guidance? - Don't worry theres only about 7 lines of codeWhat I'm trying to do is take a snapshot in one form (formMain) and then display the picture in another (FormPreview)It kind of works But as you will tell I have mad...

Hi All, I am working on an activeX Control and I want capture the mouse click event outside the control. i.e. if the user clicks on the form outside the control , I want to resize the control.what I guess should be like this.If (the click position is outside the control area) then width = 1500...

What I wanted to do is have an executable running (MyExe), identify it's thread in the system, and have another program (MyOCX) join its thread. It would have been easier if I have MyExe's VBP file so I can just add MyOCX.VBP to the project, but given the circumstances, i don't have i...

i want code to insert,update ,save,delete records using adodb with stored procedure

HiI want to dynamically create various control arrays (Checkboxes) using a function.I've added the 9 different Checkboxes (ChkBox1, ChkBox2 etc.) to the form and set their index property to 0. Now I get records from a table and want to create the checkbox arrays from those records. For the diff...

Hello,<br/>Can anybody tell me how to make the image titlebar to go on the top just next to the form (NOT MOVE THE IMAGE)??<br/>Hope you guys will help me with this.<br/>Thanks<br/>Mark