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

    How can we use a range in a table?

    I basically just need to make the database to work like this site has it http://store.dragracing.com If you notice that the categories below the "select your car" section are dependent of what car type is selected. I am using ColdFusion and Im just trying to get that access database...
  2. spidalegz

    How can we use a range in a table?

    um wow!!! my e-mail is spidalegz_2002@yahoo.com If you did what i think you did, then I owe you a lot. I can't wait to see what this is going to be like now.
  3. spidalegz

    Why doesn't the third drop box work? Plese check

    Also, check and tell me if this looks right SELECT CLyears.id, CLyears.years, CLyears.frn_model_id FROM CLyears WHERE (((CLyears.frn_model_id)=Forms!Banner!combo2)) ORDER BY clyears.years; will that get my "years," which are actual years, to show up according to the code above? From...
  4. spidalegz

    Why doesn't the third drop box work? Plese check

    Private Sub Combo0_AfterUpdate() Combo2.Requery End Sub Private Sub Combo2_BeforeUpdate(Cancel As Integer) End Sub Private Sub Combo2_GotFocus() If Len(Trim(Nz(Combo0, "") & "")) = 0 Then MsgBox "Please Specify Make first" Combo0.SetFocus...
  5. spidalegz

    How can we use a range in a table?

    Here is the link to my access file. http://www.kinkyimports.com/db1.mdb
  6. spidalegz

    How can we use a range in a table?

    WHEW. I finally got it. Okay back to the range. Pretty much, I want to see if i can put a range of years (ex. 90-98) in a table. But if i try, it will not let me since a "-" is not a number. So would i have to put years individually in the table i make? Or is there a way around this...
  7. spidalegz

    How can we use a range in a table?

    OMG i am soooooooo close. Could you possibly look at my database and check out what i did wrong in my code? I would really appreciate it.
  8. spidalegz

    How can we use a range in a table?

    lets just say. I am just getting back into Access. And pretend you would be teaching this to a 12 year old. I know its funny, but I need the help to get this done right. What i mean by it though, is that i want to be able to have for example: table1(make), table2(model), and table3(year) be used...
  9. spidalegz

    How can we use a range in a table?

    Actually, I still do not know how to use that command. In Access, where would I go to edit it like 90-98? How and where would I be able to use that?
  10. spidalegz

    How can we use a range in a table?

    OMG that is probably it!!! Thanks!!!
  11. spidalegz

    How can we use a range in a table?

    My large e-commerce store needs to select products by a vehicle specific date, make, and model. How can we have a range of car years for certain products corresponding to the car itself? How can we use the make and model also? Are there certain commands that will enable us to do this?

Part and Inventory Search

Back
Top