Recent content by Hassan

Hello guys! I have continious view form based on table. For each record here is a field "not available" represented by check box. What I would like to make is that when I click on this check box, whole line of the current record (all fields of current record) changes it's back color until this...

Hi folks! I have stopped at this quite problem - I have a form where I should place 60 buttons so user can access them easy and quick. Each button must have a caption up to 50 symbols. These buttons must work a a filter. If I make it so, then almost half of the form is filled with butons and...

Thank you Scottfarcus. I guess that it must work. But I don't know why it still doesn't work. I am pretty sure I am doing something wrong, because I am a beginner in access. Maybe you can send me a sample database with this thing working?

Hy! I have a form based on query with lots of fields where one of them is a chech box field. Also I have a single check box (without control source) in form's header. What I want is that when I select this single check box, all check boxes for all the records in the form turns to value = 1...

Hi there! I have such problem: I have form "frmFilteredData" based on query "qryDataFilter" where one field (date) has criteria: Is Not Null And Between [Forms]![frmPerfPlanDialog]![beginning date] And [Forms]![frmPerfPlanDialog]![ending date] And I have another form "frmPerfPlanDialog" with...

Well thank you guy's. I made two queries and now it works fine. Thank you again!

Thanks God! I found it! I forgot to place Me.Refresh as the first action run after clicking that button. Otherwise that record I was trying to append to new table and then delete from origin table wasn't saved. Anyway now it works fine! Anyway, thank you guys!

Well I did thoes changes but problem is still there. Nothing has changed... :-( Maybe you can look at this database and see if there is something wrong?

Jwindon, you mean something like this? Private Sub Command22_Click() Dim Msg, Style, Title, Response Msg = "This is my message" Style = vbYesNo + vbCritical + vbDefaultButton2 Title = "This is my title" Response = MsgBox(Msg, Style, Title) If Response = vbYes Then docmd.OpenQuery "Query1"...

I placed a button on my form with this code in OnClick event. When I click it, message box appears. But when I click "Yes" button in this msg box, it works every other time. Why? What I am doing wrong? Private Sub Command22_Click() Dim Msg, Style, Title, Response Msg = "This is my message"...

I have two tables - one for played performances, other for possible performances. Also I made a form based on table "PossiblePerformances" where I added a yes/no control which works as a criteria - if false (which is default) then performance is not yet played, if true it is played and must be...

Actually I have quite similar problem. I have 5 column report also representing five days of the week. In each day there may be 4 events. If each day has thoes four events then everything is ok, but as soon as there are less than four events, events from the next day are attached to the end of...

Hello! Is it possible to rotate fields in reports design? By default they are horisontal, but I need them to be vertical, because I have to print addresses right onto envelopes.

Thank your for your help, I made these changes you gave me, but it still doesn't work. On pressed or clicked button my timer stops.

Hi! I have problem with my timer event. When I click mouse button ok some key on keyboard my event stops, wen I release button or key it continues to run. Why it is so? What I have to change there? Here is my code: Option Compare Database Option Explicit Dim kaza, aaa As Long Dim sony As...