|
More site info...
Discussions in microsoft.public.access.forms - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Discussions in microsoft.public.access.forms:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
99
|
410
|
1,135
|
|
Post:
|
240
|
944
|
2,795
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.access.forms (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Discussions in microsoft.public.access.forms posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.forms Alexa graph:
|
Top authors on Discussions in microsoft.public.access.forms during last week:
user's latest post:
Deleting and existing Page Tab...
Published (2009-11-28 15:35:00)
It appears to work on the FIRST import try! I tried importing the previous file, less the ChangesTable and ChangesForm. I got several errors during the import process: 1) Name Confict with existing module for a ship_form that I do not think is directly related to the Changes Tab ??? 2) No current record (ship_form) again ??? 3) The search key was not found for any record ship_form_category_subform ??? I of course got an error for...
user's latest post:
I want to inhibit editing of one...
Published (2009-11-28 04:35:00)
AllowEdits is a boolean field (i.e.: it accepts True or False). [Status] = "Ship Requested" and [Status] <> "Ship Requested" are boolean expressions (i.e.: they return True or False) I usually add parentheses to make it a little clearer: Me.AllowEdits = ([Status] <> "Ship Requested") Note that this is exactly the same as If [Status] <>...
J_Goddard via AccessMonster.com
11
user's latest post:
Cannot enable editing of some...
Published (2009-11-26 11:40:00)
Hi - >If I create a new query for the purposes of allowing me to edit some fields: > Does it matter how many tables are in the query window? No, not really - but it does matter how they are related (see below) > Does it matter if I remove the relationships in my new query window Generally, yes it does - otherwise you end up with a large number of rows (# Rows in Table A x # Rows in Table B x ....). Leave them...
Scott_Brasted via AccessMonster.com
11
user's latest post:
Criteria for opening form from a...
Published (2009-11-28 21:25:00)
Hello again, Yes, ContirbutorID field is on form as hidden field in the detail section. The source for the main form is a table (tblDonationCampaignSetup). The source for the subform is a query. Here is the SQL for the query: SELECT tblContributors.*, tblPledges.PledgeID, tblPledges.Campaign_ID, tblPledges.Contribution_CategoryID, tblPledges.PaymentTypeID, tblPledges. DatePledged, tblPledges.AmountPledged, tblPledges.Paid,...
user's latest post:
Group checkboxes on subform in...
Published (2009-11-28 13:35:00)
When you use the 'selection button' - we call it an option group or frame. Instead of using the after update for each check box or each button, use the value for the option group. If I have an option group with 3 checkboxes or selection buttons, When I check the first checkbox, the option group will have the value =1. When I check the second checkbox, the option group will have the value = 2. Similar for the third...
Linq Adams via AccessMonster.com
10
user's latest post:
Ways to Start a particular form?...
Published (2009-11-25 13:27: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?
user's latest post:
Criteria for opening form from a...
Published (2009-11-28 22:55:00)
On Sun, 29 Nov 2009 04:48:15 GMT, "Scott_Brasted via AccessMonster.com" <u56211@uwe> wrote: >Hello again, > >Yes, ContirbutorID field is on form as hidden field in the detail section. > >The source for the main form is a table (tblDonationCampaignSetup). The >source for the subform is a query. Here is the SQL for the query: >SELECT tblContributors.*,...
BruceM via AccessMonster.com
7
user's latest post:
Combobox event in...
Published (2009-11-25 05:00:00)
Oops. You are correct, of course. To the OP, the After Update event can be used to do things such as set the Row Source of another combo box based on the one just updated, hide or unhide controls, and such, but it is not a good event for data validation. Depending on what the "bunch of things" are you may want to do some in the After Update event. J_Goddard wrote: >The After Update event does not have the...
user's latest post:
Combo-box in Sub-form in...
Published (2009-11-27 06:29: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...
|
|
|
Top 10 active forums on Discussions in microsoft.public.access.forms during last week:
|
|
Top 10 forums on Discussions in microsoft.public.access.forms:
|
|
|
|
Latest active threads on Discussions in microsoft.public.access.forms:
Started 1 day ago (2009-11-29 17:00:00)
by Crystal (strive4peace)
Hi Len,
if you are using a version of Access below 2007, you can
show the number of records directly in a textbox control :
ControlSource --> =[Form].Recordset.Recordcount & " records"
if you are using 2007, you need to calculate this in code to
display in a textbox on the current event of the main form
and ...
Started 19 hours, 47 minutes ago (2009-11-29 21:25:00)
by John W. Vinson
On Mon, 30 Nov 2009 03:09:13 GMT, "melzoh" <u56567@uwe> wrote:
>hi,
>Im currently doing up a database for a tuition centre.
>The problem now is, I have to add students into the system. I have a form
>already
>Currently, the form has the following fields:
>First Name
>Last Name
>Contacts
>Level ( grade 9,10,11,...
Started 21 hours, 37 minutes ago (2009-11-29 19:35:00)
by Allen Browne
It would be simplest if you used a single StopDateTime field, instead of
having the date in StopDate and the time in StopTime.
If you really need both fields, you could try adding the date and time
together, i.e. test if:
Now() >= DLookUp("[StopDate]+[StopTime]","TblDates","[Curre ntMth]=True")
Started 2 days, 1 hour ago (2009-11-28 16:05:00)
by Crystal (strive4peace)
Hi Scott,
*** Difference between Subform Control and Subform ***
The first click on a subform control puts handles* around
the subform object.
*black squares in the corners and the middle of each size --
resizing handles
The subform object has properties such as
Name
SourceObject
...
Started 1 day, 17 hours ago (2009-11-28 23:25:00)
by fredg
On Sat, 28 Nov 2009 22:28:02 -0800, str8trini wrote:
> I am trying to add a total to the form footer on a continuous form that will
> only total the records marked with a check box field. Is there a way to
> specify this in the control source on the total field. For example, I have 4
> records displayed on my form and 3 are ...
Started 2 days, 5 hours ago (2009-11-28 11:35:00)
by ruralguy via AccessMonster.com
Try importing your db into a new, empty db:
http://www.btabdevelopment.com/main/QuickTutorials /Howtoimporteverythingintoanewmdbfile/tabid/67/Def ault.aspx
Then Compact and Repair and then try it.
BobC wrote:
>I inherited an 2007 application which has 5 Tabs as the starting menu
>(Home, Display, Orders, Changes, ...
Started 2 days, 1 hour ago (2009-11-28 16:05:00)
by Beetle284 via AccessMonster.com
Jim T wrote:
>How can I edit individual controls after using Form Tool (e.g. sizing afects
>all like controls)
Well you didn't give us much to go on, so I'm going to take a wild stab
and guess that you're using A2007 and you have a set of controls that
are grouped, and you want to remove the grouping?
If so, select ...
Started 3 days, 2 hours ago (2009-11-27 14:55: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...
Started 2 days, 4 hours ago (2009-11-28 13:05:00)
by John W. Vinson
On Sat, 28 Nov 2009 11:45:48 -0800 (PST), Tia <tia.abdelkarim@gmail.com>
wrote:
>Hello,
>I have created a query from a table for my employee data base, the
>query is dupilicating the names.
>The name only exits once in the table but i can see a name that exits
>3 or 4 times in the query.
>
>Please help
>
...
|
|
Hot threads for last week on Discussions in microsoft.public.access.forms:
Started 4 days, 10 hours ago (2009-11-26 07:00:00)
by Ken Snell
What are the values in the ControlSource property for those fields? If they
begin with an = character, they are calculated expressions that cannot be
edited. If they are field names and those fields are autonumber fields or
calculated fields in a query, they cannot be edited.
Started 2 days, 1 hour ago (2009-11-28 16:05:00)
by Crystal (strive4peace)
Hi Scott,
*** Difference between Subform Control and Subform ***
The first click on a subform control puts handles* around
the subform object.
*black squares in the corners and the middle of each size --
resizing handles
The subform object has properties such as
Name
SourceObject
...
Started 2 days, 19 hours ago (2009-11-27 21:30:00)
by fredg
On Fri, 27 Nov 2009 23:07:21 -0500, BobC wrote:
> The two text boxes are on the same form (subform3).
> I want to inhibit the Quantity filed from being edited if the Status
> field contains "Ship Requested".
>
> The following code gives me an error 'Expected: list separator or )'
>
> Private Sub Quantity_BeforeUpdate...
Started 5 days, 5 hours ago (2009-11-25 11:45:00)
by J_Goddard via AccessMonster.com
Hi -
MS Access doesn't know what tblContributors is in that context - it is
trying to find a control or variable with that name, and it can't, hence the
error.
ContributorID must be in a control on the record (i.e. on the form) you are
double-clicking, though it can be hidden. Then, your criteria in the DoCmd.
...
Started 1 week ago (2009-11-23 08:39:00)
by Rachael
OK...I figured out how to get the Query to run...So now, how do I Supress the
question windows and get them to automatically select "Yes" so the Make table
will run without the user having to select Yes to delete and Yes to run?
Thanks
"Rachael" wrote:
> I have built a switchboard that runs reports.
>
> ...
Started 1 week ago (2009-11-23 07:10:00)
by Golfinray
Your combo should be set up to search the filed you want. That part is ok.
Now put some code in to make it work. Go into properties of the form, go to
events, go to the afterupdate event, and click the little button out to the
right. Start the code builder. Type:
Me.filter = "[thefieldyouwanttolookup] = """ & Me.combo# & """"
Me....
Started 2 days, 5 hours ago (2009-11-28 11:35:00)
by ruralguy via AccessMonster.com
Try importing your db into a new, empty db:
http://www.btabdevelopment.com/main/QuickTutorials /Howtoimporteverythingintoanewmdbfile/tabid/67/Def ault.aspx
Then Compact and Repair and then try it.
BobC wrote:
>I inherited an 2007 application which has 5 Tabs as the starting menu
>(Home, Display, Orders, Changes, ...
Started 1 week ago (2009-11-23 13:00:00)
by Dirk Goldgar
"JamesJ" <jjy@darwin_roadrunne0r.com> wrote in message
news:urvnEiHbKHA.5656@TK2MSFTNGP04.phx.gbl...
> AC 2007 sp2.
> I have a form with a list box combo box and a text box.
>
> The cbo is used to filter records in the form and is
> also synced with the list box. I have dvd titles in the list box and when
> I select an item...
Started 6 days, 2 hours ago (2009-11-24 14:55:00)
by Douglas J. Steele
What does "gets stuck" mean? Do you get an error? If so, what's the error?
Started 3 days, 23 hours ago (2009-11-26 17:45:00)
by Linq Adams via AccessMonster.com
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 it to help.
Me.Recalc
will cause all calculated fields to be re-calculated, and should do the job
here. I'd put it in the AfterUpdate event of the textbox you're ...
|
|