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
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 …
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
[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 …
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] …
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()
> `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 …
Correct syntax is: [CODE]do ... loop until ........[/CODE] OR [CODE]while ....... .... wend[/CODE]
try your luck in a vb.net forum...
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 …
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 …
Maybe you should try a VB.NET forum.
[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 …
Or should we deliver a complete program for you ;-)
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" …
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
[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]& …
try installing the latest mdac from MS (search with google)
search with google for "vbruntime files"
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
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 …
maybe the filesystem object has these properties
What do you mean by 'path file'? Is it the directory where the other app is installed in?
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.
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.
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
maybe you should set the backstyle prop. to 'vbBackStyleOpaque' (=1) instead of 0.
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
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]...
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 …
AFAIK: Nope, MDI is what it says, a mutiple DOCUMENT interface. And a document is a form.
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 …
i think they mean the event listbox (at the top of the code window) where all the events are stated
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 …
[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]
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)
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 …
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?
[quote=WaltP;337127]Why?[/quote] And why asking here (VB 4/5/6 forum)
next time remember to post in the right forum: VB.NET, this is the VB4/5/6 forum. Good luck.
first read this [URL="http://www.daniweb.com/techtalkforums/thread41057.html"]link[/URL] than ask a specific question on where your problems are
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...
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: …
For VB2005 look and post in the VB.NET forum... look for "INSERT..." and "UPDATE...WHERE ..."
next time look and post in the right forum, maybe that will help also! ;-)
to convert an integer tot string use: cStr(123) or: Format(123)
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 …
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.
PVBert