VIPER5646

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 …

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'm trying to write a Procedure to subtract days from a data but Ignoring weekends. This is what I have so far but I have a Syntax error Unexpected END, Expecting `;` I have put a ; after the last END but still get the same error. DELIMITER …

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 …