602 Posted Topics
 | Hi, How exactly are you modifying the DateTime? Are you using DateAdd or are you just changing the time "manually". It looks to me that either the modified date is in a format that the datetime picker can't understand and it is defaulting to January 1 1900. Or that your … |
| | Hi All, I'm working on a web app in ASP.net with VB.Net on Visual Studio 2010 (.Net Framework 4). I'm trying to use a datarepeater class to display results from a query on the web page so I coded away exactly as I used to in Visual Studio 2008. However, … |
| | Hi, I would never use an access database: PROS 1. Nice interface CONS 1. Microsoft do not recommend the use of Access for more than 5 users at a time. 2. SQL Server Express is Free 3. SQL server Express is more robust 4. SQL Server Express supports many of … |
 | Re: Process help Hi, Just taking a guess here but what does colProcesses.Count actually return? How about: [CODE] If colProcesses.Count > 0 Then ToolStripStatusLabel1.Text = "FSX Status: Connected" Else ToolStripStatusLabel1.Text = "FSX Status: Not Connected" End if [/CODE] OR [CODE] If colProcesses.Count IsNot Nothing then ToolStripStatusLabel1.Text = "FSX Status: Connected" Else ToolStripStatusLabel1.Text = … |
| | Hi I had written an in VB.net that took addresses from a database put them into a csv file then took the csv file data and performed a mail merge in Word to allow the user to print them out on to an Avery L7163 label sheet. The app was … |
| | Hi You've defined your SQL insert statement but I don't see you doing anything with it. For insertting records to a database I just do something like this as I find it easier: (actually I'd use a SQL Database with a stored procedure as it is more secure and SQL … |
| | Hi, You've posted this in the VB.net forum instead of the VB6 one. Err... I'm a bit rusty with VB6 are you using the package and deployment wizard? It does look like your app needs a file that comes with VBE but what one? What references do you have in … |
 | Hi I'm 100% sure on this but as .visible is a boolean you maybe able to do something like this: [CODE] for each Row in MyDatagridview.Rows if Row.Visible = false then Row.visible = true next [/CODE] The question is does the .visible let you "read" from it or only set … |
| | Hi All, I have an application written in VB.net for batch print jobs. As part of the application, the user selects two printer trays to use to print the batch to (one plain paper the other coloured for coversheets and batch seperators) I had this working until we upgraded our … |
| | Re: Database problem Try this link.... [URL="http://www.aspdotnetfaq.com/Faq/fix-error-Failed-to-generate-a-user-instance-of-SQL-Server-due-to-a-failure-in-starting-the-process-for-the-user-instance.aspx"]http://www.aspdotnetfaq.com/Faq/fix-error-Failed-to-generate-a-user-instance-of-SQL-Server-due-to-a-failure-in-starting-the-process-for-the-user-instance.aspx[/URL]  |
 | hi, Use Listview.items.count to loop through the items in the list view: [CODE] dim MyTotal as Double dim i as integer for i=0 to Listview1.items.count-1 Mytotal += Listview1.items(i).Value next [/CODE] |
| | [URL="http://www.connectionstrings.com"]http://www.connectionstrings.com[/URL] Shows you how to connect to all types of database via ADO, ADO.net etc. For Access, ensure that: 1. what ever user the Website runs under can access the file on the remote computer over the network. 2. The File is not going to be locked by another user … |
| | Hi can you post your code? On your page load are you using the page postback on the onload event? If not then the page will execute the load instructions as the order the page renders in during a post back is 1. Reload page 2. process postback routine. e.g … |
| | Hi, Do you want to create a blank record for the user to Edit each time a non matching item is in Table 2? Where are you actually populating the datagrid from? Table 1? A query run on both? Maybe you could post what code you have just now? |
| | The Intellisense should be putting a wavy line under where your syntax is wrong or may lead to issues |
| | Try: [CODE] SELECT int_Exa, COUNT(*) as nbrTest FROM TEST GROUP BY int_Exa [/CODE] The result set should will list each exam in the TEST table with a count of the number of each. If you want a count of [B]ALL[/B] exam (not just the ones that have tests,) then try: … |
| | Hi, I've never encountered this issue but it would seam to me to be to do with your projects signing settings. Right click on your project in the sooution explorer and you will get an option to open the project properties screen (alternatively Project Menu, Properties). Depending on which version … |
| | Hi All, I'm using VB.net to create a batch of word documents using the Microsoft Office OpenXML SDK. The documents are made up of a header and the main body which is made up of a table. I can sucessfully create the table in the main body. The issue is … |
| | Hi, You want to store a colour value in your DB? It really depends on what you are using the colour for, you can store it as a string in Hex format e.g. 000000 (black), FFFFFF (white) or in RGB 0,0,0 (black), 255,255,255 (white) etc or even just "Black" or … |
| | Hi all, I'm writing an application that imports and tidy up address data into a cleaned, deduped excel workbook ordered in rows with each column as an address field. One of the issues I've ran into is that we sometimes get a workbook where the multiple address fields are held … |
| | Hi You should post some of your code, you're refering to an object that the code does not know exists or understands. Posting code samples inside the "CODE" "/CODE" tags will help others see what you are doing and maybe identify where it is going wrong. Have you tried going … |
| | Hi You should do something like this: [CODE] sub EmployeeSearch dim EmployNo as integer dim mySQL as string EmployNo = cint(MyTextbox.text) mySQL = "SELECT * FROM tblEmployee WHERE (EmployeeNo =" &EmployNo &")" 'run query on db and get result. [/CODE] |
| | Hi, I'd do a double check here if I were you: [URL="http://www.connectionstrings.com"]http://www.connectionstrings.com[/URL] It lists out loads of ways of connecting to different datasources... |
| | Re: Hello there Hi, You are not checking your password value (from your query) to see if it is null it is possible that the exception is being thrown as you try to compare a string to a null value. [CODE]If strPassword = dr.Item("password") Then[/CODE] (line 30) Personally I'd change my query to … |
| | Hi Does the user you are connecting to the database to have update permission on the Employee_DB table? |
| | Hi Try looking here: [URL="http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.linkbutton.aspx"]http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.linkbutton.aspx[/URL] I'll give you a hint PostbackURL is a [B][U]property[/U][/B] of the linkbutton class |
| | Hi I want a red sports car, a million dollar home and my own airplane. Seriously are you expecting someone to do all the hard work so you can hand it in for what ever exam / practical you are doing? [B]The only place success comes before work is in … |
 | Hi Normally scrollable objects have the following properties: AutoScroll -automatically show scrollbars (True /False) HScroll - Horizontal Scrollbar (True/False) VScroll - Vertical Scrollbar (True/False) e.g. Switch on a horizontal scroll bar: [CODE] MyObject.HScroll = True [/CODE] I'm just not sure if the picture box supports scroll bars I assume it … |
| | Hi At it's simplest you just do this: [CODE] MyDatagridView.Datasource = MyDataTable MyDatagrigView.refresh [/CODE] You need to get it to refresh to show the changes Try looking up datagridView class in Google for more details on the properties and some examples of using it. |
| | Hi, I think I may have answered this in your previous question? [URL="http://www.daniweb.com/forums/thread296131.html"]http://www.daniweb.com/forums/thread296131.html[/URL] Anyway read in each line use the split function this will generate an array of a single row take this row and add it to your array. [B]Note of Caution:[/B] if your source file handles empty or … |
| | Hi, You do not define the function or method with in your sub routine, it is available to all subroutines and functions with your form. Take line 10 out and it should work. [CODE] Dim CalculateCharges As Decimal 'not needed as CalculateCharges is a function [/CODE] You have specified that … |
| | Hi You would probably be better off using the FolderBrowserDialog class (see [URL="http://msdn.microsoft.com/en-us/library/system.windows.forms.folderbrowserdialog.aspx"]http://msdn.microsoft.com/en-us/library/system.windows.forms.folderbrowserdialog.aspx[/URL]) You can use this to get the folder path then loop through the files and sub directories in the root folder. |
| | Hi, Ever had an application that you want to store [B][U]user specific[/U][/B] settings on? e.g. login name or Form background colours, User specifc DSN connections etc. So the next time they run the app the information is there for them? This can be achieved in VB.net with just a few … |
| | Hi, It could be a number of things, someone else may be opening your Access file on the network (or locally) or it could be open connections from your site code. In order to minimise the risk of it being your code, you should open the connection just before you … |
| | Hi, You cannot create a folder in the Client machine that would be a major security breach. I answered point 2 for you about six days ago. |
| | Hi, I'd be [B][U]very cautious[/U][/B] about letting anyone upload an exe file to my site. There is a reason the FTP server is blocking them... That being said there's times you need to allow it too. I usually have a list of blocked extensions that I check before upload and … |
| | Re: vb.net You'd run a query like this: [CODE] "SELECT * FROM MyTable WHERE pinno =" &textbox1.text &" and acctno = " &textbox2.text [/CODE] If you get no data back then there is not a match... |
| | Using system.io just do this: [CODE] File.copy(Source, Destination, Overwrite) [/CODE] Using FileSystemObject this: [CODE] fso.CopyFile(Source, Destination, Overwrite) [/CODE] * Overwrite is an optional boolean, I think by default this is set to False. Anyway True if you want to overwrite an existing file, False if not. Remember you will need …  |
| | Hi, There are a couple of ways to do this one is to read each line in using filesystemObject or system.io. Another is to open an excel object and read the csv file in you can then interact with it as if it were a database and even query it. … |
| | Hi, Does the user you are connecting to the access DB with have write permissions on the file / directory? The code looks ok but if the table is empty something is stopping you. |
| | Hi, Interesting, you could try this but I'm not guarenteeing it will work: On form load size height to zero: [CODE] Private Sub Form_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load me.height = 0 end sub [/CODE] This will hopefully leave the menu bar of the form still … |
| | |
| | Hi Is this for the login? What I do is on the load event of the main form I open the Login form as a dialog: [CODE] sub Form1_Load() dim frmLogin as new LoginForm 'what ever you have called your login form.. frmLogin.ShowDialog [/CODE] if you've already got the login … |
 | Hi You need to get your folder selection into a string and then open a folderdialog with the path set to that string. Where are you selecting / cutting / dragging your folder paths from? |
| | Hi Is it a particular word within a sentence? or just a label? [CODE] Label1.Font = New Font(Label1.Font, FontStyle.Underline) [/CODE] You define a new font based on the old one i.e. [CODE]New Font(Label1.Font, FontStyle.Underline)[/CODE] In otherwords the new font is based on the existing value but with underline |
| | Hi, Sure read through the file, for each line use the instr function to see if the word exists in that line. |
 | Hi, Basic programming 101 [CODE] dim i as integer =0 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Label1.Text = i+1 End Sub [/CODE] |
| | Hi Try inserting these lines: [I]Before you execute the cmd[/I] [CODE] If con.State = ConnectionState.Closed Then con.open end if [/CODE] [I]at the end sub[/I] [CODE] If con.State = ConnectionState.Open Then con.Close end if [/CODE] |
| | Hi, Is it each time your project is run you want a counter to display the number of times it has been run?  |
| | Hi, If it it still does not work, a good tip when working in Access is to use the QBE to generate the SQL for your query, that way you know the syntax is correct for Access. |
The End.