Hi all,
I am posting this question for a co-worker. She knows very little about Access but has been asked to create some reports. One the requirements is that the report contain a Pie Chart showing a breakdown of Costs as a percentage of Total Income for each Job.
I thought this would be relatively simple. Create a query where each record was for an individual job with associated costs and Total Income. Create a report...
maxx429
Last Activity: Apr 15 '08, 07:55 PM
Joined: Feb 15 '08
Location:
-
Make Chart Control on Report change from Record to Record
-
Thanks to both Stewart and Linq for looking at this.
In answer to Linq's question, the txtAddNote control is an unbound Text Box where the user enters any new notes. These notes are then appended, using code on a Command Button, to the txtSiteNotes control which is a bound control tied to a Memo field in the table to which the Form is bound.
I'm not sure if this will help, but here is a bit of additional information:... -
Bumping this on the off chance it was missed the first time around. :)
If there is not an effective way to check if my Memo field has been updated, does anyone have a suggestion as to how I can ensure that the user adds a note whenever certain fields on the Form are changed? I can't be the only person to have needed this sort of functionality, right?
I've considered using and Add Notes button and trying to trap whenever...Leave a comment:
-
Sorry, I guess I wasn't clear.
...Code:Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.Q1_Comp_Check.Value <> Me.Q1_Comp_Check.OldValue Then If Me.txtSiteNotes.Value = Me.txtSiteNotes.OldValue Then MsgBox "You Must Enter Notes Before You Can Save This Record", vbOKOnly Me.txtAddNote.SetFocus DoCmd.CancelEventLeave a comment:
-
Checking If Memo Field Updated on Form
I am trying to check if notes have been added to a Memo field on a form if certain other fields have changed. Example: If the user ticks a particular check box on the form, I want to force them to add some note detailing the change before the will be allowed to save the record.
I have the checks on the other fields working. What I can't seem to find an effective method for is checking whether the user has added notes to the Memo field... -
I'm familiar with the concept of a Composite Primary Key. I was actually intending to set up my table that way. However, I was also looking for a way to track changes to records and came across some pre-made code by a gent named Allen Browne to create an Audit Trail. His code required that the table being tracked have an Auto Number field as the Primary Key, so I modified my table accordingly. I'm not yet savvy enough in VBA to modify his code to...Leave a comment:
-
Yeah, a Site may occur numerous times, but only once per Project, so a multi-box filter sounds like the way to go.
Out of curiosity, how would one go about determining if multiple records resulted from a filter, using VBA? I probably won't need to use it now, but I can envision other applications for that capability.
Thanks for the pointers. :)
Garrett...Leave a comment:
-
Sorry for the confusion. Sometimes I'm dumber than I give myself credit. :)
Rec_Num is the Primary Key for the table on which my Form is based. I can see now that the Combo Box code I am modifying for use with the Text Box is finding the first Rec_Num in the table that is associated with whatever Site # is chosen in the Combo Box.
That explains why the Text Box code isn't working, because it's being given a Site # and...Leave a comment:
-
Thank you for the tip. This fixes the runtime error, but the form does not navigate to the Site # that's keyed into the text box.
This probably seems trivial. I'm only doing this due to user preference. Most of mine prefer to key in Sites from memory rather than scroll through the list in a Combo Box.
Does the Text Box need to be on a particular part of the Form? It is currently on the Form Header....Leave a comment:
-
Display Record on Form based on value in Text box
Good day all,
Using Access 2007 but DB is created in Access 200o format so I can still use User Level security.
I have what am sure is a very newbie question. I want to add a control to a form which allows the user to type in a value, in this case a site #, and have the form navigate to the corresponding record.
I found some sample code that does this using a Combo Box. I tried modifying this code to... -
Bingo! Thank you sir. That coupled with Me.Undo cancels the changes and stops the After_Update event from firing.
You guys are awesome. :)
Thanks again,
Garrett...Leave a comment:
-
Form After_Update Event Firing after Undo
Hi all,
I am a VBA newb. I know probably just enough to be dangerous. :)
Anyway, I have a Form that I am using [HTML]<a href="http://allenbrowne.com/AppAuditCode.ht ml">Allen Brown's Audit Trail</a> [/HTML] code on in order to track user changes to records. The code works outstanding (thanks Allen!), but I have made some modifications to force the user to confirm any changes before updating the record....
No activity results to display
Leave a comment: