Recent content by Celestz

Ok, so i'm back and I'm having this problem. Is there a way to change a textbox value that's located on REPORT HEADER section? The event will be triggered in the DETAIL_FORMAT event. I tried debugging it and the value is changed, but it doesn't show on the visual report, is there a way around...

I am aware of that and I should avoid it imo ><, anyway I encountered something. This is a new problem, although I'm not sure if there's already a solution here for this. So, I have an unbounded textbox Field in my header and I designated it for the worded total of a computation. The...

Thanks for this tip Gemma, I think I have the working code for now, and I'm gonna post it here so other people can refer to it if they need it. This is custom fit for my project so edit this to your preference, also correct me if you think anything is wrong. Cheers :) Night Differential...

Thanks for the feedback guys! I'll try this 1st thing monday when work resumes. :)

And I'm back, so I got my report working, now I need to ask if there is a way to get a Time Range between 2 Time Fields. i.e. I have 2 fields in my table named Time-In and Time-Out. Say I have a record with the time-in at 10am and Time-Out at 2am(Midnight Time Out) Is there a way I can get...

Thanks for replying and thanks for the tip, will post back here for results since I use DB Calls on Format Events to Handle the data.

Ok, I have made a report that contains unbound controls(take note unbounded, since I generate the info from queries). I have a sample function like the following that moves the controls down as I add content. Private Function MoveTotals() Me!txtTotalDeductionTitle.Top =...

Sorry, I got used to Cyan since the game forum I always frequent had dark colors. I won't let it happen again while here though, I also received some eyestrain.

Hi! I tried the search function of this forum to look for a solution for my problem but I can't seem to find it so I posted it instead, maybe I missed a few threads, not sure coz i'm quite dizzy right now. I have a form with around 45 textboxes, but i'm currently stuck up with a simple...

Thanks for this informative post, I was really crawling in the dark until I read some posts here in the forums and realized what I was doing wrong. I'll post again in the respective sub-forum if I encounter another big wall for my program. Also thanks for telling me about that requery, I...

Nvm guys, I found the error, my bad coz I didn't know you can access a control value using Me!ControlName. Close this. Thanks.

Hello, I'm new in these forums but and i'm fairly new at MS Access programming since I utilize java most of the time. I'm currently using Access 2003 and was wondering why I encounter an error with my Code. The Code is Below Private Sub cmdSave_Click() ' Dim thisText As String '...