2,155 Posted Topics
 | Yes, you will have to use the file system object. First check if a file exist, if not create it etc. Just the fact that you did not ask for code, but were willing to do it yourself, herewith all the code you need from an app I did a … |
| | Rated in the pc magazine as one of the best registry, applications and ie (cookies, temp etc) CC Cleaner came out tops! What makes it nice too is that it is freeware. Download a copy, 2 mouse clicks later and your system is clean. |
| | |
| | |
| | Welcome Manin. I'm sure we'll see you in the "Web Development/Databases/Oracle" forum. Enjoy.  |
| | |
| | Re: hello everyone Welcome Manish. Have a look at the top of the page, all the different forum spectrums are there. Just pick the forum you need help in, open a new thread and ask away. |
| | Welcome "outspoken" Dave.:D I am sure you will have a wonderfull time at Daniweb. Enjoy. |
| | Have a look at the following link, it might contain your solution. It seems that you have to double refresh and add a delay in the macro. [URL="http://www.mrexcel.com/forum/showthread.php?t=388633"]http://www.mrexcel.com/forum/showthread.php?t=388633[/URL] |
| | Yes, we can write the code for you, at a price that is. We do not do homework here for free! Be more specific on what it is you need, Notes to coins???? Do you want to turn a note value like say "$1.00" (1 dollar) into "100 cents"? What … |
| | Do not use the record count for adding a new record ID. Try the following - [CODE]'First move your recordset to the last record, then get the ID Number, Then... Dim strSubstr As String Dim xStr As Integer strSubstr = Right$(strCode, 3) ' strSubstr = "000", RSV removed xStr = … |
| | Not sure if this will help, try and see - [CODE]Dim C As Long Dim Cell As Range Dim NextRow As Long Dim Rng As Range Dim EntryWks As Worksheet Dim DBWks As Worksheet C = 1 Set EntryWks = Worksheets("Sheet1") Set DBWks = Worksheets("Sheet2") Set Rng = EntryWks.Range("D2:F") NextRow … |
 | |
| | |
| | [CODE]Text1.Text = dtPicker.Value Text2.Text = InputBox("Please enter the invoice amount.", "Amount")[/CODE] |
| | Andrew, you should know by now to give us more information. What exactly do you mean by "make a desktop on my form"? What will the list box do? How or what on the form do you want to save, and where do you want to save it to? What … |
 | [QUOTE]If .State = adStateOpen Then .Close[/QUOTE] - You have closed the connection of the recordset. Re-open the recordset. |
| | I went through your app. Where does the double booking take place, which form? What do you mean by double booking, are these equipment rentals, resulting in a certain "tool" being booked out twice? |
| | I would try something like - [CODE]'Determine whether a file is already open or not Private Declare Function lOpen Lib "kernel32" Alias "_lopen" (ByVal lpPathName As String, ByVal iReadWrite As Long) As Long Private Declare Function lClose Lib "kernel32" Alias "_lclose" (ByVal hFile As Long) As Long Private Function IsFileAlreadyOpen(FileName … |
| | Have a look at the following link. There are plenty of solutions discussed here previously. [URL="http://start.speedbit.com/search.aspx?site=suggest&cnl=7645705662&sitesearch=daniweb.com&q=datareport%20grouping&bi=263752&si=7124&cc=ZA&pop=0"]http://start.speedbit.com/search.aspx?site=suggest&cnl=7645705662&sitesearch=daniweb.com&q=datareport%20grouping&bi=263752&si=7124&cc=ZA&pop=0[/URL] |
| | If I understand the first part correctly, try the following - [CODE]Dim xRowFrom As Integer Dim xRowTo As Integer xRowFrom = 1551 +10 'Here you will add the last row copied previously and add 10 rows on to copy from. xRowTo = 1570 'Do the same here or just add … |
 | |
| | These are some solutions I found, might work for you - [URL="http://forums.asp.net/t/1146404.aspx"]http://forums.asp.net/t/1146404.aspx[/URL] [URL="http://social.msdn.microsoft.com/forums/en-US/vsto/thread/b0ac73a4-7a54-4d10-a1dd-54404ff1678e/"]http://social.msdn.microsoft.com/forums/en-US/vsto/thread/b0ac73a4-7a54-4d10-a1dd-54404ff1678e/[/URL] [URL="http://www.foxite.com/archives/excel-object-the-server-threw-an-exception-0000101419.htm"]http://www.foxite.com/archives/excel-object-the-server-threw-an-exception-0000101419.htm[/URL] I hope this help.  |
| | Re: project Welcome to Daniweb. Open a new thread under "Software/C++". I'm sure there will be posters to answer all your questions. Just read our rules of posting first. Enjoy your stay. |
| | |
| | |
 | [QUOTE]rs.Open str, [COLOR="Red"]connect[/COLOR], 2, 3[/QUOTE] Connect seems to be your problem. Firstly, is your function private or public? You have the rs.Open part correct but no reference to "str", which will be the sql string. This should be something like [CODE]Dim str as String str = "SELECT * FROM MyTable"[/CODE] …  |
| | Re: Current Time VB6 I have used 2 timers, one to show the time, a second to check for morning or afternoon - [CODE]Private Sub Timer1_Timer() Label1.Caption = Format$(Time, "hh:mm:ss AM/PM") End Sub Private Sub Timer2_Timer() If Hour(Now) >= 12 Then Label1.ForeColor = vbBlue End If End Sub[/CODE] This should answer your question. |
 | Re: vb Flex grid is for display purposes only, data grid has an edit feature where data can be changed and saved by using the data grid. Read the following link. [URL="http://forums.techarena.in/software-development/1131320.htm"]http://forums.techarena.in/software-development/1131320.htm[/URL] |
| | Re: vb Go to [URL="http://www.connectionstrings.com"]http://www.connectionstrings.com[/URL], and select oracle. It gives you all the sample code that you can use to connect via one pc, more pc's on a network etc. |
| | a grid control is a data grid that you manually add to your form. This grid will be loaded with data and can be used as a report medium. There are a few you can choose from depending on your needs. a Custom control is a control that you create … |
| | Re: dialog window Attached so long the open window file app. I'll get to the other questions later. Your question 2 needs some more elaboration. Will the questions be added to the database by you or the user? >>>Opens a file in the database - not sure what you mean here. do you … |
| | Re: vb Yes it is. If you are using VB6, only up to version 11 (XI) will work. Version 12 only works on .net and up. In your app, select references and select Crystal Report Libraries. This will give you access to the dll. In components, select crystal reports. Add a report … |
| | Re: Networking Also, are you using Local Area Network etc. What connection strings do you have? IMPORTANT!!!, how many users on the network. Access will only allow up to 5 users for save data access, otherwise it will start to drop data because the queuing system does not allow for more than … |
| | Yeah, this happened to me a lot when I reply via my e-mail link. Not looking whether I am logged in or not, write the solution (sometimes a lot of coding involved), just to find that I have to re-post my solution... |
| | Welcome to Daniweb. Check out our Geek's lounge where all friends meet.  |
| | |
| |  |
| | |
| | |
| | Welcome Roderick and enjoy your stay. Head over to our[URL="http://www.daniweb.com/forums/forum31.html"]http://www.daniweb.com/forums/forum31.html[/URL] for all the web development posts. |
| | Re: Hello.. To all Welcome to Daniweb. Your friend was correct, just remember that you have to show some effort on your side for we do not do entire projects for free. Hope to see you around in the forums. |
| | Welcome Gilroy. You came to the right place to learn. a Big welcome to you. |
| | Re: new member Welcome ramaliah. Nice to see that you have joined now. Enjoy your stay here. ps. Did the sample code helped? |
| | Re: Hi all! Welcome to Daniweb. I'm sure we will see a lot of you in the Java Forum. Enjoy your stay here. |
| | |
| | Re: edit a thread As you have send the post, scroll to your post. Under your name and avatar, there is a "Flag bad post" button and a "Edit Button". As Ezzaral mentioned, must edit the post within 30 minutes.  |
 | Re: Adodc Try - [CODE]Adodc2.Update[/CODE] Please open a new post with your question seeing that this post is already 4 years old, pleeeeease. |
| | The coding looks perfect. When you do however call frmExport the second time, clear the listbox first and then reload your query. This should solve your problem. |
| | You'll find the scripting menus under Web Development at the top of this page. The following code is saving and retrieving a picture from access database in VB6. It might not be 100% what you are looking for, but might put you on the right track, because it works with … |
The End.