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!

  • Congratulations bkrike 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: shteev
  • Content: Threads
  • Order by date
  1. shteev

    Passing contents of a textbox to a function

    Hi, I have a form in Microsoft Access. There is a textbox which contains a filename, and a button which calls a VB function. i want to pass the string in the textbox to the VB function as an argument. How do I do this?
  2. shteev

    SELECT DISTINCT, pulling an entire record of my choice

    Hi. I have an Access database of cards for a trading card game, some of which have identical names, although their other fields may not be identical. Example NAME - COST - CARD TEXT - YEAR PRINTED Fog - G - No creatures deal damage in combat this turn - 1995 Fog - G - Creatures deal no combat...
  3. shteev

    Change current record with Listbox

    I have a form which displays various fields from a record in a table. I've got those little arrow buttons at the bottom of my form so I can change the current form being displayed. But I don't know how to add an element to the form myself which I can use to select the current form. What I want...
  4. shteev

    Setting and getting table cell background colors

    I'm writing a Jscript version of mastermind, code here: http://mysite.wanadoo-members.co.uk/shteevshouse/games/MindMaster.html I'm trying to fix it so that it works for Firefox as well as Opera and IE. Each cell can be one of six colors. When I click on a colored cell, I want it's color to...
  5. shteev

    Data Entry form; validation rule violation

    I'm constructing a form in MS Access to allow the user to enter data into a table. However, I only want the user to be able to enter one record each time the window is opened. Is there an easy way to do this? What I've done is create a form which is not bound to any table; the user uses objects...
  6. shteev

    Union query problem

    Hi, I want to make a union query which adds 2 tables together; but I want it to contain a field which is in one table, but not the other. For entries in the second table, I want the union query to contain a NULL. So, something like this: SELECT [field1], [field2], [field3] FROM [table1] UNION...
  7. shteev

    Where's my hidden form gone?

    I've hidden a form in MS Access, by right clicking on it in the main database window, selecting 'properties', and clicking the 'hidden' box. How do I unhide it again?
  8. shteev

    Need help constructing a form

    I'm building a form in MS Access which allows the user to select a record each from 2 different tables (using combo boxes and/or drop boxes), display data from all fields of both records selected, and then add a record to a third table, constructed from data from the 2 records selected (the...
  9. shteev

    Help needed constructing an expression

    I'm trying to write an expression in a Query. I have a column of numbers, values between 1 and 10 (may be fractional). I want to construct an expression in an adjacent column that will print '+' is the value is >=9, '-'if the value is <=2, and NULL in any other case. Currently I'm using this...
  10. shteev

    subdatasheet/resize error - recoverable?

    I have 2 Queries. QueryA is a union query written in SQL, showing combined details of the fields that 2 tables have in common. QueryB has been designed in the Design View, with it's subdatasheet set to QueryA. When I open QueryA in the Datasheet View, I can resize the columns, resave the query...
  11. shteev

    Limiting a data entry form to new data

    I've create a form in MSAccess 2000 to which I'm using to allow a user to enter new data into a table. However, when the form opens, it always opens with the data for row 1 in the table. Its simple enough to click on the 'new record' button at the bottom of the screen before entering new data...
  12. shteev

    Excel filter/summary problem

    I'm using Excel 2000. I have a large (10000+ rows) table in one worksheet, and then a table which summarises it's results in a separte worksheet. I can use the Data/Filter/Autofilter function to filter my large table; but it only changes how the table is seen, and so the summary table is not...
  13. shteev

    Need AutoNumber to generate individual ID# across 2 tables

    I'm still writing a database in MS Access 2000. I have 2 tables, one which holds data from Type A Questionnaires, and one which holds data from Type B Questionnaires. There are large differences between the 2 types of Questionnaires. However, I need each questionnaire, regardless of type, to...
  14. shteev

    Problem aggregating and summarising 2 tables

    I'm writing a database in MS Access 2000. I have 3 tables: 1. Questionnaire Subjects 2. Type A Questionnaires - Subject (from table 1) - Average Score - .... <additional fields> 3. Type B Questionnaires - Subject (from table 1) - Average Score - .... <additional fields> Type A...
  15. shteev

    List view - Add multiple items?

    I'm writing a database app in Visual C++ 6, using a listview to display my items; up to about 6,000 of them. I'm finding InsertItem() quite slow. Is there a way I can Insert multiple items into the list with a single command, and then edit them when they are in place?
  16. shteev

    List control problem

    I'm writing an appliction in Visual C++ 6 using a List Control. When the item highlighted in the list changes, I want a message to be sent so I know, so that I can update an Edit Box (which contains text from the highlighted member of the list). But there doesn't seem to be an appropriate...

Part and Inventory Search

Back
Top