Great Plains Standard installation 8.0
On the test server we have installed the program and the data tables on the
server. When we go live, we intend to install the program on one server and
the data on another. Will this be a problem? Is there anything in
particular we need to do for this?
How will license work. Will this be looking at Database server or the
application server. What happens when I do upgrade or apply service pack.
Also, has someone run into this scenario.
What are the advantages and disadvatages of the above scenarion.
By the sounds of what you describe you are simply ins...Data Validation using List (But needs unique list in drop down lis
In sheet 1, column A is my title name while column B is person name.
Sheet 1 is my database where i do data entry in this.
In sheet 2, contains my query page. In cell A5, i uses data validation -
list, on this cell. Say in sheet 1 :
column A column B
XXXXXXX Mr A
YYYYYYYY Mr A
ZZZZZZZZ Mr A
AAAAAAA Mr B
WWWWW Mr C
DDDDDDD Mr C
But In sheet 2, cell A5, I saw in the drop down list as follows:
But i want to see this in cell A5 instead (Unique name that is) :
...Address and e-mail contact list
I do not want the e-mail address of sender automatically added to my contact list
How do I suppress
No clues here so no help forthcoming.
Want assistance? Help us help you. Give your version of Outlook. If
Express, post in an Express group - this is not one of them. If you are
using the Web interface, look under Internet Explorer as it is a part of IE,
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
A...how do i add all my suggested contacts to my contacts list?
How do i add all of my suggested contacts to my plain old contact list?
Are you asking about a beta?
"Teagan" <Teagan@discussions.microsoft.com> wrote in message
> How do i add all of my suggested contacts to my plain old contact list?
CTRL+A to select all of them then just drag and drop...
Ben M. Schorr, MVP
Roland Schorr & Tower
Aut...Distribution Lists #30
Wasn't sure which would be the best group to post this in.........
We seem to be having some issues with people viewing distribution list
members. The members are not hidden and if I remove the persons permissions
and reapply them it seems to rectify the problem for a little while. I don't
know if it is coincidence or not but most of the people having a problem
seem to be listed as the manager of the DL. I have looked and followed the
article about setting the permissions in security rather than on the managed
by option but this doesn't seem to make a difference.
T...VBA Code to Open File1; Open File2 copy sheets to File1
Using XL 2003 & 97
Need help with the following VBA code:
Dim myNewWorkbook As String
myNewWorkbook = ActiveWorkbook.Name
Sheets(Array("Formulas", "Department Lables")).Activate
Sheets(Array("Formulas", "Department Lables")).Copy _
My goal is to have myNewWorkbook active then:...Changing font size in data validation drop-down lists
In Excel 2003, I created the value list on a separate worksheet and labled
the range so I could use it in the data validation wizard on a different
The list is working fine; however, the font size in the drop-down list is
too small to comfortably read.
So far, I have tried:
Making the font in the list larger.
Formatting larger font size in the active cell with the drop-down button
And, creating the list on the same worksheet.
All three remedies have not increased the size of the font in the drop-down
Suggestions are welcome.
There is n...Could very much use a Field List
I apologize if this is out there already, but it seems that at least a few
field names changed from 1.2 to 1.3. Although I had downloaded a field list
before, from here, I cannot even find that original post, let alone any more
recent that might contain the correct field names.
I need to do some custom SQL and would prefer not to reinvent the wheel.
Thanks in advance very much to anyone who could help.
Do you have MS Access? Make a new project and attach to the database as
your data source.
You will be able to see all the tables and the field names. It has been ...List details in another sheet
Hi, I have a sheet "Data" with transactions by customer. Column A has
the Customer ID. In another sheet called "By Customer", the user
selects from a drop down a Customer ID, and clicks a button. What I
want for this button is to run a macro to get in a 3rd sheet,
"Transactions", columns B, C, D and E from the Data sheet, for the
selected customer ID. Is that possible? Can somebody help?
"Chechu" <cecichi9@hotma...About FRx 6.7 for Great Plains 8.0
"Table Failed to Open" has been prompted after generating the report even I
was using the sample provided.
How could it be solved?
This sounds like a connection problem with your database(s), maybe both the
samples andd/or your live GP data.
Are you able to quickly perform a "dump" of the chart of accounts in a new
Steps = New Row Format >> Edit >> Add Rows from chart of accounts
You may also want to check your settings under:
Company >> Information and confirm that your ODBC settings are correct ( or
pervasive if you are ...List number of permutations for text nums
I've got 4 digit text nums in A1 down
In B1 down, I would like to list the corresponding number of permutations,
Game for any formula, udf or other vba solution
Thanks for insights
Dim I As Integer, J As Integer, Rng As Integer
Rng =3D Cells(Rows.Count, "B").End(xlUp).Row
J =3D 1
Do Until ActiveCell.Value =3D ""
For I =3D 1 To Rng
Cells(J, "D").Value =3D "'" & ActiveCell & Cells(I, &qu...List of kernel mode compatible functions
Is there a list of kernel mode compatible C/C++ functions (preferably for
Wouldn't that be the WDK Help file?
Thomas F. Divine
"Jan M" <email@example.com> wrote in message
> Is there a list of kernel mode compatible C/C++ functions (preferably for
> WDK 7600)?
Your right of course. I just didnt look hard enough.
...List Box no displaying added choices
I have several drop-down list boxes in a few forms that I am having trouble
with. When I originally set up the database, I created the tables and
entered a few items to be included in the drop down list in the lookup
section of the table (design view). I then created the forms and inserted
those fields. I have since added several new choices to the drop-down list
of the table, and those new selections are available in the Table, but they
are not available in the Form. The only items available in the drop down
list on the Form are those choices that were originally there when I set up
the fo...when i am in the window to choose a folder to export none are list
I want to export my contacts to an excel file. When I am in the window to
choose a folder to export, there are no folders to click on.
What version of Outlook are you using?
Does anything show in that pane of the Import/Export Wizard?
"outlook export files" <outlook export firstname.lastname@example.org>
wrote in message news:17414043-FCB0-4C02-8ABF-C5288395157F@microsoft.com...
>I want to export my contacts to an excel file. When I am in the window to
> choose a folder to export, there are no folders to click on.
...Import contacts from Public Folder into Address List
we had an Address List that mysteriously disappeared. I have been able to
restore its contents into a Public Folder of the same name as it was
published as such. Now I have a Public Folder full on contacts but I need to
move them back to the Address List which has been recreated but is now empty.
Does amyone know how I may go about this?
Sorry, we are running Exchange 2003 Standard.
> we had an Address List that mysteriously disappeared. I have been able to
> restore its contents into a Public Folder of the same name as i...Contacts List Closes Outlook
A user in our company recent found that when using the
Contacts, as soon as he scrolls down the program locks up
and closes without warning or any dialog box. Any Ideas?
...Delete drop down list
I see instructions for creating drop down lists, but not for deleting them. I
have a list that is no longer useful and would like to delete it from the
worksheet (To clarify: I am talking about removing the list from the list of
list names that appears when using the F3 key)
Select the range.
From menu Data>Validation>Select 'Any value'
If you dont have data in those cells from menu Edit>Clear>All
> I see instructions for creating drop down lists, but not for deleting them. I
> have a l...Personal To do List
In creating an entry for the Personal To Do list, allow assingment of item to
a User Class/group rather than to a single user ID in the Target to do list
This way reminders can be set for select group rather than to all who have
...Extracting records from a list
I would like to extract records from a long list of 500 rows.
The list is already sorted by the first column. There is a maximum of four
possible values for the first column with multiple values for the other ones.
I would like to create four different lists, each with only one of the
possible value in its first column by extracting them from the "master" list.
Any help or pointer will be gratefully appreciated.
Here is some very simple generic code
Set SourceSht = Sheets("Sheet1")
Set DestSht = Sheets("Sheet1")
I have a list that has been created by using the validation too
Is it possible that when someone wants to choose something from th
list they could say type the first few words and it would automaticall
I.e you type "holi" or atleast part of the word and the cell shows th
Message posted from http://www.ExcelForum.com
Data Validation doesn't include the autocomplete feature. You can type
the entire entry, scroll through the dropdown list, or use keyboard
(arrow keys, page up, page down) to navigate th...Simple drop down list validation
I have two lists on one sheet, (Data), Services & Price.
In another sheet, (Invoice), I am using a drop down list for services,
and when a service is selected I would like it to automatically fill in
the price column.
I thought it would be simple but I seem to be getting the formula
wrong, can you help?
It always helps if you can give exact cell references where your data
is located, but in the absence of that it will be something like:
in B1 of your Invoice sheet. Assumes data occupies A1:B100 of Data
sheet...Outlook Express Address list Panel
Hi is there any way fix crack etc to get the list off email address,s to
show down in the bottom left corner The way you could in Outlook Express You
could then just double click on and address to send a new email Simple.
I really hate Windows Live Mail.
A: No. B: So do I.
Imperial Beach, CA
"Ronnie Mackay" <email@example.com> wrote in message
> Hi is there any way fix crack etc to get the list off email address,s to
> s...add public folder calendar to multiple user accounts favorite calendar list. 06-22-10
i need to add a public folder calendar to multiple user accounts
"favorites" calendar list (shows as other calendars) in outlook 2007.
i know, from outlook, you can right click and add to favorite to add
it to an individual user's "other calendars" but i need to do this for
a group of people. is there any way in exchange, gpo, or something to
do this automatically based on group membership, etc.? thanks in
...List records that do not include specified value
I have a very basic select query that list all the records from a table
SELECT tbl_cngu.cngu_no, tbl_cngu_recalls.recall_no
FROM tbl_cngu LEFT JOIN tbl_cngu_recalls ON tbl_cngu.cngu_no =
ORDER BY tbl_cngu.cngu_no, tbl_cngu_recalls.recall_no DESC;
Now I need to apply a twist and do no know how.
The [recall_no] field is a numeric field 1,2,3,4,5,... and what I would like
to do is supply the query with a [recall_no] value and have the query return
those records for which there is no such [recall_no] for a each given
[cngu_no]. How would I do this?
T...Populating a list box
I am trying to populate a list box with data from an Access table. I added
the list box field to a Great Plains form (and to the VB project) and am
trying to get the VBA code to work. The code to open the Access table works
fine but the AddItem method code bombs and returns Run-time error 438. Object
doesn't support this property or method. Here's the code:
Do Until rstSalAdjCode.EOF
cboReason.AddItem (rstSalAdjCode(0)) 'Code bombs on this line
Anyone know what I'm doing wrong here?
You cannot add items to a gplist bo...