Recent content by InFlight

  1. I

    Convert form's Macros to Visual Basic

    Hope we all learned something. I did
  2. I

    Convert form's Macros to Visual Basic

    Thanks all for your help. i got fixed. With CodeContextObject If IsNull(SearchBox) Or [SearchBox] = """" Then ' Clear Filter when search box empty DoCmd.ApplyFilter "", """""", "" DoCmd.GoToControl "SearchBox" DoCmd.SetProperty...
  3. I

    Convert form's Macros to Visual Basic

    It is a Function in the forms vba
  4. I

    Convert form's Macros to Visual Basic

    Hi I used "Convert form's Macros to Visual Basic" but i am getting errors in the If(eval) line. I have a text field called SearchBox on a form called Suppliers Function Search() On Error GoTo Search_Err With CodeContextObject If (Eval("[Form]![SearchBox] Is Null Or...
  5. I

    Page Header and GroupHeader being repeated

    That worked. Thanks so much
  6. I

    Page Header and GroupHeader being repeated

    I thought this might be a common problem and have a easy fix
  7. I

    Page Header and GroupHeader being repeated

    Yes it still works, but on some pages it is useful to have
  8. I

    Page Header and GroupHeader being repeated

    In some reports i do, others i have already taken them out
  9. I

    Page Header and GroupHeader being repeated

    Hi all How do you stop the Page Header and GroupHeader being repeated at top of page. I have attached screen views to show what happens and how i have the form. Thanks
  10. I

    Me.WindowWidth

    Hi I am trying to resize a form, but Me.WindowWidth but gives me a negative number on a 28 inch screen but it is ok on my 17 inch laptop i am using Abs(Me.WindowWidth) as a fix but only use's 3/4 of the screen Using access 2010 Does any one know why. :confused:
  11. I

    Question one to one relationship

    Yes i get a 1 to 1
  12. I

    Question one to one relationship

    One table is called Exhibitors with a field called ExhibitorID, AutoNumber another is called Finance with a field called Fin_ExhibitorID, Number Both are primary keys
  13. I

    Question one to one relationship

    Hi i am using the following code to create a relationship. But it creates a one to many, and i need a one to one Public Function CreateRelation(primaryTableName As String, primaryFieldName As String, foreignTableName As String, foreignFieldName As String, RelationshipName As String) As Boolean...
  14. I

    Required.Value

    not to me.
  15. I

    table update

    yes SectionID does exist in both tables Both tables are the same except some of the data is different. I need to keep the judges names before the data is removed from [Sections] and replaced with the data from [Section_new]
Top Bottom