Search results for query: *

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

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

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

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

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

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

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

Will do! Thanks again, -T

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

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

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

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

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

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

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

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

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)

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

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

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