|
More site info...
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.
|
|
|
|
|
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:
|
Top authors during last week:
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...
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...
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...
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...
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...
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...
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...
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::
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 ...
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
...
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 ...
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 ...
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...
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]....
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...
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 ...
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 ...
|
|
Hot threads for last week on 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,
...
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?
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.
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 ...
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 ...
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
...
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 ...
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...
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...
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...
|
|