Search results

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

Thanks It works, and now for another question (: How can I define the "page footer" of my report to be one line below the last row of my report. I put the label on the "page footer" and The defualt of the "page footer" is to display it on the bottom. I've already asked it in another forum, and...

Hello everyone I've got a report, on it open event I used the following code: Private Sub Report_Open(Cancel As Integer) Me.RecordSource = "select * from transaction where Name _ = " & """" & Forms!printre.MyFilter _ & """" & " and [Date] > #" & Forms!printre.MyDate & "#" End...

thanks man I've got it working

Hi, I've posted this problem before but now i've simplified it... my project include 2 tables: 1.Emplyees it fields are: 1.1 EmpID 1.2 EmpName 2.Transaction it fields are: 2.1 TransactionID 2.2 EmpID 2.3 EmpName 2.4 Debit 2.5 Credit 2.6 Balance I've created a form based on Transaction from...

shit, the file is too big even in winzip...