Recent content by wilpeter

Scary stuff! Back in 2009, MS decided not to update Microsoft Agent in Win7. I have Win7 x64 and they've emailed me a zipped file called HotFix. Before I decide to install, I read the disclaimer and warnings. In case it doesn't work, I'm supposed to back up both files and computer! I've too...

Yes, after every use of the db I automatically do so. Thanks.

Veeerrrry interesting! On exiting Access (and having visited the References), I was given a parting message: "Your version of Microsoft Agent isn't compatible with this version of Windows" (turns out Win7 didn't come with Microsoft Agent and it has taken 2 years for the program to notice this!)...

Have done so, Bob. The only field in the three tables that has "Yes" for it's Required property is the Key Field (Yes, no duplicates). The Credits table and Debits table both have "no". Which is why I'm puzzled at the message--which, when I say OK, is removed without objection. (Apologies for...

I appreciate your collective interest. However,... burrina: I don't use code and haven't (deliberately at least) modified any. I'm not importing - it's stand alone. I'm not on line and it's not a shared db. bob fitz: Reluctant to share due to it being a db of 10 years of my personal finances...

No, I've looked back to 2004 (the table was carried forward in 2007) and neither the debits nor the credit tables contain null values. There are thirty or more 0.00 values, minus values, and plus values. Nice try.

Back in 2007, I created and starting using a A2002 database to track purchases. Almost every day for 7 years, I've entered transactions (up to 5,875 so far) without a hitch. Yesterday and today I'm getting... Error message: "The field 'CREDITS.Trans' cannot contain a Null value because the...

Designing in A2003 and using in A2010, my database has about 30 Macro Names within the Switchboard form. Suddenly, it seems, Access has added 59 rows of continuous text below the last macro that I created. The first line reads... _AXL:<?xml version="1.0" encoding="UTF-16" standalone="no"?>...

To preface my post, I don't have a solution; but I wrestled with similar situation and decided to put three PCs on an intranet--each with a different Access version. My clients communicate with email attachments and I use gmail. I open the attachment (based on its extension - mdb accdb) in the...

Re: Solved! Thanks John.Woody! That was the solution. Now that directory is a trusted site. Cheers, and Merry Xmas to all.

Re: Looking like an answer.. I appreciate your taking the time, Mihail, to explain how I misled you with my comment 'recently decided'. What I should have said was that 'now that I share files that are being opened in Access 2010' my XP decided it cannot open them. I read your linked thread...

No, but I understand your logic, Mihail. The file was created in Access 2003 and saved as an mdb file. It can be opened in one Win 7 computer that has Office 2010. On my network, it can also be opened by my other Win 7 computer that has Office 2002. However, on the third PC, the one with XP...

Hello again, Mihail. As you might already guess, I have used Office 2002 since it was new and have already (in another computer) Office 2010. (Office 2007 wasn't popular with the customers I dealt with, so I have never had to try it.) Until today, I have always been pleased with Office 2002...

Unfortunately, the website to which you directed me is for Office 2007 customers. Office 2002 isn't as trustworthy. The Mapping a Drive allowed me in the XP to map to Drive N: However, even through Drive N: Access denies me access to the .mdb It does seem to be eluding me. I could still copy...

Agreed. I checked and have no problem opening other program files. The reason I had to set up the network from the XP computer, was that the Win7 computer would only 'find' the other Win7 computer on my network. Thus, I had to set up three networks "Self - an XP" with "Basement - another XP"...