I search the table for a combo of last name + first 3 letters of first name. Then I display a dialog with the choices found (if any) and let the user choose one of those to edit or to continue the add.
Debits and Credits should be separate fields if you are thinking in accounting terms. Each should be positive values and the type of account you are posting to determines whether you subtract or add to the debit/credit balance, then the credits-debits give you the balance. You can do a running...
Would you consider having the access app on a RDP server and then the Apple clients could use a RDP session to run the app. This way any tablet or machine could use the app.
I joined in 2009, I think I did post back then a couple times, but am not sure :)
My back-end is SQL Server and the underlying table has a couple thousand clients (not a lot DB speaking) and the associated child-tables may have another couple hundred thousand records (but each client would only...
None, to filter the report on the current client I pass a "[ID]=?" in the WHERE clause of the docmd.openreport function where ? is the ID number of the current client.
No calculations. It is strictly a contact sheet. The 7 reports are other areas of the contact (i.e. medications list, allergies list, etc.) that are linked to the main report via an ID field.
I have a weird problem... I have an Access application that print a report with 7 sub-reports in it. When I preview the report, it looks fine. When I print it directly to the printer, it looks fine. The problem is when I print from the preview, Access error with a "...too complex..." error and...
Hi, I am Stuart and I live in Maine, US. I have been programming in C, Pascal, Visual Basic since college (for the last 28 years). I am an experienced Access developer as well.
I still work with Access and Delphi (Pascal - Embarcadero).