Search results

  1. B

    multiple check combo box and get the result in textbox

    arnelgp i make what you tell me to do but nothing happen when i click on checkboxes i put 20 checkboxex and i rename chkBox1 --> 20 and label lblLabel1 --> 20 and i put the textbox nothing happened any help sir and what if i want to choose the items from a combo box???
  2. B

    multiple check combo box and get the result in textbox

    thank you so much sir I'll try it right now
  3. B

    multiple check combo box and get the result in textbox

    hello guys I want to create a multiple check combo box then I want all the checked items in a textbox for example If I check item1 - item2 - item5 in the textbox I want the result like this -------------------------- |item1 - item2 - item5| -------------------------- thanks in...
  4. B

    Open report with multiple criteria (two)

    thank you sir, i should not a mistake like this :)
  5. B

    Open report with multiple criteria (two)

    i'm trying to open a report after executing a sql to save data from a form and after saving i want to open the report with the saved data so i want to open it with multiple criteria where number = same number in form and date = same date in form this is my code DoCmd.OpenReport...
  6. B

    linking data

    Minty thank you for you response but i find a way i create a new field in movies table named (movie_series) in that field i choose from combobox for example saw for all saw series and the subform source it will be the movies table and the link Master and child will be the movies_series and...
  7. B

    linking data

    hello guys i have over 3000 movie and i'm making them a database everything is fine but i have an idea when i double click on any movie to see the info i created a subform where he will list all the movies linked to this movie for examle if i double click on lethal weapon 01 i will get the...
  8. B

    dlookup problem

    my mannnnn thank you so muchhhhhhhhhhhhhhh
  9. B

    dlookup problem

    thanks for your hard work please try in the telegram number 41288 and in the telegram date 2014/10/10 sorry but it's in arabic language
  10. B

    dlookup problem

    thank you JHB for your help If DLookup("Telegram_Number", "tbl_Violation_Of_Building", "Telegram_Number Like " * " & Forms!frm_Add_Violation_Building!Telegram_Number & " * " And Telegram_Date = #" & Format(Forms!frm_Add_Violation_Building!Telegram_Date, "yyyy/mm/dd") & "#") Then i did it...
  11. B

    dlookup problem

    Yes it's number so any help with how to write it
  12. B

    dlookup problem

    i add the "*" If DLookup("Telegram_Number", "tbl_Violation_Of_Building", "Telegram_Number Like ""*" & Forms!frm_Add_Violation_Building!Telegram_Number & "*"" And Telegram_Date = #" & Format(Forms!frm_Add_Violation_Building!Telegram_Date, "yyyy/mm/dd") & "#") Then but now i'm getting...
  13. B

    dlookup problem

    hello guys i want to check if the number and the date of telegram is existed the number should be LIKE not equal the date should be equal this is what i wrote If DLookup("Telegram_Number", "tbl_Violation_Of_Building", "Telegram_Number Like " + Forms!frm_Add_Violation_Building!Telegram_Number...
  14. B

    checking if data exist

    i tried it's the same result i work on my solution thanks anyway
  15. B

    checking if data exist

    i want to check if data entered in a form field is existed the form is bounded to a table i used this code If DLookup("Telegram_Number", "tbl_Violation_Of_Building", "Telegram_Number Like " & Forms!frm_Add_Violation_Building!Telegram_Number) Then MsgBox ("number existed") Me.Telegram_Number =...
  16. B

    adding dates where the client didnt pay

    Thank you I'll try the two option
  17. B

    adding dates where the client didnt pay

    hello i'm making a daily renting cars system the client should pay every day ( day by day) everything is ok but if the client pay at these days dd/mm/yyyy 01/01/2015 02/01/2015 03/01/2015 10/01/2015 11/01/2015 12/01/2015 at the date 15/01/2015 i want to check the payments how to let the...
  18. B

    Custom Format

    hello guys i have a table "tbl1" that contains a field named "Movie_Size" (Data Type = Short Text) in my form i have 2 text boxes first text box unbounded named "Movie_Size1" second textbox named "Movie_Size" bounded to "Movie_Size" in tbl1 in the first text box i will type the movie size...
  19. B

    getting information from one field to two field

    plog thank you so much it works essaytee thank you too they are not seperate but it's investigator and his assistant maybe i should names investigator - assistant thanks again guys before i join this access community i know nothing about access but now i know too many things so many thanks...
  20. B

    getting information from one field to two field

    hello guys i have a table that contains Investigator1,Investigator2 and other fields and another table that contains PID, Rank_Name_Family and other fields am making a query in that query i want to get the names of Investigator1 and Investigator2 Investigator1 and Investigator2 is the PID...
Back
Top Bottom