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 Chriss Miller 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. shteev

    Passing contents of a textbox to a function

    The button has the following event: On Click = ProcessTextFile(arg1) The function ProcessTextFile() is passed a single argument when it's called. I want to pass whatever the contents of a particular text box are (let's call it TextBox1).
  2. 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?
  3. shteev

    SELECT DISTINCT, pulling an entire record of my choice

    That returns both records.
  4. 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...
  5. shteev

    Change current record with Listbox

    Cheers, that's working well! One more thing on a related note: If I apply a filter to the recordset in the form, how do I update the listbox so that it displays the filtered list?
  6. 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...
  7. shteev

    Setting and getting table cell background colors

    Indeed. I notice that you CAN set the background color with a cell with this command in all 3 browsers: oCell.style.backgroundColor = 'rgb(255, 0, 0)' but if you test it's value you still get 3 different return values: IE returns 'rgb(255,0,0)' (no spaces) Opera returns '#ff0000' Firefox...
  8. shteev

    Setting and getting table cell background colors

    I'm running that code in Firefox 1.0PR and it's not working properly; cell colors rotate as far as green, and then stop changing. It returns a value in the style 'rgb(255, 0, 0)' which will not test positively against '#ff000'
  9. 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...
  10. shteev

    Data Entry form; validation rule violation

    Finally found it :) Set the following properties: Data Entry: yes Tab Key Cycle: Current Form You can then set 'Navigation Buttons' to 'No'; although having just discovered how to do all this I'd be wary of it in case I somehow managed to increment the record, and wouldn't be aware of it.
  11. shteev

    Data Entry form; validation rule violation

    Thanks for your help; the purpose of this form, however, is to allow a user with no experience of Access to enter data, so I don't want the form to be able to display data for more than one record either, to avoid confusion. I've solved the problem now. I don't fully understand where I was...
  12. 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...
  13. shteev

    Union query problem

    This works great! I had tried [null] which didn't work for reasons which appear all to obvious to me now...
  14. 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...
  15. shteev

    Limiting a data entry form to new data

    Is there also a simple way of setting up the form so that only one new record can be added?
  16. shteev

    Need help constructing a form

    Ahh, lovely, I knew it couldn't be anything too complicated. Can anyone help with my second problem?
  17. shteev

    Need help constructing a form

    My other problem is how to GET data from elements in the form, so I can pass that data to other elements. Specifically: I have 2 subforms on my form, both showing entire tables, as a datasheet view (so the user can sort/filter the data shown). I wish to select one record from each of these...
  18. 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?
  19. shteev

    Need help constructing a form

    Ok, I think I understand, but there's a problem and I'm clueless how to solve it. I've simplified the code down to this: Private Sub Attach_Comment_Button_Click() Dim strSQL As String strSQL = "INSERT INTO CommentXREFQuestionnaire" & _ "VALUES(""28"", ""E"", ""2"");" DoCmd.RunSQL strSQL...
  20. shteev

    Need help constructing a form

    I was hoping to get away without using Visual Basic cos I'm not very skilled with it. But it doesn't look too hard to achieve. I don't fully understand the code you've written, tho; It's constructing an INSERT query on the fly, but whats with the _ and """ characters?

Part and Inventory Search

Back
Top