Showing results 1 to 25 of 500
Search took 8.03 seconds.
Search: Posts Made By: Wamphyri
Forum: Word, PowerPoint, Outlook, and Other Office Products 01-28-2013, 06:11 PM
Replies: 2
Views: 345
Posted By Wamphyri
Yes it is possible. From a quick look. Your...

Yes it is possible. From a quick look.

Your if strSubject should be.
If ((strSubject = "Fer-CARS-05") or (strSubject = "M10-898")) Then
Forum: Random Thoughts 09-14-2009, 11:04 AM
Replies: 8
Views: 1,056
Posted By Wamphyri
Which ADT system are you using? I know the...

Which ADT system are you using? I know the version of Meditech that we are using is like that. It's like stepping into the early 80's.
Forum: Database and Reporting 07-30-2009, 05:36 AM
Replies: 2
Views: 261
Posted By Wamphyri
Question Sending info from Sql 2000

I've got an SQL 2000 server (Server_S) and an application server (Server_A). The application on Server_A is a TCP listener expecting to receive either an XML formatted message or an HL7 formatted...
Forum: Word, PowerPoint, Outlook, and Other Office Products 03-20-2009, 12:27 PM
Replies: 2
Views: 1,089
Posted By Wamphyri
I haven't touched word vba in a some time but...

I haven't touched word vba in a some time but something along the lines of what's below might get you thinking in the right direction

Dim v As Long, lstring As String, p As Paragraph

For Each p...
Forum: Word, PowerPoint, Outlook, and Other Office Products 08-25-2008, 12:50 PM
Replies: 7
Views: 387
Posted By Wamphyri
Depends on how you plan on storing the data. ...

Depends on how you plan on storing the data. Access can likely store your data (obviously it is not the best DB to do so, but it could easily do it.)

Since I don't have any example of the data...
Forum: Word, PowerPoint, Outlook, and Other Office Products 03-04-2008, 11:49 AM
Replies: 2
Views: 246
Posted By Wamphyri
Nope, your not missing anything, but you might...

Nope, your not missing anything, but you might find the following thread of interest.

http://www.thescripts.com/forum/thread197392.html

There is a sample drag and drop database (I haven't tried...
Forum: Word, PowerPoint, Outlook, and Other Office Products 02-28-2008, 12:07 PM
Replies: 1
Views: 1,857
Posted By Wamphyri
I'm able to get it to work using...

I'm able to get it to work using SendaKey.SendaKey (vbCr).

I was able to get the Dos command to run the DIR command followed by a CR
Forum: Word, PowerPoint, Outlook, and Other Office Products 02-05-2008, 09:46 AM
Replies: 2
Views: 711
Posted By Wamphyri
You can try some basic error handling, to tell it...

You can try some basic error handling, to tell it to try again untill the page is ready.


Sub test()
On Error GoTo Catch
Dim ie As Object

Set ie =...
Forum: Word, PowerPoint, Outlook, and Other Office Products 01-28-2008, 08:35 AM
Replies: 1
Views: 213
Posted By Wamphyri
Then only thing I can think of off the top of my...

Then only thing I can think of off the top of my head is to link the filetype to Excel (which you already know how to do). Then in Excel's Personal.xls create an Event to check if Excel is trying to...
Forum: Excel 10-19-2007, 12:40 PM
Replies: 8
Views: 318
Posted By Wamphyri
Your problem is your IF..Then statements are...

Your problem is your IF..Then statements are actually IF..THEN..END IF statements.

So what you are really saying is

If CommandButton1.Enabled = False Then
CommandButton1.Enabled = True
End...
Forum: .NET Database and Reporting 09-28-2007, 12:16 PM
Replies: 2
Views: 292
Posted By Wamphyri
It would be interesting to see one of the access...

It would be interesting to see one of the access databases with this. Perhaps attaching a zipped new database that you've done this to.
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-28-2007, 12:04 PM
Replies: 2
Views: 3,695
Posted By Wamphyri
Not sure what it is exactly you want but you...

Not sure what it is exactly you want but you don't need to use all that code to get the output you are getting

Dim w As Integer
w = Weekday(Now, vbSaturday) - 1
MsgBox "DAYS BACK TILL SAT + " &...
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-27-2007, 01:41 PM
Replies: 2
Views: 259
Posted By Wamphyri
Assuming that your listbox has something similiar...

Assuming that your listbox has something similiar to www.xtremevbtalk.com as the text in the box. You can create a hyperlink and follow it on a user's click (or double click, whatever)


Private...
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-26-2007, 01:49 PM
Replies: 2
Views: 748
Posted By Wamphyri
What you are reading is .Net code. If you...

What you are reading is .Net code.

If you know how to get 1) the username and 2) the computer name (both of which are extremely easy to get, you can get the Full Name.


Set objUser =...
Forum: Excel 09-25-2007, 11:56 AM
Replies: 1
Views: 2,263
Posted By Wamphyri
Yes it is possible. How are you outputting it to...

Yes it is possible. How are you outputting it to the userform? If you are using one of the many table/grid controls, you can have the control sort it for you. Word can sort tables based on the the...
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-25-2007, 11:43 AM
Replies: 4
Views: 862
Posted By Wamphyri
Have you tried using MarkAllEntries rather than...

Have you tried using MarkAllEntries rather than MarkEntry?
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-21-2007, 01:11 PM
Replies: 2
Views: 1,261
Posted By Wamphyri
Since I haven't worked with Outlook for 4 years...

Since I haven't worked with Outlook for 4 years now, my knowledge of the Outlook Library is a little shaky. But you could try declaring myMail as Object rather than as a MailItem. That should work...
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-21-2007, 12:55 PM
Replies: 4
Views: 299
Posted By Wamphyri
Yes and no. Because you have a space in the...

Yes and no.

Because you have a space in the table name and the product number field you need to put square brackets around them [].

For example the Access SQL might look like this:

SELECT...
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-19-2007, 01:53 PM
Replies: 1
Views: 388
Posted By Wamphyri
Are you testing with the same file on all the PCs?

Are you testing with the same file on all the PCs?
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-19-2007, 01:48 PM
Replies: 4
Views: 299
Posted By Wamphyri
Its not too hard. A dynamic query could do...

Its not too hard.

A dynamic query could do this easily. I'll show you the basics below

SELECT Count(ProdMold.Mold) as ComMold
from ( SELECT ProdMold.Mold
FROM ProdMold
WHERE...
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-07-2007, 11:46 AM
Replies: 12
Views: 503
Posted By Wamphyri
Take a look at the following it should address...

Take a look at the following it should address all 3 issues

Sub ConvertLists()
Dim p As Long, i As Long, Listlevel As Long
Dim bBullet As Boolean, bPrev As Boolean
Dim sType As String, sTags As...
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-05-2007, 07:24 AM
Replies: 2
Views: 238
Posted By Wamphyri
Why do you have tblUserInformation in there?

Why do you have tblUserInformation in there?
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-05-2007, 07:00 AM
Replies: 12
Views: 503
Posted By Wamphyri
Same. Where are you putting the code? ...

Same.

Where are you putting the code? Because I used ThisDocument rather than actually opening a document and assigning it to a document variable (or using ActiveDocument). You need to put the...
Forum: Word, PowerPoint, Outlook, and Other Office Products 09-04-2007, 09:42 AM
Replies: 12
Views: 503
Posted By Wamphyri
yeah worked on your rtf. this is the output...

yeah worked on your rtf.

this is the output I get

<OL TYPE="1">
<LI>List Item 1

<OL TYPE="a">
<LI>Nested List Item 1
Forum: Word, PowerPoint, Outlook, and Other Office Products 08-30-2007, 10:55 AM
Replies: 12
Views: 503
Posted By Wamphyri
I took a different path than your original code,...

I took a different path than your original code, since it had difficulties with extremely nested lists. You'll have to change my debug.print statements into useful output statements but it should be...
Showing results 1 to 25 of 500

 
Forum Jump
Advertisement:



Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe