Search results

  1. I

    subforms and filters

    i have a sub form that opens a list of activities. on this subform i created a button that gives me only sertain activities by a filter. the problem is the button opens me the subform a second time instead of refreshing the one that is opened this is my code: Dim strwhere As String...
  2. I

    assending / dessending

    i have a label with the following code: Private Sub date_Label_Click() Me.OrderBy = "date ASC" Me.OrderByOn = True End Sub how can i change it so on the first click it will arrange by desending dates and on the second click arrange by assending dates?
  3. I

    programing a button

    i have a sub form showing me all my activities. * i want to create a button that by pressing it i will only get the future activities. (now i get future and past activities) * i want a button that by clicking it I will get all the activities with a sertain word in field X. thanks
  4. I

    popup calander

    how can i make a popup calender in access2003? i want to have a small icon next to my textbox there is calender 11 activX but its in 2007/
  5. I

    Insert automaticaly records

    Hi good people, I am trying to add automaticaly records to my data base, but I got error code 3134, I think it because the date and time fields my code is: Strsql = "INSERT INTO activityclosed ( teachers,project, cost,activity,subject,room,lab,notes,phisics,storage,date,from time, class) "...
  6. I

    Wrap text in spreadsheet activex

    Hi all, I have added a spreadsheet to my application, but sime times the text is too big, so I tried to put the attribute wraptext=true, but I couldn't found t. Can you please help me. my code is: Dim dbVideoCollection As DAO.Database Dim rstVideos As DAO.Recordset Dim dbVideoCollection1...
  7. I

    meny to meny relationships

    how can i make a meny to meny relationship? i dont understand the access help...
  8. I

    relationships

    when i open the relationships window, i dont see eny relasionships. if i press the relationship preview i see a lot of relationships. how can i delete them (or see them in the relationship window)? and if i make a new relationship and save. when i open the window again, i dont see it. WHY?
  9. I

    parameters

    can i make the parameter in a query be a combo?
  10. I

    query info to combo

    i have a query that groups the items in one of my feilds how can i make the query info load to my combo?
  11. I

    horisontal form

    how can i make my form horisontal?
  12. I

    playing with colors

    I have a long list af activitys from different projects. my DB gives me a form with all activitys by date (i get the form by preesing the date in the calendar). however, i want each row to be in a different color according to its project (i have 7 different projects) is it possible?
  13. I

    sub form

    i want to make a sub form for phone call summery. i want a new line to open each time i fill the line before how can i do it?
  14. I

    edit button

    i have a tabular form i witch i defined data entry=no i want a buuton at the end of each line, that by pressing it, ill be able to edit the line. how do i program the button?
  15. I

    textbox problem

    i have a form that shows me a list of clients. i wrote a search code that works when i press a button. is it possible to make the code work automaticly the second i write something in the text box (without needing the button?)
  16. I

    combo box

    is it possible to make a combo box with an option for multi choosing?
  17. I

    one form two tables

    i have a form for adding new workers. i need the information to be added into two different tables (the same fields added into two tables) how can i do it?
  18. I

    automaticly closing forms

    in my project there are a lot of forms/ when I open a form I want the rest of the open forms to close (to prevent too meny forms to be open at once) how can i do it?
  19. I

    combining 2 fields into one

    I have two tables. the first has sir name and family name as 2 different fields. the second has full name as 1 field. I want the second table to show the names from the first table but in one field. is it possible?
Back
Top Bottom