Search results

JR, I have: but where do I place it? If it put it in the control source of the next text box it doesn't get updated. Thanks.

This is the query code I have but I want it done in VBA. And also "abbe" needs to be the value in combo136. Thanks

Hi all, I have a drop-down box (combo136) and I would like to so show a record when the user clicks a name in the list. It sounds so simple but im struggling. I would like to place the code in the sub in vba: Private Sub Combo136_AfterUpdate() the table I would like to get the data from...

how do you get the page tab into an integer? Thanks my tab control is tblctl14 and first tab is personaldetails and second tab is Absent.

any idea anybody?

not quite sure I understand. You have to go into tab index 1 to open the form. then when you close the form the main page takes it back to tab index 0. I want to go back to the same tab that form was opened from i.e. tab index 1. cheers

hi all, I know this has been answered quite a few times and I have looked on the boards but still with no luck. the bad thing is I know this is an easy question and im kicking myself as to why it isn't working. I have tblctl14 on a form and in the page Absent there is a button which calls...

excellent, thanks. your a star

I have the following line: If IsNull(DCount("*", "qry_checkallusersforticks")) And username1 = "Janine" Then Can you tell me if this is likely to work? The program does process the line but always goes staight to the Else commands. The query it refers to is: SELECT absent.id...

can somebody help or can i use dsum in the way as i did that query above? cheers

I got round the DCount line by running this is a query and then calling it with the Dcount function SELECT * FROM absent WHERE (DateAdd("m",-12,Date())) < (((absent.Start_Date))); But I cant do that with the DSum function so any ideas are welcome as im getting stuck cheers

I have even tried this: LTotal6 = DSum("[Days]", "absent", "[Name] = " & Chr(34) & Combo136.Value & Chr(34) & " And [absentcode]='countme'" And "Start_Date >#" & DateAdd("m", -12, Date) & "#") cheers

hi gemma, thanks for your answer, I now have the following: LTotal6 = DSum("[Days]", "absent", "[Name] = " & Chr(34) & Combo136.Value & Chr(34) & " And [absentcode]='countme'" And [Start_Date] > "# & ((DateAdd("m", -12, Date))) & #" it is erroring on the m just after the DataAdd. I...

Hi all, I have the following code: LTotal3 = DCount("[Name]", "absent", "[Name] = " & Chr(34) & Combo136.Value & Chr(34) & " And [absentcode]='countme'" And [Start_Date] > ((DateAdd("m", -12, Date)))) LTotal4 = DSum("[Days]", "absent", "[Name] = " & Chr(34) & Combo136.Value & Chr(34) & " And...

cheers DCrake, I'll add that in as well. every little helps... (as a well known supermarket says).

hi, cheers for the code then, it is excellent. and whats better is the fact that I can nearly understand it. I did do the clear breakpoints and debug but to no avail. I have since changed that line to < 2 and it seems to work. No idea why tho - would you have any idea? Cheers Martin

I just tried doing clear all break points and no luck. but the < 2 seems to work. just our of interest do you know why doing it the other way didn't work? Many many many thanks

hi, I have pasted the module that it goes to into the attached txt doc. Thanks Hope you can help

Hi all, I have a username/password form and when the user clicks ok the program goes through some checks and then is meant to load another form. But when the user clicks on the program brings up the vba code window and highlights a line in yellow. When I press F5 the program continues and...

excellent, thanks. works a treat.