Recent content by snoopy22

Hi everyone. I'm kind of a novice in VBA so have mercy :D My problem is this: I've got one report that needs to be open multiple times, each time for different person. In other words i think i need to create multiple instances of this report. this is my current code: (Imagine i've got a...

Hi everyone. I'm kind of a novice in VBA so have mercy :D My problem is this: I've got one report that needs to be open multiple times, each time for different person. In other words i think i need to create multiple instances of this report. this is my current code (Imagine i've got a loop...

Thanks, I found it.. me.txtSearch.text instead of me.txtSearch, silly me...

Help! doesn't anyone know?

Thanks! you're right! thanks a lot!

Hi everyone, I've got a project that works fine at home but when I try to open It at my office it's not wotking properly. I've managed to locate the problem but I dont know why It happens. the problem is this: I've got: 1. txtDate(textbox) 2. lstNames(list of all the customers) 3...

Hi, it's me again :D I've got: 1. txtsSarch(textbox) 2. cmdSearch(button) 3.subTrans(a subform within the form) every time i push the button my subform present the search result according to the search filter(txtSearch) and it works fine. here is the code: Private Sub cmdSearch_Click()...

Yes... It looks nice, but I still want to bold the external lines... any idea? thanks for your help

Thanks rich! your code really helps, but I need the whole report to look like a table, not just the details section. can you tell me how to change the code to influence on the whole report? thanks in advance,ofir

I would like to sepreate the "cells" and "rows" in my report with bold lines so it will look like a table. How can i do it?

Hi Roy Thanks for the advice. "Just curious - why use a message box in a report - I've never done that (except in the on no data event)" I call the report from a form, so the box appears on the form and you were right, It was simplier than i thought, I just needed to move the msgbox from the...

On my details section (in my report ) I've got a procedure On Format event I debuged it and I've noticed It been called twice so the msgbox is show twice too Why does it happend and how do i get rid of it? here is the code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)...

the problem was,that I wrote: Forms!subTrans.recordsource instead of: Me.subTrans.Form.RecordSource the query works fine.

thanks guys I've already got It working! but thanks for your comments, you were right!

Hello everyone, I've got a main form with a search field and a subform. what I would like to do, is when I hit the "search" button, the data on the subform will be changed according to the search filter, I've got no problems with the sql expression. my problem is: How can I change the...