|
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:
|
91
|
295
|
1,024
|
|
Post:
|
185
|
689
|
2,888
|
|
|
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:
Access DB slower on one computer...
Published (2009-11-10 10:43:00)
Compact On Close is considered a very bad thing to use, so I hear... Maybe he could do it manually from Tools -> Database Utilities -> Compact and Repair and see if it makes a difference. -- Jack Leach www.tristatemachine.com "I haven't failed, I've found ten thousand ways that don't work." -Thomas Edison (1847-1931) "ryguy7272" wrote: > Sounds weird. Can you...
user's latest post:
path of related tables in VBA in...
Published (2009-11-10 20:10:00)
"lucainbici" <lucainbici@discussions.microsoft.com> wrote in message news:4E704FAE-F436-4FE9-BED4-D55153B39410@microsoft.com... > Hello, I'm writing in English but I'm Italian: forgive my language errors > ... > I'm burning my brain. I'm trying to write some rows of code in a form of > the > front-end database, to get the path of a related table...
user's latest post:
Calculate number of days in...
Published (2009-11-09 09:51:00)
In this specific case you'd need to create a custom function. Below is one I threw together rapidly to try to help you out. It is not the most elegant way to do this but it does work. Feel free to improve upon it. Function NoDaysByMonth(dtStart As Date, dtEnd As Date) As String On Error GoTo Error_Handler Dim iNoMonths As Integer Dim dtFirstofMonth As Date Dim dtLastOfMonth As Date iNoMonths = DateDiff("m",...
disneygoof via AccessMonster.com
9
user's latest post:
One front End - Multiple...
Published (2009-11-10 19:13:00)
I can't explain any more...I don't know exactly myself what occured, until I get back into those areas, I just can exactly remember. However my understand is compacting reorders auto numbers to the MAX last used, if the table is empty I thought it started over at 1? Maybe I am wrong, does not matter, I need to fix whatever I did wrong to correct what ever is casuing my problem. Thanks for everyone's help! I do...
user's latest post:
syntax to copy text string from...
Published (2009-11-07 15:45:00)
Hello, The following code gets me close, but not quite. When this runs, I get an error that the field doesn't exist. It's reading the text in the field as if it's a field name. I'm just trying to copy the text string from Pic_Location to the clipboard when I enter an unbound text box so it's ready to insert into the next chosen record. The code is: ****************************************** Private Sub...
user's latest post:
One front End - Multiple...
Published (2009-11-10 19:09:00)
On Tue, 10 Nov 2009 14:00:21 GMT, "disneygoof via AccessMonster.com" <u32262@uwe> wrote: >As I "guessed" my way through things early on, I used auto numbering in some >tables and should not have, becasue they ended up being temp table...so If I >compact and repair the back-end table, it will re-order my autonumbers. Compacting has never reordered any existing...
user's latest post:
Importing csv in...
Published (2009-11-10 19:25:00)
Have you tried creating an import specification? It's been a while, and you didn't indicate what version of Access you are using, but the import wizard used to provide a way (lower left corner) of creating an import specification, which allows you to tell Acces which fields to keep, and what to name each of the columns as you import them. Once you create this import specification, you can use the TransferText method and...
user's latest post:
FollowHyperlink works in Mozilla...
Published (2009-11-03 12:16:00)
Please ignore my request. I have learned a bit more about the problem and have reposted it as subject "Secure Hyperlink Fails".
user's latest post:
Can I use Access VBA code to...
Published (2009-11-10 21:54:00)
On Wed, 11 Nov 2009 03:54:37 GMT, "trevorC via AccessMonster.com" <u44860@uwe> wrote: Yes. Set a reference to "Microsoft Visual Basic for Applications Extensibility" and then you can access the Modules collection, add procedures, etc. Requires expert coding level. -Tom. Microsoft Access MVP >Hi All, >Is it possible to use Access VBA to create an Excel macro and copy it...
user's latest post:
Problem with PRINT REPORT TO PDF...
Published (2009-11-10 05:58:00)
SOLUTION: COLONS. I HATE COLONS. I had found earlier that colons crap out filenames. AWESOME so I now use an underscore in between hours and minutes in my timestamps on purpose. This however does not prevent me from being a dumbass and putting a colon SOMEWHERE ELSE in the filename variable. IN SHORT - DO NOT USE COLONS IN FILE NAMES. GUARANTEED FAIL. Thank you for your time and help. -- BlueWolverine MSE - Mech. Eng. Go BLUE!...
|
|
|
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, 20 hours ago (2009-11-10 21:54:00)
by Ken Snell
Two things jump out at me.
This code line:
Set xlsheet = xl.ActiveSheet
likely is the primary source of your Excel instance remaining. When you use
any of the "Active" objects, ACCESS creates a new reference to the EXCEL
object, which then isn't being closed. Replace this line with a specific
reference to a ...
Started 11 hours, 7 minutes ago (2009-11-12 07:46:00)
by Dorian
Look in Toolbar property of the report.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
"JimP" wrote:
> I have a report that displays from an autoexec macro. Right-clicking on the
> report displays a mysterious toolbar (looks like it came from another ...
Started 1 day, 5 hours ago (2009-11-11 13:50:00)
by vanderghast
Assuming the database has a saved parameter query, query13 as example:
SELECT MAX(Ds.d)
FROM Ds
WHERE (((Ds.d)<=[limite]));
You can then EXEC it like this:
? CurrentProject.Connection.Execute("exec query13 7").Fields(0).Value
or use an open connection to the database. Note that (here the single)
...
Started 1 day, 5 hours ago (2009-11-11 13:00:00)
by Vincent Verheul
Hi Matt,
Maybe a good strategy is to:
- split your Access application into a Front-end (appication with Forms,
Queries, Visual Basic / Macro's) and Back-end database (Tables / data)
- put the Back-end database on a shared server
- Save the Front-end as MDE ('executable')
- put the Front-end MDE on a special place on ...
Started 12 hours, 18 minutes ago (2009-11-12 06:35:00)
by Tom van Stiphout
On Wed, 11 Nov 2009 20:57:01 -0800, Chris C.
<ChrisC@discussions.microsoft.com> wrote:
That may be a good workaround. There are two problems here: you can't
control how ODBC wants to open your text file, and it may well want to
open it exclusively (not knowing you won't be writing). The other is
you can't control how other apps ...
Started 13 hours, 13 minutes ago (2009-11-12 05:40:00)
by Jeff Boyce
One approach might be to link to that table from within the "other" mdb,
then use copy/paste to generate a 'local' copy.
Are you sure you need a separate copy? Would it be sufficient to merely be
able to link to the existing table?
--
Regards
Jeff Boyce
Microsoft Access MVP
Disclaimer: ...
Started 16 hours, 28 minutes ago (2009-11-12 02:25:00)
by Stefan Hoffmann
hi Jack,
Jack Leach wrote:
> Is it possible to put a custom Type into an array? Is it possible to use a
> ParamArray and pass no values to it (make it optional, so to speak).
No, not really.
> Worst case, I can break down all of these printing parameters into seperate
> variables rather than using a Type, but I'm ...
|
|
Hot threads for last week on Discussions in microsoft.public.access.modulesdaovba:
Started 2 days ago (2009-11-10 17:55:00)
by disneygoof via AccessMonster.com
My current db of tables is getting quite large and growing...I am worked
about maxing the db out. Also I thought this would be easier to maintain the
tables.
Marshall Barton wrote:
>>I currently have a front-end that resides on each pc, linked to a back-end on
>>the server...no issues. I want to take the back-end and break it ...
Started 3 days, 6 hours ago (2009-11-09 12:23:00)
by Jack Leach
Wiithout looking at your actual code, and just a shot in the dark to boot, I
would be suspicious of using the square brackets [] as characters in a
filename. Aside from how the filesystem might handle these (I don't know
how), these to have a special meaning in VBA and there's a good possibility
that somewhere in that code of Mr. ...
Started 2 days ago (2009-11-10 18:09:00)
by Armen Stein
On Mon, 9 Nov 2009 11:12:56 -0800 (PST), lackeysc <lackeysc@gmail.com>
wrote:
>Select * from PB6
>union
>Select * from PB17
>union
>Select * from PB32
>union
>Select * from PB64
>
>
>Assuming that the above union query can be created, I would then need
>to run a grouped query against the ...
Started 1 day, 20 hours ago (2009-11-10 21:54:00)
by Ken Snell
Two things jump out at me.
This code line:
Set xlsheet = xl.ActiveSheet
likely is the primary source of your Excel instance remaining. When you use
any of the "Active" objects, ACCESS creates a new reference to the EXCEL
object, which then isn't being closed. Replace this line with a specific
reference to a ...
Started 3 days, 10 hours ago (2009-11-09 08:34:00)
by Daniel Pineault
DateDiff() should be what you are looking for.
DateDiff("d",#10/17/09#,#11/16/09#) + 1 = 31
DateDiff("d",#10/17/2009#,#12/15/2009#) + 1 = 60
For more information look at the help on the subject. It can be used in
VBA, queries, forms, reports...
--
Hope this helps,
Daniel Pineault
http://www....
Started 1 day, 20 hours ago (2009-11-10 21:54:00)
by Tom van Stiphout
On Tue, 10 Nov 2009 19:26:58 -0800, ThriftyFinanceGirl
<ThriftyFinanceGirl@discussions.microsoft.com> wrote:
You could create a query with unique records using the DISTINCT
keyword (or set the Unique Values property of the query). Then create
a second query based on the first one, and use the Count function:
select count(*)...
Started 1 week ago (2009-11-05 06:42:00)
by Daryl S
Luis -
If the button and the textbox are both in the subform, then the reference
would be:
Me!TextBox1.Caption = "Test"
--
Daryl S
"Luis" wrote:
> Hello.
> I have a form (" MainForm") with a subform ("Main_SubForm"). The subForm used
> as Source Object ("SF_SourceObj") has a ...
Started 1 day, 20 hours ago (2009-11-10 21:54:00)
by Tom van Stiphout
On Wed, 11 Nov 2009 03:54:37 GMT, "trevorC via AccessMonster.com"
<u44860@uwe> wrote:
Yes. Set a reference to "Microsoft Visual Basic for Applications
Extensibility" and then you can access the Modules collection, add
procedures, etc. Requires expert coding level.
-Tom.
Microsoft Access MVP
>Hi All,...
Started 1 week ago (2009-11-05 06:02:00)
by Jack Leach
Search the help for DLookup (or go to www.allenbrowne.com/tips.html and
import his ELookup function).
variable = DLookup("fieldname", "tablename", "where clause")
will return null if no values are found, so you may want to wrap with the
Nz() function:
variable = Nz(DLookup("fieldname", "tablename", "whereclause"), ...
Started 6 days, 10 hours ago (2009-11-06 08:04:00)
by Beetle
Comments inline:
> I enter a value in textbox1, textbox2 should only have choices available per
> the data from textbox1.
A text box doesn't have "choices". A user can enter a value, or you can
display a value. You could use code to build a list of values separated
by, for example, a comma and display it in the text box, ...
|
|
Size: 9,263 bytes
