Search results

Sorry all, I am barely a newbie programmer, I need help with structuring a complex query to drive an exception report. Relationships and Background: ----------------------------- I have four tables, Buildings Member-Volunteer Jobs-Willing-To-Do Job-Roles Key related fields...

The following code fails with Data Type Mismatch at the statement: .FindFirst "[mid] = '" & Me![MemIDLU] & "'" mid is a autonum (long integer) so I assumed it was the quotes. MemIDLU is a control on a form. But if I remove the quotes, then I get MemIDLU is not a field or expression in the...

Iv'e got a form that uses a key (UnitKey) to look up the record if the key is found. If found I want the focus to move to a particular control, if not found I want the focus to move to another inquiry control. I think my code is wrong when I try to test the result for the If/Then statement...

I'd like to have my tab controls appear across the bottom of the tabbed page. Is this possible in AC2K?

How do I test the count of related records in the many side table? I have two tables, Members and DuePmts joined on MemberID. Members have a 1-to-many relationship to Duepmts. As payments are posted to DuePmt records, a new ExpireDT assigned. What I need to do is create a query (to drive a...

I have read all that I can and still can't figure out what is wrong with my syntax. I am trying to count the null occurances of a field within a report. I tryed this in the group footer: =DCount("[MemberID]","FinTreasCampRpt","[MemberID] is null") I know I have records that meet the null...

How do I install the runtime? I own a copy of O2K Pro and recently bought the Developer disks at a steep discount. This was the equivalent of buying O2K Developer. I want to distribute my DBs in exe format. When Auto-running the CD it puts the whole MSDN library and other stuff on my...

Where should I begin looking to fix this problem? I have a complex form that is one main and four sub-forms. I have been using it for data entry into several related tables for some time now. I made some changes to one of the underlying queries and/or tables. But I can't see to remember...

I am trying to retrive the record that has the latest expiration date for inclusion on a report or for display in a form using a query to pull the related expiration date from the Many to One side of a relationship. I have tried unsucessfully to use the MAX(fieldname) function. I keep getting...

I can't seem to figure out how to convert the stored true/false values in a table as Yes or No in the output of a report. Instead I get -1 for yes and 0 for no. Any ideas? TIA