Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MJnaeblis

    Keep groups on same page

    My problem is similar, but I am only looking to NOT have the group header print if it's the last thing on the page. As long as at least one record comes after it, I don't mind the group being broken. But I hate when the group header appears at the bottom and the first record of that group starts...
  2. MJnaeblis

    Why are my variables being shared?

    no, it only happens when they go at the same time. like if two people on two different machines hit the save button that does a DB operation at the same time, one of them gets the error. also the objects are no longer public. they are declared at page level with only Dim. to me, this just...
  3. MJnaeblis

    Why are my variables being shared?

    I have posted this question in the VB.NET forum, but I suppose it really belongs here. I first had my SqlConnection object as a public variable. When two users tried to do database operations at the same time, one would get an error saying the connection is already open. I have tried putting...
  4. MJnaeblis

    SqlConnection and Multiple Users

    well, i have noticed that it is not just the SqlConnection object. all variables seem to be shared by the users. this time i set all SqlConnections to session variables. that worked fine, but now my SqlDataReaders are causing problems. It seems that when one user has finished with the database...
  5. MJnaeblis

    SqlConnection and Multiple Users

    Whenever I am using an SqlConnection object and one user has it open, a second user (on a different machine) produces an error saying the SqlConnection is already open. I set a new instance of SqlConnection, open the connection on each page, and bring info from the DB. at the end of page_load i...
  6. MJnaeblis

    Passing Parameters from .NET to Crystal

    Thanks for that website. Actually I found what I was looking for on the Crystal site after some really tedious searches. Here it is for any who are also having this problem. http://support.crystaldecisions.com/library/kbase/articles/c2010242.asp use it for each param in your report. works...
  7. MJnaeblis

    Passing Parameters from .NET to Crystal

    I am trying to pass a set of parameters (two dates) to a report from .NET. However nothing seems to be working. My ReportDocument.RecordSelectionFormula works fine, but i have tried to use ParameterValue(s) and ParameterField(s) with no luck. Does anyone know how to do this? I either get null...
  8. MJnaeblis

    Unloading Textboxes?

    your solution would only work for me if i was not making an unknown amount of textboxes. this form needs to dynamically create a number of textboxes equal to the number of records. there was actually nothing wrong with the code, only what was calling the code. i was trying to unload from a...
  9. MJnaeblis

    Unloading Textboxes?

    yes, robert, i was. my code was correct. however, i was trying to unload from a combobox click event. this is not allowed (which escapes my logic). anyway, i just switched to a listbox and it works just fine. thank you everything was worked out in thread 222-112214 mjnaeblis
  10. MJnaeblis

    How to unload form controls

    thanks for your help, Robert. mjnaeblis
  11. MJnaeblis

    How to unload form controls

    it fails on the very first textbox (which is the upperbound textbox). according to MS's help on error 365, you cannot unload controls in the click event of a combobox, as you said. could this pertain also to all subs and functions called DURING the event as well? i made a command button and...
  12. MJnaeblis

    How to unload form controls

    this is what i used in the public sub Dim i As Integer For i = txtBedCID.UBound To 1 Step -1 Unload txtBedCID(i) Unload txtBed(i) Next mjnaeblis ps. the number of bed and bedCID are the same
  13. MJnaeblis

    How to unload form controls

    Thanks Robert, but this did not work either. i am still getting the 'Cannot unload within this context' error. mjnaeblis
  14. MJnaeblis

    How to unload form controls

    i am trying this very thing and have another thread with the exact same problem. i have tried setting them to nothing, turning off their visibility first, and unloading backwards in the array. i still am encountering a <cannot unload in this context> error. none of these things help and the...
  15. MJnaeblis

    Unloading Textboxes?

    sorry. i got an error when i tried to post this message, so i posted it again. i don't see any retract options, so i appologize for the redundancy. mjnaeblis
  16. MJnaeblis

    Unloading Textboxes?

    hi. what i am trying to do is populate a form with textboxes that hold data from a recordset. each record (yielding one field) is put into a textbox array. i have the first, txtBox(0), on the form in Des.Time, then as the user selects the query options, the form populates with the textbox array...
  17. MJnaeblis

    Unloading Textboxes?

    hi. what i am trying to do is populate a form with textboxes that hold data from a recordset. each record (yielding one field) is put into a textbox array. i have the first, txtBox(0), on the form in Des.Time, then as the user selects the query options, the form populates with the textbox array...
  18. MJnaeblis

    Is a Specific Order By Possible?

    thanks for the suggestion, tho Crystal didn't seem to like that. it totally ignored my Case in SQL and gave me an error on trying to sort by theorder! ...stupid Crystal reports... thanks tho. MJnaeblis
  19. MJnaeblis

    Is a Specific Order By Possible?

    i am trying to designate a specific order in which the records come out, not ascending or descending. is this possible with a Select and Order By? or perhaps another keyword that i am unfamiliar with? i'm working in Crystal Reports with SQL Server. example: SELECT LastName FROM People WHERE...

Part and Inventory Search

Back
Top