Search Results - VBForums

Search:

Type: Posts; User: BlueFox

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Re: How to group by a table based on another table

    Its something like this:
    First create groups
    create table feegroups(feegroupid int,feegroupname varchar)
    insert feegroups values(1,'SEMESTER1')
    Next:
    create table feetypes(feetypeid int,...
  2. How to group by a table based on another table

    I have fee groups and under that fee groups, there are fee types. When there are entries of all the fee types under a group, the group name must be displayed. How can I achieve this?
    Example There...
  3. [RESOLVED] Help Needed to save continuous number based on 2 types on entries in a single table ?

    SQL SERVER 2000:
    I need to save 2 kinds of the same bill to a tables called bills. But each kind should have same continuous bill numbers.
    Meaning if A and B are the two kinds, both should have...
  4. Re: Help in preventing application going non responsive during restoring a backup

    Here is the line I am getting Stuck at
    dim cnn as adodb.connection
    .....
    cnn.execute "RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK' WITH REPLACE" '<<Here

    The database...
  5. [RESOLVED] Help in preventing application going non responsive during restoring a backup

    I have an application which backs up and restores database (sql server). Somtimes it takes a long time. I need to put a progressbar or a gif while the query is being processed. Doevents is not...
  6. Replies
    12
    Views
    880

    Re: vb6 need help (Runtime error 3265)

    Run time error 3265 is 'item not found in the collection' Error. I think you are using a column name that does not exist in the database like Rs!eArea or something like that
  7. Re: Need Help In Designing a query for returning students who did not pay fees

    Yes, It is sql server 2000 and I need feesids and names to be dynamic. I have also added an amount column. If we can get the total, We can use it for each students entry in feespayments table total....
  8. Re: Need Help In Designing a query for returning students who did not pay fees

    This is the result for your query
    109285
  9. Re: Need Help In Designing a query for returning students who did not pay fees

    A list of all students who haven't paid any fees type. That is what I want. If a student has paid all the fees type, he should be not in the result. If other student has paid one, from total of four...
  10. Need Help In Designing a query for returning students who did not pay fees

    I need to list the names of student who did not pay the fees (there are mutiple fees types). The logic would be find those students who does not have the entry in the feespayment table for that...
  11. Re: How To Add referece directly to .vbp file?

    I usually take my source code when installing some updates or for fixing some errors with me. I will run it on the client computer (Yes, I have vb6 installed on to solve the issues on site. Many of...
  12. Re: How To Add referece directly to .vbp file?

    It is my client's computer. Therefore I cannot reinstall or shutdown the computer (because it has sql servers etc). When I modify my program, which is a group project with dll project,I make .dll...
  13. [RESOLVED] How To Add referece directly to .vbp file?

    I know I can add reference from the project>references, But in many computers,(Most Win 7 Or Greater versions) Some "error accessing the system registry" errors are popping up. I have read all the...
  14. Re: Vb-Sql 2000 Date format Problem in query

    Parameters Then!!.
  15. Re: Vb-Sql 2000 Date format Problem in query

    So Should I omit Format Function?
  16. Re: Vb-Sql 2000 Date format Problem in query

    While Clicking Search Button On Server This is the query being generated:
    select * from admission where deleted=0 and dob between '12/09/2013' and '12/11/2013'
    But the same search button generates...
  17. Re: Vb-Sql 2000 Date format Problem in query

    I don't think, while using the parameters, I ever got wrong date. The problem was while building query for report, I embed the date into the query string from the date picker. Some records are...
  18. Re: Vb-Sql 2000 Date format Problem in query

    When Updating I Try To Use Procedures. But When displaying Reports, the query is string and I am using recordset. Are you saying that I don't have to worry when I am using parameters?
  19. [RESOLVED] Vb-Sql 2000 Date format Problem in query

    I am using vb6 for developing my database application for storing and displaying data. The Problem is the date format in different computers using my application. The Client has different computers...
  20. Re: Need help in designing a query to show rows as columns in Sql 2000

    Solved. I Did Some Violent Coding in front end and Achieved the Result.
  21. Re: Need help in designing a query to show rows as columns in Sql 2000

    Does Sql 2000 Support PIVOT?. Also I am not using excel. It is a spread sheet control in vb6
  22. [RESOLVED] Need help in designing a query to show rows as columns in Sql 2000

    I have a table called markregister. It has data something like
    StudentId | PaperID | Marks
    1 | 1 |10
    1 | 2 |43
    1 | 3 |36

    The task...
  23. Re: Error opening Printer.Port. Bad file name or number!!

    I too am using the generic text only driver. But I cannot send printer codes to that (DOT MATRIX) printer. From what I have learnt, I need to send the raw data to the printer to achieve this. I can...
  24. [RESOLVED] Error opening Printer.Port. Bad file name or number!!

    I was trying to print to the printer in raw mode for sending control codes. I am not being able to control the printer.height by using printer.print method. The printer is ejecting too much paper. I...
  25. How Can I Set The Print Layout With Continuous Paper?

    I have to set a print layout for a continuous rolling paper with width 5 inches. What Should be the paper size when using the printer object. How can I set the printable area and A fixed height for a...
  26. Re: Need Help in Designing Logic of a School Database. One for each year or Only One?

    Well this software has additional accounting, and other tasks. Let Me Try T.Y.
  27. [RESOLVED] Need Help in Designing Logic of a School Database. One for each year or Only One??

    For a school software there will be settings that won't change and students that will change. Should I create a new database for each year? Or just enter students and change their 'Grade/Standard'...
  28. Re: How Can I truncate only some tables in a database using procedure?

    There will be multiple tables. I will try to loop in the procedure then...
  29. Re: How Can I truncate only some tables in a database using procedure?

    T.y. Very much
  30. Re: How Can I truncate only some tables in a database using procedure?

    Yes I am passing a table name and an indicator to decide whether to truncate it or not
  31. [RESOLVED] How Can I truncate only some tables in a database using procedure?

    There will be a true or false condition specifying whether to include or exclude the passed table names from truncating. That is, if I pass true, then truncate the tables which were passed to the...
  32. [RESOLVED] Any tools for setting print layout during design time?

    I have some variables I need to print. I have hard time setting x and y for the printer object. I need to set it during design time by dragging and creating positions for variables. Something like...
  33. Re: How to change the default instance of sql server 2000 to a named one

    When I click debug option from the menu in sql query analyzer in a computer with sql server running with default instance,only 'go','toggle breakpoints','remove all break points' buttons are enabled....
  34. [RESOLVED] How to change the default instance of sql server 2000 to a named one

    I need to change the default (computer name) instance to a named one (computername\instancename) or sql server 2000.
    This is for debugging stored procedures in query analyzer. I am not able to debug...
  35. Re: Update 2 tables in a procedure. Row count of one table unknown

    Its like a stored procedure which updates details about a person. That person may have/not have children. Also their count will differ. After supplying parameters like age,sex etc you have to update...
  36. Update 2 tables in a procedure. Row count of one table unknown

    I have two tables i need to insert data into using a stored procedure. One is main table and other is its detail table.There would only be single row in main table
    The problem is the count of rows...
  37. Re: Need help to show adjustable layout of invoice in a picturebox in vb6

    There would only be text. Do I need separate pictureboxes for that?
  38. [RESOLVED] Need help to show adjustable layout of invoice in a picturebox in vb6

    I have a invoice/receipt to print from my vb6 form. I need to show its preview in a picturebox with contents. User must be able to change the x,y (currentx,currenty of printer object) of the position...
  39. Re: How to make sure I insert unique values in a column when they are not zeroes?

    There is a problem with 'when to turn off the identity aspect' thing. I do not know if the user in going to put their own value or accepting the maximum value which I generated for them. Or there...
  40. Re: How to make sure I insert unique values in a column when they are not zeroes?

    szlamany, Will that identity column allow me to let users put their own number in that column? Because they will. But it will be unique. FunkyDexter,I cannot add constraint because there will be...
Results 1 to 40 of 67
Page 1 of 2 1 2



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.