|
More site info...
Discussions in... - 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.modulesdaovba:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
101
|
371
|
1,026
|
|
Post:
|
242
|
899
|
2,812
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.access.modulesdaovba (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.modulesdaovba posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.access.modulesdaovba Alexa graph:
|
Top authors on Discussions in microsoft.public.access.modulesdaovba during last week:
user's latest post:
Problem using Microsoft Web...
Published (2009-11-23 16:15:00)
Does anyone know the name of the file the message is referring to as the "OLE server"? If I can find out the name of the file, I'll make certain that it is registered! Jim "Jim Evans" <jim@microsoftdiscussions.com> wrote in message news:OnDGgO5aKHA.5608@TK2MSFTNGP05.phx.gbl... >I am trying to access the Custom properties of a Web Browser ActiveX >control on a form...
user's latest post:
Problem with updating connection...
Published (2009-11-26 18:50:00)
"Stuart McCall" <smccall@myunrealbox.com> wrote in message news:OR9sgawbKHA.4780@TK2MSFTNGP04.phx.gbl... > "BrainDead" <BrainDead@discussions.microsoft.com> wrote in message > news:F360C612-7095-46C3-9EE0-EDD06E92E48F@microsoft.com... >>I have an Access 2007 db that allows the user to combine data from various >> sources and...
user's latest post:
QpenRecordset in...
Published (2009-11-25 12:30:00)
Why bother? Why not just use DLookup to see whether the value exists in the table, rather than using a recordset? However, in answer to your specific question, it sounds as though you don't have a reference set to DAO. While in the VB Editor, select Tools | References from the menu. If Microsoft DAO 3.6 Object Library isn't one of the selected references at the top of the list, scroll through the list until you find it,...
user's latest post:
Combo On Not In List - am I...
Published (2009-11-26 19:20:00)
"Billp" <Billp@discussions.microsoft.com> wrote in message news:C52D91CD-2C23-4BD4-92B6-31329B107798@microsoft.com... > Yes i asked too much especially the hope that I could get it to do > anything > before it was added to the list. I have reverted back to a more silplar - > I > hope > > intpak = MsgBox("Do you wish to add a new...
user's latest post:
Declaring Public Const in...
Published (2009-11-26 14:30:00)
'Variables' are members (or fields) of a class, and probably by extension we can say the same for modules, that is OO terminology, but what I pointed out was that COM, on which is based Access-VBA since at least 2000, does NOT expose 'variables' and so, COM, TECHNICALLY, uses properties to handle module public variables. A writeable property is clearly different than a function. So I assume you meant read only...
user's latest post:
Access 2007 and Windows 7 in...
Published (2009-11-22 06:53:00)
Check to make sure all of your references are what they should be. I don't know what "standards" windows 7 may or may not have but the errors you describe are almost always a reference issue. hth
user's latest post:
The best way to speed up...
Published (2009-11-26 03:41:00)
Here are a few link to review to get you started on the path of ms access database design principles and ms access database application tunning: http://www.granite.ab.ca/access/performancefaq.htm http://www.fmsinc.com/MicrosoftAccess/Performance.html http://www.blueclaw-db.com/access_consultant_rapid.htm http://dbageek.blogspot.com/2004/10/microsoft-access-performance.html
user's latest post:
is there a way to get number of...
Published (2009-11-20 09:25:00)
Define "large" ... (do you mean more than 3, more than 10, more than 100?) If more than 3, why? Do you expect your users to be simultaneously using multiple screens, performing multiple tasks? (are they all under 30?<g>). As an alternate approach, if you provide your users a single form at a time, focusing what they're working on to a single topic, you'd never need to have more than one...
user's latest post:
Combo box columns in...
Published (2009-11-24 16:20:00)
Pastor Del wrote: >I have 2 combo boxes on an unbound form. I want to fill the list of the >second combo box based on the second column of the first combo box selection. > I have successfully used [Forms]!MyForm]![MyCombo] in the row source of >combos before and Forms !MyForm!MyCombo].Column(1) in code before, but the >.Column(1) does not work for me in a combo row source. > >How can...
|
|
|
Top 10 active forums on Discussions in microsoft.public.access.modulesdaovba during last week:
|
|
Top 10 forums on Discussions in microsoft.public.access.modulesdaovba:
|
|
|
|
Latest active threads on Discussions in microsoft.public.access.modulesdaovba:
Started 1 day, 22 hours ago (2009-11-26 03:41:00)
by Daniel Pineault
Here are a few link to review to get you started on the path of ms access
database design principles and ms access database application tunning:
http://www.granite.ab.ca/access/performancefaq.htm
http://www.fmsinc.com/MicrosoftAccess/Performance. html
http://www.blueclaw-db.com/access_consultant_rapid .htm
http://dbageek....
Started 1 day, 7 hours ago (2009-11-26 19:00:00)
by Billp
Yes i asked too much especially the hope that I could get it to do anything
before it was added to the list. I have reverted back to a more silplar - I
hope
intpak = MsgBox("Do you wish to add a new contact?" & vbCrLf & _
"Select " & vbCrLf & _
" - YES to open Customer Table to Enter / Delete contacts?"...
Started 1 day, 7 hours ago (2009-11-26 18:45:00)
by Stuart McCall
"BrainDead" <BrainDead@discussions.microsoft.com> wrote in message
news:F360C612-7095-46C3-9EE0-EDD06E92E48F@micros oft.com...
>I have an Access 2007 db that allows the user to combine data from various
> sources and then updates queries embedded in an Excel 2007 spreadsheet. I
> update the connection string and the command text with the ...
Started 2 days, 22 hours ago (2009-11-25 04:20:00)
by Alex Dybenko
hi,
no, you can’t declare it that way, you have to declare public variable, set
it to CatchParam("P_PATH", 0) at strartup and then use it
Public T_PATH As String
sub main()
T_PATH = CatchParam("P_PATH", 0)
....
Started 1 day, 14 hours ago (2009-11-26 11:50:00)
by vanderghast
(len(originalString) - len( replace( originalString, substringYouCount,
vbNullString)) ) / len(subStringYouCount)
Replacing (temporary) each substring occurence, in the original string, by a
zero length string reduce the original string by a total of Number of time
the substring is found * length of the substring. That is what the
...
Started 1 day, 14 hours ago (2009-11-26 11:46:00)
by vanderghast
If you mean 'removing' the replications features... you can start with
http://www.trigeminal.com/lang/1033/utility.asp?It emID=7#7 (note that the
site is multilingual).
Vanderghast, Access MVP
"victor kingobol" <dvarich@hotmail.com> wrote in message
news:289D68ED-F580-47C1-83B2-1743917FC6A6@microso ft.com...
> como puedo ...
Started 1 day, 15 hours ago (2009-11-26 11:10:00)
by ruralguy via AccessMonster.com
I would add the following code:
Dim MyStart As Integer
MyStart = InStr([ResponseXML], "element")
...and then use MyStart in place of all of the occurances of:
InStr([ResponseXML], "element")
...in the code. It will be easier to read and should expose the problem.
Leslie Isaacs wrote:
>Hello All
>
>...
Started 1 day, 16 hours ago (2009-11-26 10:25:00)
by Rick Brandt
gmazza via AccessMonster.com wrote:
> Hey there,
> I'm going crazy in my head over this one.
> I am getting a syntax error on my Update.
> Here is a little background followed by code.
> SubmitDate is a Text field with a yyyy-mm-dd format.
> Submit is Dimmed as String
> I am importing a .csv file into table ...
Started 1 day, 18 hours ago (2009-11-26 07:41:00)
by ryguy7272
Check out this code for manipulating Excel from Access:
Make sure you set a reference to Excel, and then run this code in an Access
module:
Option Compare Database
Option Explicit ' Use this to make sure your variables are defined
' One way to be able to use these objects throughout the Module is to
Declare them ...
|
|
Hot threads for last week on Discussions in microsoft.public.access.modulesdaovba:
Started 2 days, 22 hours ago (2009-11-25 04:20:00)
by Alex Dybenko
hi,
no, you can’t declare it that way, you have to declare public variable, set
it to CatchParam("P_PATH", 0) at strartup and then use it
Public T_PATH As String
sub main()
T_PATH = CatchParam("P_PATH", 0)
....
Started 3 days, 11 hours ago (2009-11-24 14:46:00)
by Rose B
Can you be a bit more specific? In general you could either have....
If <Condition> then <Action>
or
If <Condition> then
<Action>
else
<Action>
end if
You can nest your IF statements as well.
Try using the Access Help function - this describes it very well.
"...
Started 1 week ago (2009-11-20 07:06:00)
by Daryl S
DaBears -
This will cound all the objects in the MSysObjects table. Obviously, don't
mess with the system tables...
SELECT Count(MSysObjects.Id) AS CountOfId
FROM MSysObjects;
Started 1 week, 1 day ago (2009-11-19 18:50:00)
by Jack Leach
Read here:
http://www.mvps.org/access/general/gen0005.htm
As far as the control button for the access application, that can be disabled:
http://support.microsoft.com/default.aspx/kb/24574 6
p.s. - I'll get the rest of the MenuBar code tomorrow, I don't have access
to it at the moment...
Started 1 week, 1 day ago (2009-11-19 06:50:00)
by Douglas J. Steele
Set dbsHomedata = wrkDefault.CreateDatabase("C:\Transfer\Homedata.md b", _
dbLangGeneral, dbVersion40)
(yeah, it's a little confusing that you need to use dbVersion40 to be
compatible with DAO 3.6!)
Started 1 week, 1 day ago (2009-11-19 09:30:00)
by Jeff Boyce
Sash
Nope. "Format" is not the same as "storage".
On the other hand, if you were to use a query to gather what you want to
export, and explicitly set the value to have "padding" and then explicitly
convert it to a character string (see CStr() function), you'll probably get
your full width.
Regards
...
Started 1 week, 2 days ago (2009-11-18 15:45:00)
by Jack Leach
To programmatically access the MenuBar (commandbars) collection(s), you need
a reference to Microsoft Office XX.0 Object Library (fill in XX with your
version of Access/Office).
Access the menu bar itself through the CommandBars collection. Then, each
file/tab on the menu is in the Controls collection of the CommandBar (and
...
Started 1 week, 1 day ago (2009-11-19 06:35:00)
by Daniel Pineault
To determine the path to the application itself, use:
Application.SysCmd(acSysCmdAccessDir)
Started 1 week ago (2009-11-20 05:55:00)
by Jim Evans
I do this type of thing with a . vbs script or a .bat script. After the
script is created and saved to a particulat folder on c:\, I create a
Scheduled Task to run the script. The Scheduled Task requires credentials.
I believe the user credentials you use must be those of a local user so,
create the user on the system that is ...
Started 5 days, 19 hours ago (2009-11-22 06:53:00)
by Jack Leach
Check to make sure all of your references are what they should be. I don't
know what "standards" windows 7 may or may not have but the errors you
describe are almost always a reference issue.
hth
|
|
Size: 1,045 bytes
