i have 2 list boxex which are bound together, if you select the ist list box it shows valeus in second table. below the list boxes i have a txt box and command button. Instead of going down each table they can just type the selection and press find it also has a find next butt that searches all the tables. I now want to create a check box that allows the users to view values only in the selected table can anyone assist.
...
dstyles7
Last Activity: Mar 14 '07, 04:20 PM
Joined: Mar 8 '07
Location:
-
check box to select values only in selected table
Last edited by willakawill; Mar 14 '07, 05:49 PM. Reason: please use [code]...[/code] tags when posting code -
Thanks again i changed it however when i try to to a wildcard search it goes directly to the first record in the list box no matter what name you type it goes to the first. unlike the othetr txt box where it finds and character that is entered in the list box.
i really appreciate yur help
"WHERE [FFField Name] LIKE '*" & txtFieldName & "*' OR " & _
"[Field... -
Thanks for your help . i have i problem i can do a wild card search in txt field name and i pulls up the correct values however txt field description's wild card search isn't working. can you assist
"WHERE [FFField Name] LIKE '*" & txtFieldName & "*' OR " & _
"[Field Description]= '*" & txtDescription & "'"
Set mRS = mDB.OpenRecords et(Sql,...Leave a comment:
-
need emercency help DoCmd.RunSQL Sql error
there are two list boxes in a form i have a command populate button that takes the values from the list box and inserts the primary key value from the selected list box into a access table. The table populates correctly it shows a message box
"You are about to append 1 row(s).
Once you click yes, you can't undo command to reverse the changes
Are you sure you want to append the selected rows "YES OR NO"... -
It is still pulling up a error messageLeave a comment:
-
Sql Help
I CREATED A LIST BOX AND TEXT BOX WITH A COMMAND BUTTON BELOW
THE TXT BOX IS USED TO FIND INFO IN THE LIST BOX . I CREATED A SQL STAMENT THAT DOES THIS. HOWEVER I WOULD LIKE TO CREATE A WILD CARD WHERE IF SOMEONE ENTERS CARACTERS FROM A-Z IT WILL PULL UP A RECORD. BELOW IS MY CURRENT SQL STATEMENT
SQL = "SELECT LWFieldKey, LWTableLink, LWTableName, [LWFieldName_4], [Field Description] " & _
"FROM... -
using wildcard character in query
i created a list box and text box with a command button below
the txt box is used to find info in the list box . i created a sql stament that does this. however i would like to create a wild card where if someone enters caracters from a-z it will pull up a record. below is my current sql statement
SQL = "SELECT LWFieldKey, LWTableLink, LWTableName, [LWFieldName_4], [Field Description] " & _
"FROM... -
Sql Help
I created a list box and text box with a command button below
the txt box is used to find info in the list box. I created a SQL stament that does this. However I would like to create a wild card where if someone enters caracters from a-z it will pull up a record. Below is my current SQL statement :
...Code:SQL = "SELECT LWFieldKey, LWTableLink, LWTableName, [LWFieldName_4], [Field Description] " & _ "FROM
No activity results to display
Leave a comment: