Search results

Thanks, gemma, The form is bound to a table. I'm just setting it up, so I'm only experimenting with adding new records, although, so far, I wasn't able to enter anything. I was able to see all of the records in the table I used. I did check several times that Data Entry was set to "yes." There...

I want to have a form that opens to allow users to add new records. I set the data properties to Allow Edits, “yes”, Allow Deletions, “yes” Allow Additions, “yes”, and Data Entry, “yes.” When I open the form, it opens to the first record, not a new record, as I intended, and when I use the arrow...

I'm also tryiing to get my form to open to add records. On Form Properties, on the Data Tab, I set Data Entry to "yes". When I open the form it still goes to the FIRST record, and when I use the arrow at the bottom to go to the last record, the add record botton is grayed out. It's as though...

Another expert stepped in and found the solution to the problem. It was that when I imported the main data table from Excel, fields that should have been numeric came in as text. It never occurred to me to look. I changed the fields to numeric, and I was able to sum on both footers. Whenever I...

Hi Beetle, I managed to sanitize the data reasonably quickly. I've uploaded the file. Hope you can find what went wrong. Many thanks, Henry

I saw how to attach the application, but I would have to sanitize a huge amount of confidential information. I can do it, but I would be duplicating the application rather than attaching the original one. I'll try to do that.

How do I do that?

I am summing the results of a calculated field from a query in a report. The report is grouped at two levels, and I need to sum at two levels. The amounts I am summing are expenditures by social service agencies. Each agency has several programs. I need a sum for each program and then for each...

I’m trying to sum a set of numbers in a report. The numbers are amounts spent by programs belonging to social service agencies. One thing that complicates matters is that, all programs made spending requests, not all requests were approved. I want to show all requests on the report, but amounts...

I've been an entry-level Access user for a long time, but now I find myself being pulled in to the program more deeply, and I'm begining to have to write code. I've done some programming a long time ago with DBase, and I've done things with Excel that amaze even me, but Access programming is a...