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

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

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?

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

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

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

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

Hello guys, I've got a form bounded to a table("transaction"), when the user enter number in txtPreyerBillNo, the Preyer's name appear automatically in the lstName I've done it by putting a quary into the row source of the lstname: SELECT Preyers.Name, Preyers.PreyerBillNo FROM Preyers...

Hello guys, I want to display data from a table where all records from the given date -that the user will type on txtGivenDate(textbox) - until now be shown. so i used this one: "select * from transcation where date >" & txtGivenDate it's not working... any ideas?

hello, i've got a project and i want to limit the user to a specific forms, i dont want him to start changing the design and modules of it, how can i do that?

i've got a form with several text/combo fields that bound to a table also i've got 3 buttons on it: save,erase,add new i've noticed that when i'm changing a field in the form it saves it into the database even if i didn't push the "save" button! why does it happen? can anyone tell me how to...

hello, i'm newbi to access i have a check box bound to a yes/no field, my problem is that when i mark/unmark the check box the value of the field is not yes/no, it is show me a drawing of the state of the check box in the field. how can i make it to get the value yes/no?

Hello everyone, i was managed to narrow down my problem, but still, no solution... so with your premission i'll repeat it: I've got a control tab with the folowing tabs: 1. subform name "personalInfo" 2. subform name "CompanylInfo" i want the control tab to show the relevant records...

Hello everyone, I've got a control tab with the folowing tabs: 1. subform name "personalInfo" 2. subform name "CompanylInfo" i want the control tab to show the relevant records according to the filter also, i got a form name "advanced search" where the user type the desire filter. then he...

hello guys, i need to build a program which the user has an option to search with several criteria, for example. suppose the user type in the folowing control boxes: name: matt city: california then he will be able to see the results(all the man with the name "matt" which lives in california)...

i've got a combo box with a list of values in it, how can i choose(without user intervine) a specific value from the cobmo box to be shown like it has been chosen by the user (again sorry for the spelling)

hello everyone i've got a control tab with a "left to right" view and i want to change it to "right to left view", i've already changed the defualt direction from tools->options->international to "right to left", and it doesn't seem to work... any ideas? (sorry for the spelling)