Please help. Question about querying a subform
I asked this yesterday and see all kinds of questions around me being
answered and suppose i just did not word this correctly.
I have a table of lab results. It is related to my patient table. It is a
one-to-many relationship. I have a date field, which is the date of last
labs. I am trying to build a query that will pull only the most previous lab
from each patient, with the criteria of it having been more than 6 months
ago. I do not want to pull lab dates from 10 months ago, if there is one
within the last 6 months. This is for a Dr and it is a priority that I get
it d...Office apps won't open, report Office in use by another use
Operating System: Mac OS X 10.4 (Tiger)
A few days ago, our Office applications started showing the report that "An Office program is being used by "user." your installation exceeds the number of installations permitted by thelicense agreement. Click More Information to learn about Microsoft Office licensing."
But OFFICE ISN'T BEING USED BY ANYONE. All computers have been restarted to no avail. HELP!
> A few days ago, our Office applications started showing the report that
> "An Office p...Clustering question
Win2k3 domain, Exch 2003 w/sp2.
In an emergency can one cluster node hold two EVS(s)? Or will only one
start up? Any docs. to back it up?
P.S.: I wrote an iTunes podcast tutorial and just want to publicize it.
You can find it at: http://www.nikoli.net/itunepod
Active/Active clusters in a 2-node configuration - when one node fails the
other can host 2 EVSes.
MVP - Exchange
NEW blog location:
"Clayton Sutton" <email@example.com> wrote in...Outlook 2007 question
We have had an issue when we set a user to change password at next logon
that it causes them to lose their settiings - they have to complete the
Outlook wizard to configure the mailbox etc.
Do the loose the settings just for Outlook or do they loose all the settings
for the profile also?
> Outlook 2007
> We have had an issue when we set a user to change password at next logon
> that it causes them to lose their settiings - they have to complete the
> Outlook wizard to configure the mailbox etc.
...my first question
hi friend...am new to this group....currently am doing Mtech in MIT,
chennai. I want to know details regarding compression technique for my
final year project......
1, I want to know any available content based compression
content based in the sense...want to consider text,
numeric and special characters as separate.......not audio and
"lin" <firstname.lastname@example.org> wrote in message
> hi friend...am new to this group....My report contains multiple copies of each record
I have three tables (parent/guardian, children, otheradults). that are all
related with left joins (i.e. Include ALL records from 'Parent/Guardian' and
only those records from 'Adults' where the joined fields are equal.) by
ContactID (which is the parent/guardian ID) same for children.
I created a query called Family which successfully combined three queries of
each table where I combined the first and last names into one field.
When I create my report, it creates an entry for EACH child rather than
listing the children and related adults under Parent/Guardia...How to update one form when closing another ?
I have two forms open.
frmPeople has the Focus
frmAccount does not.
frmAccount has subFormPeopleList
I add a new person to frmPeople (which is linked to frmAccount)
When I close frmPeople I want to update frmAccount so the new person
shows in subFormPeopleList
But I'm also wondering if I add code to the "close event" for
frmPeople to update frmAccount
What will this do if frmAccount is not open? Will it add the person
twice? I'm guessing not as updating a form doesn't really add data to
the table... right?
Thanks for any help.
Thanks...Windows xp updates question
When I try to update Windows XP IE will not load page. It's as if the page
didn't exist. I go click on 'Tools/Window Update' but the MS update page
will not be found.
How can I fix this?
> When I try to update Windows XP IE will not load page. It's as if
> the page didn't exist. I go click on 'Tools/Window Update' but the
> MS update page will not be found.
> How can I fix this?
Windows XP _____ Edition with Service Pack _ __-Bit?
Internet Explorer version _?
Assuming some 32-bit version of Windows XP...SumProduct with date and time
I have finally found that with my formulas the calulations are based
on the time. Can someone help me find the best way to correct this
without using macros to strip the time out of the data.
Bob 09/08/2007 01:05 13/08/2007 00:00 Bob
Bill 10/08/2007 23:39 Bill
Kyle 11/08/2007 07:36 Kyle
Bob 16/07/2007 20:39
Bill 27/07/2007 19:59
Kyle 18/07/2007 16:51
Bob 14/07/2007 16:31
Bill 21/06/2007 16:46
Kyle 30/06/2007 16:55
Bob 12/06/2007 01:05
Bill 13/06/2007 23:39 1 2 0 1 1
Kyle 14/06/2007 07:36 1 1 1 1 1
Bob 12/01/2007 20:39 1 1 2 0 1
Bill 13/08/2006 19:59
Kyle 14/05/1999 16:51
These are t...Another unclear e-learning question
The question is:
"If you were creating a culture of your own using the
CultureAndRegionInfoBuilder class, which value would you set for the
CultureAndRegionModifiers parameter ?"
In this question it's not quite clear if the question mean if a new culture
from scratch should be created or if
an existing culture should be changed.
If the question mean that a competely new culture from scratch than
alternative 1 or 2 should be used. Alternative 1 for a neutral culture and 2
for a specific culture.
If the question mean...Incoming mails from another external domain are lost
I have a Exchange Front-End & Back-End combination. Front-End Server also
has SMTP Relay server and Intelligent Message Filtering. Front-end server is
in a DMZ Zone. I have a pix firewall.
I got a peculiar problem. One user has complained me saying he has not
received a email sent from another company (external domain say xyz.com).
I have checked the server logs and the filtered spam emails. I could not see
any email from xyz.com in the server logs. Also the sender from xyz.com did
not receive any NDR for this mail also.
Can anybody help me on this?
Is the...View Customization Question
My director came to me the other day and asked about customizing his view of
his accounts. He had two requests. I figured out the first one, but I'm
having a little trouble figuring out if he can do the second one.
When he opens up a single account, instead of it opening automatically to
the Information section, he would like it to automatically open to the
Help is much appreciated!
You can make a new tab pn Account form (contact view and make it the
first one on account form).
Now you use Iframe . you can get idea from here
http://icu-mscrm.blogspot....standard color dialog box inside another dialog box
does anybody know if it is possible to place a standard color dialog
box inside another dialog box?
I'm using the MFC library.
Any snippets of code are welcomed.
...OLE Object Data Type Question
Hi, a friend of mine supports a very simple Access 2000 database for keeping
tracks of his .JPG file. The database has a table with several field, and
one of them is of OLE Object data typy. He opens that table, rightclicks OLE
Object field, selects Insert Oject and creates a link to a .JPG file. After
finishing insertion the OLE Object field contains kind of "MSPicture3" or
"MSImage3" (I don't remember exactly the text).
Before a month ago he moved his database to another computer and now after
insertion into the OLE Object field a link, it contains "...Question on Attachment
I want Attachment field below Subject field
When i attach any file or folder the attachment should
shown below subject as a seprate field like subject or Bcc
Which version of OL are you using? This works in OL2000.
Try changing the message format from "Rich Text" to "HTML"
or "Plain text." This works for me but not every one likes
receiving HTML emails. I use strictly plain text. To get
at this setting go to Tools, Options then click "Mail
>I want Attachment field below Subject field
>When ...Week starts on Friday
I have created a calculated field that is supposed to specify the week a job
occurred. The week starts on Friday and goes through the following Thursday.
My calculated field looks like this:
WorkPeriod: Format(DateAdd("d",-1*(DatePart("w",[Ticket Date])+1),[Ticket
Date]),"mmm dd""/""yy") & " - " &
It returns a period formatted as: Dec 04/09 - Dec 10/09 (for e...Getting started with GP10.0
So, now I've installed it, what do I do?
If I open the application, I get a list of servers (means nothing to me) and
a username and password box. Again, I haven't a clue what I could put in here.
Is this software supposed to be for lay-people? It seems horribly complex if
you're not a programmer.
Where is your reseller? You need a good VAR to help you implement this
product. I don't know of any product in the price range of Dynamics GP
that is "super-friendly" the first time you use it. A good rule of the
thumb: more functionality = more complexity.
Japhe...searching for a given record
I have to think there is a very easy way to do this, but I've been
struggling for a couple of days now and I could use some help.
All I want to do is search for a particular record using a form. I
don't want my users to have to right click and even think about
filters or anything like that. I want them to be able to type in a
partial name and press a button on the form and have the matching
records pulled into the form.
What's the best way to accomplish this?
Open the relevant form in design mode and make some room in the form's
header. With the wizards enabled, draw ...Outlook 2000 Error 550 Sender verify failed
We have one machine on our network that cannot send mail for some reason.
Everytime this machine attempts to send mail using Outlook 2000 it fails,
reporting the following error:
"The message could not be sent because one of the recipients was rejected by
the server. Server response: '550 Sender verify failed'. (Account: 'Fred',
smtp server: 'relay.clara.net', error number: 0x8000ccc79)."
It is not a simple matter of setting the authentication on the outgoing mail
server, as all the other machines on the network (also using Outlook 2000)
do...Java vs. C++ (Date class)
I'm porting some Java code into C++. Which class I should use instead Date
class? Note that Date support miliseconds.
Also, which class I should use instead of Vector class? std::vector?
"Petar Popara" <email@example.com> wrote in message
> I'm porting some Java code into C++. Which class I should use instead Date
> class? Note that Date support miliseconds.
Oh dear. Both the Java and the C++ date classes do assorted odd things with
time zones and "daylight saving"; neither is documented fully or ...how to create a calendar to select a date in access 2007
I want to select a date from a pop up calendar on the form.
Access 2007 automatically adds a date picker to a Date/Time field.
MCP, MOS, MCAS
> I want to select a date from a pop up calendar on the form.
...RMS Database Questions
We are working on a RMS project with some customization for data extraction
and reporting. The data extraction and reporting mandates maximum number of
characters for certain fields, such as ItemLookupCode, which cannot excede
14 characters. We are evaluating some of the possible options to meet this
requirement. One of the possible solutions appears to be changing the field
lengths in the RMS database tables. We have the following questions and
appreciate your help if you have any answer for us.
a) Is this a viable option?
b) Can you resize any or all the columns?
c) Can you extend...Creation date
I would like a way to insert the creation date of worksheet, not the creation
date of the template.
Thank you in Advance
Merci a l'Avance
you'll need VBA for this. Find below a UDF for this task:
Public Function Get_Creation_date() As Date
Enter the following in your target cell:
and format the result as date
Martin Racette wrote:
> I would like a way to insert the creation d...Outlook starting problem
"Cannot start Microsoft Outlook. A dialog box is open.
Close it and try again."
...Help: Can I change the date formula from mm/dd/yyyy to "mmm-yy" et
If the date was input as mm/dd/yyyy (12/31/2004), can I convert the format
to "yyyy-mm-dd"(2004-12-31) or "mmm-yy"(Dec-2004)? i tried to change date
format from "Format Cells-- Number tab--Category--choose "date" or "custom"
but just failed.
While Strangely, If i imput the data as "2004-12-31", i can change it to
whatever date format i like.
Appreicate your advice at earliest convenience.
sounds like your imported dates are not recognised as 'date' values but are
stored as 'Text&...