How sort recordsets with fallback tiebreak fields
Access 2007 developing 2003 database
I have a recordset I want to sort in ascending order of field
"localOrder" (Long). Sometimes there will be ties. In such cases I
want it to decide on ties by sorting on UrgencyID (Long). If there
are still ties, I want it to sort by "whenAssigned", which is a Date
I tried the following code,
Set rst = CurrentDb().OpenRecordset( _
"SELECT taskID, whenAssigned, UrgencyID, localOrder FROM
tbl_tasks " & _
"WHERE personIDassignedTo = " & myID & _
...Visual basic and emprt fields
I recently converted from Access 97 to 2003. (we're a little behind the
times at my company). Anyway, we have some visual basic code which
interfaces with the Access database in order to populate BOM's in AutoCAD,
My problem is that the code does not like fields with 'null' values. It
didn't seam to mind then in 97? I've since entered a meaningless character
in those fields to get the code to function so the company can still run, but
is there a 'real' fix?
I'm only self taught at VB, but I think it has something to do with an empty
records...Contact address fields Outlook 2002
I've converted my Outlook 2000 contacts to Outlook 2002, the address
information seems not to be right.
The City-info is in the ZIP-field, the state info in the city-field and the
zipcode in the state-field. In the 'All fields'-tab the information is in
the right fields.
I've migrated from Outlook 2000 SP3 English to Outlook 2002 Dutch. It seems
some programmer/translator mixed up the addressfields in the
contactinformation-window. I need this information for my program. Is this
solved in a servicepack/upgrade, or is any workaround available?
It seems to be a common probl...Additional Fields for Items
I have a couple of questions regarding the items part of RMS.
1. Is there an open through MS or an addon available to add more custom
data fields on the item database that would be available to put on labels and
sort reports by? To answer in advance I am already using the 3 Sub
Descriptions offered, but I need more.
2. When making custom labels, is there a way to get the 'Notes' area from
the special page to go onto a label?
Thanks for any help in advance
One option is not to use the RMS Labels but use Microsoft Word with Mail
Merge and labels. This allows you t...Updating mapped fields
I made a mapping from account to a contact. The fields that are mapped
are the general adress fields. When I create a new contact from an
account the adress values from the parent account are used for the new
contact. So far so good.
My problem is that I want to automatically update the adress fields of
a contact when the values change in the parent account. This isn't
done automatically by MS CRM. Is there a way to do this? I've tried to
create a manual workflow rule that will do this, but that won't work I
Does anybody have a solution or some pointer for me?
Thanks in a...Sort a numeric field
I want to sort the following in "true value" as opposed to the order that is
provided below. My import document provides this format. Maybe not the best
explanation, but can you help?
Thanks as always -
On Sun, 26 Jun 2005 09:16:02 -0700, "sdmccabe"
>I want to sort the following in "true value" as opposed to the order that is
>provided below. My import document provides this format. Maybe not the best
>explanation, but can you help?
>Thanks...Macro to change pivot field with latest value 03-01-10
This is a re-post as my questions hasn't been answered by anyone...
Hi there and thank you in advance for any help.
I have written a macro that changes (hides / shows) fields on a pivot table.
One of these changes the field used for the page fields section of the pivot
table. However, when i add a field to this section, it defaults to All. How
can have this field default to the latest value in this field.
Let me explain further: I want the pivot to be shown either by date or by
week. The macro then changes the page field section to show either the date
or week field. If ...Equation Question in Query
I am trying to limit my query to search for dates between 9/4/2007 and
1/20/2008 but I need to exclude 12/9/2007.
I have the following equation and am not sure how to get it to exclude the
date I need.
Between #9/4/2007# and #1/20/2008*
Any suggestions would be greatly appreciated.
Between #9/4/2007# and #1/20/2008# AND <> #12/09/2007#
Build a little - Test a little
> I am trying to limit my query to search for dates between 9/4/2007 and
> 1/20/2008 but I need to exclude 12/9/2007.
> I have the following equation and a...Outlook PST question..
I am working on a little project. I am trying to see if there is
something Macro/WSH script, etc. to automate the breaking up of a PST
file? I often see users with large PSTs (to the point outlook takes
along time to open) but not to the point that outlook wont see it. I
was just looking for something to break the folders up in the pst into
say Alpha order and file them into new PSTs. Would save alot of time
and I am not too good at scripting..
...How to advance date field by one day on mouse click?
I have a date field in a form and I want to be able to advance whatever
date is presently in it by one day with a click of the mouse. What do I
enter in the On click property of the field?
"SamJ" <firstname.lastname@example.org> wrote in message
>I have a date field in a form and I want to be able to advance whatever
> date is presently in it by one day with a click of the mouse. What do I
> enter in the On click property of the field?
Better to use the + and - keys, but here's the code you ne...Copy/Move question
Several time a day, in an Excel 97 workbook, I move a short list of numbers
upwards in a column. To accomplish this, I highlight the existing numbers,
then copy them starting with the first blank cell. I then return to the old
numbers and delete them. I do not use the "move" function because it
destroys the related "index/match" formulas in the columns to the right. Is
there a way to have the old numbers disappear automatically (as in a move)
when I use the copy function?
How about a macro that does what you want.
Record it when you do it manually and...Closing a PO causes Approved By field to be changed
We use Purchase Order Approvals in the Purchase Order Enhancements module. We
recently discovered that the field POA_Approved_By (which normally contains
the user ID of the person who approves the PO) is updated with the name of
the person that closes the PO (if it's manually closed).
Does this make sense? Because of this, we don't have a record of who
originally approved the PO.
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Currently supporting: GP 9.0, SP2
...Separating field information
I need some help. Can this be done with queries?
Database has 13,000 records
All records are identical except for the History Field that will contain one
number 1, 2, 3, or 4
In a query that contains no records with a history of 2 select the records
with a history of 1 but not 3 or 4.
In a query that contains no records with a history of 1 select the records
with a history of 2 but not 3 or 4.
Thanks for your help.
That is unclear to me. You must be leaving out some necessary detail,
since the way I read your post all you need to do is apply criteria of
=1 for t...Diaglog/Threading Data Exchange Question
I have learned a lot from all of you, and I hope to over come my latest road
block. I have a smal IRC Chat client I am making.
I have a Dialog Box with Control and I use a worker thread for connecting to
IRC - That Thread will update controls on the Dialog by sending
Now my problem is in the ListBox Control that I have extended to do popup
menu with various commands.
I need to be able to read that controls methods from within the Thread.
so I need to do this from within my IRC Socket thread:
(code not exact - pseudo code)
CListBoxEx myUsers; //Defined in my ...Microsoft Access "Classroom management database" question
Microsoft Access "Classroom management database" question.
When grading, it has the ability in this template to put in scores for Assigments, Quizzes, Exams, Etc. For example, student scores 45 our of 100 possible points.
BUT it does not calculate that into a grade, that field is editable and I guess you have to manually put in a letter grade. Leaving room for human error.
Is there a way to make the # of points work or translate into a Letter Grade.
Path is: Open Classroom management database, go to classes, choose assignment tab, and click View assignements. THere you can ...Pivor Table Data Field
This is a multi-part message in MIME format.
I have tried to "show" a data field after using "hide" in field =
settings. How can I make this reappear? Not using Field drop down =
option. The fields orgin is from the excel list and not a calculated =
<!DOCTYPE HTML PUBLIC ...Office 2010 Beta Question
I am attempting to install Office 2010 Beta. After downloading the software
from the Technet site. I disabled my anti-virus software. After I click on
the file to start the install. I receive a message indicating the files
unziped and then the install process hanges. I never see the prompt to start
the Install Process. I am running Windows 7 Ultimate with the current fixes
applied as of this post.
Please post your query in one the forums from this list:
I recently added a front-end server and everything seems to be working ok. I
can send and receive mails from OWA without any issues. However, in looking
at WinRoute my Front-end server is the only server listed with a RED X and
is not connected to the master.
Can anyone explain to me why this may be so or what is wrong?
Exchange 2003EE sp2
A true front-end server doesn't route mail because you remove the mailbox
store. If your "front-end" is a hybrid front-end and bridgehead server,
then the answer would depend on how you have the bridg...V LOOKUP Question
Why is it when I am using the VLOOKUP function with
spreadsheets dervived from different database sources at
work(i.e. general ledger system, time reporting system)
the VLOOKUP values are sometimes N/A when in fact there is
an exact match. When I type the information over (exactly
the same), the data is then found. Does this have
anything to do with text formatting?
Check for spaces or special characters in the cells.
If the values are supposed to be numeric, they may not be recognized because
in fact they are text. To cure that, format an empty cell a...Summing fields between two dates
I think I know how to do this but any extra help would be appreciated.
I have a table with four fields - net sales, payin date, payin number, and
payin amount. What I want to do is create a query that will summarize all of
the amounts in "net sales" within a specified date range. I thought an
expression reading SUM([net sales]) BETWEEN [start date] AND [end date] would
work, but it doesn't.
Für Elise - Support the Breast Cancer & Heart Foundations
SELECT SUM( [net sales] )
WHERE fieldWithDateHere BETWEEN [start date] ...Creating an autonumber ID field in a make table query?
Some time ago I asked this question and was told it couldn't be done.
Well, I'm asking it again. I know there is no existing MS Access function to
do this (using access 2003).
Is it possible to create a function to do it?
If yes please be specific. I don't know vba. About all I know about
"modules" is that it's one of the "Objects" choices in the upper left.
An Access "autonumber" field is just that ... Access automatically
creates/assigns row identifiers.
Instead of trying to get Access to do something it doesn't understand, could
you ...Outlook (Inserting a file) Question :-)
Hi, I was hoping someone would be able to answer this question.
when I goto insert a document in OUTLOOK its default is my documents.
What I mean is when I click on insert it opens up the folder my
documents. Can this be changed to a different folder??
I have all my files in a different folder that I would like to open
when I try to insert a file.
Thanks in advance for the help
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
Can anyone h...Write-in Product Security Question
What elements of the security do I have to have set up in order for my
salespeople to add write-in products to quotes and orders? What does the key
need to be set at for each of these elements?
...Sync Center question
How do I use sync folders on my PC (using Sync Center or any other program)
with a USB drive?
Currently "Setup sync partnerships" does not show anything.
Visa Home Prem SP1
Thank you for your help.
you can sync external devices
like flash drive and flash cards to
the hard drive (and vice versa)
with microsoft's sync toy.
it is free and can be found via
DatabaseBen, Retired Professional
- Systems Analyst
- Database Developer
- Veteran of the Armed Forces
- nntp Post...Customization question: how to put up a single button onto toolbar which converts to "Symbol" font?
I'm running Excel X on my Mac with Panther (OS X). I'm a scientist and often
need to convert some characters to the Symbol font. In Microsoft Word, I was
able to use the Customize feature to put a button onto the toolbar which
converts the selection to be of Symbolic font. In Excel, I can't seem to do
it. When I do "customize" and hit the "command" tab, I can choose Font,
which says "In the Font box, select a font name" but when I click it, it
doesn't let me type a font name nor gives me a list of the fonts (unlike
Word, which does). It looks like...