Access 2000 deleting records
Hello all, sorry for the previous post with nothing in it. Here is the
problem I have resently upgraded an Access97 back end to Access 2000 due to
size restrictions of Access97. we were running an Access 2000 frontend at
that time. since converting to Access2k we keep getting "#Deleted" records
"Can't save without edit or new" fields inside of records are "#deleted" and
so on. I have run diags on equipment and found nothing out of the norm.
Problem is intermittent, may go most of day without problem then get some or
may start the day out with problem th...Print Selected Record
I want to print a popup form. I used the command button wizzard to set up a
button to print the form. How can I filter what's printed to be only the
selected (active) record?
Sammie Access 2003
Although allowed, Forms are really not designed for printing. Why not just
create a report to present the data for the current record. Then you can use
the Where argument of the OpenReport method to have the report limited to the
active record on the form?
Dave Hargis, Microsoft Access MVP
> I want to print a popup form. I used the command...Record Macro in Excel 2007 not recording everything
I've been using Excel 2007 for a few weeks now and I've noticed that
the 'Record Macro' functionality is not so complete anymore.
For example if you record a macro when adding a picture to your
sheet,resizing & moving it, then saving your sheet.
The result is the insert & save sheet code. The resizing & moving of
the picture is not present in the macro.
Another example, add a comment to a cell. Then start recording macro
and change font of this comment. Then you got a nice empty macro.
I hope this is a setting because otherwise I will go back to Excel
...HTML code-bug mouseover problem in page created with Excel.
Aloha potential savior.
I decided to make a site with Excel (why is that so funny?), which is
going slow but ok, considering I know very little, but now ran into a
problem: When I integrate a mouseover tag into a cell, it results in
the cells being white upon first load. See for yourself:
How do I change the HTML code in order for the cells to start out with
a color instead of white?
Please make me stop ripping out my hair;-)
Although this is not an html group...
Where you have code such as:
<td colspan=4 class=xl56 style='border-right:.5pt so...Charting #2
I'm creating what I call a running total spreadsheet where I list the Item,
Category, & Amount as column headers. Examples could be:
1) Printer, Hardware, $150
2) Visio, Software, $150
3) Computer, Hardware, $2000
How can I create a chart that sums all the Categories (Hardware = 2150)
together. Everything I try, list each line item separately.
1. Create a pivot table and build a charts based on this table (look at
http://www.cpearson.com/excel/pivots.htm for an introduction to pivot
2. Create a seperate sheet in which you sum up a...Sound card / sound devices not recognized
I recently re-installed XP SP3 after a virus attack and now my machine is not
recognizing my headphones nor my plug and play speakers (both of these work
on other machines).
My machine is a Gateway, built 12/2003, P4, Windows Media Player 9.
My best guess is that it is a sound card issue. I don’t know whether the
card is on the motherboard or separate: I haven’t ID’ed the type of sound
I ran a program called Everest that lists all the components, but under the
motherboard I did not recognize anything that looked like a sound card.
I have made sure the speakers are...Money 2003
I've set-up mortage loan account connected to hause asset account.
I'm downloading bank transactions reports through internet. Beside others
are loan payments.
How I can declare those payments aftewards as loan payments regarding
specyfic loan account? Could I define split beetwen principal and interest?
...Mail Merge from Outlook Skips Records or doesn't merge at all
Outlook 2002 with Windows XP
I set up a mail merge from Outlook with several
contacts. The document seems fine, I can see all the
recipients when I "view merged data" and in the "mail
merge recipients" but when I complete the merge into a
new document only 2 records are merged. When I switched
to labels I received an error message "data records were
empty or no record matched query".
I've set the merge up "saving the contact data file to
another document" and not saving it, neither worked.
...Thumping sound in XP after I click someting
Ok I built an home theater PC (HTPC) with Windows XP and had all the latest
updates. To make a long story short, my projector blew a bulb and it took
about 6+ months to replace it. During that down time, I didn't turn the PC
I was able to finally buy a bulb, and start the PC up again. Now, whenever I
initiate an activity with a mouse, and the activity happens, I get a thump,
where a ding is supposed to sound. For example, if I click the Back button
in IE and it goes to the previous page, I get a thump. If I click Ok on a
dialog box, I get a thump; if I double-click on ...Need to populate a Report with several records
In short, I have one report containing 5 records from the same table. The
individual records are layed out to support proper printing. I need to
populate each record with from the same table. I can not give them all the
same pointer to the table or I get 5 copies of the same record. How can I
populate those 5 records with 5 records from my table?
I think you need to have a group by in your report. Thus you will get 1
group of data for each of the 5 that you are refering to as 5 records.
> In short, I have one report containing 5 records from the same t...Hottest day on record? Try 1930
A Bit of History for Global Warmers: Look at 1930
By Randy Hall
CNSNews.com Staff Writer/Editor
August 04, 2006
(CNSNews.com) - People sweltering from a heat wave in the Mid-Atlantic
region of the U.S. might find cold comfort in the fact that the temperatures
of the past few days are not the hottest on record. That "honor" belongs to
a summer 76 years ago -- decades before the controversy over "man-made
global warming" began.
"From June 1 to August 31, 1930, 21 days had high temperatures that were 100
degrees or above" in the metropolitan Washington, D.C., ...Migrating Exchange 5.5 to Exchange 2003 #2
Hi - we are looking to migrate Exchange 5.5 (running on Windows 2000 Server)
to a new box running Exchange 2003 (with Windows Server 2003). Nothing fancy
about our current configuration..just one machine running a few domains.
What is the easiest way to go about doing this? I have yet to find a really
good step-by-step on these procedures. Thanks in advance!
There are a few good articles and whitepapers out there. One is
strategically targeted at medium-sized businesses.
http://www.microsoft.com/downloads/details.aspx?FamilyId=38F816A4-FB6A-4CDB-991C-2D8FF73B5CE5&displayl...Count Filtered Records
Sometimes when I filter a list, the status bar displays
how many records are in the filtered list e.g. "70 of 174
Other times, the status bar only shows "Filter Mode".
Can anyone tell me why this is or how I can get Excel to
always show the number of records filtered.
Thanks and Happy Xmas
When your list has many formulas, the Status Bar may show "Filter Mode"
instead of a count of the visible records. You can use the Subtotal
function to count the visible rows.
The following MSKB article has some information:
XL2000: Exce...Office XP Sounds
I'm having a problem with the Office XP Sounds add-on, available for
download at Microsoft's Web site. I've tried installing them a few times,
but only 20% of them really work--the rest of the time it's like they don't
even exist. I know this because they were working just fine a couple weeks
ago, but then I decided to reformat my hard drive and now I can't for the
life of me figure out how to get them all back. Any and all help would be
-- Kyle W.
...Tracing Links #2
That tells me what file I am linking to, but what I want to identify i
which cell in my current worksheet is linked to these externa
worksheets, as I cannot find a reference to the external documen
anywhere in my current workbook.
The reason I ask is that I am trying to avoid the "Do you wish t
update links" message when opening my file.
Stephen Pain's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1526
View this thread: http://www.excelforum.co...CRM licensing question #2
Can one use CRM 4.0 client access licenses for CRM 3.0 Small business
...Earn money using PAYPAL #2
As Seen On OPRAH & 20/20 - TURN $6 into $24600
Earn money using PAYPAL
all you need is:
1) An email address
2) A PayPal account
THIS IS A 2007, CURRENT EMAIL LIST
I decided to give this one a shot...
Especially since the so called "risk" is only $6.00. Anyway, only
after implementing this
exact system I about fell out of my chair as money ACTUALLY started
rolling in. I couldn't believe it.
is THE legit and profitable one. Here is how it works... There is a
list of 6 email addresses. When someone new
comes along he/she removes #1 off of the list, mo...low voice recording volume with Sound Blaster X-Fi Xtreme Audio sound card
Here a while back I build a new computer and installed a Sound Blaster
X-Fi Xtreme Audio sound card. The Asus P5Q PRO TURBO motherboard I put
in it had integrated sound but would not do what I needed.
Now, I'm having problems with the microphone not having enough volume
to properly record voice. For some reason when I go into Sounds and
Audio Device Properties, Voice and Test Hardware the mic volume yield
is very low unless I put a boost under Record Control, Advanced. After
I do another Test Hardware everything working properly but when I try
anything that uses analog...Better be safe than sorry #2
It is better to be safe than regret later. To be safe on internet visit
www.mysafelinks.com and see how to be easily safe.
...Outlook Security Settings #2
I am trying to use Outlook security settings.
I have installed the settings precisely as described on
the MS site and the settings work perfectly for me and
one or two others but not for the rest of my defined
We are using Exchange 2003, Outlook 2003 and Outlook XP.
I cannot find any debugging or logging info anywhere and
am a little stuck as to what to do next.
Can anyone offer any ideas???
...Database error in POS 2.0
I just started getting this msg "A problem occurred while checking your store
database." Now it won't let me back up.
This has been going on for a week - my [stupid] salespeople just told me.
Now, it's too late to restore from backup w/o redoing a week's worth of
Anybody know a way out of this???
How old is your database (and how big)?
Before getting into the nuts and bolts of the database, try connecting to it
from the store admin and reindexing it.
JR Data Inc.
> I just started getting this msg &quo...Error message when creating new record
I keep getting an error message on my form when trying to create a new record.
The error message says -
A related record is required in the table tblCustomperProfile.
I dont know what i am doing wrong.
I have about 5 to 6 tables with relationships consisting of one to one and
one to many. The form uses tabs, so i have all most of the tables fields
displayed on the form and two subforms.
I'm quite sure that all the tables are related properly, but i cant work out
why it keeps saying that.
If someone could help me, or give me ideas why this is happening please.
Thanks in advance
Dos...CRM 1.2 to 3.0 Upgrade error
We are experiencing this error after most of the upgrade is complete. We have
only made supported customizations within CRM. Any Thoughts?
System.Exception: Action Microsoft.Crm.Setup.Server.PublishDefaultDataAction
failed. ---> System.NullReferenceException: Object reference not set to an
instance of an object.
objectTypeCode, String picklistName, Int32 optionValue, String optionLabel,
Microsoft.Crm.Tools.ImportExportPublish.PicklistPublisher.UpdatePicklistValue(Pickl...Filter for unique records
i have a table with
id seq group
1 AA 1
2 AB 1
3 AA 2
4 AB 2
5 ABC 3
6 BCA 3
7 ABC 4
8 BCA 4
now, i want to filter this data set so that, it comes with unique seq only
1 AA 1
2 AB 1
5 ABC 3
6 BCA 3
but, remember, this is not what I want??
1 AA 1
4 AB 2
5 ABC 3
8 BCA 4
that means in the data set there are same seqs assigned to different Group,
but i want all this similar seq to be in a single group and delete other
groups with duplicated seq. i tried
SELECT grouping.seq, last(grouping.groupno)
FROM grouping group by grouping.seq;
...Folder List Font Size #2
I am using Outlook 2002. I increased my screen resoloution for a project i
was working on. After I was done I changed it back to 800x600. Now the fonts
in my folder list are larger than they were before. Is there any way I can
adjust the font size of the just the foler list? The font size in my Outlook
folders is what I am used to.
Also the font under my icons looks different after I changed it back. So
maybe its a system setting?