Search results

Hello, I have a main form called "F_Invoices" and a subform named "SubF_Orders" which has to show the orders corresponding to the current invoice in the main form. The forms are linked through the field "Invoice_ID". All invoice data is collected in table "T_Invoices" (primary key...

I just finished programming a database (written in the version of MS Access in Windows XP Professional) and installed it on another PC with the version of Windows XP Home. I thought, it will be the same, but now the database starts behaving really odd. 1. It asks whether I really want to open...

Hi, does anybody know where to do download the HTML Help Workshop for creating custom help? I already searched the MSDN Knowledge Database and the Microsoft Support Center, without any results. If you have the link, please post it!

How do I do that? Is that a system-defined function?

I am working on a report that summarizes sums of sales pro category, then a Total of these sums is calculated. The problem is that, if there are no sales in a category, the resulting sum is =0. The Total (of all sums) is then also =0. So how can I calculate a Total that tolerates sums=0? Do I...

I spent 2 days programming queries for a report only to discover that they are not visible in the Print Preview. Only the Report Header and the Page Footer are visible, but the Details section and the Report Footer aren't. I already checked the Visible property of the Report, of the Details...

I am working on a form called Invoices with a subform TransactionsForInvoice. It shall show all transactions that refer to a particular invoice and then show a sum of the amounts of these transactions. Later I compare this sum to the invoice amount and state whether the invoice is payed or not...

Is there any fine solution to restrict the user's ability to edit information in the record source of the form without limiting the usability of it? Perhaps to link a read-only form to a special "want-to-edit-something?" form. Can that be accomplished and how? ... Perhaps there is another...

Something gone wrong! I tried it out now, but it still doesn't go. Probably I made some mistakes when designing the form and it is still not linked together. I created a query and a form with the fields BankID, BankName, AccountNumber, InvoiceIDTransactionID and some others and linked -...

Thanks a lot! I will try this out now.

I'm quite new to Access programming. I was trying to make a table named Transactions. This table contains two look-up columns from the table Banks called "Bank Name" and "Account Number". For each bank there is only one corresponding account number. I want this account number automatically to...