No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
47 Posted Topics
Re: in vb ide build an exe file get a dependency walker and check which dependencies are needed for your exe file create those dependencies on youre target machine OR get a setup (e.g. setupfactory) tool that builds a setup which does this for you it can make a cabin file … | |
Re: always interesting is a hardware database where al the hardware can be stored big companies love db's like that also with the possibilities for storing software versions and licenses | |
Re: [quote=QVeen72;386935]Hi, When u purchase BarCode Scanner, it Comes with complete Package (Fonts/LabelPrint/ReaderSettings etc..) What we normally do is, When Purchase, A unique Number is allotted to that medicine/Item. In Item Printing, "BarCode" font is used for that Unique key. This label is sticked on the Item. While Sales, when u … | |
Re: 1. You attempted to use an object variable that hasn't been Set Solution: Specify a reference for the object variable. For example, use a Set statement to set a reference to the object: [CODE]Dim MyObject As Object ' Create object variable. Set MyObject = Sheets(1) ' Create valid object reference.[/CODE] … | |
Re: Why don't you use the query unload event and place 'cancel = true' there? Otherwise look here: [URL]http://vbnet.mvps.org/index.html?code/forms/killclose.htm[/URL] *change: Private Sub Form_Load() IN Private Sub MDIForm_Load() | |
Re: > `conn.execute "INSERT INTO tblUsers (UserName, Password) VALUES ('Hello', 'World');", conn` should be `conn.execute "INSERT INTO" & tblUsers & "('" & UserName & "','" & Password & "') VALUES ('Hello', 'World');", conn` remark 1: don't mix the variables with text strings! remark 2: there are some single qoutes between the … | |
Re: Correct syntax is: [CODE]do ... loop until ........[/CODE] OR [CODE]while ....... .... wend[/CODE] | |
| |
Re: I'm thinking why you want something like that. If you work with combobox1.enabled in the gotfocus event of combobox2, than the combobox1 hasn't got a focus anyway. And viceversa. Default by clicking on a control it gets the focus. So how could a user change the other combobox? What is … | |
Re: You will have a long way to go with such an assignment and if this is a problem for you I guess you havent got a clue about coding. No offense. I guess you buy a book about Access first. Or start with a small app in VB first. Build … | |
Re: [URL="http://support.microsoft.com/?kbid=103257"]MS KB 103257: ACC: Reading, Storing, & Writing Binary Large Objects (BLOBs)[/URL] [URL="http://support.microsoft.com/?kbid=210486"]MS KB 210486: ACC2000: Reading, Storing, and Writing Binary Large Objects (BLOBs)[/URL] Images (but you can also store copies of executable program files or other non-OLE data in a Microsoft Access table) can be loaded from files into … | |
Re: Or should we deliver a complete program for you ;-) | |
Re: Better solution is to give al the option buttons the same name. Make a control array of them. This way your code is more readable, everything in one event. [code=vb] Private Sub Option1_Click(Index As Integer) Select Case Index Case 0 MsgBox "first" Case 1 MsgBox "second" Case 2 MsgBox "third" … | |
Re: I don't get it. Don't you have google? In 1 second I got this result. Look here: [URL]http://hamilton.bell.ac.uk/swdev1/notes_pp1_5.doc[/URL] I just searched on: +adodc +recordset +select You can also try to seach on: +adodc +recordset +find | |
Re: [COLOR=green]1. Those brackets "(" and ")" should leave. sFileName = sDir & ActiveDocument.Name & [COLOR=red]"(" [/COLOR]& CStr(Month(dDate)) & "-" & CStr(Day(dDate)) & "-" & CStr(Year(dDate)) & "_" & CStr(Time(dTime)) & [COLOR=red]")"[/COLOR] & ".pdf"[/COLOR] 2. I would try this (lookup the format function in vbhelp): [COLOR=green]sDir & ActiveDocument.Name & [/COLOR]Format(dDate,"mm-dd-yyyy_hhnn) [COLOR=green]& … | |
Re: try installing the latest mdac from MS (search with google) | |
Re: search with google for "vbruntime files" | |
Re: runtime error 91: somewhere in your code you probably didn't use SET , example: Dim a as SOMEOBJECT a = .... instead of: SET a = New SOMEOBJECT | |
Re: Make a public form variable in the second form. Load the second form modally. Pass the value to the form as a propertie. If you are ready in the form close is The form properties stay preserved. Do with them what you want (e.q. in the fist form). Then, unload … | |
Re: maybe the filesystem object has these properties | |
Re: What do you mean by 'path file'? Is it the directory where the other app is installed in? | |
Re: first thing to check is for never ending loops. try to write to the debug window OR write to a textfile so you can check the exe. | |
Re: make a menu with the name MenuPopUp set the visible prop. to false now the menu only can be made visible by this command: Call Me.PopupMenu(MenuPopup) Just add the sub menu's as you like. These will have their own event to add code. | |
Re: go on, study hard make wishes that can come true first learn how to walk then try to learn how to jump what I mean is: if you haven't got a clue don't start with this | |
Re: maybe you should set the backstyle prop. to 'vbBackStyleOpaque' (=1) instead of 0. | |
Re: why would you want a vb app that generates a c++ exe? don't you have access to google? this isn't the place to get complete apps nor is it the place to search for people who finish your graduation project | |
Re: You can't (in a easy way) Add the listview control. A quick search with google gave me the attached sample. All credits go to the [URL="http://www.vovisoft.com/vovisoft/sources/code1/code1.htm"]owner[/URL]... | |
Re: If vbYes = MsgBox("press", vbDefaultButton1 + vbYesNo + vbMsgBoxSetForeground + vbQuestion, "Title") Then End If vbDefaultButton 'connects' the first button (here the Yes button) to the enter key. vbYesNo means that there will be 2 buttons to click on. vbMsgBoxSetForeground means that what ever happens the messagebox will be put … | |
Re: AFAIK: Nope, MDI is what it says, a mutiple DOCUMENT interface. And a document is a form. | |
Re: Below the code for a loop through the worksheets. Also a piece of pseudo coding for the change in ranges. Add your code inside the loop... [code=VBA] Sub Test Dim ws As Worksheet Dim iCount as Integer For Each ws In ActiveWorkbook.Sheets iCount = iCount + 1 '--add your code … | |
Re: i think they mean the event listbox (at the top of the code window) where all the events are stated | |
Re: you can make a userform that fullfils your needs. use: [code=vba] UserForm1.Show vbModal [/code] to show the form put u commandbutton on the form to close the form put the following code in the commandbutton click event: [code=vba] Sub Command1.Click UserForm1.Hide End Sub [/code] The textbox properties are still readable … | |
Re: [code=vba] Sub test() Dim r As Range For Each r In ActiveSheet.UsedRange Select Case r.Value Case 2480, 4465, 3140, 2689 r.Delete End Select Next End Sub [/code] | |
Re: you only can password protect the project and/or worksheet with a pasword this is not a strong protection if you do so, choose a very long password with a lot of different characters (upper/lower/symbols/etc) | |
Re: read the file save the last line read it again at a certain interval check if the last line has changed if it has: save it again repeat the previous 3 lines or check the filedatetime at certain intervals if it has changed, open the file and read the last … | |
Re: do you want to insert the content in a body of an email? or do you want to attach the sheet to an email as an attachment? | |
Re: [quote=WaltP;337127]Why?[/quote] And why asking here (VB 4/5/6 forum) | |
Re: next time remember to post in the right forum: VB.NET, this is the VB4/5/6 forum. Good luck. | |
Re: first read this [URL="http://www.daniweb.com/techtalkforums/thread41057.html"]link[/URL] than ask a specific question on where your problems are | |
Re: A long shot: Close all running programs before starting the app. Also shutdown the app's in the systemtray (the icons where the clock is). Maybe this helps... | |
Re: Ved_TheOne, NewIndex isn't ment for that. Just remove the item and add it at its new position. Here's how I did it. Place a listbox (list1) on a form Place 4 command buttons on a form. Name them: cmdUp, cmdDown, cmdAdd, cmdRemove Place the following code in the General section: … | |
Re: For VB2005 look and post in the VB.NET forum... look for "INSERT..." and "UPDATE...WHERE ..." | |
Re: next time look and post in the right forum, maybe that will help also! ;-) | |
Re: to convert an integer tot string use: cStr(123) or: Format(123) | |
Re: With: [code]Private Sub List1_Click() MsgBox List1.ListIndex End Sub[/code] You can detect which item is clicked With [code]List2.AddItem "blablabla"[/code] you can add an item to the second listbox. Or: [code]Private Sub List1_Click() Select Case List1.Listindex Case 0 msgbox "1st item" Case 1 msgbox "2nd item" Case 2 msgbox "3th item" Case … | |
Re: Private Sub Command1_Click() List1.AddItem "1", 0 List1.AddItem "2", 1 'add just below the other items List1.AddItem "3" 'add at the top of all other items List1.AddItem "second 1", 0 End Sub Private Sub Command2_Click() List1.RemoveItem 0 'remove the top item End Sub |
The End.