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

    Tabular Form: Click a record to bring up new form with like data?

    Thanks, I attempted to do it this way, but got confused with all the optional Filters and Wheres, but found out that ... It seems as though the button wizard can do everything I needed. Create the new button, and make it Open Form and select the criteria with which the form should return...
  2. Tasuki

    Tabular Form: Click a record to bring up new form with like data?

    I have a tabular form, where i rearranged it to look like a table. I added a button so that if they click the button next to the record, it will popup another form with data pertaining to the row clicked. I'm having problems getting the button to work. How can I make the form come up and have...
  3. Tasuki

    Query to lookup a value in a field on a form and use in Criteria..

    Woot! I figured it out... doing a search on the Access Other Forums. In the OR below the CRITERIA, add: OR [Forms]![Form1]![Text1] Is Null And it works! Hope this helps anyone else who wants to do a dynamic search form (can be dynamic if you don't use the button like I did, just do it in...
  4. Tasuki

    Query to lookup a value in a field on a form and use in Criteria..

    Thanks PHV for all your help. I settled with a button with onClick: Me![Form2].Refresh Although I haven't solved the problem with it not showing NULL fields when search criteria is blank, I'll try to figure it out later. Tried your way above too, but it kept popping up the PropertyTag field...
  5. Tasuki

    Query to lookup a value in a field on a form and use in Criteria..

    Okay, it works searching on non-null values. But there's no way to query the null values using that LIKE statement. I changed to: Like "*" & [Forms]![Form1]![Text1] & "*" That way it will search everything in the text field and not just from the beginning. Two last questions if anyone can...
  6. Tasuki

    Query to lookup a value in a field on a form and use in Criteria..

    Thanks PHV. Although it doesn't seem to match anything in that field on the form. It does return all non-null fields though, but matching doesn't seem to work. How would I make it show both null and non-null fields? And how come the statement doesn't seem to work when I do a search? I guess...
  7. Tasuki

    Query to lookup a value in a field on a form and use in Criteria..

    I have a form (Form1), that has one field (Text1), and a subform which is the table view of a query (Form2) using (Query1) to show the data. I wanted to add to the criteria, something like: Like " & [form1].[Text0] & " & * And therefore, will update the query based on what I type on the form...
  8. Tasuki

    Populate fields based on a record from another table?

    Will do! Thanks again, -T
  9. Tasuki

    Populate fields based on a record from another table?

    Thanks, that works great now. The ErrorHandler part doesn't seem to work, saying it's undefined or something, but I commented it out and it works. The code is not 100% perfect because after exiting the form and re-entering a new form, it only seems to carry over data from the very first carry...
  10. Tasuki

    Populate fields based on a record from another table?

    Thanks PH, Looks like the solution I'm looking for, although I keep getting an error using it. Always getting a syntax error at: If ctl.tag = "CarryForward" I think I did everything as specified. I changed the After Update event to the code for Multiple Controls, and change the Control Tag...
  11. Tasuki

    Populate fields based on a record from another table?

    Hmm, I think I've got it using the DLookup function. Is there any way to use DLookup to pull the value of the last record inputted? It would be much better than having to reset the default form if the DLookup can populate certain fields based on the last entry received... Hopefully...
  12. Tasuki

    Populate fields based on a record from another table?

    Hi, I have 2 forms, one form is the default value form, and the other is a regular form. -The default value form will have common values that are used frequently in the regular form. -The regular form, will look up the current default values and populate them to the related field. This...
  13. Tasuki

    Using - $id = $query->insertid, not working...

    I'm not sure what you really mean, is there something that I shouldn't be doing in this code? It is actually a one-time use thing, importing data from a tab-delimited text file (exported from Excel file) into MySQL for a website. I wanted to keep a one-to-many relation between the NetClass...
  14. Tasuki

    Using - $id = $query->insertid, not working...

    Nevermind I figured it out... using something like this: $NetTypeID = $sth->{'mysql_insertid'}; Returns the last inserted auto-incremented value. Hope that will be of help to someone looking to insert something similar to this. -T
  15. Tasuki

    Using - $id = $query->insertid, not working...

    I'm not sure if I'm using this correctly. For the following piece of code: $id = $query->insertid [What it does: If you have a field that is auto incremented, then this function will come in handy. It will return to you the the unique id given to the field after the query.] I have two tables...
    • Tasuki
    • Thread
    • Replies: 4
    • Forum: Perl
  16. Tasuki

    Array help...

    Thanks Ken, that works great. Thanks DRJ478, I thought it returned all the results in an array in the variable.
  17. Tasuki

    Array help...

    Sorry, I didn't notice you changed to ORDER BY... still yields same results. In MySQL I get: +------------+ | date | +------------+ | 1999-11-30 | | 1999-11-30 | | 1999-11-30 | | 2004-02-03 | | 2005-03-02 | +------------+ 5 rows in set (0.00 sec)
  18. Tasuki

    Array help...

    Thanks Ken, just tried: $dateresult = mysql_query("SELECT date from tblNetClass GROUP BY date"); $datearray = mysql_fetch_array($dateresult); //print_r($datearray); //$e_date = array_shift($datearray); //$l_date = array_pop($datearray); $e_date = $datearray[0]; $l_date =...
  19. Tasuki

    Array help...

    I'm having a tough time trying to find a solution to this, hopefully someone can shed some light. I'm trying to grab the earliest and latest date in the database. So this is my code: $dateresult = mysql_query("SELECT date from tblClass GROUP BY date"); $datearray =...
    • Tasuki
    • Thread
    • Replies: 8
    • Forum: PHP
  20. Tasuki

    OnChange help...

    Thanks kaht. It was the name of the button that was the problem. I've changed it and it finally submits on selection. I will be careful next time with naming and make sure they are unique. Thanks for the advice, and help. I've run into another problem where it seems my PHP code doesn't...

Part and Inventory Search

Back
Top