Creating Client Tracking DB, need advice
I'm new to Access 2003 database design, but I've been asked to create a DB
for tracking our clients. I'm starting out quite simple, and hope to modify
and expand as I learn more. What I have done is create a single table
capturing all of the information I currently have been asked to capture, such
as Contact Information, Demographics, Industry, and a place for notes. I
figured out how to create some drop down lists for some of the categories,
but I have a couple of questions about what I am doing before I roll this out
to users. I'm starting with a access DB ...Need Formula To Find Blank and NonBlank Cells
I have a worksheet with 6 columns (by Month)
Sep Aug Jul Jun May Apr
I have to review starting for example with May, I need to find any cell in
May range that is null <> where Jun and Apr both are not null <>
So if May is null and Jun and Apr are not null than I would count that as 1.
If May is null and either Jun or Apr are null then I would not count them.
"hilltop55" <firstname.lastname@example.org> wrote in message
news:08D989CB-D1B4-49F...2004 trial, how do I get rid of it?
My trial is over, and I want my Money 2002 back. Does
anyone know how I can do that?
The easiest way is to use control panel->add/remove programs to remove the
2004 trial pieces (there are two programs to uninstall). Then reinstall 2002
and use the backup file created when you first installed Money 2004 - it'll
be named something like My Money.M10. Any transactions entered in the trial
which you want to keep will need to be re-entered into the 2002 version, as
you can't downgrade a file from 2004 to 2002.
Glyn Simpson, Microsoft MVP - Money
Check http://support.microsoft.co...Need to import EDI file
Hello. I have an EDI TS-130 file (academic transcript) that I would like to
import into Access 2003. Is this possible to do for free? If so, how?
...Force a page break in code
I need to force a page break in the Detail_OnFormat
Event when a value changes. How do I do that?
> I need to force a page break in the Detail_OnFormat
> Event when a value changes. How do I do that?
Insert a PageBreak control from the ToolBox bar at the desired location. Even
though such a control is never "visible" other than in design view they do still
have a Visible property. That property effectively turns on and off the
PageBreak so you can minipulate that in your code.
Rick Brandt, Microsoft Access MVP...Where to get missing msvcp70.dll?
After I uninstalled a bunch of software, when I run an app it says app
failed because msvcp70.dll was not found.
Re-installing that app does not help. I guess I need to restore the missing
msvcp70.dll. What is the official way to get it?
Some sites offer this file for download but I'm not sure the files are
In my system32 folder there is msvcp50.dll, msvcp60.dll, msvcp71.dll, but no
msvcp70.dll. It is not in the recycle bin either :(
"james" <email@example.com> wrote in message
> After I un...get rid of macro option at startup
I created and then deleted a macro in an Excel file.
Why do I still get the warning box (i.e. the one asking if I want to enable
or disable macros) when I open the file?
Is there a way to get rid of this since I no longer have macros in this
You need to delete the empty module.!
"Brad Rench" <firstname.lastname@example.org> wrote in message
> I created and then deleted a macro in an Excel file.
> Why do I still get the warning box (i.e. the one asking if I want to
> or disable macros) when I o...AOL IMAP account
I have set up AOL email account as IMAP type and keep getting pop up in outlook " your IMAP server wants to alert you the following: Can't read attachment for message 6438.
this pops up for many times and each time the number is different.
new profile same issue.
Office Version:Office 2007
Operating System:Windows Vista / Windows 7 - same issue.
Submitted using http://www.outlookforums.com
Do you have a virus scanner installed which integrates itself with Outlook?
Uninstall this integration part of your virus scanner and try again; you'd
still be sufficiently p...Keeping a table in a form editable and checking that fields are filled in before allowing a save
Firstly apologies if this is the incorrect forum but I was looking for
a general word forum and could not find one. Please point me to one if
I am trying to create a form where I want to specify what items need
to be filled in. (Review minutes from design reviews). I want to make
certain fields mandatory like the date, attendees and check list used
and want to block saving of the document with a warning until they are
filled in. Is there a way of doing this?
Also as a part of the review actions are filled in to a table.
depending on how many actions there are the table...Exchange 2003 SP1 to get DST patch & Exchange 2000 patch is available to anyone for $4,000
This is a multi-part message in MIME format.
In the "New Highlights" section: "Exchange Server 2003 SP1 will now be =
supported for an updated version of the Exchange CDO patch to be =
"DST Hotfixes for products in Extended Support can now be purchased for =
...need custom cut and paste functions
I once wrote here about a problem I had cutting and pasting where columns
would turn to "REF!" after a cut and paste. I would work around it by
copying, pasting and then manually deleting instead. I thought turning
everything in the sheet to absolute references would solve the problem but
it didn't so now I am thinking of a different solution.
Could someone tell me what I need to do to write my own cut and paste
functions which would basically copy the selection and then on a paste it
would paste and then delete the original selection from where it was copied
from...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <email@example.com> wrote in message
> How to get only the year in the date form...Mailbox needs reducing
We have this mailbox that has been left for months and with no limits, it's
Ho can I trim in down, I don't really want to go into the mailbox and do it,
can Exchange do it?
Gonzo <firstname.lastname@example.org> typed:
> We have this mailbox that has been left for months and with no
> limits, it's now 11GB!!
> Ho can I trim in down, I don't really want to go into the mailbox and
> do it, can Exchange do it?
Presuming you're not on 5x or earlier, you can use mailbox management
policies to get rid of items ol...I need help restoring Public Folders
I've been having issues getting Public Folder replication going between 2
Exchange 2003 servers.
Prior to doing any work I performed a Backup using Veritas Backup Exec and
this completed and verified correctly.
I screwed things up and managed to delete some of the public folders on my
original server. I'm not 100% sure what I did but it is a mess and the only
backup I have is the Exchange backup I created before doing any work.
The public folders contain a number of Contact Lists and a very important
I have restored the public folders but when the restore c...How do add another code to a current one?
I have this following code to make the rows changed based on the critea in
column 16, and I need add A "Red, Yellow, Green" for status to only one
column 30 at the end of the spreadsheet. How do I add another code? I keep
getting an error..
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range, clr As Long
For Each c In Target.Cells
If c.Column = 16 Then
Select Case c.Value
Case "Analyze": clr = RGB(204, 255, 255)
Case "Build ": clr = RGB(204, 255, 255)
Case ...You wont believe this! SERVER DOWN
I was helping the operations/it director to get RPC over HTTP going on their
exchange server for a company I use to be the sys admin for. The ops/it
director was doing the add/remove programs portion to add rpc over http
there, somehow in the process of doing this he managed to uninstall IIS -or-
just NNTP and SMTP (I can't figure out which and he claims he did neither).
Long story short, I've reinstalled NNTP and SMTP, reconfigured SMTP to the
best recollection I have of the previous config and the server still refuses
to send/receive email, even internally. All services are s...Need help on a formula 05-20-10
I need a formula to calculate the following information please: I will have
someone enter a time (ex 6:31) in cell C3. If the time matches one of the
times in cells B17-B22 I need it to display 4.6, if it matched one of the
times in cells B23-28 I need it to display 4.7, if it matches one of the
times in cells B29-34 I need it to display 4.8 and so on. Does anyone have a
simple formula I can do for this please?
Can't do the "and so on" part, bu...[ANN] "Bend Word to your Will" -- April 2005 edition free download
THIS ANNOUNCEMENT IS ABOUT A *NON-COMMERCIAL* RESOURCE BASED IN PART ON
ACCUMULATED ADVICE FROM THIS NEWSGROUP
The latest version of my notes on Word -- titled "Bend Word to Your Will" --
is now available for downloading from the Word MVPs' site,
WHAT IS "BEND WORD TO YOUR WILL"?
"Bend Word to Your Will" is not a commercial product for sale -- it's free.
It's a dictionary-style (mainly) set of notes on Word that I've been
continually adding to and polishing for the past four year...Getting kicked of outlook2003
Every time I print directly after I get kicked offline
Do you mean that Outlook closes?
"jp614" <email@example.com> wrote in message
> Every time I print directly after I get kicked offline
No, It completely boots me off the network. When I loose connection to
Outlook it takes my computer offline--looses connection...
"Vince Averello [MVP-Outlook]" wrote:
> Do you mean that Outlook closes?
> "jp614" <firstname.lastname@example.org> wrote in message
> ...Problem with vba code to export query result in excel
I have a access report that exports to excel with click of a button after
choosing parameters. This works well. However I have to modify couple of
fields to utilize formula in the export module. I am not sure how to do this.
I am writing the above code which seems to cause problem. I appreciate any
help to resolve this issue. Thanks.
If lngColumn = 12 Then
xlc.Offset(0, lngColumn).Value = =([UnitPrice]*[OriginalShippedQty])/1000
It seems the fields UnitPrice and OrigianalShippedQty are not being
>I have a acces...Formatting cells and getting pound signs
I am using Excel 2003 with all updates as of 4/28/04 and trying to format a cell using the custom category and choosing the #,##0.00 type.
I am trying to add the $ symbol at the beginning of the type and add text at the end of the type to look like this $#,##0.00 "text".
When I do this however it shows up in my cell on my worksheet as ##########. It does know what the value is and shows as I would expect it to when I place mouse over cell in a balloon
If I use only the $ symbol befor the type it shows fine. If I use only the "text" after the type is shows fine. Using the...Need to retrieve a deleted Excel File
On Saturday I hide an excel sheet and then protected the
workbook. When I got into work today to open the file it
was non-existent. What do I have to do to retrieve the
file? Does it make a difference if the file extension
ended with .csv?
Thanks in advance!
Search in Windows to make sure it's still on your compute
go to the folder the file is in and look to make sure it's still ther
If you didn't do this, you might need to to text, which includes *.cs
Excel is not set to open this type of file by defaul
Did you (try to) open the file with Excel.
If so : did ...need some XL URL's please
I would appreciate some good site links for XL how to's and working examples
aimed at Novice - Intermediate.
Go to the heading:
Excel Lessons & Tutorials (#tutorials)
It's just after halfway down.
Norman Harker MVP (Excel)
It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
...Code about setting Y Axes scale.
I couldn't understand the lines between 35-42, why he thought the
dbMinScale after the change is the one he want. What the logic of
this code section. Any one who could understand please help me. thanks
Private Sub USP_SetYAxesScal(ByVal i_strWSName As String, ByVal
i_strChartName As String, Optional ByVal i_intDecimal As Integer = 2)
Dim dbMaxScale As Double, dbMinScale As Double, i As Integer, j
Dim xTargetChart As Chart, vTemp() As Variant, blnInit As
Boolean, dbMax As Double, dbMin As Double
1 On Error Resume Next
'get max/m...get rid of extra spaces between paragraphs worked only once.
Changed style from Word 7 to Word 3, used help online, but still have 2 left
with spaces I cannot get rid of on my last page. Got any help for me?
Only fools and bigots prefer French over Spanish to be taught in public or
In the Styles pane (Ctrl+Alt+Shift+S), right-click the style name and choose
Modify from the context menu. In the Modify Style dialog box, click Format,
Paragraph. Make sure that Line Spacing is what you want, and that Spacing
Before and Spacing After are both set to zero. Click OK. To transfer the
style definition to the attached template, d...