Recent content by Celestz

  1. C

    Changing an Unbound Textbox Value in Report Header are on Detail Format Event

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

    How to Dynamically Expand Detail Section of a Report?

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

    How to Dynamically Expand Detail Section of a Report?

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

    How to Dynamically Expand Detail Section of a Report?

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

    How to Dynamically Expand Detail Section of a Report?

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

    How to Dynamically Expand Detail Section of a Report?

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

    How to Dynamically Expand Detail Section of a Report?

    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 =...
  8. C

    Error 2158 on a Recordset

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

    Textbox Validation - On Exit?

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

    Error 2158 on a Recordset

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

    Error 2158 on a Recordset

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

    Error 2158 on a Recordset

    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 '...
Back
Top Bottom