Recent content by JHMarshIII

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...

Resolved memidlu is a combo control on a form. The .value and dropping the single quotes made the difference. Thanks for the structure suggestion. John...

Ok, OT, but can you help me to understand the syntax of this statement, I am confused by the single, double quotes and the appersand: FindFirst "[mid] = '" & Me![MemIDLU] & "'"

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...

Thanks Thank you, the code works great.

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?

If it is the null values creating your problem you might try using the Nz Function to pre-fill the nulls.

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...

Thanks for the feedback. What I ended up doing was adding an expression to the underlying query: NewMem: Nz([MemberID]),"New") to convert the nulls to a text value that could be evaluated as a control in the report. This is not the way I really wish to accomplish this, because MemberID is not...

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...

Just view? Won't the access runtime permit the end-user to update tables, queries, DB application permitting?

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...

Phew! That did it. It was a third table I added to the query at a later date in error. Thanks!

I did look at this help area, no luck. I will look again.