Search results

  1. T

    please it's very important to my work

    hi every one i will try to be specific this time, may be someone will help me here what i want is to create data base to store the location of my shop vehicles i have place to store vehicles and i design the place into zones and bays for example zone A contains 30 bays and zone B contain 32...
  2. T

    (Office2007) make dropdown menu elemtn not available if i selct it

    please i just need clarification if it's possible or not i really need help in this
  3. T

    (Office2007) make dropdown menu elemtn not available if i selct it

    sorry if i didn't get it , but i don't use any query i just have one table and one form it's more than simple database i add teh data in teh row source for the drop down menu hope i make it alittle clear
  4. T

    (Office2007) make dropdown menu elemtn not available if i selct it

    i have a simple database that to store things in specific locations i put the elements name and select the places from dropdown menu and save it .. the problem is : i store element A in Place A when i go to store element B i don't wanna place B to be Available
  5. T

    help in caluclation option buttons values - word 2007

    I have a section on a form that has 4 questions, numbered 1-4, with 4 option buttons per question. Each of the option buttons have the same response (bad, normal, good, excellent), and each answer is given a point value for each question. bad give 1, normal give 2, good give 3, excellent...
  6. T

    calculate option box values in a form

    i use word 2oo7 so what i did i use option button from the developer tab so evaluation one is just a text i wrote the actual option button is the option button 1:bad option button 2 : normal option button 3 : good option button 4 :excellent so you have evaluation 1: bad...
  7. T

    calculate option box values in a form

    dears, hope anyone can help me here i have a form with option box it looks like that evaluation 1 : bad normal good excellent evaluation 2 : bad normal good excellent evaluation 3 : bad normal good excellent evaluation 4 : bad normal good excellent...
  8. T

    How to make this query

    Thanks sam u r great man take this :) as u know i have many combo boxs so when i select value from one box and press the price button without complete the selection from the other combo the error in the attached picture appear why ? i expect the message that said no data available...
  9. T

    How to make this query

    when i change the fileds in the tblVehicles from text to number this error appear - i change the strSQL to long Private Sub Price_Click() Dim strSQL As Long Dim intCount As String Dim lngPrice As Long Dim myRS As Recordset strSQL = "SELECT a.VehicleID, a.MakeID, a.ModelID, a.GradeId...
  10. T

    How to make this query

    thanks man ... you are right i had set the NEW years field as Number so i think i have to make all of the rest of the field numbers so i can u se it in calculation later or what u think
  11. T

    How to make this query

    dear sim it was great really what u did , but now i face this when i try to make adjustment in the code like ad more columns to the tblvehicle like the yesrs it create error here is the code i highlight what i add to ur original code Private Sub Price_Click() Dim strSQL As String Dim...
  12. T

    How to make this query

    thanks A lot , it's very nice it's work great
  13. T

    How to make this query

    thanks for ur great support and i'll give it a try and tell u but there's one thing which id 's u talk about i review all my id's and it's all numerical so can u please tell me what u mean
  14. T

    How to make this query

    hi all i make a database for cars so i will give u a brief a bout what i did i create number of combo box so the user can select values form it Ex: Car make - model - transmission - year and so on i learn how to make every combo box available after the selection of the previous combo i...
  15. T

    Still in the Combo Box Issue

    See what i sent thanks for ur support but i think u didn't see the last version i sent i made lot of modification ... kindly review it and see the different
  16. T

    Still in the Combo Box Issue

    sorry my friend ..not working too i put in the first combo the following Private Sub cboMake_AfterUpdate() 'First Combo Me.cboModel = Null 'Second Combo Me.cboGrade = Null 'Third Combo Me.cboGrade.RowSource = ""...
  17. T

    Still in the Combo Box Issue

    Not what i mean thanks man but i already do this and it clear the combo box but if you click the combo box you will find the data there still exist fro the previous selection look ... before u select combo box 1 if you click on combo box 2 you will not find any thing so because i have...
  18. T

    Still in the Combo Box Issue

    hi great people thanks for the help i almos reach my goals i have a proplem i hope it's a little on i have three cascading combo box which working great when selecting value from the first comb the second combo load the values and the same for the second when select value the third...
  19. T

    Many to Many Relationship

    It's Really Nice Morning Hi Krester i really don't know what to say i just open my pc and check the form .... download the file and it's really nice morning .... thanks alot but don't think it's the end i will study what u do and if i didn't get any think i will come back it's great...
  20. T

    Many to Many Relationship

    try to test it with the toyota make because it's the one i finish
Back
Top Bottom