Search:

Type: Posts; User: VS2013

Page 1 of 9 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    10
    Views
    722

    Re: Need help to resolve this query.

    The same error pops up even after updating the suggested code. The txtSarchCustName.text contains the query text.
  2. Replies
    10
    Views
    722

    Need help to resolve this query.

    Hi,

    I am getting the following error...

    ---------------------------
    Error
    ---------------------------
    Syntax error (missing operator) in query expression 'City where [CName] LIKE '%%''....
  3. Re: Which Database is best for Small to Medium size Business Applications?

    Thanks for your kind reply.
  4. [RESOLVED] Which Database is best for Small to Medium size Business Applications?

    Hi,

    Which Database is best for Small to Medium size Business Applications? I am using the MS Access Database now. Please advise.
  5. Re: Need a query to show data of a customer account in a report form...

    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 =...
  6. Re: Need a query to show data of a customer account in a report form...

    Sorry. I didn't mention the database. It is MS Access Database.
  7. Re: Need a query to show data of a customer account in a report form...

    I am getting this error: ---------------------------
    Error
    ---------------------------
    Unrecognized keyword WHEN.
    ---------------------------
    OK
    ---------------------------
  8. Re: Need a query to show data of a customer account in a report form...

    I tried it but got the error as shown in the snapshot.
  9. Re: Need a query to show data of a customer account in a report form...

    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,...
  10. [RESOLVED] Need a query to show data of a customer account in a report form...

    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...
  11. Re: How to get the total value (excluding last record value)?

    Thank you so much for your kind support.
  12. [RESOLVED] How to get the total value (excluding last record value)?

    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
    ...
  13. Re: Need query to get only last record of a customer from his/her total records ...

    Got it. The code is working fine now. Thanks a lot for your kind support.
  14. Re: Need query to get only last record of a customer from his/her total records ...

    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...
  15. [RESOLVED] Need query to get only last record of a customer from his/her total records ...

    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...
  16. Re: What is wrong with this query? Not showing any result.

    Thanks a lot. It's Working now.
  17. [RESOLVED] What is wrong with this query? Not showing any result.

    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...
  18. VS 2019 Re: Getting error on retrieving multiple search data from same field?

    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...
  19. VS 2019 [RESOLVED] Getting error on retrieving multiple search data from same field?

    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 &...
  20. VS 2019 Re: Throws an error after adding one more extra field in the code!

    Thank you so much to both of you for the support. It is working now.
  21. VS 2019 Re: Throws an error after adding one more extra field in the code!

    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,
    ...
  22. VS 2019 Re: Throws an error after adding one more extra field in the code!

    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.
  23. VS 2019 [RESOLVED] Throws an error after adding one more extra field in the code!

    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,
    ...
  24. Getting error : IErrorInfo.GetDescription failed with E_FAIL(0x80004005)

    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...
  25. Re: How to generate a report based on customer number (retrieving data from 3 tables)

    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,
    ...
  26. How to generate a report based on customer number (retrieving data from 3 tables)?

    How to generate a report based on customer number (retrieving data from 3 tables and show it in a datagridview)?
  27. How to change the existing positive value of a textbox to a negative value on button_

    How to change the existing positive value of a textbox to a negative value by clicking on btnChangeToNegativeValue?
  28. VS 2019 Re: Do I need to create a Setup file of my Project to use this app. on another Laptop

    Thank you so much for your kind advice in detail.
  29. VS 2019 [RESOLVED] Do I need to create a Setup file of my Project to use this app. on another Laptop?

    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...
  30. Re: From Date is okay but values are not showing for To Date

    Thanks.
  31. Re: From Date is okay but values are not showing for To Date

    Thank you so much for the support.
  32. [RESOLVED] From Date is okay but values are not showing for To Date

    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...
  33. VS 2019 Re: Combo Box doesn't fetch data from MS Access Database when I apply If Conditions.

    Private Sub cboMainCategory_SelectedIndexChanged(sender As Object, e As EventArgs) Handles cboMainCategory.SelectedIndexChanged
    Call cboLoadSubCategory()
    txtSubCategory.Select()
    ...
  34. VS 2019 Re: Combo Box doesn't fetch data from MS Access Database when I apply If Conditions.

    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.
  35. VS 2019 Re: Combo Box doesn't fetch data from MS Access Database when I apply If Conditions.

    It highlights while executing the file: SYSTEM.DATA.DATAROWVIEW
  36. VS 2019 Re: Combo Box doesn't fetch data from MS Access Database when I apply If Conditions.

    Getting the attached message.
  37. VS 2019 Re: Combo Box doesn't fetch data from MS Access Database when I apply If Conditions.

    The following code is also not fetching values as expected.


    Public Function cboLoadSubCategory()
    Dim FindText As String
    FindText = "CIVIL"
    Select Case FindText
    ...
  38. VS 2019 Re: Combo Box doesn't fetch data from MS Access Database when I apply If Conditions.

    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.
  39. VS 2019 Combo Box doesn't fetch data from MS Access Database when I apply If Conditions.

    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()
    ...
  40. Re: The code throws an error while retrieving data from two tables

    The problem has been resolved. Thanks a lot for your kind support.
Results 1 to 40 of 329
Page 1 of 9 1 2 3 4



Click Here to Expand Forum to Full Width