Recent content by tarek_ta2ta2

  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
Back
Top Bottom