Search results

Perfect! Works great. Thanks Len! R. Fisher

I have a table, which is a linked table to my CRM package (GoldMine). I need to extract info out of GoldMine which I have found Access to be very good at doing. One of the items I am reporting on is email body information. Problem is when I create an Access report with a text box defined to put...

Tying to update a field in a table to contain only the first n characters of another field in the same table. eg. [master].[field1] Text - contains up to 150 characters [master].[field2] Text - can only contain 24 characters Want to update field2 to the first 24 characters from field1...

Thanks all - the acCmdSaveRecord did the trick. dcx - in response to your question of why I am trying to do this ... First off, I am an access hacker! I know what I am trying to accomplish but ain't always sure it's the best approach. What I have is a form with a couple tab pages. Each tab...

have a datasheet form with about 10 fields. When I enter data into field 2 for example, is there a way for me to "force write" that data into the table after I make a change and tab to the next field? I have calculations in following fields that rely on the data from field 2. Currently, when...

Got it - Thanks!

On my form (frmClientTracking), I have setup 4 Tabs (pages). Each tab has a different subform. 2 of the Tabs (Pages) are set to visible=No. On the subform on Tab 2 for example, I have a yes/no field. When I check the field, I want to set "Visible=True" on Tabs (Pages 3 & 4). Form =...

Mark - Thanks for the direction here. As in the past, when I pose a question, I provide the working solution here for other folks seeking answers. As far as selecting the Rep off the switchboard, I simply used an empty text box on the report itself called AccountRep. When I click on the...

I'll give it a shot - Thanks! R. Fisher

Namliam - Apologize for the "non-reply" to this post, don't want to come across as ungrateful for the assist, the email notification for this went into my "junk mail" folder for some reason. One thing I am learning through this project is not to rely so heavily on the Access wizards. They are...

I have created a report that looks kind of like a spreadsheet where there are rows and columns of information. For some fields, I am using DCount and others I am using DSum to pull the correct information ouf of a table. An example of the DCount expression...

Not sure how to post an example but let me give this a shot & see if it works, working from the display form backwards, here is what I have: Form: SummaryStatistics (the screen where I am displaying the info). TextBox Name: MTDRecovered (the field on the screen) ControlSource...

Have a display form that presents global, YTD & MTD stats. One of the fields is TotalRefund. For the global total this isn't an issue because there is data (numbers to add up). For MTD, when there is no values (no refunds Month-to-date), I get a #error in the field. When I change the calendar...

Thank You Paul!, Knew it had to be something simple. I moved the code to the On Current for the Details form itself (rather than the On Got Focus for the FeeElection field) and it works like a charm! Thanks Again - R. Fisher

Folks - Thanks so far for all the assists out there ... Am learning quite a bit and have been using this forum as a reference to get through some issues. Here's one I cannot quite figure out. I have a form [Details] which has a Subform [PaymentInfo]. the fields on the [PaymentInfo] Subform are...

Folks - Thanks all for the assist with this. Trial and error with these options finally gave me the results I was looking for. The following is the "solution" I have working. Not sure if it is conventional or not, but at least it works and brings up the correct subform based on the FeeElection...

Msgbox = Poor Man's debugger???

Put the line in ... when I bring up the form (first record happens to be 0% Fee Election, I get a little msg box that has 0, the 40%s say 0.4 and the 50%'s say 0.5 R. Fisher

I will get this, swear to "you know who"... Ok, each of the 3 subforms are named: SF0, SF40 and SF50 respectively. I change the code to: Private Sub Form_Current() Select Case Me.FeeElection Case 0.5 Me.SF50.SourceObject = "SF50" Case 0.4 Me.SF40.SourceObject = "SF40" Case Else...

Ok, I know I have to build an event for this, never used vb side of access before. So I have the 3 subforms (SF0, SF40, SF50) on the main form called ClientTracking. Each of the subforms has "visible" set to "no". There is a field on the ClientTracking form from the ClientTracking table called...