|
More site info...
General Discussion | Forum profile
|
|
Forum profile page for General Discussion on http://www.officefrustration.com.
This report page is the aggregated overview from a single forum: General Discussion, 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 "General Discussion" 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 General Discussion:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
425
|
1,784
|
4,997
|
|
Post:
|
1,110
|
4,931
|
14,167
|
|
|
General Discussion Posting activity graph:
|
Top authors during last week:
user's latest post:
Research project: one database...
Published (2009-11-08 23:59:00)
On Sun, 8 Nov 2009 14:12:01 -0800, hannah wrote: I'm a bit of an access novice and I've had a wee search around these posts but I apologise if my question has already been covered elsewhere. I'm trying to build a database to hold questionnaire responses for my research project. There are 11 different questionnaires (each goes to a different sector e.g. the government, fishermen, farmers etc) and my question is whether (and how)...
John W. Vinson external usenet...
24
user's latest post:
Selecting and Printing Specific...
Published (2009-11-08 23:56:00)
On Sun, 8 Nov 2009 13:53:09 -0800, "HankL" wrote: Hi John, I attempted to rearrange the controls in Design View of the Form. That did not change the appearance of the form. However, I now have a scroll bar on the side of the form and allows me to scroll from one record to another in alphabetical order. Could this also be considered as a Continuous Form? It almost certainly is. You should be able to rearrange the controls on...
Arvin Meyer [MVP][_2_]
19
user's latest post:
How to open mdb without Access...
Published (2009-11-03 23:47:00)
Only if the other computer has a program that can read Access data. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Nova" wrote in message ... Thanks all I mean, It is possible to convert file from mdb to other fomat that can run on computer which has no MSAccess. "Arvin Meyer [MVP]" ?????: "Nova" wrote in message ... Is it possible to...
KenSheridan via AccessMonster.com
19
user's latest post:
Dupplicate Data
Published (2009-11-08 19:09:00)
On second thoughts you don't really need a subquery. This should do it: SELECT [CustomerID], MAX([VisitDate]) As [Last Visit] FROM [CustomerVisits] HAVING MAX([VisitDate]) = DATEADD("d",[Forms]![Work to be Completed]![DaySinceLast]*-1,DATE())) GROUP BY [CustomerID]; Ken Sheridan Stafford, England -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200911/1
user's latest post:
ole link to jpg
Published (2009-11-07 05:09:00)
Tom, Have a look at these... http://www.granite.ab.ca/access/imagehandling.htm -- Gina Whipp "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "Tom Kimberly" Tom
user's latest post:
Dupplicate Data
Published (2009-11-08 19:09:00)
On second thoughts you don't really need a subquery. This should do it: SELECT [CustomerID], MAX([VisitDate]) As [Last Visit] FROM [CustomerVisits] HAVING MAX([VisitDate]) = DATEADD("d",[Forms]![Work to be Completed]![DaySinceLast]*-1,DATE())) GROUP BY [CustomerID]; Ken Sheridan Stafford, England -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ccess/200911/1
user's latest post:
reference question
Published (2009-11-08 01:12:00)
"Mark Andrews" wrote: Thanks for the info. You wouldn't want to take a look at http://www.ostrosoft.com/smtp_component.asp and help me figure out the best way to use this component? Would love to figure out a way that I don't need to register it (and just include the files in the directory the front-end db lives). I would think using something like this component would help tons of people struggling with emailing...
user's latest post:
Referential integrity settings
Published (2009-11-08 01:29:00)
"Lars Brownies" wrote in : I'm used to check the ref. integrity checkbox when making relations, but not the checkboxes below that setting. So people have to manually delete the "many"-records, before they can delete the main record. I noticed in an inherited mdb that all 3 ref. integrity check boxes are checked. Is this common practice and is it recommended? Or can I run into problems with that? 1....
Gina Whipp external usenet poster
15
user's latest post:
filtering postings
Published (2009-11-06 00:32:00)
David, Oops, you are correct... I have Windows Mail on y Vista machine and Windows Live Mail on my XP machine and do often confuse the two eMail programs since I don't use either. I have my Mail program open all day as I am in my personal eMail and business eMail all day (I am in and out of all all day long). So for me, I prefer to have my newsgroup show up in the same place. I have one program that handles two things. Then I have Access...
Larry Linson external usenet poster
15
user's latest post:
Identity crisis?
Published (2009-11-05 22:54:00)
"David W. Fenton" wrote That has nothing to do with the question, though. The question is: What's so great about ACCDB? . . . but I just don't see anything in the ACCDB format that is helpful in garden-variety Access apps. I couldn't say... unless you are fond of using multi-value fields (that high-pitched whine you hear is Ed Codd, spinning in his grave like a turbine over the corruption of a more-or-less...
|
|
|
|
Latest active threads on General Discussion::
Started 1 day, 11 hours ago (2009-11-09 06:47:00)
by John W. Vinson
On Sun, 8 Nov 2009 20:56:01 -0800, sburruss
wrote:
i keep getting this message every time i try and change the autoformat. it
won't even allow me to use the look up wizard correctly because it ask you to
confirm the autoformat change also. Help!
Access version? What is it you're trying to autoformat? What are you trying to
change it to?
--
John W. Vinson [MVP]...
Started 1 day, 14 hours ago (2009-11-09 04:34:00)
by RCGUA[_2_]
On Nov 8, 7:42*am, RCGUA wrote:
I have an Access 2003 Form with a listbox that has three columns. *I
know that using a list box like this is not ideal if I want to control
the left-right alignment, however, I am using the method from Stephen
Lebans * * http://www.lebans.com/justicombo.htm
and it seems like it will work great, except that I would like to
control the alignment of ...
Started 1 day, 14 hours ago (2009-11-09 04:12:00)
by Larry Linson
"christian" wrote
teacher at school only runs powerpoint 2003, i only
have powerpoint 2007, what can i do?
First, save your presentations in Access 2003 format.
Second, scroll down and find a PowerPoint newsgroup for PowerPoint
questions. It is easy to be misled by the online interface you used, but
this newsgroup is for technical discussion of and questions and answers
...
Started 1 day, 15 hours ago (2009-11-09 03:34:00)
by John W. Vinson
On Sun, 8 Nov 2009 18:26:01 -0800, christian
wrote:
School can only run 2003 powerpoint presentations, I have powerpoint
2007,what do I do?
Ask in a Powerpoint forum. This forum is for a different program, Microsoft
Access. The webpage can be confusing and may have misled you.
Access 2007 has an option to save a database in 2003 format - you might want
to try File... Save As ...
Started 1 day, 16 hours ago (2009-11-09 02:24:00)
by No Name
is this the grope im lost agan darn pc
wrote in message
...
hope this works
Started 1 day, 16 hours ago (2009-11-09 01:55:00)
by Gina Whipp
shakool,
You've posted to the incorrect newsgroup. This one is for Microsoft Access,
you meant to go here...
http://www.microsoft.com/office/comm...&lang=en&cr =US
And when you get there, ti will help them to know what versionof Word you
are using.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/...
Started 1 day, 18 hours ago (2009-11-08 23:59:00)
by John W. Vinson
On Sun, 8 Nov 2009 14:12:01 -0800, hannah
wrote:
I'm a bit of an access novice and I've had a wee search around these posts
but I apologise if my question has already been covered elsewhere.
I'm trying to build a database to hold questionnaire responses for my
research project. There are 11 different questionnaires (each goes to a
different sector e.g. the government, fishermen, ...
Started 1 day, 18 hours ago (2009-11-09 00:03:00)
by John W. Vinson
On Sun, 8 Nov 2009 14:15:01 -0800, lbohen
wrote:
I have a database of over 10K records, each has the following phrase that I
want to change from
border="0" /centerstrongfont color="#990000"Free USA Shipping, Orders
$50 or more!/font/strong/center/pp
to
border="0" /
There must be a character that is preventing the finding of the phrase as
the search does NOT find it and...
|
|
Hot threads for last week on General Discussion::
Started 1 week, 2 days ago (2009-11-01 02:54:00)
by saraqpost@yahoo.com[_2_]
Set rst = "SELECT tblActData.Dept, tblActData.Amount,
tblActData.COAKey, tlkpCOA.Number, " _
& " tlkpCOA.Account, tblActData.Subsidiary,
tblActData.FiscalYr, " _
& " tblActData.FiscalMonth, " _
& " #" & "DateSerial([tblActData.FiscalYr],
[tblActData.FiscalMonth],1) # " _
& " FROM tblActData INNER JOIN tlkpCOA ON tblActData.COAKey =
tlkpCOA.COAKey " _...
Started 6 days, 21 hours ago (2009-11-03 20:49:00)
by Rudolf Lamour
"Zen" r- schrieb im Newsbeitrag
...
Hey all,
I'm experiencing a frustrating problem with access on 2 out of 4
computers, literally all of a sudden. Here's the scoop.
4 office computers with XP Pro and Office 2002. We just made a change to
our front end mdb so we could push some invoices to quickbooks.
I went ahead and opened the front end on two computers, everything
...
Started 1 week ago (2009-11-02 23:32:00)
by Dirk Goldgar
"RCGUA" wrote in message
...
I have an Access 2003 Form with a listbox on it. The row source is a
Table/Query. The query sorts the records according a Date/Time field
in the table. The Date/Timefield is Short Date.
When I use the form and add a record to the list box, the code below
scrolls down the listbox to bottom and selects the last record. The
problem is that the last...
Started 4 days, 22 hours ago (2009-11-05 20:10:00)
by Douglas J. Steele[_3_]
Doesn't the vendor have any recommendations?
The best solution would be to use Late Binding if that's possible.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"Mark Andrews" wrote in message
...
I want to use Ostrosoft's SMTP component in a product that many people will
have to install.
Their newest product consists of a DLL ...
Started 1 week, 2 days ago (2009-10-31 20:31:00)
by HankL[_2_] external usenet poster
Access 2003
Is there a way that I can select specific records from a database to print
out specific columns for those records?
As an example, I have a database of restaurants. I want to select
certain restaurants in that database to print out on a sheet of paper for a
friend.
Thank you in advance for your support and suggestions,
HankL
Started 1 week, 1 day ago (2009-11-02 11:07:00)
by Stefan Hoffmann
hi Nova,
Nova wrote:
Is it possible to open file access in a computer which has no Access program
(no install MS Access)
Yes. You may use Notepad.
But I have to assume this is not what you had in mind when asking this
question...
The problem is: What do you mean with "open"?
As you find on all Windows versions the MDAC/Jet components, yes you can
for example open it in...
Started 1 week, 1 day ago (2009-11-02 01:17:00)
by John W. Vinson
On Sun, 1 Nov 2009 17:27:28 -0500, wrote:
I have a tab delimited file which if opened in Excel would have about 80,000
rows - something my Excel 2002 cannot do. It can only open about 65,000
rows. It was suggested that I could open this file in Access but although
I've used Excel for years, I am not familiar with Access.
Is there a simple way to open such a file in Access 2002 (...
Started 5 days, 11 hours ago (2009-11-05 07:03:00)
by Gina Whipp
Deb,
First time I heard Access has a problem with calculations. Now granted it
does not Round the say way Excel does but there are numerous, let me say
that again, NUMEROUS fixes for that. However, I created a Property
Appraisal database which amounts to a big calculator and it calculates just
fine. Now that being said, without knowing what type of database you want
to ...
Started 5 days, 18 hours ago (2009-11-05 00:16:00)
by John W. Vinson
On Wed, 4 Nov 2009 12:52:02 -0800, an wrote:
Hi!
I have a continous form with checkbox Yes/No named Conf and textbox named Val.
When I click in Conf the check boxes are all Visibles
I have:
Private Sub Conf_Click()
If Me.Conf = True Then
Me.Val.Visible = True
Else
Me.Val.Visible = False
End If
End Sub
When I click one checkbox all Val textboxes turn to ...
Started 1 week, 2 days ago (2009-11-01 08:51:00)
by James A. Fortune external usenet poster
A version of Outlook 2007 has suddenly appeared on my computer without
my initiation. I have good antivirus protection so it's likely that it
was done by the company I work for. Last week, other software was
installed on my computer by my company without my knowledge. When I
brought it up to them as a result of the software not uninstalling
itself completely (Oops), it was explained...
|
|
Size: 568 bytes
