Search:
Type: Posts; User: VS2013
Search:
Search took 0.03 seconds.
-
The same error pops up even after updating the suggested code. The txtSarchCustName.text contains the query text.
-
Hi,
I am getting the following error...
---------------------------
Error
---------------------------
Syntax error (missing operator) in query expression 'City where [CName] LIKE '%%''....
-
Thanks for your kind reply.
-
Hi,
Which Database is best for Small to Medium size Business Applications? I am using the MS Access Database now. Please advise.
-
Now the code is working fine. But what I need is, instead of mentioning CUSTNO =1 in the code, I want this CUSTNO to be taken from txtSearchCustNo.text. How can I do that?
WHERE
q.CUSTNO =...
-
Sorry. I didn't mention the database. It is MS Access Database.
-
I am getting this error: ---------------------------
Error
---------------------------
Unrecognized keyword WHEN.
---------------------------
OK
---------------------------
-
I tried it but got the error as shown in the snapshot.
-
As per your kind advice, I tried the following code which is working fine. But don't know how to get a virtual column to show the balance amount.
"Select CUSTNO, CUSTNAME, INVNO, INVDATE,...
-
Hi,
I have two tables:
1. SALESTABLE
2. RECEIPTSTABLE
I am now retrieving data of the above tables in separate datagridviews using the below code which is working fine.
Private Sub...
-
Thank you so much for your kind support.
-
Hi,
The following code works fine to get the whole total of a column in a table.
Dim TotalReceipts As Double
For Each dgvRow As DataGridViewRow In dgvReceipts.Rows
...
-
Got it. The code is working fine now. Thanks a lot for your kind support.
-
Thanks to all for their support. The first of the code is working fine but the second part of the code throws an error.
This is the code which I am using as per your advice.
"Select...
-
Hi,
I have a table "Reciepts_Table" in MS Access Database where I stored the information of received amount from all customers. I can extract all the records that customers paid to date in a...
-
Thanks a lot. It's Working now.
-
Hi,
I am using MS Access Database as backend in VS Project. The following code doesn't show any records and no error as well. Please support.
= "Select...
-
Thanks a lot for your valuable support. It is working fine with the following code:
"Select ExpNo,ExpDate,MainCategory,SubCategory,Description,PaidTo,TotalAmount,SearchCode from ExpensesTable...
-
Hi,
I have the following code to extract data related SearchCode (In this case CIVIL) which is working fine. But now I need to extract data related to CIVIL as well ELECTRICAL (both CIVIL &...
-
Thank you so much to both of you for the support. It is working now.
-
Dim StrSql As String = "Select ST.CustNo As Cust_No, ST.CustName As Cust_Name, Sum(ST.Total) As Total_Amount,
IIf(IsNull(TotSol), 0, TotSol) As Amount_Paid,
...
-
Thanks for your kind reply. Now, it shows the below error:
Syntax error in query expression 'St.CustName IIf(IsNull(TotSol), 0, TotSol)'.
Looking forward to your kind reply. Thanks once again.
-
Hi,
The below code is working fine with 2 fields:
Dim StrSql As String = "Select ST.CustNo As Cust_No, Sum(ST.Total) As Total_Amount,
...
-
When I tried to show multiple table data in a single datagridview, I am getting the below error:
IErrorInfo.GetDescription failed with E_FAIL(0x80004005)
Below is the code:
"Select...
-
The following code for joining two tables is working fine. But here I need to use 3 Tables. Please support.
"Select ST.CustNo, ST.CustName, Sum(ST.TotalAmt) As Total_Amount,
...
-
How to generate a report based on customer number (retrieving data from 3 tables and show it in a datagridview)?
-
How to change the existing positive value of a textbox to a negative value by clicking on btnChangeToNegativeValue?
-
Thank you so much for your kind advice in detail.
-
Do I need to create a Setup file of my Project to use this app. on another Laptop? Or can I use the .exe file along with other files of my project's Debug folder and copy it to my friend's Laptop who...
-
-
Thank you so much for the support.
-
I am using the following query to fetch data between two dates. But it shows values from FromDate as I wanted but the values are not shown for the ToDate.
For example:-
From Date: 5/5/2022
To...
-
Private Sub cboMainCategory_SelectedIndexChanged(sender As Object, e As EventArgs) Handles cboMainCategory.SelectedIndexChanged
Call cboLoadSubCategory()
txtSubCategory.Select()
...
-
Now it shows the data but only for the first Select Case statement which is "CIVIL". It shows the same result for all the other Select Cases.
-
It highlights while executing the file: SYSTEM.DATA.DATAROWVIEW
-
Getting the attached message.
-
The following code is also not fetching values as expected.
Public Function cboLoadSubCategory()
Dim FindText As String
FindText = "CIVIL"
Select Case FindText
...
-
Thanks for your kind advice. I am looking for tutorials that help debug coding on YouTube. Since I need it urgently, I posted it on two sites.
-
Hi,
I am not able to fetch data in Combo Box while applying some If Conditions. Without conditions, it works fine.
Below is the working code:
Public Function cboLoadSubCategory()
...
-
The problem has been resolved. Thanks a lot for your kind support.
|
Click Here to Expand Forum to Full Width
|