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 Rhinorhino 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: *

  • Users: VBAHole22
  • Content: Threads
  • Order by date
  1. VBAHole22

    How would you save a portion of your database if you had to?

    I have a database with 6 tables that are all joined together in one way or another. At certain points in time I want to take a subset of the records in one table(based on a criteria in that table) and 'catalog' them somehow along with the related records in the other tables. It's somewhat hard...
  2. VBAHole22

    Connection, parameter management

    I have a long block of code that makes about 10 or 12 different parameterized queries against SQL server. Some are readers others are NonQuery. My question is what is the best way to manage the connection(s) to optimize performance. One way I had was opening and closing the connection after...
  3. VBAHole22

    mouseover only works once

    I am trying to create a mouseover script that calls back an xmlrequest to get data off of my server without a post back. I modeled my code after this http://www.anders.com/projects/blogQuote/ and added my own C# web service back end I'm having a problem with it in IE though. It works when the...
  4. VBAHole22

    Dynamic table name in a query

    Is it possible to write a T-SQL query that goes through another table and pulls out a field that is the name of a table and another field that is the name of a field and then query for that? I'm not explaining so well, sorry. I have a table that has id, tablename, field. I want, for every record...
  5. VBAHole22

    Tricky SQL query - MINUS SETS

    I have a program that takes a point and creates circles of different sizes around the point. Then these circles are intersected with the locations of hospitals. I then get the number of the hospital out of that intersection. Anyway here is the issue. I have a table that contains the hospital...
  6. VBAHole22

    Drives not recognized one day.

    So one day I turn on my computer and my drives are no longer recognized. They are getting power. I have a dvd and a cd drive. I haven't moved my machine around lately so I don't think it can be a bad connection. I have XP. It's a Dell 2350. Device Mangler says everything is working fine but the...
  7. VBAHole22

    Another Newbie Update question

    I am just learning Oracle after having an Access SQL Server background and the SQL is killing me. The joins work so differently. If I just had some base code to start with I would be off and running. What I am trying to do here is update a table (A) with a value that determine by looking at...
  8. VBAHole22

    Child Control Properties

    How can I set the Text property of a child textbox control in a panel control on an asp.net web form? I have panel1 and it has textBox5 in it. I want to set the text in textbox5 to "Hello". How do you do this? I know how you can't do it and this is what I have been trying: Dim ctl As...
  9. VBAHole22

    Categorizing Query

    I have a field with a text value. I want to write a function that updates another field with the value of the first letter of that text field, but only when it falls within a specific group. For example, if the text field is 'goat' then the first letter if 'g' and I have a table that lists...
  10. VBAHole22

    Copy tables between servers, dbs

    How would I go about copying a table from one server to another server. The tables are in different databases. I suck at SQL PLus, I usually use Aqua Data Center. I know I need to use an INsert Into statement but how do you specifiy the different servers? Do I have to have a middle step, like...
  11. VBAHole22

    Exceptions

    I have a snippet of code that builds a command button for use in another program. I am using a bitmap image for the icon of this button. If I spell the name of the bitmap image incorrectly it doesn't work. So I set up a Try Catch block to catch this. It works but the trouble I am having now is...
  12. VBAHole22

    Request.form with null values

    I am writing an ASP page to take the results of a user survey and enter them into a new record in an access db. It works fine when the user fills out all of the questions (some yes/no, some multiple choice) but if they leave one blank the page returns an error at the line where the db would be...
  13. VBAHole22

    Optional Parameters in a Stored Proc?

    Can stored procedures accept optional parameters? I am using an ADP in Access2k against an SQL Server 2k database. I am trying to build a form that allows users to query a particular table in my database. What I would like is for them to be able to select from among 5 criteria to use in their...
  14. VBAHole22

    MaxRecords on a stored proc?

    I have a stored procedure that I use to fill in a combobox on a user form. I like the fact that this box uses AutoExpand to finish off what the user is typing, however, I don't think that it is working with the entire range of possible values. When I run the proc in my Access project it defaults...
  15. VBAHole22

    Repeat previous entry

    I have an Access 2000 project running on a SQL Server 2000 db. My main form is a data entry form and I would like my users to be able to hit a key to copy the value of the same field from the previous record. I know this is possible in Access using a key combination but I can't get this to work...
  16. VBAHole22

    Adp Connection issues with SQL Server

    I designed a nice user interface using an Access project (.adp) based on a SQL Server 2000 db. It works fine and dandy and now I want to move it to another machine so the data entry technician can begin using it. I cannot seem to get it to work though. It will open but it has no tables and it...
  17. VBAHole22

    Parameter returned from stored procedure

    I know there is a way to get a parameter back out of a stored procedure I just don't have the sin tax right. Can anyone help me out? Alter Procedure ReturnIDfromCommonName @COMMON_NAME varchar(50), @ID char(6) OUTPUT As SELECT @ID =BOVA FROM BOVA_TAXONOMY WHERE COMMON_NAME = @COMMON_NAME...
  18. VBAHole22

    Text-heavy, Book-like Reports

    I have a db that stores large blocks of text as answers to questions posed to users. I have about 30 fields with this type of format. I would like a report that prints out the text of the question and then the resulting answer. My problem is that i want this text to go 'down' then page and not...

Part and Inventory Search

Back
Top