Search results for query: *

Wow! Thank you so much.....

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

??? I tried to copy the SQL that ACCESS created for my query but its giving me nothing but problems... here is the format I am using in my query... [Forms]![Product Development Search Form]![cboprofam] Or NZ([Forms]![Product Development Search Form]![cboprofam],"") = "&quot...

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

I recieved an error message " NO VALUE GIVE FOR ONE OR MORE OF THE REQUIRED PARAMETERS" Also when I debug ".OPEN" is highlighted

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

MPASTORE....your solution worked! thank you....now I am trying to add a left or right join to see all the PICTURES in the picture table regardless of the information in the DEV table.....SO I want to keep the SQL statement the same but I need to add the JOIN into it Source = "select...

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

Yes....I am using a right join Now the reason I was omiting fields because I had the # set to 8 per page but only have 5 boxes to display pics. so each page was omitting 3 records......3 * 60 pages is alot of missed errors....I am using DB pix as my picture manipulater for Access but I will soon...

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

I am still getting an error and it has something to do with ".open" ???

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

get ready for this beast....... SELECT Development.[Revision A cad], Development.[Revision A], Development.[Kinder Number], Development.Date, Development.FAMILY, Development.FIXTURE, Development.[Active/Obsolete], Development.[RND #] FROM Development WHERE (((Development.[Revision...

Also...I set up NULL query with only one field and it works for some reason the other stuff just doesnt mesh well....

Basicaly the NZ statement is there so if the combo box on the form is left blank the query ignores it and returns the other boxes input....

Well I have the query linked to a form that I search by 6 different criteria.... I am using this form for each criteria. [Forms]![Product Development Search Form]![cbopstat] Or NZ([Forms]![Product Development Search Form]![cbopstat],"") = "" but I am wanting to add...

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

Won't that return every value...I simply want the boxes that dont need to be used or not needed for that particular search to be NULL or Ignored....So only the items that meet the specified criteria are returned.....