Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Using Forms | Forum profile

Forum profile page for Using Forms on http://www.officefrustration.com. This report page is the aggregated overview from a single forum: Using Forms, located on the Message Board at http://www.officefrustration.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Using Forms" on the Message Board at http://www.officefrustration.com is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: Microsoft Office (Excel, Word) forum - OfficeFrustration - Using Forms (site profile, domain info officefrustration.com)
Title: Using Forms
Url: http://www.officefrustration.com/forumdisplay.p...
Users activity: 27 posts per thread
Forum activity: 220 active threads during last week
 

Posting activity on Using Forms:

  Week Month 3 Months
Threads: 220 639 1,740
Post: 578 1,700 4,713
 

Using Forms Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Douglas J. Steele[_3_]
19
user's latest post:
one label all forms
Published (2009-11-26 23:07:00)
You could set the form's Caption to that. That would mean that it would appear in the bar at the top of the form. However, you'd have to set it, so I don't know whether that'll save you anything. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "seeker" wrote in message ... I want to put a label on all my forms that says YOU ARE IN ARCHIVE. Can I do this without...
Jeanette Cunningham
19
user's latest post:
Group checkboxes on subform
Published (2009-11-26 23:19:00)
You can put code like this on the after update of the checkbox. Private Sub Check1_AfterUpdate If Me.Check1 = True Then Me.Parent.[NameOfControlA] = "T" Me.Parent.[NameOfControlB] = "W" DoCmd.Close acForm, Me.Name End If End Sub The above code assumes that the first checkbox is called Check1 Where the code has [NameOfControlA] , replace it with the name of the control on the main form. Do similar for...
BobC[_6_]
18
user's latest post:
How to start a split form when I...
Published (2009-11-26 17:03:00)
I'm using the 'page' menu of 2007. I want to automatically start a particular split form when I click on a particular menu page. I have tried to place a subform on the page, but I could not get the form to open as a 'split' form. I would prefer doing this with a Macro. Bob
Linq Adams via AccessMonster.com
13
user's latest post:
enable check box on read only form?
Published (2009-11-26 19:21:00)
Like Tore I don't really understand most of what you're saying. I doubt that being in Edit mode has anything to do with the error being thrown. It would help people here to help you if you 1) Posted the error message 2) Posted the code you're using for this task -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com...
Jeanette Cunningham external...
12
user's latest post:
Labels that /look/ bold but...
Published (2009-11-25 03:32:00)
With some fonts, a larger size font can look 'bold' when compared to a smaller size of the same font. Perhaps you have 2 different fonts and one looks 'bold' while the other one doesn't. Does this apply to your form? Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia "John Harrington" wrote in message ... Why is it that sometimes labels look "bold" (when they are not...
Dirk Goldgar
12
user's latest post:
Subform within a form
Published (2009-11-24 21:04:00)
"PJ" wrote in message ... I have a subform (frm Grid Pricing) within a main form (frm Tranche). I have a text box in the subform that I want based off of a text box in the main form. The text box name in the main form is cmbGrid Pricing Format with a control source of Grid Pricing Format. So if "CDS/CDX" is selected in the text box named cmbGrid Pricing Format I want the text box in the subform to say...
Daryl S[_2_]
12
user's latest post:
Combo-box in Sub-form
Published (2009-11-26 15:30:00)
Len - Did you add the artist field to the table behind the subform? And is the new combo-box bound to this new field? If so, please tell us what is not working... -- Daryl S "Chris" wrote: Could you please help me with a problem I have with Access 2003? I am not very experienced with Access; I have done a college course at Level 2 (CLAIT Plus), so I know the basics but this has got me stumped. My database is for my CD...
KARL DEWEY
11
user's latest post:
Ways to Start a particular form?
Published (2009-11-24 22:28:00)
Question 1 - Create a macro named Autoexec with action OpenForm and the form as argurment. It will run every time Access is opened except when the SHIFT key is held down. Querstion 2 - What kind of 'menu page' do you have? -- Build a little, test a little. "BobC" wrote: 1) I want to automatically open a particular form when the Access file (Access 2007) is opened. I would prefer doing this with a Macro. 2) I would...
SilvrT[_2_]
10
user's latest post:
Disappearing Forms - Page 2 -...
Published (2009-11-24 00:26:00)
On Nov 22, 5:37*pm, "AccessVandal via AccessMonster.com" u18947@uwe wrote: I failed to mention I was using A2000. This even could happen in A2007 or A2010. The problems might come from Internet security, anti-virus software that might interfere Access or the problems might be hardware like RAM, Harddisk corruption. I my case, none of the above (not yet). Access sometimes appears to freeze for more than 1 minute which I...
Jeff Boyce
10
user's latest post:
Duplicate values
Published (2009-11-24 00:01:00)
Mike What's the SQL statement for your [qryListFrom]? Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for...
 

Latest active threads on Using Forms::

Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 day, 11 hours ago (2009-11-26 23:07:00)  by Douglas J. Steele[_3_]
You could set the form's Caption to that. That would mean that it would appear in the bar at the top of the form. However, you'd have to set it, so I don't know whether that'll save you anything. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "seeker" wrote in message ... I want to put a label on all my forms that says YOU ARE IN ...
Thread:  Show this thread (3 posts)   Thread info: one label all forms Size: 743 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: one label all forms :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 day, 11 hours ago (2009-11-26 23:19:00)  by Jeanette Cunningham
You can put code like this on the after update of the checkbox. Private Sub Check1_AfterUpdate If Me.Check1 = True Then Me.Parent.[NameOfControlA] = "T" Me.Parent.[NameOfControlB] = "W" DoCmd.Close acForm, Me.Name End If End Sub The above code assumes that the first checkbox is called Check1 Where the code has [NameOfControlA] , replace it with the name of the ...
Thread:  Show this thread (2 posts)   Thread info: Group checkboxes on subform Size: 1,898 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Group checkboxes on subform :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 3 days, 5 hours ago (2009-11-25 05:43:00)  by Tom van Stiphout[_2_]
On Wed, 25 Nov 2009 23:09:36 GMT, "Uschi via AccessMonster.com" u25116@uwe wrote: If you don't write code, it may be easier to instruct the users to hit Ctrl+F on the SpaceNo field, and enter the value they want to search for. -Tom. Microsoft Access MVP I need to create an unbound text box with a command button (Search) on my form which will enable the user to find the ...
Thread:  Show this thread (5 posts)   Thread info: Need an unbound text box and command button (Search) Size: 876 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Need an unbound text box and command button (Search) :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 day, 11 hours ago (2009-11-26 23:11:00)  by Jeanette Cunningham
If the subform has allow additions set to no, then change it to yes. To go to a new record, DoCmd.GoToRecord , , acNewRec Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ".Len B" wrote in message ... I have a form whose job is to collect data in a subform in the top half and display the past entries (uneditable) in the bottom half. The RecordSource of ...
Thread:  Show this thread (2 posts)   Thread info: Clear the subform Size: 1,466 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Clear the subform :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 2 days, 7 hours ago (2009-11-26 03:08:00)  by jack
I am not moving off a textbox I am moving off the field in the subform. I am using access 2007. Tried recalc on the afterupdate on the field with no luck. -- Thank you, Jack "Linq Adams via AccessMonster.com" wrote: Requerying a form updates the data in the underlying table(s) being displayed. As a calculated field, this shouldn't be stored in the table, so I wouldn't expect...
Thread:  Show this thread (8 posts)   Thread info: Requery to update data Size: 1,092 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Requery to update data :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 day, 14 hours ago (2009-11-26 20:58:00)  by Reva
Correction to my earlier post. The combo box consists of 3 columns - description, rate, unit of measure. Although the bound column in Column 2, it is now bringing in the description instead of the rate. Again the [ExtendedCost] field is correct. "Reva" wrote: I have created a form which includes the fields [Unit], [Rate] and [ExtendedCost] which is the sum of [Unit]*[Rate]....
Thread:  Show this thread (2 posts)   Thread info: Combo Box Selection is Blank Size: 1,038 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Combo Box Selection is Blank :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 day, 22 hours ago (2009-11-26 12:49:00)  by Tore
It is hard to fully understand your problem from your description. May be you could trap the error by using the check box "before update" event in vba-code. This event runs before the checkbox is actually updated, and it allows you to to write vba code that checks if any "line items" exist. If not, the "before update" procedure could cancel the update and prevent the error. If the...
Thread:  Show this thread (3 posts)   Thread info: enable check box on read only form? Size: 878 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: enable check box on read only form? :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 day, 19 hours ago (2009-11-26 15:18:00)  by Douglas J. Steele[_3_]
"doesn't work" doesn't give us much to go by... What problem are you experiencing? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Chris" wrote in message ... Could you please help me with a problem I have with Access 2003? I am not very experienced with Access; I have done a college course at Level 2 (CLAIT Plus), so I know the ...
Thread:  Show this thread (4 posts)   Thread info: Combo-box in Sub-form Size: 1,832 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Combo-box in Sub-form :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 2 days, 17 hours ago (2009-11-25 17:39:00)  by Paul
Thanks for the info, Tom. One of the things I suspect is going on is that some users type something into a field or two, and let it remain there in the edit state which might be tying up the record and page. If I put a 60 second timer in the form that says something like If Me.Dirty then Save Record, would that actually save the record and possibly solve the problem? Thanks ...
Thread:  Show this thread (3 posts)   Thread info: intermittent error message when editing data in a form Size: 2,710 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: intermittent error message when editing data in a form :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
 

Hot threads for last week on Using Forms::

Using Forms
Started 1 week, 1 day ago (2009-11-19 21:22:00)  by Ken Snell
You need to use the form's BeforeUpdate event to write the value of that unbound control into the appropriate field in the form's recordset. -- Ken Snell http://www.accessmvp.com/KDSnell/ "Weebl" wrote in message ... I have a form that calculates a production rate in "parts per hour". This form needs to be able to differentiate between Line work, Cutter work, ...
Thread:  Show this thread (19 posts)   Thread info: Getting an UnBound control value into a Table field?????? Size: 1,842 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Getting an UnBound control value into a Table field?????? :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
Started 2 days, 4 hours ago (2009-11-26 06:52:00)  by BobC[_6_]
I am working with a application that I did not create (Access 2007) I cannot seem to be able to allow editing of some fields on a subform. I changed the properties to Enabled (yes) and Locked (No); but I am still unable to edit the desired fields?
Thread:  Show this thread (19 posts)   Thread info: Cannot enable editing of some fields Size: 350 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Cannot enable editing of some fields :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
RE: Disappearing Forms - 11 new posts
Started 1 week, 3 days ago (2009-11-17 20:20:00)  by SilvrT[_2_]
Guess I should mention I am using Access 2003 SP3 and working with an Access 2000 file format.
Thread:  Show this thread (24 posts)   Thread info: Disappearing Forms Size: 190 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Disappearing Forms :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
Started 3 days, 18 hours ago (2009-11-24 16:51:00)  by Douglas J. Steele[_3_]
If sAudTmpTable contains special characters (which includes spaces), try sSQL = "DELETE FROM [" & sAudTmpTable & "];" If it doesn't, what's the actual content of sSQL when the code fails? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "BenEl via AccessMonster.com" u56454@uwe wrote in message news:9fa530926c82e@uwe... "Syntex ...
Thread:  Show this thread (10 posts)   Thread info: Audit log for 1 field Size: 1,668 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Audit log for 1 field :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
Started 3 days, 15 hours ago (2009-11-24 19:08:00)  by KARL DEWEY
Calculation are done OUTSIDE of the table so changing the table won't do it. You need to apply the formating to the object that is displaying the calculation. -- Build a little, test a little. "Weeble" wrote: I have a calculation that is being rounded, much to my dismay. I tried setting the decimal places to 2 in the table and yet my results are still rounded to ...
Thread:  Show this thread (10 posts)   Thread info: How do I stop rounding of my calculation results. Size: 732 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How do I stop rounding of my calculation results. :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
Started 1 week, 1 day ago (2009-11-19 16:33:00)  by Keith Wilby
"sonofroy" wrote in message ... I have a form with 2 fields Amount1 Amount2 What I am trying to accomplish is when you fill in Amount1, Amount 2 will automatically be 80% of the value of amount1 My code for Amount2 is =[Amount1]*.8 every event I have tried has produced nothing for Amount2. Any ideas where I should put this to get Amount2 code to work? Thanks ...
Thread:  Show this thread (9 posts)   Thread info: Event Procedure not working Size: 814 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Event Procedure not working :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
Started 1 week, 1 day ago (2009-11-19 14:13:00)  by Mr. B[_4_]
Brandon, Look in the Help file and learn about using Sub Forms. Anytime you have a one-to-many relationship between your tables, you will want to use a Sub Form that is embeded in your main form that will display the "many" side of the relationship. Using a sub form is not restricted to having only one. You can have more than one sub form. There is a Master and Child link ...
Thread:  Show this thread (8 posts)   Thread info: Forms: not working right with tables. Size: 3,029 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Forms: not working right with tables. :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
Started 3 days, 19 hours ago (2009-11-24 15:17:00)  by Daryl S[_2_]
Tia - It is easier for us if you post the query using the SQL View of the query. To get a list of vacant jobs, you would use the same two sources in your query, but use an outer join (double-click on the line joinging the two sources to see the joins). You will want to show ALL records from the query/table that shows the job title and the number to fill. Then in your query...
Thread:  Show this thread (8 posts)   Thread info: Total Positions vacant+filled Size: 2,127 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Total Positions vacant+filled :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
Started 2 days, 7 hours ago (2009-11-26 03:08:00)  by jack
I am not moving off a textbox I am moving off the field in the subform. I am using access 2007. Tried recalc on the afterupdate on the field with no luck. -- Thank you, Jack "Linq Adams via AccessMonster.com" wrote: Requerying a form updates the data in the underlying table(s) being displayed. As a calculated field, this shouldn't be stored in the table, so I wouldn't expect...
Thread:  Show this thread (8 posts)   Thread info: Requery to update data Size: 1,092 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Requery to update data :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Using Forms
Started 2 days, 21 hours ago (2009-11-25 13:50:00)  by Douglas J. Steele[_3_]
Try: =IIf(Format([StartDate], "yyyymm") = Format([EndDate], "yyyymm"), "[" & Format([StartDate], "mmm-yyyy") & "]", "[" & Format([StartDate], "mmm-yyyy") & " to " & Format([EndDate], "mmm-yyyy") & "]") -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "usm01" u56492@uwe wrote in message news:9fb0e4adc2d56@uwe... i have 3 textbox in a...
Thread:  Show this thread (8 posts)   Thread info: Display billing month based on start date and end date Size: 2,336 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Display billing month based on start date and end date :: Using Forms :: Microsoft Office (Excel, Word) forum - OfficeFrust..."