When I run the code below I get "External table is not in the expected
format" error at line rsData.Open sSQL, sConnect, adOpenForwardOnly,
Public Sub SelectFromAccess()
Dim rsData As ADODB.Recordset
Dim sPath As String
Dim sConnect As String
Dim sSQL As String
'Clear the destination worksheet
'Get the database path (same as this workbook)
sPath = ThisWorkbook.Path
If Right$(sPath, 1) <> "\" Then sPath = sPath & "\"
'Create the connection s...Word text copied into email loses formatting alignment
When copying a Word document (containing indented and numbered paragraphs and
bullet points into an email, the left alignment of the document loses its
justification. How can this be fixed?
If the formatting is important, send the document as an attachment.
You have no control over how the recipient sees the email.
If you are concerned that the recipient might not have Word, use one of the
free pdf converters to convert the document into a .pdf file.
Hope this helps,
Doug Robbins - Word MVP
Please reply only to the newsgroups unless you wish to obtain my s...Dynamics 7.0 tables in SQL server 2000
I need to know what should be the content of each of the tables with names
starting with "GL" in SQL Server 2000 when using 7.0. Is there a reference
that I can go to in Customersource that tells me this information? Thanks.
There is an online reference: Tools >> Resource Descriptions >> Tables.
Also there is a SDK avaailable on the Great Plains CD's.
"Dave Christman" wrote:
> I need to know what should be the content of each of the tables with names
> starting with "GL" in SQL Server 2000 when...Maintain formatting of sub project when inserted into master proje
I'm using Project 2007. I have a master project and have inserted some
sub-projects into the master project. ('Link to project' was checked which is
what I want.)
I had applied formatting to the original sub-projects' gantt charts task
bars e.g. sub-project1 task bars were green, sub-project2 task bars were red
I found that this formatting was lost after inserting the sub-projects into
the master. The sub-projects assumed the formatting settings of the master.
Is there a way to maintain sub-project formatting?
In article <000A42E...Changes to the global template
Recently I had to start a new username because of some corrupted files. I
was able to save my documents.
However, everytime that I quit microsoft office a dialogue box appears and
"Word cannot save changes to the global template because it was opened with
read only access. Do you want to save the changes in a template with a
Initially I tried to save it, because I was afraid that the changes to my
document would not be saved. Now I click save, and the next dialogue box
"Microsoft Visual Basic"
"Run-Time errror "5995"
Word c...Conditional Formatting Equation Question
I am trying to get a Conditional Format to do something if there is
"NO" entry in A2.
Any ideas as to what this formula would look like?
Any help would be appreciated.
or, if by "NO" entry, you mean a blank cell:
>I am trying to get a Conditional Format to do something
if there is
>"NO" entry in A2.
>Any ideas as to what this formula would look like?
>Any help would be appreciated.
>...Tables/ queries question
I have a table for recording college attendances, some of the courses are at
Campus 1 and some are held at Campus 2. I've got a field for course code,
course anme and a check box to show if the student is at campus 1.
When I enter the student ID number into the form, at the moment the name of
the course comes up automatically in the text book, as I think it's reading
the information from another database on the system.
At the moment I've got a check box on the Form to enter manually into the
table whether the student is at Campus 1 or Campus 2. What I wondered is if...Creating an Excel table from Access
I have an Access database which I use to log downtime for systems. I have a
requirement to produce a monthly report based on this data, however, this
needs to be exported to excel in a specific format.
Down the left side of the report need to go the names of the services, with
the days (numerically like: 1, 2, 3 .. 29, 30 etc) across the top. Then I
need to count the number of times each service was down on a give day, and
insert that information into the necessary cell - so if intranet services
had been down twice on 16th March, for example, there would be a 2 in column
16, whi...Cannot insert explicit value for identity column in table x
Sql Server 2005 9.00.4035.
We have a hub and spoke topology which includes 6 tables with identity
I need to add a new subscription to a new server (same version/sp). I took
backup from another subscriber and restored to new server, ran snapshot, push
subscription. To make sure a new record would replicate, I added a record at
the publisher with the followig text:
Insert into tblicimagefolder (imagefolder) values ('dummy')
A conflict occurs with the following: This failure can be caused by a
constraint violation. Cannot insert explicit value for identity c...problem with pivot table
I am trying to make a pivot table from my date.
My data includes Names, Dates (which I formatted to month, "m" in the
format cells option)and Amount due.
In designing the pt, I have "Name" in the row field, "Date" in the
columnn field and "Amount due" in the Data field.
I want my data to be grouped as follows:
1 2 3 4
Name $100 $20 $30 $20
Instead I am getting more than 1 month column i.e.
1 1 2 2 2 3
Name $80 $20 $30 $20
Do you know why...Payroll w/h tables
When can we expect new payroll withholding tables for Ohio? In December our
gov announced a late year change repealing a prior payroll credit previously
announced. We have been told that the withholding tables are not correct yet
GP/Microsoft has not released new tables yet. When can these be expected
since we are practically done with January now???
According the information I have, there are no pending changes for OH. You
may need to contact Support about this issue.
Charles Allen, MVP
> When can we expect new payroll withh...Language change in outlook express
I cannot change th language to english in outlook express by defult it has
please help me how to change in options. i check all my regional settings
shows english(us) execpt in word and express.
nishkrish <firstname.lastname@example.org> wrote:
> I cannot change th language to english in outlook express by defult
> it has French.
Ask in an Outlook Express newsgroup.
Brian Tillman [MVP-Outlook]
Ask in the Outlook Express newsgroups
Outlook Express with IE7
http://www.microsoft.com/co...modify the Type of Field in a Table From another MDB through a Command button
Hello to all!
I hope can help me. By technical questions that would be to me very long to
explain, the following necessity arises to me:
I need To modify the Type of Field in a Table From another MDB through a
Command button. The field at issue would happen to be "Number" to "TEXT". Is
this possible one? I wait for alternatives.
Thanks in advance, and sorry for my poor english.
Is it not possible to open the other database and simply open the table in
design view and then change the field.
It seems very complex to do the codeing what will most pro...change direction of cursor after enter
In excel 2003, how do I change cause the cursor to go the next cell to
the right, rather than to go to the cell below? Thank you!
Tools > Options > Edit > Move selection after Enter > select Right.
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"duke" <email@example.com> wrote in message
> In excel 2003, how do I change cause the cursor to go the next cell to
> the right,...How-To: Last change date on row
When I set up a database I always include a last change date that auto
updates every time any field in the record changes. Does anyone have a
suggestion for how to achieve a similar function in a spreadsheet. i.e.
put the current date/time in a field in the row whenever anything in the
GGG's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29220
View this thread: http://www.excelforum.com/showthread.php?threadid=489447
For example, to put the last change date in...Stop running sum(Over All) when customer change
I hv report based on tblTransaction which contains many customers with their
transactions by date wise. I grouped report on CustomerID sub Group by
Fromat(trnDate,”MMM-YY”) to get monthly transactions for each customer. I
made calculated field to obtained closing balance with running sum over Group.
I want to make the Running sum – over all but when customers is changing it
must stop and start again, by default it will give running sum of all the
customer, exactly this I don’t want. Any idea to stopped or make running sum
based on customer when month is changing it ...How to change labels on a chart from numbers to words?
Can Someone Please help me? I can't figure out how to change the labels on my
chart in excel from numbers to words!
I'm not sure which labels you want to change to words, but maybe Jon
Peltier's charting tutorial will help you:
> Can Someone Please help me? I can't figure out how to change the labels on my
> chart in excel from numbers to words!
Excel FAQ, Tips & Book List
I suspect it's this page:
http://peltiertech.com/...conditional format #3
Fra: "Niels B�ge Egstrand" <firstname.lastname@example.org>
Emne: Re: Condition Formatting!
Dato: 2. november 2004 11:55
is it possibel to opperate with 9 different collors in conditional format ?
No, you get up to 3 formats under conditional formatting (plus the normal
If you need more formats, you could use some event macro.
"Niels B�ge Egstrand" wrote:
> Fra: "Niels B�ge Egstrand" <email@example.com>
> Emne: Re: Condition Formatting!
> Dato: 2. november 2004 11:55
> is it possibel to opperate with 9 different collors in...save formats of percentage when copying a chart
How do I keep the percentage format of data on a chart when I copy/move the
chart to another spreadsheet that does not have the original data in it?
...Batch Number Changed
I recently upgraded GP from Ver. 8 to 10. few days back i notices that around
800 SOP orders transfered to One batch. This Batch was not existing before.
system created the batch. How this could happen? i checked in the activity
tracking table, no clues from there.
...Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy
and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
user. my client want to know how to enable it. hope for your prompt action.
Only works for SQL 2005. If you client wants to use a beta database server...
> I'm curious why are the Change Password Next Login, Enforce Password Policy
> and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a
> user. my client want to know how to enab...display a number that is decimal degrees in Deg:min:sec format
How can I create a format to display a number that is in decimal degrees, in
In article <DD958DEA-4DE1-4C80-80D5-D959F720E452@microsoft.com>,
"Sterling" <Sterling@discussions.microsoft.com> wrote:
> How can I create a format to display a number that is in decimal degrees, in
...Help using Tables
I need some help. I have a table that has a percentage range. Like this.
Less than 90%
101...league table #4
Sorry peeps email is firstname.lastname@example.org
...change from SIZE ON DISK: 4:00kb
I am using publisher 2000. How can I can size on disk:
4:00KB into bigger number such as 16:00KB in "properties"
You can't. The file size is what it is because of the content. Why do you
want to change the file size? This won't help you to open it.
If you are getting an error message, that's a different story. Are you
running Norton Antivirus on your system?
MVP Microsoft [Publisher]
"nguyen" <email@example.com> wrote in message
>I am using ...