Search results

  1. D

    Need help with SQL in an Access query that has UNION for the non-relational queries/tables

    Please have patience with me. I not familiar with modern programming. I'm almost 81 years old and had two Fortran II classes at NYU in the mid 1960s. The most I do now are relatively simple batch files that I run from the command prompt on my desktop computer. I'm retired but am a membership VP...
  2. D

    Help Needed to SetFocus on Unbound Text Box in Form Header Section

    In the header section of a form is an unbound box to type in either LastName or FirstName, depending which field radio button was selected (I always have it set to LastName). I would like the cursor to be on this unbound box when the form is opened. Right now the cursor blinks on the first...
  3. D

    Question How Can Cursor Focus Default Be Set To Search Bar Instead of a Field?

    I would like the cursor for all forms, etc., queries, etc., to be by default, on the search bar above the status bar in Access 2007. That is the section that has three boxes -- the record # box, the filter box, and the search box. Right now the cursor is on the first field of any form, etc...
  4. D

    DMax Function in Query Works But Not As I Want

    I am trying to get the DMax function to work differently than it is working. I am retired and do volunteer work for a non-profit organization, as a Membership Chairman. I have two related tables: tblMembership and tblMembersTrans. The Membership table has all membership data, such as...
  5. D

    Need VBA Code for Conditional Default Field Value

    Hi: I would greatly appreciate it if someone would please convert the following into VBA code for an Access 2007 field on a form. It is needed to create a conditional default value based on another field's category: (Note: TransType, MembershipYear and Dues are field names and are all on the...
  6. D

    Currency Field-Access Copy/Paste Problems to Word, Outlook

    Hi: In a transaction table, I have a currency field. When its Format was Standard, and Decimal Places was 2, if I did a copy of the table, which appears on a form together with data from a main table with names, addresses, etc.and pasted it to either MS Outlook or MS Word, the cents, even when...
  7. D

    Need VBA Code to set true or false to two records based on date

    I do not know VBA syntax or how to properly set up programming using VBA code in MS Access. I would like to automate changes to two records in the database depending on the current date. The situation is that I have two records for one person (each with a different primary auto number field)...
  8. D

    Query Does Not Work-Selct Members with No Transaction for Selected Years

    Table 1: tblMembershp Table 2: tbl MembersTrans Relationship: I am a volunteer for a small non-profit organization. I maintain membership records and am also a member of the board of directors. Everyone is an unpaid volunteer. I want to generate a query (MS Access 2007) that will show...
  9. D

    SUBJECT: Form Combo Box Causes Query Error Message

    I have attached a test version (only a few test records and various forums, queries, etc. deleted) of the database causing a problem. I'm sorry for such a long post; however, it is the only way I know to adequately explain the problem. Using Access 2007, I created two similar combo boxes...
Back
Top Bottom