Search results

  1. 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...
  2. 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
  3. 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:
  4. 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...
  5. I

    table update

    I have 2 Tables Sections_New and Sections. Both have the same fields and data type. I am trying to copy the data from the Judge field from Sections into Sections_New using the following code the error is cannot find input table Sections_New. the table Sections is a linked table and Sections_New...
  6. I

    Required.Value

    I am using VBA to change [myTableName]![myFieldName]!Required.Value = -1 I am getting error Error 2465 Can't find field '|1' referred to in your expression
  7. I

    Insert Fields into a table

    Hi I found this code and using it. My problem is i am addind a field called PhoneNum. it adds it ok but i want to change the InPut Mask to varMask = "!\(999" & Chr(34) & ")" & Chr(34) & "900\ 0000;;_" Public Sub fSetOrdinal(db As Database, strTbl As String, intOrdinal As Integer...
  8. I

    Split form record selectors

    Is it possible to hide the record selectors on a datasheet in a split form. They have a + and when you click on them it shows the sub form which i don't want them to use through the datasheet as it has code on some of the fields. Thanks
  9. I

    In design view subform appears as a blank white rectangle

    I have a button on my form to go to design view. When I change from form view to design view on a form with a subform, the subform usually appears as a blank white rectangle.:confused:
  10. I

    Find and Replace

    This question is about an old program called "Find and Replace 9.0" by Rick Fisher I used to use it when I had Office 2003 now I am using 2010 and it want work anymore. The program provides a "Find and Replace" function for Tables (searching design elements such as field names, not the data in...
  11. I

    Question calculate inbreeding

    Hi. I am building a database for bird breeding. Does anyone know of any code / Function to calculate inbreeding and AVK. Cheers
  12. I

    Question ActiveX Controls

    Hi all Does anyone know anything about an ActiveX Control ciaXPSpin30.XPSpin30 I find them good except that you can't change some of the values. ie Max, Min etc The max is set at 10 and i would like to set it to 3000 and the Min to 2000 Any idea's Thanks
  13. I

    Enter Password for Select in

    I have written a database for bird shows. I need to see what data is changed in a table. in a query from a different database. I have this SQL SELECT Exhibitors.* FROM Exhibitors IN 'M:\InFlight\Data\BirdShowData.accdb'; When i view it in design view it asks for the password which i enter then...
  14. I

    Moving from one record to the next

    Hi all What is the order of sequence when moving from one record to the next in a form? Is the On Current triggered first?
  15. I

    Lock table default values

    Hi I have a table that i need to lock the default value from being changed in table edit view
  16. I

    InFlight

    Hi to you all from New Zealand
Top Bottom