|
More site info...
Discussions in microsoft.public.access - 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:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
396
|
1,113
|
3,113
|
|
Post:
|
849
|
2,484
|
7,901
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.access (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 posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access Alexa graph:
|
Top authors on Discussions in microsoft.public.access during last week:
user's latest post:
Access Developer Extensions -...
Published (2009-11-25 10:55:00)
It doesn't really matter what you've got as the Connect property for the linked tables in what you're distributing, as long as you can correct it. (the installation from Access Developer Extensions won't do that for you, by the way) If you have no other way to determine the correct path, you'll probably have to prompt them at that point. See http://www.mvps.org/access/tables/tbl0009.htm at "The...
user's latest post:
How do I concatenate all the...
Published (2009-11-25 09:23:00)
How is the data stored in your database? Table and field names with datatype? Post some sample data records.
user's latest post:
Want to export "True"...
Published (2009-11-25 09:20:00)
You would have to export from a query and use a calculated field. Field: SomeFieldTF: IIF(SomeYesNoField,"True","False") Or as an alternative: Field: SomeFieldTF: Format(SomeYesNoField,"True;True;False") John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Pat Coleman wrote: > I am exporting a table in Access 2003 to a...
user's latest post:
2007 vs 2003 file size in...
Published (2009-11-25 15:50:00)
On Wed, 25 Nov 2009 14:10:01 -0800, Jake F <JakeF@discussions.microsoft.com> wrote: >I converted a database to 2007 and the file size went from 21 mb to 2.1 mb. My guess is that if you Compacted the database in 2003 that it would shrink similarly. The conversion process includes the equivalent of a compaction step. >Does anyone know a reason for this? Most of the posts I've read have said to...
user's latest post:
'The setting for the...
Published (2009-11-25 10:13:00)
Do you have a combo box associated with one or more of the fields in this table? If so, what does the ListRows property say for that field/those fields?
user's latest post:
intermittent error message when...
Published (2009-11-25 20:50:00)
On Wed, 25 Nov 2009 15:55:06 -0800, "Paul" <BegoneSpam@forever.com> wrote: For performance reasons Access locks records a page at a time, not a record at a time. A page typically contains several records. Multi-user conflicts are a fact of life with any development tool. So you try to gracefully handle them. Perhaps in your error handler you can go to sleep for a second or so and try again? -Tom....
user's latest post:
Increment Field in...
Published (2009-11-24 09:20:00)
Aha! So, Ken, you admit that the 'lookup data type' IS good for something ... causing confusion! <G!> Jeff B. "KenSheridan via AccessMonster.com" <u51882@uwe> wrote in message news:9f99e777cd0ee@uwe... > Firstly do not rely on an autonumber to give you the number of rows in a > table. All it guarantees is a unique value for each row. If a user > begins...
user's latest post:
Access 2007 in...
Published (2009-11-25 08:29:00)
http://support.microsoft.com/kb/826208 Read the whole thing carefully.
user's latest post:
How To Scroll To End On Current?...
Published (2009-11-25 11:50:00)
"Randy Yates" wrote in message news:m37hte5su6.fsf@ieee.org... >I have a subform in continuous form mode on a form, and depending > on the number of records in the subform, a vertical scroll bar may > or may not appear. > > By default, the subform is oriented so that the top-most records > are displayed and the scrollbar is in its top-most state. How do I > cause...
user's latest post:
Expanding the size of my report...
Published (2009-11-25 12:45:00)
Anne, Sounds like you might have reached the maximum of 22 inches... how long is your report?
|
|
|
Top 10 active forums on Discussions in microsoft.public.access during last week:
|
|
Top 10 forums on Discussions in microsoft.public.access:
|
|
|
|
Latest active threads on Discussions in microsoft.public.access:
Started 1 day, 4 hours ago (2009-11-26 18:00:00)
by Linq Adams via AccessMonster.com
There are several hotfixes for SP3. Here's a link to Allen Browne's page on
the SP3 bugs, along with links to two (I believe) of these. The second one,
at the very bottom, addresses your particular problem, but you need to
install the other one as well, if you haven't already done so.
http://allenbrowne.com/bug-Access2003SP3.html...
Started 1 day, 4 hours ago (2009-11-26 17:35:00)
by Tony Toews [MVP]
Pavel Fursov <PavelFursov@discussions.microsoft.com> wrote:
>After installing Office 2003 Cumulative Update for June 2009.
>Access 2003 SP3 + CU June 2009 (or April 2009).
What version of Access? I have 9.0.6926 SP-3)
>To reproduce a crash:
>Create new database. Click New Macro. Select Beep action. Click Save button....
Started 1 day, 1 hour ago (2009-11-26 21:05:00)
by John W. Vinson
On Thu, 26 Nov 2009 06:53:01 -0800, Emma <Emma@discussions.microsoft.com>
wrote:
>Where aare my postings going I keep searching for them but their not showing
>upp on the Discussion group?
Start: This is REALLY FRUSTRATING for you... but also for us.
You say you cannot see responses to your messages. True, the ...
Started 1 day, 1 hour ago (2009-11-26 21:05:00)
by John W. Vinson
On Thu, 26 Nov 2009 06:36:01 -0800, Gen <Gen@discussions.microsoft.com> wrote:
>The problem I'm having is
>that I'd like them to be able to enter multiple meetings with
>frmMeetingDetails, and if I set it to " Data Entry = Yes" it only allows one
>meeting at a time.
Well... then don't use Data Entry = Yes. Just open the...
Started 2 days, 16 hours ago (2009-11-25 06:05:00)
by Tom van Stiphout
On Wed, 25 Nov 2009 01:48:29 -0800 (PST), Rajtomar
<rajtomar219@gmail.com> wrote:
While that may seem a good idea at first, very quickly you are
developing a Report Designer, and Access already has one. You could
not possibly write 10% of its functionality in a month.
So for those power users offer their own copy of Access, ...
Started 1 day, 3 hours ago (2009-11-26 19:10:00)
by Allen Browne
You are entering your criteria one on each line, at the bottom of the query
design window?
If so, these are treated as ORs. Provided your data meets ANY of the
criteria, it's included. So, the record that contains "Advance Amount Paid"
meets the criteria:
not like "Paid Amount"
so it gets included.
Try ...
Started 1 day, 7 hours ago (2009-11-26 15:25:00)
by Douglas J. Steele
Not really, although you can simplify it considerably.
Create a function (must be a function, not a sub) along the lines of:
Function DropCombo()
If TypeOf Me.ActiveControl Is ComboBox Then
Me.ActiveControl.Dropdown
End If
End Function
Then, with the form in Design mode, select each of the ...
Started 1 day, 4 hours ago (2009-11-26 17:35:00)
by Tony Toews [MVP]
dusty68 <dusty68@discussions.microsoft.com> wrote:
>My office 97 Access Program begins automatically and it just began to happen.
>
>Is there someway to make this from happening? It is very frustrating when
>your logging into the computer and all of a sudden access 97 starts to run ..
Check your Start >> All Programs >> ...
Started 2 days, 14 hours ago (2009-11-25 07:40:00)
by GBA
I have been in your exact same shoes and I find that the answer will depend
on a variety of factors and one must select the best tool for the job - so to
speak....
one option is the www.AccessTables.com service; this allows everyone to
operate a copy of the Access db locally and then you send in the tables -
they consolidate/...
Started 2 days, 14 hours ago (2009-11-25 08:25:00)
by Douglas J. Steele
Why not just include code in the front-end to determine where the back-end
is and relink?
|
|
Hot threads for last week on Discussions in microsoft.public.access:
Started 5 days, 7 hours ago (2009-11-22 15:25:00)
by (PeteCresswell)
Per .Len B:
>I have split databases before and I have put passwords
>on them. I have never applied user-level security though.
>
>At the moment I have a project that will require user-
>level security and I want to split the db.
>
>Is there a better/best time to split and a time to do
>the security thing? What is the ...
Started 5 days, 3 hours ago (2009-11-22 18:50:00)
by Jeanette Cunningham
Using runtime access, any unhandled errors do exactly what has happened to
you.
In an accdb file, if you get an error, access can open the debug window and
tell you there is an error.
In the runtime, instead of getting a message about the same error, the
runtime will just shutdown the database.
Where to start?...
Started 2 days, 14 hours ago (2009-11-25 07:40:00)
by GBA
I have been in your exact same shoes and I find that the answer will depend
on a variety of factors and one must select the best tool for the job - so to
speak....
one option is the www.AccessTables.com service; this allows everyone to
operate a copy of the Access db locally and then you send in the tables -
they consolidate/...
Started 1 week, 2 days ago (2009-11-18 17:00:00)
by Daniel Pineault
For some general specs on the limit of access 2007 see:
http://blogs. msdn.com/access/archive/2006/06/05/ac cess-2007-limits.aspx
http://www.databasedev.co.uk/access_specifications .html
That said, I have dbs with 100,000's of records and they run without any
issue. I have seen MVPs mention dbs with 1,000,000's of records. 6,000...
Started 4 days, 9 hours ago (2009-11-23 12:40:00)
by ruralguy via AccessMonster.com
You really want the code in a separate procedure and then call it from the
AfterUpdate event of the TType control *and* the Current event of the form.
Mary wrote:
>I'm trying to create a form that will change the backcolor on one field based
>on the value of a different field. The code below colors all the M fields
>green, even...
Started 1 week ago (2009-11-20 09:14:00)
by Jerry Whittle
Go to the Relationships window and, if not already done, create a
relationship between the Customers table and each of the other tables. Enable
Referiental Integrity and set Cascade Delete.
If Access won't let you do this, you probably have some 'orphans' with an
Order or Payment not having a valid Customer. You'll need to fix ...
Started 3 days, 3 hours ago (2009-11-24 18:35:00)
by Tony Toews [MVP]
gmg <gmg@discussions.microsoft.com> wrote:
>I am converting a big Access 2000 Database to Access 2007.
>Since Access 2007 no longer has workgroup security, I will also need either
>SQL Server or Sharepoint.
Actually an A2007 MDB still has ULS. A2007 ACCDBs do not.
However if you have personal data then you should...
Started 1 week ago (2009-11-20 05:25:00)
by Lynn Trapp
Alex,
Are you requerying the comboboxes when the new record is created?
Started 1 week, 2 days ago (2009-11-18 11:43:00)
by Daryl S
Jessica -
When you say formula, I assume you mean a function? If not, you can apply
the same reasoning below to your embedded code...
I assume you have a CaseCloseDate available in your data, and that it is
blank until the case is closed. If your function that calculates age accepts
two dates, and you pass in the ...
Started 3 days, 12 hours ago (2009-11-24 10:15:00)
by Douglas J. Steele
You'll need to supply more details. What kind of errors are you getting?
What action causes them?
For what it's worth, there's no reason for the back-end to be an MDE. MDEs
are intended for code, not data.
|
|
Size: 676 bytes
