How to write networking code in VBA?
I am quite familiar with BSD networking API. But I don't know the first
thing about network programming in VBA. I've done a Google search, and I
will continue to do so. But so far, I have not found a concrete example
(that I can access). I would very much appreciate some hand-holding.
Here is what I want to do in a macro. It's really very rudimentary.
on error goto done
connect(TCP) to ipAddress:portNumber
for each line (read from a file or otherwise provided by the macro)
send line (terminated by \r\n on the wire)
recv response (one line terminated by \r...zz report
Can I re-print the z and zz report? if I can't where can I find the
information that I need from last month sales.
Manager | Journal | View | Select the batch you need your Z report, hit end
on your keyboard. Should take you right to the Z report for the batch you
selected. You can use the same procedure from the journal in POS.
"Jose" <Jose@discussions.microsoft.com> wrote in message
> Can I re-print the z and zz report? if I can't where can I find the
> information tha...worker thread #3
Could I get a comment on the following thread function and start of thread?
Is there anything that is incorrect? I'm trying to use two audio buffers for
the first time, and this is also the most I've ever attempted to use a worker
thread and event. My audio is playing back all chopped up, and I am
suspecting that there's something I need to know about handling the thread.
UINT AudioStream(LPVOID pParam)
CAudioFile* audiofile = (CAudioFile*)pParam;
I seem to have a glitch on my new worksheet
when I select a drop dowbn cell, or click a check box, or just press enter
my sheet jumps to cells higher up, sometimes foating imagionary cells over
the top of true ones,
Only doing it on this speadsheet, though not old ones
...Problem in MS CRM 4.0 with Expand/Collapse on a SSRS 2008 report
I'm working on a SSRS report wich is deployed in a IFRAME in MS CRM 4.0. The
deployement works, the report is available in the IFRAME.
I have two linked problems, in my opinion:
The function Expand/Collapse works in SSRS, but not in my CRM's IFRAME.
The report contains parameters. Changing their values doesn't work in MS
CRM, but do work in SSRS viewer and in the report manager.
In my CRM report, I see the '+' (for expanding), and when I click on it, the
page is reloaded, but nothing changes (it didn't expand).
When I try to view a CRM report [using SQL Server 2005 Reporting services],
the following error is displayed:
"You do not have sufficient privileges to view this report. Contact your
I would really appreciate if someone can provide guidance in resolving this
How are you running your environment in terms of identities of AppPools for
CRM and Reporting.
You find that you need to give the appPool acocunt permissions within
Goto the Report Manager and check the permissions for your CRM reports. It
may not ...How to create org chart from excel file with reports to column
How do I create an organization chart from an excel file that has a "reports
to" column. The "reports to" column indicates the hierarchy of who reports
How to generate a report with print preview and print commands? I
believe there is no built-in class to generate reports. I would like to
generate a report from my application, which reads data from a flat
Thanks in advance.
...Open Report with selective criteria
I have a database and i want to create a report where I can choose from a
list of names from a dropdown menu and when I choose the list of names it
will go the report for just that name which I choose. I dont know if I
should do this as an event property or a code? How would I go about doing
On Wed, 28 Nov 2007 06:55:02 -0800, rzwlkr33 wrote:
> I have a database and i want to create a report where I can choose from a
> list of names from a dropdown menu and when I choose the list of names it
> will go the report for just that name which I choose. I dont know if I
&g...Diagnostic-Code: smtp; 4.4.1 Did not receive the expected protocol response.
We are able to send and receive emails to any domain except one domain. When
someone from this particular domain replys to one of our emails or trys to
send us an new email message their Exchange server returns the following
Reporting-MTA: dns; mail.movgal.com
Diagnostic-Code: smtp; 4.4.1 Did not receive the expected protocol response.
***The body of that message contains****
This is a delivery status notification, automatically generated by MTA
mail.movgal.com on Sun, 05 De...Excel Function help needed please!
I have an Excel spreadsheet with several worksheets from which I need
to compare values from several columns in sheet one to a single column
in sheet two, and return the value contained within one cell (a
"title" at the top of the column)in sheet one to an adjacent cell to
the original value cell within sheet two. Can anyone help me to
figure this one out?
try the following:
- sheet one has a heading row (row 1) and consists of columns A:F
- sheet two has its data stored in column A (starting in row 1) and you
want to place the column heading of the matchin...Adding extender fields other than strings to reports
I have found 2 TK's on adding extender fields to SOP reports, but I have
Date, list and checkbox fields, but no way of adding these fields to
Dynamics. Is this possible?
kb 898983 seems to be correct to me but the author of both of these is the
"Extender" guru of the team so she'd know which is the better.
But as a Dexterity developer I thinking the above looks ok.
So that said, how will this help you? Well maybe it will and maybe it
won't. It depends on how eOne coded their function. Though this data is
not string data, you'll want to still use the rw_Tab...Crystal Reports 8.5 Edition
For MSCRM v1.0, which edition of Crystal Reports 8.5 will suffice?
Standard, Professional, or Developer? Is there an edition that will NOT
work with MSCRM's Crystal Enhancements?
Online Business Software Portal
You will need Professional or Developer.
>> Other Microsoft CRM Online Forum Resources:
>For MSCRM v1.0, which edition of Crystal Reports 8.5 will
>Standard, Professional, or Developer? Is there an
edition that will NOT
>work with MSC...EARN $12 Per Page URGENTLY REQUIRED 350+ ONLINE WORKERS
An established term paper writing service is looking to expand and
hire new writers. We take on assignments on all subjects, so we're
looking for people with specialized knowledge, but who can also branch
out of their comfort zone. Writers will need to follow instructions
and produce clean, plagiarism-free copy on deadline. Editing positions
are also available. To REGISTER ......CLICK on the IMAGE which is
BELOW the SEARCH BOX? http://www.earnonlinemoney.suisse.st/
...GP Detailed Trial Balance Report
Hello all, we are getting some strange numbers from the trial balance detail
report.. Here is what's happening.
we do a section or accounts and by date select just posting accounts and
the report then shows only 2 decimal places so for instance an account was
posted with a credit value of 144.702 and a debit of 1281.96 which if you
calculate gives you a value of 1137.258 which great plains in the account
number footer shows as 1137.25 for the net change. On the the report total
for net change GP shows 133,964.83. when you actually calculate the total of
net change am...merging spreadsheet with reports
I'm a teacher who uses an Excel spreadsheet to average
grades. I'd like to merge each students row of grades and
average into a Progress Report in Word. Do I need an
object link and a mail merge or what?
You could do a main merge in Word. Set up your table in Excel with a
heading in each column, and rows of student data below, with no blank rows.
In Word, set up your report, then use the Mail Merge wizard to connect
to Excel. Add the fields to the report (e.g. Name, Score1, etc.), and
merge the document with the list.
Sherry McAllister wrote:
> I'm a teacher who use...worker declines task, manager accepts it, but worker still is assigned to the task
I have a problem with declining tasks. I try to do it as described in
"Microsoft Office Project Server 2003 Project Managers Guide".
Worker (resource) logs into Project Web Access, enters "tasks" tab.
There he chooses one task and clicks "decline". Then manager logs
into Project Web Access and enters "updates" tab. In this tab he
to accept this change, then clicks "update" button. MS Project starts
and opens the project. According to documentation, in this moment
the change which is just being accepted should be incorp...This formula needs help
have added information on my web page www.mykaltx.com to help.
I got some great input from some of the other users.
I appreciate all the help.
The spreadsheet is now able to calculate the weight of steel beams
pipe, angle channel and plate.
What I need now is for it to calculate the weight of a trapezoid. Th
spreadsheet will have to use the weight for plate. The kicker is i
will have to calculate the weight for plate the top width the botto
width and the length as well.
If you have any ideas let me know.
Also I am not that great at explaining myself. Let me know if I need t
I ...Column Header that moves with Data?
Does anyone know if it is possible, and if so how to have a colum
header move with the data?
I have a sheet with a ton of data and the list is growing, I would lik
to see the column header "float" with the list instead of having t
scroll to the top and check it out.
thanks for all help
Message posted from http://www.ExcelForum.com
if i'm understanding correctly -
click in cell A2 and choose windows / freeze panes
to undo it choose window / unfreeze panes
"wendellarina >" <<firstname.lastname@example.org> wrote in
mess...I need help with Excel formula
I need help with Excel formula (first one is correct but I don't know how to
add second formula)?
=IF('1'!W16="($E20>2000000,0,IF($E20>100… =""AB8",'1'!W16) or
On Sat, 26 Dec 2009 06:31:01 -0800, antoinette <email@example.com> wrote:
>I need help with Excel formula (first one is correct but I don't know how to
>add second formula)?
>=IF('1'!W16="($E20>2000000,0,IF($E20>100� =""AB8"...Laying out a Report
I have a database with two tables called Fillers and issues linked. I want to
make a report on issues under two different sections of the filler.
Model = 6000 S/N 235 J/N 12 Date started Date complete
Date Part issue drawing issue bill of material issue assingned to plan
Date Part issue drawing issue bill of material issue assingned to plan
Any suggestions would be appreciated
What field is linking Fillers and issues?
It looks like you want two records from issuses for every filler record. Is
this correct? If so, h...I need printing help
I recently upgraded to Outlook 2003 from Outlook XP. I used to be able to
select a group of Notes for printing and then defined a print style with a
custom header and footer. I used to be able to print all the items with
each item starting right after the previous item -- not with each item
starting on a separate page.
Now when I try to print multiple notes the print option for printing each
item on a new page is selected and grayed out. I can't turn the option off.
What's curious, though, is I can get the Print Preview to present that way
by plaing around with differnet sequence...Static Library : How to share code with other developers ??
I want to share som classes with other developers working on a big project.
I dont want to share the source code, so I'm trying to use a static library.
The Problem now, I have to share the *.h files. They are normaly in a
directoy wich is not shared. I dont want to copy the *.h files to another
lokation. It would be the best to generate one *.lib file, where all my
classes i need to share are in. I also dont want to change my classes,
because they are used in other projects. Is it possible to use "precompiled
headers" ? Can anyone tell me what the easiest way is to share ...need field and file info on reported field information in reports
I need to find out were the data(file and field) for the following report
fields are in the Sql database. If they are calculated, info on which fields
and file would be helpful
Report Field Report
Total sales Monthly Sales Report
Profit Monthly Sales report
Account receivable balance Accounts Receivable Detailed rpt
Sales Tax Actual Sales Tax Analysis
Sales Tax exempt ...post code / zip code search
I have a form based on a query that lets me seach customer by post
The code i use on the field i type the post code in is
Me!PostCodeSearch.SelStart = Len(Me.PostCodeSearch)
Some of our post codes in our database have a space in them and some
do not, my current code does not let me search with a space in it. if
i press the space bar is just does not accept it
How do i wrtite the code to i can have a space it it like ST14 5GH
and not like ST145GH
Or a away by query will search for postcodes with or without a space