Search results

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"?>...

I have three desktops sharing a network at home. An XP with O2002; a Win7 with O2002; and a Win7 with O2010. I access Access from all three PCs usually without a problem, but my XP recently decided that it will not open my most recent undertaking...even though it was created on the XP and...

I'm using A2003 (yes, still). An accounting type form requires the "Type" be entered as either (numeric) 1, 11, or 2. On the same form, one of the three Yes/No fields must be checked as confirmation. My hope is that I can use the "SetValue" action in a macro. My first attempt (to set the...

Designed an unbound form in another database where it served as a menu (with several command buttons to goto other places); no problem so far. Then I copied/pasted it into another database, deleted all the macros from the command buttons, and replaced them with 'embedded macros' that opened...

Starting with XP on a single PC, I expanded to Multi-user PCs with various operating systems (but not Apple) without problem with my Access 2003 multi-database file program. Now I'm asked if I can change to Win7 x64 PCs that already have Office 2010 loaded. My first thought was to transfer...

In contemplating conversion of 2003 databases to Office 10, I wonder if my 32-bit XP can permit both Office Pro installations (2003 & 2010) without conflict. Would partitioning be better? or must I use a new PC with Win 7 and keep the 2003 database in the XP PC until successfully converted...

In an input form called "FrmReceipts" that feeds a table called "TblReceipts", one of the fields is called "OverUnder". This field has as its Control Source a formula: [RunningTtl] - [PaymentAmount]. There are several money fields in the form which must total the payment, so the "OverUnder"...

I realize many features must exist in 2007 and 2010 Access that were not in the 2002-3 version; but can an on line input form be used to a table that feeds a 2003 database in my desktop? If so, what application applies? I'm thinking of having members of a club update their own address/phone...

My Receipts report has seven currency fields, each of which uses a variation on =IIf([code]="A",[Amount]*0.4,Null) The Total field has the formula: nz([DonationA1],0+nz([DonationA2],0+nz([DonationB],0))) (shortened from seven fields). All but one of the six fields is usually Null, (depending on...

Report has a conditional expression with IIF that produces a string result when record value of currency field is not zero; and I want the string to say "Amount of Donation is $29.50" for a $29.50 value and be blank for a $0.00 value. I have =IIf([Don4]0," ","Amount of Donation is "&[Don4]...