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. DixieDean

    Load Image from Directory into Image Control

    I see. Thanks again Jason
  2. DixieDean

    Load Image from Directory into Image Control

    Hi Jason Thanks very much for letting me know. I'll take a look at the links you kindly provided. Many thanks.
  3. DixieDean

    Load Image from Directory into Image Control

    Hi there. I'm so inexperienced in coding, it's embarrassing!!! I am using VWDE as a means to allow users to load an image from their own machine's directory into an image control, without having to store the image in any back-end database (i.e. directly from their machine). An example would...
  4. DixieDean

    DataSet Anomaly - Going Insane

    Thanks jshurst Another snippet of knowledge that I shall add to my growing arsenal. Also, thanks for5 your help throughout what has been a torrid time for me. And thanks to jbenson I stand corrected.... said the man with the othopaedic shoes. DixieDean
  5. DixieDean

    DataSet Anomaly - Going Insane

    Hi jshusrt and c8msm Just to let you know I've cracked the problem. It was parameter-oriented, but nothing to do with how the front-end was compiling them or how they were being sent through to SQL. At the risk of being branded an imbacile, but with the intention of helping others to avoid...
  6. DixieDean

    DataSet Anomaly - Going Insane

    Hi jshurst Just to keep you abreast of efforts at my end. I undertook a number of alternative approaches to try to ascertain if there were any particular anomalies occurring when certain aspects of the procedure were amended. 1. I removed the UserCode parameter from both the SP and VB...
  7. DixieDean

    DataSet Anomaly - Going Insane

    Hi jshurst Many thanks for looking at this for me. Here is the SP (sp_EvNIInList) and also a function that I ripped from another web site. This function (called “Split”) receives a string of delimited values and “splits” them into individual search criteria, which are then placed in the IN...
  8. DixieDean

    DataSet Anomaly - Going Insane

    Hi c8msm Thnks a lot for helping me out with this quandary. I tried to apply your advice to this problem. I used the following code. Please note that I removed the initial Parameters.Add method and replaced it by creating two parameter objects and assigning their properties as suggested...
  9. DixieDean

    DataSet Anomaly - Going Insane

    Hi jshurst Thanks for your last response. Your help is most welcome and appreciated. I tried applying your suggestion to resolving this problem, but, I’m afraid, to no avail. However, I have made some assumptions with regards to the code you posted. 1. I assume that the two parameters you...
  10. DixieDean

    DataSet Anomaly - Going Insane

    Hi ca8msm Thanks for your response. I'm afraid I'm a real novice at this. I would really appreciate it if you could provide an example of creating a parameter object and setting its properties accordingly, particularly if you could place it in the context of this problem. Many thanks in...
  11. DixieDean

    DataSet Anomaly - Going Insane

    Hi jsHurst Sorry to keep bothering you with this, but I've just ran a similar routine without any parameters and .... yep, you were right. It works fine. It's the darn parameters that are causing the problem. However, due to the need for these parameters, as any hard coding of search...
  12. DixieDean

    DataSet Anomaly - Going Insane

    Hi jshurst I've done as advised (i.e. removed the connection open and close elements). I eagerly await your help with this. It's driving me crazy. Thanks very much for your assistance. DixieDean
  13. DixieDean

    DataSet Anomaly - Going Insane

    Please, can anyone help me? I am a newbie to SQL Server Express 2005 and VWD Express, and I’m currently working on a personal project that consists of a relational database back-end (SQL SE 2005) that holds sports event data (i.e. number of participants, winner and date of event, etc), which I...
  14. DixieDean

    Use Label to Display Output from Stored Procedure

    Thanks for the quick response. I'm afraid I don't really have an example to offer, as I'm merely trying to understand how to get the DateRange label to display the string and the incorporated output values of the stored procedure. The truth is that I don't know where to start, as most of the...
  15. DixieDean

    Use Label to Display Output from Stored Procedure

    Hello Please help. I am a total novice with VWDE, and would be most obliged if you could overlook my general ignorance and help me with this issue. I have a web form called Demo.aspx which incorporates a label (DateRange) that I would like to display the earliest and latest dates when a user...
  16. DixieDean

    Problem with Multiple Values in Delimited String Criteria for Paramete

    gmmastros, thanks very much for pointing me to the solution. It works a dream. If you're ever in Liverpool, let me know, 'coz I owe you a huge drink. Many thanks and merry christmas. DixieDean
  17. DixieDean

    Problem with Multiple Values in Delimited String Criteria for Paramete

    Please stop me from going insane. I am but a humble, inexperienced developer, and I’m currently developing a web-based system, using SQL Server Express Edition 2005 as the back-end database application, and I have a parameterized stored procedure that I want to accept a parameter called...
  18. DixieDean

    Using Multi Select List Box Selections as Search Criteria

    Hi Zameer Many thanks for your help. It's very much appreciated. Regards DixieDean
  19. DixieDean

    Using Multi Select List Box Selections as Search Criteria

    Hi Helpers I am a MS Access numpty that needs to find out how I can use a multi select list box as the basis of the criteria used in a select query. I have a list box on a form from which users will select a number of options. Each selection will be placed into an “In (…” list within the...

Part and Inventory Search

Back
Top