Outlook 2003, 2GB max file size?
Can Outlook 2003 surpass its previous versions' 2GB max
file size? If so, what is the "new" limit?
Humongous - theoretically practically unlimited? - probably exceeds the
capacity of the dektop.
Though why any desktop user should have need of a single pst of even 1gb I
find hard to invisage. Info overload? - You backup to what media?
"Michael in Portland" <firstname.lastname@example.org> wrote in message
> Can Outlook 2003 surpass its previous versions' 2GB max
> file size? If so, what is...Add new record in a sub form
I have a Booking Form with 2 subforms - Customer Details & Booking
Details. I can find a Customer & get his details displayed in the
Customer Details section, and click a button on the Booking Details
subform which executes the following:
DoCmd.GoToRecord , , acNewRec
This works fine - I can enter details for a new Booking.
I also have an Enter/View Customers form in the system, and I am
trying to put a New Booking button on there which opens the Booking
Form with the selected Customer Details at the top and the Booking
Details sub form open to Add a new booking.
I tried execut...Show the records from table based on time range
I created a form will display the records from a table. The records in the
table contain years (mm/dd/yyyy) information. I would like to write the code
to retrieve the records based on the year range. For example, retrieve all
data from year 2000 or data from 2001. Could some one help me?
There are several ways to implement this, but the basic filtering is:
Year([YearInfoDate]) = SomeYear.
You could use the Where argument of the OpenForm method.
You could use the Form's Filter and FilterOn properties.
You could include it in a query to use as the form's r...looking for outlook forum or answers
looking for outlook forum or answer
hokieguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2191
View this thread: http://www.excelforum.com/showthread.php?threadid=37600
and then look for the outlok section.
MS Excel MVP
"hokieguy" <email@example.com> wrote in
&...Plugin running on deletion of a record
I'm having some problems with a plugin which runs whenever a custom entity is
deleted. The plug-in code itself seems to work fine, but after it steps out
of the plugin, I get a "The requested record was not found or you do not have
sufficient permissions to view it", and the record itself doesn't get deleted.
Within the plugin, I do access the record itself to get some information
that is not passed in the message. It might be that the entity is not
Do you guys know what's the proper way to release the dynamicentity? (I
tried to set it to null,...Thank you Mr. Max
I want to thank you once again for your respond and provided solutions for
my problem. I m very thankful and grateful to Microsoft Office who provided
such fantastic platform for learners who can improve their skill through it.
Your solution is working in new opened workbook but it is not working in my
this file which is I m already working. Please find out what is the reason.
I m sending my file to you
Thanks and regards.
Rao Ratan Singh
"Rao Ratan Singh" wrote:
> ...it is not working in my file .. Please find out what is the reason
Believe you didn't foll...SmartList Security for New SmartLists
I'm having a problem with version 9 SmartList Security.
I create a SmartList and then open SmartList and let it add the new object.
I go to Advanced Security and the SmartList is marked automatically but
nobody that is marked for it can see it. I have to unmark and remark the
Is there a setup issue or a software issue?
Charles Allen, MVP
I have you gone into Smart list Security. I have found that even though the
New Smartlist object is checked in Advanced Security, it will not be checked
in the Smart List Security.
I believe that this has been writt...Access External Tables Using SmartList Builder
Can I access external SQL tables in SmartList Builder? We want to query
tables in the Tensoft Fabless Semiconductor Manufacturing (FSM) software
module that is bolted to GP. Thank you.
You certainly can! If your tables reside in another database, you will need
to create views from within your GP company database as follow:
create view vwTensoftTable as
select field1, field2,...,fieldN from YourTensoftDatabase.dbo.tensofttable
You will need to then grant permissions to DYNGRP on those views. From there
on, you can pull into SLB.
Mariano Gomez, ...Check for record
I am using the following code to determine if a record is present, then doing
stuff accordingly. Trouble is...I do get the message if there is a record
and do not get the message if there is not.
Am I doing something wrong? Is there a better way?
If HasData1(ClientID) Then
Else ( I even tried NOT HasData1(ClientID))
MsgBox "no record"
Thanks for your help,
HasData1 appears to be a function in your application. You need to have a
look at it and see what it is returning. Your code expects it to return a
I was training a group of customers today on SmartList builder and they were
creating trying to create a SmartList report. Everything goes well until at
least 4 or 5 of them were having errors saving the SmartList in the
SmartList Builder window. The error was something about a duplicate key
being created on the SLB11000 and the SLB 11100 tables (I cannot recall
which users have errors on which tables) but after attempting to save the
SmartList ID and building the SmartList ID on the actual SmartList view, I
cannot see the favorite there. (They say they may have, at one point in...PivotCharts (max cell/row limits)?
I've recently created an Excel spreadsheet to track Utility (water, sewer,
electricity) consumption and costs at 5 different locations...tracking the
past 3 years. It's 11 columns wide and is now on it's 389th row.
To view the data graphically (i.e. by individual site or type of utility) I
am using PivotCharts...which by the way are AWESOME!
Unfortunately, when I'm trying to view the last site I'm unable to view all
of it's data...oddly enough it stops at about 260 of the 388 records/rows.
I've hit REFRESH but still nothing. Are these two related? (I figured, it...Go to a new record on another form?
I have a form (Form2) which is being opened (or sometimes set focus to) from
another form (Form1). On the open and gotfocus events, I want it to go to a
new record; however, I also want it to be able to see/edit previous records
(so the DataEntry mode option is right out).
-I have no OnGotFocus, OnLoad, etc events in Form2
-the code on Form1 calling Form2 is on a command button. I've included the
whole mess of code on that button, just in case I'm missing something
Private Sub Command28_Click()
'the "record the valiant effort of this volunteer&qu...Prefer how Outlook 2000 looked-now using 2003-Can I switch views?
I don't like the way Outlook 2003 displays and would prefer to go back to the
2000 display. Is this possible.
Kinda, http://www.slipstick.com/emo/2003/up031029.htm#classicview might be
"Manhart" <Manhart@discussions.microsoft.com> wrote in message
>I don't like the way Outlook 2003 displays and would prefer to go back to
> 2000 display. Is this possible.
Outlook 2003 is highly customizeable - tell us what you want to change, and
we'll tell you how to achieve it.
There is ...Received Not Invoiced
GP 9.0 contains a prewritten Smartlist under Receivings line Items entitled
"Shipments Received but Not Invoiced*". I, erroneously, expected the results
to match the Received Not Invoiced report (Reports - Purchasing - Analysis -
Received Not Invoiced). However, it does not. In my instance, the Smartlist
contains numerous items that are not on the report.
It appears that the Smartlist is simply querying POP10500 file and comparing
the QTY Shipped field to the QTY Matched fields and displaying those items
where these amounts are not equal.
When I attempted to examine the Rece...Smartlist Security
OK... SmartlIst Builder.... V10
Where did they now hide the Smartlist Security window to give User/User
Class access to the new objects????
Access to smartlists is controled through the Alternate/Modified forms and
Reports (Tools->Setup->System->Alternate......) Select the profile (forms
and reports group) to be modified and then select Smartlists. View the list
of Smartlists and mark which ones this profile should have access to.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and ch...Tracking shared records in 4.0
Anyone know if 4.0 version has the ability to track shared records easier
none so far. but you can try the SDK
"Bernardina" <firstname.lastname@example.org> wrote in message
> Anyone know if 4.0 version has the ability to track shared records easier
> than 3.0?
...Default column layout in Smartlist Builder
When generating new Smart list using the Smartlist Builder tool it would be
great to allow for a means of identifying what the default column layout to
be rather that having to create a favorite to do that. For Example. If SLB
wanted to place columns 1, 2, 3, 4, 5 as such you could tell it to make it 5,
4, 3, 2, 1 instead in the root folder of the new SL created
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see th...Easy report? How to report on a record, skip, report, etc.
I have a totals query that looks like this:
SegmentID LandCost ImpvCost Damages Relo Incidental Demolition
001 $ amt $amt $amt $amt $amt 002
$ amt $amt $amt $amt $amt 003 $
amt $amt $amt $amt $amt 004 $ amt
$amt $amt $amt $amt 005 $ amt
$amt $amt $amt $amt 006 $ amt
$amt $amt $amt $amt 007 $ amt
$amt $amt $amt $amt 008 $ amt
$amt $amt $amt $amt 009...Next Record in ListBox
Is there an easy way to move to the next record in a list box after the list
box has been clicked on?
you can use following code:
If Me.MyListbox.ListCount > 0 Then
Me.MyListbox.Selected(1) = True
Alex Dybenko (MVP)
"Martin" <Martin@discussions.microsoft.com> wrote in message
> Is there an easy way to move to the next record in a list box after the
New User - Went into Smartlist under Customer Balance and added the aging to
it but when it refreshed everything was 0-30 days. I know if I run an AR
aging report it will not reflect everything in 0-30 days. Where does the
Smartlist pull its data from.
Go to Tools->Routines->Sales->Ageing and run this process. It ages the
accounts just like the report but it writes the data back to the tables.
This provides the data for the SmartList as well as updating the agening
displays and information printed on statements.
Richard L. Whaley
btw.....more informat...SMARTLIST REPORTS
i can't modify smartlist reports is there a way to modify reports from
smartlist. can i modify smartlist reports in version 9 or in the succeeding
If you are talking about creating you own smartlist reports, you can use
Smartlist Builder. This will allow you to create your own smartlist, as well
as use SQL Views to pull into Smartlists.
If this is not what you are looking for, can you please explain a little
more about which reports you want to modify in Smartlist.
> i can't mod...Max Account length and number of segments
Just discovered today (after about 10 straight hours of tinkering) that your
max account length and number of segments will affect your ability to test
3rd party dictionaries in TWO (Fabrikam). I had the account length maxed out
to 66 and the number of segments set at 5 (sufficient for TWO's accounts)
however I got an error everytime I tried to debug in the script
"Setup_Account_Format". I found that switching to max account length 12 and
max number of segments 3 alleviated this problem. Not sure if this has been
posted anywhere else, but I sure couldn't find it so ...V10 Smartlist Builder smartlists
I upgraded from V9 to V10, none of my users (except power users) see the
manufacturing smartlists or the Smartlist Builder smartlists we created in V9.
Where is the security for this?
Is there any way to group the ever increasing list of SmartList
reports into logical 'folders'. Would be great to have one for
Finance, one for Operations etc. and have department or function
specific reports under there instead of a huge list through which one
has to scroll.
Nope, but it would be nice. I have seen folks add their name to the
end so other people know no to change it. You could add a department
to the front so at least everything would be grouped together. Then
again, you've already got a big list like the rest of us don't you?
Mark (DynamicAccounti...loop thru cells to find matching record
I'm having difficulty with the following code.
I think thre are several issues, perhaps the easier one first.
When I set the following range, I noticed it didn't start at row 14
but at row 12, not sure why?
Set rng = wsSheet.Range("A14:A" & Cells(65536, "A").End(xlUp).Row). I
noticed that the message box shows cells I'm not interested in.
The more difficult problem is per the following
The active workbook, "sheet 1" has a lising of serial numbers, the
serial numbers start at row 14, the exact number varies, hence the set
rng as per abo...