Is it possible to import a Form with VBA onto a GP system that isn't
registered for Customization Site Enabler or Modifier? From my
understanding, I don't believe that you can, but was wondering if there was
some kind of workaround to get a Form with VBA imported.
Thanks in advance!
No there isn't a workaround. If you don't have either of these, VBA is not
initialized and it won't import.
This posting is provided "AS IS" with no warranties, and confers no rights.
"danrose03" <firstname.lastname@example.org> ...simpleType Question
Is this correct?
I am representing my database in an XML schema, but I am not just naming an
element=database field. But some of my IDs (i.e. USER_ID, and PROFILE_ID)
are not the same length in numbers. They are defined in the database as
NUMBERPS(2,0), NUMBERPS(3,0),...,NUMBERPS(8,0). Therefore in my complexTypes
should my ID/Identity fields use a simpleType with the limiting facets.
<xs:element name="app_id" type="id4" />
<xs:element name="enabled_ind"...Query Question 01-29-10
If the field 2ndCompany is "True" then "#" if not " "
This is not quite working as all Clients are getting a "#"
2ndCompAlert1: IIf(Not IsNull([2ndCompany]),"#")
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3
If 2ndCompany is a Boolean (Yes/No) data type:
If it’s a text data type with a value 'True':
2ndCompAlert1: IIf([2ndCompany] = "True","#&quo...Cryptic question
I apologize for not being more descriptive in my first
question money would not copy to CD. I was trying to put
the file not money itself onto CD. What I would like to
do is put the file to CD and then run money off to CD. I
hope I'm wording this right as I am new to computers. It
will not copy to a floppy disk neither. But it backs up
just fine to CD
...Formula Question #6
I have a spreadsheet the contains different locations and students that
have either passed or failed a test. Columns c2-c146 contain the name
of the students location and columns d2-d146 contain the words pass or
fail. I can do a formula for counting the number a student at a
location or how many passed or failed. I used
=COUNTIF(C2:C146,"Bennettsville") for counting how many students at
that location and =COUNTIF(D2:D146,"Pass") for counting students that
passed from every location. I want to combine them to find out how
many passed or failed at a given location.
Sugg...Invoice Form Question
I've created an Invoice form which seems to work pretty well for creating
invoices, but now the Office folks would like to add some functionality.
Right now, we track our orders by Order Number. The Order Entry table
includes information that is unique to the order as a whole. There is also
an associated Order Details table which includes information specific the
line item for a specific order. The Part Numbers table includes information
that is standard to the Part Number. Right now the Invoice information is
included on the Order Entry table. My thinking was that the relatio...Making a shopping list
This was posted by a friend in another forum.
Please can someone format a a table in excel for me. I need a tabl
that displays a list of items that i can enter a number in a colum nex
to an item, this would then generate another table that i could the
print showing only the items i have have selected and the qauntity. i
like a shopping list from a supermarket .
It's really anniying me that I can't work it out, as it seems very ver
simple to do
EARTHWALKER's Profile: http://www.excelforum.com/...quicker entry of list rows
If a cell within a list contains a formula, when a add a new row to the list
#I typically want the formula copied to the new row. While this is not hard
to do it gets repetitive.
I'd like either for Excel to auto-copy formulae when entering a new row
within a list or to have an option to choose columns within a list that are
to be auto-copied.
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 the button, foll...Deleted Server still appears in MTA queue list
Hi all, I recently deleted a server from our 5.5 Org. This went fine but we
notice that that server still appears in the drop down list when you check
the MTA queues. No mail is in the queue for the deleted server but I was
wondering if anyone knew why it might still be appearing there and if it can
be removed from the list somehow. Thanks.
On Wed, 4 May 2005 10:40:02 -0700, Thorin Miley
>Hi all, I recently deleted a server from our 5.5 Org. This went fine but we
>notice that that server still appears in the drop down list w...Dlookup Question
I have a form that needs to look up a "goal" by matching several fields in a
> table. I can't figure out how to do dlookup with multiple criteria
> Form = frmManualTaskDataEntry
> Table = tblMailCodeTasks
Here's what I have that doesn't work:
Private Sub cbxCompany_AfterUpdate()
Me![Goal] = DLookup("[Goal]", "tblMailC...RMS SO 2.0 Manager
On one of my RMS SO 2.0 Manager's computer I'm having a huge delay (about 5
minutes) before the Item list shows up (Database - Items). This only happens
on this one machine that's "directly" connected to the RMS server (no VPN
etc), while it's trying to bring up the Items List the SOMANAGER.EXE process
CPU Utilization stays at 99% and there is no network utilization/activity.
When I bring up an (all) Item List/Value report it doesn't take very long at
Has anybody else encountered this problem and knows of a potential solution?
I've already tried r...Case sensitivity question/problem
I have 2 modules that open the exact same recordset, but with different
queries, yet the queries are basically the exact same.
Anyway, my first module runs perfect. The second one errors on duplicate
value being inserted and I debugged and found out why:
If fld.Name = "PromoId" Then
If IsNull(fld.Value) Then
Promo = ""
Promo = fld.Value
This is the exact pice of code taken from both modules, no differences.
PromoID, with an uppercase D is the PK f...Postoffice Address List
Recently bought a laptop with XP professional with
Outlook 2003. Our company network has machines with
Outlook 2000 that use postoffice address list. I am no
longer receiving emails from other employees (I do
receive email from outside). Can postoffice address list
be used with XP? What should I do about this?
Thank you very much.
Talk to your mail admin at work - no one here knows what your work uses or
how to troubleshoot it.
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...Junk E-mail lists
We have IMF enabled on Exchange 2003 and the junk email can deliver to the
Outlook 2003 Junk folder without any problem. But one of our user currently
notice all junk are now going into her Inbox instead of the Junk folder,
after check, I found the following message appear when rebulid her Outlook
"Unable to add to the server Junk E-mail Lists, you are over the size
allowed on the server. The Junk Email Filter on the server will be disabled
until you Junk E-mail Lists have been reduced to the size allowed on the
But I cannot find any contents under the Outlook...how do I use color in drop down list in Excel
I am creating a drop down list with three items in it. I would like for each
item to have it's own color. Is this possible?
Not possible within the dropdown.
You can color the cell after the choice is made using Conditional
Gord Dibben MS Excel MVP
On Fri, 12 Mar 2010 09:39:02 -0800, TroyB <email@example.com> wrote:
>I am creating a drop down list with three items in it. I would like for each
>item to have it's own color. Is this possible?
...Exporting group of lists with direct and indirect relationships
I am looking to move an entire set of directly and indirectly related lists
from one sharepoint site to another.
If I export a list from one Sharepoint site to another, it brings over the
directly related lists, but not the indirectly related ones. Copying them
wholesale in Sharepoint Designer only brings over When copy them in
Sharepoint Designer, only brings over a couple of folders and a small number
of .aspx files - no data.
Any thoughts? Thanks in advance.
microsoft.public.access and microsoft.public.access.gettingstarted are
newgroups dedicated to answering questions ab...country list
I am trying to create a data validation list containing all countries. How
can I get such a list into Excel without actually having to type every
Thanks in advance
(remove nothere from email address if mailing direct)
"BigBloke" <BigBloke@discussions.microsoft.com> wrote in message
> Hi there,
> I am trying to create a data validation list containing all countries. How
> can I get such a list into Excel without actua...Distribution Lists not working
I recently had to reload Outlook 2000 and since that time
my distribution lists don't seem to work correctly. I
don't get any error messages nor do I get any
undeliverable mail messages but many people on the list
don't receive my email. When I delete and re-add all the
names it works fine. I have downes of lists with hundreds
of names each so that really isn't an ideal soultion.
Any help would be appreciated
Theres a limitation in the feature with outlook.
unfortunately If you put to many user in the distribution
list the list dosent work correctely. Im not sure exac...Public Folder + Global Address List
Is there any way to import the contacts and groups from the public folder on
exchange to the global address list and if so how?????
Ever Learning Net Admin
You would need to create them as contacts in AD for them to show in the
GAL - there's no drag and drop way.
Can probably script it to pick up from a PF, but probably easier to copy
them to a local Contacts folder in your PST, export to CSV. Can open the CSV
in Excel to make any changes. Then import to AD using a script. Look at
scripts in the TechNet Scripting Center - there may be one already.
(I'm sure someone will com...Is there a list of characters that Word considers equivalent on Fi
Word's Find will find "equivalent" characters. For example, a find for
straight quotes will also find curly quotes, and a find for a space will also
find a non-breaking space.
Where can I find a list of the characters that Word considers equivalent in
...Add an HP printer to your list of approved printers
My IT consultant and myself ran some tests and we agree to your conclusion
that our printer is indeed causing the problem, i.e., Great Plans to hang and
freeze up my whole sytem. He installed the HP LaserJet 4 driver on my
computer and so far so good. Unfortunately, I have printed some GP reports
and they print at a different fonts. I am afraid how my checks will look.
But I will cross the bridge when I get there. One other issue is what would
normally print on one page such as the Chart of Accounts, some sections would
overflow to the second page.
Would you please add the HP Lase...Listview/Treeview
I am trying to do a listview or treeview in Access 2003 that allows the
users to sort the entries using drag and drop.
It should work the way Internet Explorer handles its favorites or Windows
handles drag and drop in its Start Menu.
You can drag one entry in between others and the drop target is represented
by a line.
Is there a way to replicate the behaviour of sorting via drag and drop in
All I can do now (die to some help in the german group) is to drag one
element on top of another element but that makes sorting a mess. I need a
way to drag one element BETWEEN ...Nothing appears in Custom Recipients List
I'm running Exchange 2003 in a mixed 5.5 site. When I set up a new custom recipients list and check properties and Preview I see all the mailboxes and distribution groups that I want. However when the users look at the list from Outlook there are almost no entries. I get 3 of the 20 or so distribution lists and none of the users visible from Outlook. I've checked for errors in the event log around the RUS service but have found none. Does anyone know where I should be looking for a problem
When a member of the company sends a message to various
domains, he or she will recieve the following error
Your message did not reach some or all of the intended
Subject: E-mail black list
Sent: 8/16/2004 2:28 PM
The following recipient(s) could not be reached:
recipient@e-mail_address.com on 8/16/2004 2:28 PM
There was a SMTP communication problem with
the recipient's email server. Please contact your system
<our.server.org #5.5.0 smtp;554 denied by
Does anyone have any suggest...Data Validation with repeaters excluded from the source list
In sheet 1 I have data in Column A starting from row No 2 like :-
Now, the above list which is in column A will have its rows expanding. That
is today the data may be till Row 300 and tomorrow it will/might
increase to 500 and after some time it may go to even 2000 or so.Now many of
the records in column 1 are repeating. Like U may notice "Aw", "Rt" etc more
The "solution" I desire is in Sheet 2 Column C starting from Row 2, I want
to create a dropdown (validation list) based on the data in column A of