Hello,
In MS Word 2000, when typing the name of the current month, the AutoCorrect feature goes ahead and suggests a complete date (i.e. August 30, 2004).
Which is cool except when it gives yesterday's date or even two days ago.
My system time and date are current. Where else would Word be...
Hey all,
I want to publish a birthday list with all the dates in order from Jan 1 to Dec 31.
My database contains entire birthdates including the year. So it sorts from oldest people to youngest.
How do I extract just the day and month info (or to put it another way, discard the year info) to...
I have deleted MSHEARTS.EXE from Windows/system32 but it keeps coming back!
Any ideas how to put the wooden stake through this evil program once and for all?
dan
Any idea why, in a normal PP presentation, I'm selecting several objects, and when I try to Group them (either by right-clicking or from the Draw menu), the Group option would be grayed out?
Thanks,
Dan
I'll try to be succinct here.
I work in a department tracking Donors and Gifts (donations).
I have a table of Donors, who are linked to a table of Gifts. Those Gifts are given to various Accounts.
These Donors are assigned to Caseloads via a unique number.
I represent a subset of a large...
I wrote about this 2 weeks ago. Compact and Repair on source (linked) DB seemed to fix it. Not any more. Here's the current scoop:
When trying to look at our data using simple forms, the error message "Invalid Argument" appears and #Name? appears in a bunch of the fields.
We have...
One of my users in the field has suddenly had her DB go wacky on her.
It happens when she clicks on any button on a form or when trying to open a form from the database window.
She can open tables.
But when opening a query, she can see the information in the background, gets the "Invalid...
Hey all,
My form has a combo box referring to a LU (lookup) table.
My (well-trained) users may have occasion to add a record to the LU table, so I created an "add records" button that opens a little tabular form where they can add (but not edit) a record.
When they close that form...
I'm writing reports referring to a SQL database. But for my remote users, I have to convert the data source to be a .dbf file. I have done this and changed the location to their local hard drives.
There are four linked tables I have to "re-locate," and I have done that. When I...
I'm producing a report listing donors alphabetically, with their name and address in the group header, and the Detail listing their contributions by date under their name.
I started by creating a simple formula putting their First and Last names together, last name first, so they'd sort...
Hey all,
I have a DistinctCount function that returns a number with two decimal places. Of course, I want no decimals since this is a count.
I looked in CR help and found the Round function, and changed my formula look like this:
Round (DistinctCount ({CONTACT1.CONTACT}),0)
But it still...
I was getting this message after tweaking some simple queries:
Record is deleted. (Error 3167)
You referred to a record that you deleted or that another user in a multiuser environment deleted. Move to another record, and then try the operation again.
I was locked out of much of my data...
Hey all,
New to CRW but have written quite a few Access reports.
I'm getting donation data from our SQL server.
The donation amount is coming out as a STRING instead of numeric. I have already put in request to the programmers to change that.
In the meantime, is there a function to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.