Search results for query: *

I used a query in VB with an access form as the front end to create a report...I have modified it to try to make it work in SQL Server...it is returning too many fields though currently..... Select dev.KinderNumber,dev.Client,dev.MFG,dev.FAMILY,dev.Intro_Date,dev.FIXTURE,dev.Dimensions_HWD...

trying to set something up so when the user is done searching for one item they dontt have to go and manually clear out out each box

I have a form that I am trying to set up to clear the previous fields....after use currently the user has to go and delete the previous search criteria

Below is my code to give me a PAGING type form...I currently have a form with text and combo boxes that pass parameters to a query and it works fine...the problem is the output only returns one item per page....I solved this by using my paging code for this form...but I want to set it up so a...

Source = "select Development.[KinderNumber],Development.[Date],Development.[Client],Development.[MFG],Development.[Fixture],Development.[Dimensions (HxWxD)],Development.[MFG Price],Development.[Item Number], dp.[Image], dp.[Revision_ Letter] FROM developmentpictures dp, Development WHERE...

.Source = "select Development.[KinderNumber],Development.[Date],Development.[Client],Development.[MFG],Development.[Fixture],Development.[Dimensions (HxWxD)],Development.[MFG Price],Development.[Item Number], developmentpictures.[Image], developmentpictures.[Revision_ Letter]FROM...

I have a form that through VB code loads information from 2 tables in a WEB or Paging style format.. Basically one table is nothing but pictures with basic information and there are various pictures for each "ID" number because of revisions to te product design. the other table is a...

here is my code and it works fine as is: Set cn = CurrentProject.Connection Set rst = New ADODB.Recordset With rst .PageSize = 8 .ActiveConnection = cn .Source = "SELECT * From Development, developmentpictures" .LockType = adLockOptimistic .CursorType = adOpenStatic .Open BUT...

trying to set up a query that returns only fields with data if empty or null it omits it in the results... please help!

I have a query that is to search 9 different criteria from one table. I have a form that is set up to transfer the info from the combo box and send it to the query. I can either search by finding the product that fits all the criteria or no...criteria....I need to have the query ignore the...

I have a query that is to search 9 different criteria from one table. I have a form that is set up to transfer the info from the combo box and send it to the query. I can either search by finding the product that fits all the criteria or no...criteria....I need to have the query ignore the...