Search results

  1. R

    Access 2013 Query

    Hello geeks! I am grappling with the Query design view of Access 2013 for two days, day and night, in the following way :-( It is a very simple Query, named "qryStudentsByClass" with a few fields, notably: StudentID, StudentName, DoB, Age (Calculated field), and Class etc. I have entered the...
  2. R

    Finding Value of an Un-bound Field

    Hello everybody I have an Access Form with a number of controls - all bound to different Fields from a Table. Everything is working fine except 2 problems, as below. I need to find a value of a Field of the Current Record, in the bound Table; which is not associated with any Form Control. I...
  3. R

    Is a particular form Open or not

    Good day everybody I am making good progress in my project with the help of you geeks. Presently, I am facing couple of problems as below. I want to know; if a particular form, "frmViewEdit" for example, is open or not. If a user tries opening a Child-form, it should see the Parent-form...
  4. R

    Custom Menus fall under AddIn in Access 2007

    Hello geeks The Custom Menus are working fine with MS Access 2003; but they fall under AddIn menu. Is there a way to move them out on the main Ribbon? Please help.
  5. R

    Assigning Default Value to ComboBox from a Table Value

    Hello everyone I have a ComboBox with "Row Source Type" as Table/Query. I am trying to assign it a default value from the attached table, programmatically. It does not recognise ListIndex or Slected(index) etc. Would any wizard help me, with a programatic solution, for getting around this...
  6. R

    How to Find Max. Size of a Record

    Hello wizards I have a query as mentioned on the subject line. After designing the Structure of a table, how can I know what will be the maximum size of each record; so that I can estimate the total size of my data table. Any help is highly appreciated.
  7. R

    Refreshing a Column Value in the Master Table

    I have two tables - a MasterTable and a ChildTable - related by a field "PO_Number" (set as Primary key in the MasterTable). There is a column "PO_Status" in the MasterTable and its corresponding column "Status" in the ChildTable. I need to refresh a column in the MasterTable automatically, as...
Back
Top Bottom