Recent content by Ydrasil72683

Unforunately that didnt work anybody else have some ideas

I think I should explain this better when somebody inserts say "K" for the Block on the form, the query should display all the lockers in K block, or for example if I put in 1001 in locker Number I should get the record that has 1001 has a locker number. but instead of that I am getting all the...

Well what should be happening is the user enters data into the form, then this data is used by the query to sort the data and display the search results. Instead of doing this it is displaying all the data

Okay that brings up all the data but it doesn't sort it by what I put in the form. Any ideas ?

This what your looking for ?

Hello Looking to get some help with a query I am doing I am using Like "*" & [forms]![myform]![myformfield] & "*" Or Is Null in my Criteria field of the query, to try and get the form to display records that have blank fields but it will only display fields that have all the fields filled out...

Now as well I have enter in the OR underneath Criteria Where fieldname Is Null and it doesnt return any values

Hello I am running a query with Like "*" & [forms]![Frm_Lock_DES]![LNumber] & "*" in the Criteria field. This links it to the form which returns all the records that have all values in them, For example 1st name,last name, email etc. But if a record has a blank field it will not return...

you will have to forgive my ignorance but is there another way to do this without VB script

I was wondering how do you get the the search results of a query to display on a pre set report, by clicking on a button on a form ? Any and all help would be greatly appericated.

Ty for the advice john sorry getting back to you so late, got caught up in work.To answer the question Gina I do try and copy/paste to the forum but I get the above mentioned error,but I was wondering if anybody would know of a sample I can look at to append data in a table using a form ?

You will have to to forgive my lack of understanding, but is the the code in SQL veiw what you are looking for ? if not where do I look to see the code you are looking for the query ? and I did attempt to post my code from the SQL veiw but apparently the forum considers it a email address for...

sorry about my late reply but know I am not running any filters and on my command button I put: Private Sub Command35_Click() Me.Filter = "" DoCmd.OpenQuery "Q_Lock_search", acViewNormal End Sub Unforunately this still gives me a blank table, so if its not a filter what else could it be ?

Hello I am new to Access, but I am currently working on a small database in one of the local college to keep track of all the lockers in the building. Now the way it works is the user will enter the search criteria data into a form, then that data is sent to the query which searches for...