Creating a new field based on conditions
I have a database that tracks insurance information for our various vendors.
Each insurance type has 2 fields - a requirement field (yes/no), and an
effective field (some show an expiration date, some are yes/no). I have
created a query that will return only the records for which insurance is
required but is expired/missing. My problem is that I want to create a new
field that is calculated based on the values in the other two fields in order
to make the resulting report more user-friendly.
For example, if GLRequired is True and GLExpiration is <Now(), I want the
new field to say...parsing a date and time field #2
I am having trouble parsing the date and time in a field. I download
data from a data base and the date and time come together in one
field. I want to seperate the two. The date and time comes across as
the following: "2/1/2009 14:37" in the cell. When I parse it, it
seperates into three columns as follows: "2/1/2009", 2:37 AM", and
"PM" I can see what is going on but I would like to get two columns
with one as the date and the other as the correct time. are they any
ideas on how to address this?
Try using the TimeValue and DateValue functions.
First format ...How do I freeze or lock cells to show up on each page without typ.
I have a 4 page sheet. I have a header already. But I want to freeze the
cells that head up the first page. I've done it before in school but can't
remember what it is called or how to do it...that's why I'm doing this.
Anyway, I want these cells to print off on each new page without having to
type them on each page. I hope that makes sense and I hope that someone can
If you mean for printing do file>page setup>sheet and select rows to repeat
otherwise for viewing you can select a2 if the headers start in row 1 and do
window> freeze panes
...converting tabular structures in a Word document into an actual table or reading data from the tabular structures using VBA code
I have a macro which can read the last cell/column of all tables in a
Word 2003/2007 document and store the data in an MS-Access table. But,
some Word documents have the data in structures like a table format
but are not actually tables. The structure looks like a table, but the
table borders are actually line connectors. These documents were
created by a software(VeryPDF PDF to Word converter) which converted
the PDF documents(the original format these documents were) into Word
1. Is there a way I can convert/replace the tabular structures with
actual tables in Word so t...How do I convert a word table into an excel document?
I have managed to get the info accross no problem but the formatting is all
over the place. For instance - 07/10 meaning July 2010 is appearing as 07/Oct
despite me going into format cells custom then enter mm/yy which has always
You can't use it like that regardless of formatting, you need to put in the
whole date or else Excel will always assume the current year so any real
date used for calculations needs to be numeric and needs a day, so you can
enter (assuming US date format) 07/01/10 and use a custom format of mm/yy
or if you don't need it for...Insert,Update Data in sage (MS Access Linked tables) using Vb.net form
I am developing application using vb.net which requires integration with SAGE
LINE 50 (Accounting software ) V11... The data which SAGE is using is MC
ACCESS 2003 database... with linked tables in it... Now I Have developed the
Sage connection using ODBC which works fine when reading the record but
cannot Add or Update record into the Linked tables.... When i debug the
program the error is at the line where it has...
Can anybody Help ?????
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/acce...help with dynamic tables
This is a bit complicated to explain but I'll try my best. In columns A, B,
C I have different drop down lists. Column A has Store1, Store2, Store3,
etc. Column B has Dept1, Dept2, Dep3, etc. Column C has ProductA, ProductB,
ProductC. As of right now, these lists are not dependent on each other, I
can choose anything from any list regardless of the previous category. Also,
the length of these lists is undefined, meaning I will constantly be adding
to them in sequential rows below. And then columns D and beyond have data
such as Sales, Profits, # of items, etc.
What I...Publishing Layout and tables
Operating System: Mac OS X 10.6 (Snow Leopard)
I am trying to copy and paste text from one cell of a table to another cell in the same table. The document is in Publishing Layout. The paste command deletes the text in the destination cell and then places a big empty text box on top of the table. I do dozens of these documents that are primarily tables and graphics. Previously I used Publisher on my old PC. Should I go back, or can this be done in Word for the mac?
On 2010.01.29 8:44 AM, in article 59bb1ce2.-1@webcrossing.JaKIaxP2ac0,
"Toni_T@officefor...Extract text from field
If you have a filed that contatins the following data:LastName, FirstNameWhere LastName has varing lengths. Can you run an update query to obtain just the LastName part of the field? If so, what would be the command?Many, many thanks in advance. On Tue, 6 Mar 2007 14:09:45 -0500, "Mary M" <none@no_email.com> wrote:>If you have a filed that contatins the following data:>>LastName, FirstName>>Where LastName has varing lengths. Can you run an update query to obtain >just the LastName part of the field? If so, what would be the command?>>Many, many thanks in...CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report.
Report is using Quotes and Quote Products
I have a custom field in Quote Products which is a bit field Yes-No
When I use that field as a filter for report output, I get all records. The
filter criteria appears to be ignored
Is this an inherent problem with Report Wizard or Am I doing something
depends on your business logic and what you want to see.
If you have three quotes:
Quote-1 has three products, all with the custom field set to Yes
Q2 has three products, two set to Yes, 1 to No
Q3 has three products, all set...Investment Summary on Home Page
This is a multi-part message in MIME format.
Okay, I have had investments that I have sold completely within an =
account and purchased other investments. When I go to "My Money" home =
page, it will still show the old investment under the "Investment =
Summary", "Investment Performance" and "Best and Worst Performance" =
sections, along with the new investments. How can I clear out the old =
investments from...Page up and Page down
Is there any way the you can use Code to cause a form to do page up and page
down. I have a Long form that some of the information that is at the bottom
of the form is out of view and only use by certain people.
How can I have a botton on click go page down to the bottom and another
button that will return the form to the top of the form.
I know that you can use the keys to accomplish this but for appearance value
I would rather use a button on the form to accomplish this.
You can put a Page Break control on your form.
Then, code on the Click event of your button...Querying multiple records in two tables
Hi, in my database I have tables for users (UserID, UserName),
projects (ProjectID, Project Name), and qualifications (QualID,
QualName). I have join tables for users_qualifications (UserID,
QualID), and projects_qualifications. (ProjectID, QualID).
What I need to do is run a query for a project to show which users
have the exact matching qualificiations.
Users can have many qualifications, projects can require many
qualifications, users may only work on a project if the qualifications
required/held match exactly.
Assuming that ProjID, and QualID are numeric, the following sho...How do I print 4 postcards to one page to match my postcard paper
I bought perforated postcard paper that has 4 postcards per sheet. How do I
create that in Publisher? I created it exactly how I want it to look and
then realized it's only printing 2 per page.
Which version of Publisher are you using?
MVP Microsoft [Publisher]
How to ask a question
"Lauren" <Lauren@discussions.microsoft.com> wrote in message
>I bought perforated postcard paper that has 4 postcards per sheet. How do
>...reading and displaying memo fields
I got an ODBC database with a memo field. Now I use a CRecordSet in
VC6 to read the database with CLongBinary for the memo field. After
reading 18 fields he's out of memory.
Is there a way to use CString instead of CLongBinary, cause it's only
text in the memo fields (I already tried, but then I get an error
message that the database could not be read)? Or is there a way to
read all other fields first and only read the memo field when the user
choose a specific item in the database?
Thank you for helping me!
...IM error ADO field is nothing
I am trying to do an import for manual payroll checks. I have used the same
set up as is used in the sample but I recieve the above error. It also says
0 integrations failed.
I can't find anything in knowledgebase.
Thanks for any help.
Open IM, select your integration, double-click on Mappings. Click on the
Transactions collection, then click on the Options tab. You will want to make
sure the Record Source option rule is set to Use Source Recordset and that
the Source is set to your source query.
If the above is defined properly, then you will want to make sure you a...Reminder Time vs Due By Field
I'm using O2003. For a contact, there is the Due by Field. There is
also a Reminder Time field. If you update the Due By field, it updates
the Reminder Time field. However, if you update the Reminder Time
field, it does not update the Due By field. By default for a contact,
you have access to the Due By field. The Reminder field is avaialble,
but you have to manually add it.
In Tasks, it seems to work the same in that if you update the Due By
field, it updates the Reminder Time field. However, if you update the
Reminder Time field, it does not update the Due By field.
However, you have a...Report Filter focus
I am experiencing an issue with the report filters in RMS. It is not a
show stopper, but annoying.
When I launch a report in SO Manager on a win XP machine, RMS version
1.3, the report filter is there, but the correct field is not selected
and the filter under Filters is not selected. When this happens and I
want to change the filter, I first need to click on the Filter itself
in the bottom box and then select the correct field out of the Fields
list, then change the Value. Is there anything I can do to fix this?
To use a real report as an example, When I run the Detailed Sales
rep...How many pages can a booklet have?
Hi how many pages can a booklet have? Is there a limit to the pages in a
publisher booklet. Each page has three photos.
There is no limit, your RAM may decide for you. What version Publisher?
Mary Sauer MSFT MVP
"Verystumped" <Verystumped@discussions.microsoft.com> wrote in message
> Hi how many pages can a booklet have? Is there a limit to the pages in a
> publisher booklet. Each page has three photos.
...Field mapping for Appointments in filtered views
I’ve been looking at this for ages but cannot find the field for Contact for
an Appointment in the filtered views.
Regarding is dbo_FilteredAppointment.regardingobjectidname and is also in
dbo_FilteredActivityPointer.regardingobjectidname with a foreign key of
Optional seems to come from dbo_FilteredActivityParty.partyidname with a
foreign key of dbo_FilteredAppointment.activityid
Does any one know where the Contact for the Appointment get stored?
Also a link to a ER diagram for 3.0 or a mapping resource would help me from
unnecessary trawling throu...Link to Page when saving to web
I have some drawings that have several shapes with "Go to page on
double-click" behavior. How can I keep this functionality when saving as a
...Excel pivot table #2
i encountered an error in my pivot table.
i created an olap cube using the analysis manager.
the cube displays the correct data of my measures but on my
pivot report, it displays #N/A....
i need help to fix this one... thanks.... =)
...Tables in 2007
What are the advantages to converting a list to a table in 2007? Why does
the table have a name?
I did read in help that you can post a 2007 table to sharpoint services.
What does that mean?
Go to the excel help and type Tables then open the one that says Demo:
Organize your data by using an Excel table, and then in How to do it, click
on Overview of Excel Tables
if this helps please click yes, thanks
> What are the advantages to converting a list to a table in 2007? Why does
> the table have a name?
> I did read...Summarising per page
I have a worksheet that contains a list of numbers, and in printout is
more than 5 printed pages.
What I want is to summarise the list per printing page.
I want to do this for any printed page length (i.e. Letter, A4,) or
orientation (Portrait, Landscape).
Thanks in advance,
have a look at
Nick Karoumpalos wrote:
> Hi all,
> I have a worksheet that contains a list of numbers, and in printout
> more than 5 printed pages.
> What I want is to summarise the list per printing page.
> ...Easy way to copy fields?
I have made a lot of customizations to the Leads form by
adding a lot of fields. Now I want to add most of those
fields to the Contacts form so that when I promote a Lead
the info carries forward. Is there an easy way to copy
and then link these fields or do I have to manually
create them all all over again as Contact fields and then
You need to create the exact same fields in contacts then create mappings
betweek leads and contacts in the deployment manager-schema manager.
Have a look at the tool and see if it makes sense. As always I recommend you
test this out on your tes...