Recent content by inbal

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

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?

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

no i have only the calender 5

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/

Hi Guus2005, This was just a copy paste error from access to the forum, so if you have more ideas... Thanks, Inbal

Thank HTH, I added the code and it wrote me: Run time error 438 Object doesn't support this property or method So, if you know other ways... Thanks

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) "...

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

now i get it thanks!

2003 but i got it to work... i had to copy and past the tables and it worked

can it be a query that does grouping?

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

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?

thanks a lot!