Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. BigFizil

    Query issues....

    Wow! Thank you so much.....
  2. BigFizil

    Query issues....

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

    trying to clear combo boxes on search form

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

    trying to clear fields on form after use..

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

    Trying to pass criteria from form to creat sql...help!!!

    ??? 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...
  6. BigFizil

    Trying to pass criteria from form to creat sql...help!!!

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

    SQL problems....Please Help!!!

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

    Source = "select Development.[Kinde

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

    SQL problems....Please Help!!!

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

    SQL problems....Please Help!!!

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

    SQL problems?? Please Help!!!

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

    SQL problems?? Please Help!!!

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

    SQL problems in VBA!!!! please help!

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

    SQL problems in VBA!!!! please help!

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

    Help! Need to set up Access query that omits blank fields

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

    Help! Need to set up Access query that omits blank fields

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

    Help! Need to set up Access query that omits blank fields

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

    Help! Need to set up Access query that omits blank fields

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

    Help! Need to set up Access query that omits blank fields

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

    HELP!!! Multi-Combobox search w/ query linked to form.

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

Part and Inventory Search

Back
Top