Search results for query: *

My table has two fields used as the key, ContactLastName and CompanyName. If the user attempts to add a duplicate record using my form I would like a custom error message to display and the record not added to the table. I tried following advice given for a previously asked question in this...

My Customer form has an "Add Record" button that writes the new record to the table. I would like the user to have the option of just adding it or adding and printing that current record (and not all the records that have been previously written). What is the best way to handle this? My "Add...

I have a simple form for a simple table. The first several fields are required, which I did at the table level. I have 2 problems: (1) If I do not enter all the req'd fields and click my "Add Record" control button, I get the error "You can't go to the specified record". I would prefer to...

I'm trying to create a report that shows a manager's beginning budget in the group header, purchases against the budget in detail lines, and then ending budget balance in the group footer. The data is from a query, which includes a calculated cost value of each purchase of Expr2...

I have an Inventory table which contains partno, inventorycount, and countdate from the last physical inventory taken. I also have a Purchases table, which contains partno (same as in Inventory table), purchaseqty, and purchasedate. I want to create a report that shows my current inventory...

In order to show only counts I have a report which displays only a group footer and page footer. One field in the group footer counts the number of times a field equals a given value. I am using the =abs(sum{fldname]="X")) expression. When the group count equals zero, on some lines it...