- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 3
- Posts with Upvotes
- 3
- Upvoting Members
- 3
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
62 Posted Topics
 | You can create a table which contains UseGroup and column with datatype bit for Menu Names, so you will have `UserGroup Menu1 Menu2 Menu3 and so on ` Then Create a Form (say module access) which contains checkboxes that corresponds to every Menu and maybe a combobox for UserGroup so …  |
 | Hi under this event Private Sub dgSO_CellContentClick(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgSO.CellContentClick if user click the checkbox in datagridview, a window pops up and ask data when user press escape (no data input), the popup form will dispose and the checkbox should be unchecked This code …  |
| | Hi, I have 2 checkboxes in a datagridview I added this code Private Sub dgSO_CurrentCellDirtyStateChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles dgSO.CurrentCellDirtyStateChanged If dgSO.IsCurrentCellDirty Then dgSO.CommitEdit(DataGridViewDataErrorContexts.Commit) End If End Sub and when user click the checkbox, i used this code Private Sub dgSO_CellContentClick(ByVal sender As Object, ByVal e … |
| | Hi My vs stopped working everytime i click datagridview Probelem Signature: Problem Event Name: CLR20r3 PS 01:devenv.exe PS 02:10.0.30319.1 PS 03:4ba1fab3 PS 04:System.Drawing PS 05:4.0.0.0 PS 06:4ba1e086 PS 07:49 PS 08:1f PS 09:System.InvalidOperationException Locale ID:1033 Additional information about the problem: LCID:1033 Please Help, Thanks |
| | You can refer [Here](https://social.msdn.microsoft.com/Forums/vstudio/en-US/a043244e-d7f1-416b-bd7b-6c6d7986647b/how-to-export-a-vbnet-windows-form-into-a-pdf-format?forum=vbgeneral) and [Here](https://msdn.microsoft.com/en-us/library/microsoft.visualbasic.powerpacks.printing.printform%28v=vs.80%29.aspx#Y0) See if it can help you |
| | Hi, I've been working on a project when suddenly an error occured when I clicked a control and shows a error picture on the control. I'ved attached a picture for reference. I continued working ignoring the error which led me to my previous problem which is still unsolved [Unusual behavious … |
| | Hi, I think this is a simple problem maybe on settings, I dont know but when I select a control in any form , even the form itself it doesn't look selected. What i mean is usual behaviour should show like square or dots around the control when we select … |
| | Hi, Im trying to use a multi column combobox from this thread [Here](http://www.codeproject.com/Articles/8619/Flat-MultiColumn-Combobox-with-Autocomplete) Just wondering if there's a way to show Column header from its datasource (sql) Can't find a property to do this Thanks |
| | Hi, I originally created this query to get a result from a single select statement Its funny that it became a very long query having sets of joined table Its also maybe annoying to look for it so im trying to trim it down most of it have same joined … |
| | Hi, Im trying to extract data from sql server where conditions are multiple and variying I have a datagridview with 2 columns ID and Name I need to create Select Query to extract data where condition is 'ID should be equal to the value or values in Datagridview ID Column. … |
| | Hi, I have to forms, second for is shown from the first form trough showdialog command. Both forms have datagridview User will select data from DGV in second form then pass all this data to DGV in first form How can I achieve it, I know how to do it … |
| | Hi, I need to compare record using sql ce I have this data, can be thousand rows ID Type Date Time 02-0009 I 01/02/2014 8:00 02-0009 O 01/02/2014 18:00 02-0009 O 01/03/2014 18:00 02-0009 I 01/04/2014 8:00 02-0009 O 01/04/2014 18:00 For every date there should be a 'I' and … |
| | Hi Ive been using my sql server lately but for this past few days, its been crashing. I'm trying to find solution but seems nothing works or I'm just doing it wrong. Its sql server 2008 R2 Error details: Problem signature: Problem Event Name: BEX Application Name: Ssms.exe Application Version: …  |
| | Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …  |
| | Hi, I have a data, employee attendance record with following format > 01-0002,I,4/21/2014,07:34:00 01-0002,O,4/21/2014,18:09:00 01-0002,I,4/22/2014,07:47:00 01-0002,O,4/22/2014,18:09:00 01-0002,I,4/23/2014,07:54:00 01-0002,O,4/23/2014,18:07:00 where I is in and O is out The table contains lots of records for this saves records from the start how can i search a record with no In or no … |
| | Hi, Im making a simple program which converts a encrypted text file the upload it to sql CE. This is time in and out logs of every employee. The date is extracted from a machine and downloaded as encrypted file. We managed to decrypt it by getting the equivalent value … |
| | Hi, How to use in select statement with where condition comparing a Null value and with value? I have this Statement `Select Col1, Col2, Col3 From Table where DateDeleted` 'Here comes the problem The condition is something like if DateDeleted (which is actually a date) is Null then get records … |
| | Hi Is there a way a vb form structure the same as its backgroud picture? Its same with making the form invisible and let its background picture remain Im trying to make a program that when it runs, it displays like widget. thanks  |
| | Having problem with looging in my server. Before it runs smoothly. While learning this system, I came accross the idea of exploring the contents of Microsoft SQL Server in Program Files. I found some exe files inside and tried to run them with the curiosity of what are those for, … |
| | Hi Just asking for a better solution for my approach in getting sql result with different multiple conditions based on comboboxes. I have a 4 comboboxes, for Branch, Type, Status and other info. User can select conditions from this comboboxes. The default value is "All", meaning no specific condition at … |
| | Hi, Im having a hard time figuring this maybe a simple query. This is my first time to use sql compact edition. How can I query a select statement inside a select statement which tables are not related at all. What i need to accomplish is to insert a logo …  |
| | Hi, is it possible to combine Stored Procedure and Text Command Type in Select Statement? I have a stored procedure that compute available items, it quite a bit long select statement, now i need to call this statement in another select statement which is in text command type, how will …  |
| | You could do some work around if your using database Try to upload your excel to a datatable then count the number of rows |
 | Try this Try Dim com As New SqlCommand Dim adap As New SqlDataAdapter Dim table As New DataTable Dim str As String str = "SELECT [S_Name]FROM [VBP].[dbo].[Purchase_Order] Where [O_N0]='" & Val(TextBox3.Text) & "'", myConnection" com.Connection = Con com.CommandText = str table.SelectCommand = cmd adap.Fill(table) If table.Rows.Count > 0 Then combobox.DataSource … |
| | hi we have an office chat messenger in our office, it is executable, and ofcourse cannot modify the codes already. i dont know exactly how this messenger save history, looking from its root folder, i cant see something related from its conversation or message history. I just need to save …  |
| | Hi Im working with a project, simple IM for our office... I have a Table in sql with column Status, if a user opens this application, the status column changes from 0 to 1, if it closes this app, the status turn back to 0. On my form load event, … |
| | Hi, Im trying to load animated GIF's from a folder to my listview, I'm able to load it but not moving One more problem is, a lot of GIF are inside that folder,but the display in listview show the same image how can i fix it, is there better way … |
| | There are a lot of problems (for me) in dealing with dates, try to check the datatypes you used in your column, or convert each date to make sure they have the same format: (CONVERT(Datetime, @IssueDate, 101)) Hope that helps |
| | You can use the app.config to change the connection string [Try](www.daniweb.com/software-development/vbnet/threads/442986/database-from-other-network-attached-to-sql) or do what i did from my previous system. before the system starts, it checks for available connection from the server, if none, a form shows with combobox that shows available servers and databases, there you can select the … |
| | your problem is much more related to sql, mov your thread to ms sql pr my sql |
 | try this [Step by step guide](http://vb.net-informations.com/crystal-report/vb.net_crystal_report_step_by_step.htm) |
| | Re: code for barcode You can make one's stop application for that Iguess. Inventory and sales management. An application that will cater both the inventory and sales. Maybe one its menu will be your inventory where you can add your products then automatically prints the barcode after saving, then a POS for sales part … |
 | Try to Start your loop from 0 For intIndex As Integer = 0 To 36 > For intIndex As Integer = 1 To 36 if im right, this generates 35 txtbox only  |
| | Application Events like in a button click? Yes you can, Declare your module as public: Module *Name of module* Public Con As SqlClient.SqlConnection Public sub Connect Your connection here end sub end module Then an button event use: Call Connect Hope that helps |
 | In deletion part, what I did before was to add a column status on my db, when i delete a record it will add the word 'Deleted" on its status part. The SQL statement in showing records includes where statement with the condition status is NULL, this way those the …  |
 | May I ask what database are you using? How did you save your image? did u included the file path? |
 | You can also use the app.config of your project to alter the connection string check this [Network Application](http://www.daniweb.com/members/1023916/Lethugs/posts/2) [Click Here](http://www.daniweb.com/software-development/vbnet/threads/442986/database-from-other-network-attached-to-sql#post1911058) |
| | Why not try to create a program you will use to manipulate the data using programming languages such as dotnet? Maybe, (depends on your case) can make your work easier. Then you can export it to excel for mabe reporting purposes |
 | You may also like to look at this [Combobox](http://www.daniweb.com/software-development/vbnet/threads/447277/retrive-data-from-table-to-combobo#post1932210) |
 | Re: ConnectionOpen Try also to look at this [MSDN](http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/4ac85f2e-77c5-459e-9f26-28ef544e5ea3) [Stackoverflow](http://stackoverflow.com/questions/12481818/connect-to-ms-sql-server) [DbForum](http://www.dbforums.com/microsoft-sql-server/1215073-dbnetlib-connectionopen-connect-sql-server-does-not-exist-access-denied.html) |
| | Yes, I lot maybe, and there are lots of tutorial out there. But first there are things you have to consider.. What sql server are you using? What is your front end programming language? Imports System.Net.Sockets Imports System.Text Imports System.Data.SqlClient Module Connect Public Con As SqlClient.SqlConnection Public constr As String … |
| | Hi, Im trying to get the depreciation value of an equipment every month. My system gets the number of months from date of purchased up to current date for the computation of depreciation. I can run the report anytime but the computation must be like this: Sample: Date purchased January … |
| | How did you created your mdi child? Is it programmatically or a separate form made during design time? How did ou make your panel transparrent? If you used the a transparrent backcolor, create an event that will follow the backcolor of your mdi child when your panel move over that … |
| | Try to create a user id from sql management studio > security> logins node. Right click logins then new select new login. Grant needed permission to that user then change your connection string to Dim conn As New SqlConnection("Server=youpcname\SQLEXPRESS;Database=users;User Id = yourcreatedlogin, Pass = yourpassword;") |
| | Try this, it might help you [Click Here](http://go4answers.webhost4life.com/Example/passing-variable-dialog-another-dialog-211368.aspx) [Click Here](http://www.tek-tips.com/viewthread.cfm?qid=369380)  |
 | |
| | This is a forum and asking questions (or starting a discussion) are some of the main purpose of it, better you post your problem already so we can help you immediately (if we have also extra time to do it) :) |
| | What do you want to filter? Null billno? |
| | Hi, im using crystal report on my project. It working very well but I just want o make it more flexible. I have textobjects with of course text in it. They are not bound since they are just additional information on my report. How can i make those textobject editable … |
 | [Check This](http://www.vbforums.com/showthread.php?541211-RESOLVED-Last-Record-from-MS-Access-table-to-Textbox-on-a-form!) |
The End.