Search results for query: *

a= active and p = pending. so i only want active if 'a' comes up , but if 'a' doesnt come up then i would like to use 'p'. curently im getting 2 records if a person has a person has an 'a' and 'p' Thanks

let me know , if i explained what i needed clearly thanks

i am using sql server select cs_id,net_ben_amt,max(upd_dtm) a from cis.dbo.ag_elig_rslt ager where pay_mnth = '200610' and cur_elig_ind in ('a','p') and ager.delt_rcrd_sw = 'N' and ager.elig_sts_cd = 'PS' and ager.pgm_typ_cd = 'CW' and cs_id = 'BA43183' group by cs_id,net_ben_amt this is...

on my mouse, when i use the roller ( i dont know what its balled its in between the right click and left click, lol). if i go down it goes to the next record and when i go up it goes to the previous record, is there away to stop that. i only want the to go up and down records on the form by...

thanks for all your help it worked im a crystal reports and sql guy, but there need a form in access for entering data. im not that strong in access i really appricitate it, and thank you for being very patient with me, s

i did set the control source of the check box to reason_not_aided how do i bind my checkbox to the bootlean field in properties the name is chkReason_not_Aided and control source is Reason_not_Aided\ still didnt seem to work is my code in code builder right? Private Sub...

is this a problem or do i need to change the field types in sql server?

im using a sql server table, so my access form is linked to this table and it updates it when new records are entered in the form. all my check boxes are data_type bit in the sql server table

its hidden nothing is entered in it should i get rid of it ?

no, just a check box and text box

ok, i have check box called ,chkReason_not_Aided and i have a hidden text box called Reason_not_Aided the text box is hidden on the bottom of the form should it be a text box in the chkReason_not_Aided control source i put Reason_not_Aided. it didnt seem to work. remember in my code builder i...

i have a chkReason_not_Aided and i have a Reason_not_Aided should i only have one ? basically all i want is a check box, so in my table , if its checked it gives me 1 and if it isnt it gives me 0 so when i do my reporting, i can do calculations on this field maybe my example is off the wall...

im sorry if i am asking these questions but how do i make the check box bound what i did, i click the check box and placed it on my form then i went to code builder and wrote this Private Sub chkReason_not_Aided_AfterUpdate() If chkReason_not_Aided = True Then...

yes, if a person goes back to a previous record i would like to see the checks, but if they go to new record, i would like it blank with no checks, so they can enter new data

in my form i have many check boxes and when i check the boxes and click on next record, the checks dont got away how would i do this, im not very strong at access Private Sub chkReason_not_Aided_AfterUpdate() If chkReason_not_Aided = True Then Me.Reason_not_Aided =...

i have downloaded release 2 on my pc. does enterpise need to be xi release 2 , for the bursting option to work or can i just have my pc on release 2 and have enterprise on xi release 1?

damn u guys are great, all this help , so quick thanks all IT WORKED :)

thanks for all your guys/girls help this seemed to work after i got the tip on the coding from u all. select * from cis.dbo.INDV_DIS where indv_dis_typ_cd = 'te' and DateDiff(Day, GetDate(), dis_end_dt) >= 0 and DateDiff(Day, GetDate(), dis_end_dt) <= 30 order by 3 i want to get people...

im still getting dates over 30 days with select * from cis.dbo.INDV_DIS w here indv_dis_typ_cd = 'te' and DateDiff(Day, dis_end_dt, GetDate()) <= 30 order by 3

how do i narrow it down to 30 days or less?