Search results

but I want to save it! here is the sample, the language of the project is not english so I hope you'll get it right.

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?

thanks i'll do that

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

never mind i've got it working now... but thanks for the tip about viewing the checkbox as a text field! :)

so how can i check the value of the check box? suppose i have an unbound checkbox name "c_problem1" and i want to check if it's value is the same as the field in the table name "problem1" I know it's vba, but do you know how to do it?

exactly i want it to show as yes/no on the table field

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?

thank you for helping i've managed to solve it, appearntly there's a problem to apply filter on a subform, so i changed the sub form's recordsource in the on_open event instead of docmd.applyfilter ,sfilter i wrote me.recordsource= "select * from table where" & sfilter

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

I found the problem you were right, thr applyfilter does'nt recognize the sfilter, how can i change his type to be a global? or how can i get to it from another form? suppose the "sfilter" is on "advancedSearch" on a procedure event results_click(a button that apply the search)

i've already tryed it same problem...

i put it in the main form("PersonalInfo") event

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

I see, thanks i got it working now... thank you all for posting p.s. ata gever sof haderech :cool:

thanks man I've got it, except for the part you're writing : & """" & "*" & c_firstname & "*" & """" why do i have to write 4 brackets at the begining and end of that code, i've looked at the debug for sfilter and it gives me for example: [FirstName] like "*mark*" and [cityID] = 1 so where...

thank you sharon! it's exactly what i need! but i'm afraid i didn't get the meaning of the following rows: sfilter = "[nameID]>0 " If Not IsNull(c_firstname) Then sfilter = sfilter & " and [FirstName] like " & """" & "*" & c_firstname & "*" & """" If Not IsNull(c_lastname) Then sfilter =...

thank you for helping but i'm having difficulty to understand the code, could you please write a short comment that explain each row?