Search results

  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]
  16. I

    table update

    This code won't work ether. Cannot find input table db.Execute "INSERT INTO Sections SELECT Sections_New.* FROM Sections_New;" is it because Sections_new is in the current DB and sections is a linked table what code should i use to tell the difference between the 2 db's and table's
  17. I

    table update

    Yes this works CurrentDb.QueryDefs("qryKeepJudges").Execute But how do i do it with the code strsql = "UPDATE Sections_New INNER JOIN Sections ON Sections_New.SectionID = Sections.SectionID SET Sections_New.Judge = [Sections]![Judge];" db.Execute strsql
  18. I

    table update

    This Works DoCmd.SetWarnings False: DoCmd.OpenQuery "qryKeepJudges" DoCmd.SetWarnings True But i am trying to learn how to do it with db.execute
  19. I

    table update

    I haven't done that before. I will try
  20. I

    Required.Value

    Yes it did.Thanks I am still learning. Cheers
Top Bottom