- Strength to Increase Rep
- +5
- Strength to Decrease Rep
- -1
- Upvotes Received
- 5
- Posts with Upvotes
- 5
- Upvoting Members
- 3
- Downvotes Received
- 2
- Posts with Downvotes
- 2
- Downvoting Members
- 2
- Interests
- Programming
- PC Specs
- Windows 10 x64 - 16GB Ram - intel I7
63 Posted Topics
Hello all I have a form with two datagridviews. Grid A is polulated with orders from DB, grib B has an empty table with the same column name as grid A. Im currently draging orders from Grid A onto grid B. My isue is that since grid B has only … | |
Hello I have created awhile ago in VS2017 an application [application A] with CR sp21 which works fine. Now Ihave another application [application B] created in vs2019 with CR sp29. When I install app B on the same pc where App A is installed the CR wont work so I … | |
Hi all I Have a CalendarvProject with a 3rd party Calendar control. the application was working fine untill I upgraded the Calendar Control . When I opened the solution two references were no longer availabe, so I had errors. One of the references was ExtremeCalenderControl the other AxXtremeCalendarControl. I was … | |
Hi all I have a datagridview with 2 columns. fist column is Datagridview combobox the second is a datagridtextbox. I'm trying to fill the second column based on the combobox selection . The Method that captures the selected item does not track which row is being edited. I have tried … | |
Hello all. I have a funtion in MYSQL to substruct days from a date. This function seamsto work but some dates it times out. This is my function CREATE DEFINER=`root`@`localhost` FUNCTION `Calculater`(intrval int, req date) RETURNS date DETERMINISTIC BEGIN declare calculated date; declare added int default 0; Lbl_Loop: Loop IF … | |
This application was sending out orders without errors when smtp wasn't secured. Now the clients webmail server was changed to ssl. After making the changes the server times out. I did some research and found this .ConnectType = SmtpConnectType.ConnectSSLAuto I'm anable to assign the SmtpServer.ConnectType = SmtpConnectType.ConnectSSLAuto. This is my … | |
Hi all I have a x32 bit application on a windows10 x64 machine. The application was working fine untill I change the connection string from OLEDB to ODBC with a DSN. Since my application x32 bit I created a x32 bit DSN to an ACCESS db wich also is a … | |
Hi I Currently working on a project to schedule installers to do installations. When scheduling the user will select the day of intall and if the number of days the instalation will take or motning or afternoon if its only hafday and I want the application to search which installer … | |
Hi I'm having an 'The application is in Break Mode Error' when debuging this sort code. Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim ds As New test1 Dim reportdoc As New CrystalReport1 ds.Tables.Add(Test_tbl) DataGridView1.DataSource = ds.Tables("Datatable1") reportdoc.SetDataSource(ds.Tables("Datatable1")) With CrystalReportViewer1 .ReportSource = reportdoc .Refresh() End With End … | |
Hi I have a datagridview with 9 Processes each process holds dates for stating and compleating a job. When a process is Late a cell back color is set to yellow, when today is the day the same date on the cell the date gets bolded,if the date is altered … | |
Hi all I'm new using LinQ. Im having Specified Cast not Valid in this Function. Hope someone let me know what I'm doing wrong. this is the Function Private Function GroupedBy() As DataTable Dim Sales As New ds_Sales_OELI Dim dt As DataTable = Sales.Not_SCheduled GroupedBy = New DataTable Dim dr … | |
Hi I have an app that I compleated about 2 years ago with vs2010 and all is working. Now I just oppened the app in vs to make some additions and the error 'Format' is a type and cannot be used as an expression is all over the entire app … | |
Why am I getting a System.StackOverflowException when assingning a value to avariable. I have used the same process on other forms in this project and they work fine, don't know why this is happening. This is the error "An unhandled exception of type 'System.StackOverflowException' occurred in System.Windows.Forms.dll" the exception hapens … | |
Hi All I have a method to configure a datagridview, meaning changing the column widths, format columns etc. If I call the configuration meathod from the form load doesn't work because the form hasn't been totaly loaded and I dont get the correct size of the datagrid, to be able … | |
Hi all I have a table with a Masked column. How can I INSERT or UPDATE data into the masked column at run Time with out Loading the column into a textbox. The column is as Folows ID Process 1 StartY CompleatY 2 Start_ Compleat_ Thanks in advance. | |
Hi all I just started using Crystal reports in vs2010. I have created a Dataset in the Designer and pulled data from an access DB. The dataset is being populated fine. My Issue is when I assign the dataset to crystal database expert and drag the columns to the report … | |
Hi all I Have 3 Queries in access 2 of them are being used as a calculator we willcalled them Cal1 and cal2. The third query The Order query displays the Customer , the orders and totals which consistes of cal1+cal2 (there is a possibilyty of some cells for cal1 … | |
Hi all I have a DataGridView with 2 Columns an Order column (text) and a price Column (decimal) The Datagrid contains all the orders and price for a certain customer. I'm currently adding all the prices and adding a new row to the datatable containing the total.In this row on … | |
Hi all I Currently have a MDI Form that contains a DataGridView. When I open a dialog form as a MDi MdiChildren the dialog form partionly hides behing the Datagridview. (I also tried with a windows form same thing happens). Can any one help me solve this with out having … | |
Hi all I have a Products table which has a description and a size column the description is a string value and the size has a double value. What I need to do is after reading the data it converts the decimals value of the size column into a fraction. … | |
Hi all I have a Mdi Child Fom being oppened from the parent the form opens but the Load event will not fire UP. Doesn't the load event suppose to fire up every time the form is opened? Here isthe code usedto open the form from the Parent and also … | |
Hi all I have multiple checkboxes to be used as the status of a certain order. another words as the order is being processed the user will check the status and a date will be inserted into an access table. Now my isue is when a checkbox is checked for … | |
Hi I have a column (ColumnC) in an access query which extracts the notes from column A and ColumnB and seperates them with a comma. This is the expressoin I use in access (Note: [RecheckNote] & IIf(Not IsNull([RecheckNote]) And Not IsNull([CTNote]),",","") & [CTNote] ) What I would like is to … | |
Hi I'm trying to Select Data from an Access DB. I wrote this query to Select all Invoices that were Invoiced between two dates. I get the following error Syntax error (missing operator) in query expression 'Invoiced >=02/01/13 AND <= 05/01/13' "SELECT * FROM invoiced_filter WHERE Invoiced > " & … | |
Hi all I have an Access database Table and one of the columns has a date value the column name is closing. I would like to do an order by closing asc the null values are allways on top and I would like it to be at the bottom. I … | |
Hi all I have the folowing to calculate the Number of weeks between two dates. The OpenDate= Nov-1-12 and closingDate= Nov-29-12. When Executing the the NumberOfWeeks=3 If I go to the calander 4 weeks why is the NumberOfWeeks=3 NumberOfWeeks = DateDiff(DateInterval.Weekday, OpenDate, ClosingDate) Thanks In Advance. | |
Hi all I'm trying to shade a cell based on a date difference between column 7 & 8. It seams to work accept column 8 seams to be the one being shaded instead of column 7. I have googled but can't find a solution to have the calculatin being made … | |
Hi In my program I have a Dataset that populates a Rdlc file and it was working Fine until I Encrypted the Accdb file and now when I run the App I get "Not a valid password" error at this line [CODE]Me.Services_QryTableAdapter.Fill(Me.CFIDataset.Services_qry, RprtID)[/CODE] I have tried Modifying the connection for … | |
Hi all. I have a program in vb.net and with it I have an expiration Key. I would like this key to be valid for 3 moths for example. I don't want to use the users system.date because to prevent them from changing the date. I there a way I … | |
hi I have successfuly created an access database with vb.net accept it is not password protected. Can someone help me to password protect this DB. Here is the code I use. Thank you [CODE] Private Sub Button2_Click(sender As System.Object, e As System.EventArgs) Handles Button2.Click Try Dim cat As New ADOX.Catalog … | |
Hi all In the following Sub I'm sending an Attachment when the email has been sent I would like to delete the attachment but I get an system.IO.IOException Error. the file I'm trying to delete is being used by another process. How can I detect if the process has finished. … | |
I have a reportviewer that prints a second empty page with the header only nothing in the body. I have searched for this issue and I learned that the Width of the report body should be equal to the page width minus the right and left Margins. So I have … | |
I have two arraylists. The JobArraylist gets adresses from a database table and JobIDArray Gets the ID for those addresses. I'm populating a Combobox with the JobArrayList which is working ok. When I select a an address in the combobox I use the sectectindex to get the AdressID from JobIDArray. … | |
Hi all With the following SQL " Dim Query As String = "UPDATE JobName_tbl SET [JobDate]=@NewDATE, JobAddress=@Newaddress Where JobID=@ID" nothing happens nothing gets updated nor do I get an error. But as soon as I remove the [JobDate]=@NewDATE, it works fine. Hope someone can help me with this situation. Here … | |
Hi all I created a RDCL in the designer. I would like the User to Determine what is shown in the Report. How can I change the query at runtime? (ex. changing the customer Name) This is the query that I have in the properties SELECT [Date], Address, Customer, Orders … | |
Re: Hi I agree with you both. I my self started with vb2008 , with the help of DaniWeb and Google I learned allot. I still have lots to learn Good Luck | |
Hi all I'm using a dialog form with two bottons and two Radio buttons. I'm oppening this Dialog when a button is clicked on the parent form. My situattion is when the Dialog opens the code in the button event continues to execute, but I only want it to continue … | |
HI ALL! Let me start by letting you know that I'm still new to VB. All I know about Programing is with the use of google, Videos, and some good help from DaniWeb. I'm doing a program which searches datagrid colums with some classes That I have wrote. I have … | |
Re: Well good question. But I'm just starting into the developers world. I kind of started late I'm near my 50's and hope my memory won't go so soon. | |
Re: I seam to be having the same problem. I added the the code that NetProgramer suggested but I wasn't successful. My error is given at the While m_Dr.read This is My code. [CODE] query = "Select * From " & Tabela & " where Model= @Model" & " Order by … | |
[QUOTE]Hi all I am using Vb2008 Express and an Access DB. I would like to Display a note from a column in the Notes_tbl to a text box this from an Access database. Here is the code that I used but it does not do the job. [/QUOTE] [ICODE] Dim … | |
Hi all I would like to do a Calender with tasks in VB but I can't seam to find a calender that I would be able to choose the size of the Cells. I was able to use Month Calender but I can not resize it. If there is such … | |
[QUOTE]I currently have two desktops and one laptop in the same workgroup. The desktops have XP PRO and the laptop has a VISTA OS I am the Administrator on all PCs. I can see both Xp's when openning the Network on the Vista. I'm sharing a folder in my vista … | |
:?: Hi all I'm trying to import data from an exel sheet to a data grid but I keep on getting the following error "The Microsoft Jet database engine could not find the object" Here is my code Thanks [CODE]Imports System Imports System.Data Imports System.Data.OleDb Public Class ExellFrm Private Sub … | |
[QUOTE]Hi all I have two forms which are being displayed from the MDI Parent form. In the following code I would like to send data from form 1 to form 2. [/QUOTE] [CODE] DsgnForm.InsertOE = txtOrderEntry.Text DsgnForm.InsertFN = txtFirstName.Text DsgnForm.InsertLN = txtLastName.Text DsgnForm.InsertAD = TxtAddress.Text [/CODE] [QUOTE] My problem is … | |
Hi I'm using XP PRO with sp3 and administrative Rights. When I go to start All Programs>Accessoeries>Ststem tools I get an empty folder. The same with Control Panel Administrative Tools also empty. When I did a Search I found them in Documents and Settings\Allusers\Start Menu\Programs\Aministrative Tools. Will I be able … | |
[QUOTE]Hi I have a datagridview which I would like to change the the color of the text in a cell if the number is negative in the Total column. This is what I have so far. [/QUOTE] [CODE] Dim rowcont As Integer = (TTLGrid.Rows.Count) - 1 For x = 0 … | |
[QUOTE]Hi all I have been straggling to mask a text box. I searched for the Mask property I could not find it. I have also tried to use textbox.mask it tells me that mask is not a member. I'm trying to enter currency in The text box ($1000.000) I'm using … |
The End.