Recent content by ayeshamiah

  1. A

    Does any one out there know ?

    Many thanks for your help caroline and, You have opened my eyes. It explains why the code has been behaving erracticly. I have now resolved all the issues. Many thanks again My apologies Richie and all members for venting my frustration out on the forum, it was wrong and very childish...
  2. A

    Maximize forms

    Sorry richie I meant Ron
  3. A

    Maximize forms

    Jack you are wrong and richie is that a tested answer or a wild guess.
  4. A

    Does any one out there know ?

    anything about how access treats forms that are being maximized Thanks to all you have tried to help to my previous question, but I don't think you have understood this site has always disappointed when it has come to giving answers invoving any VBA code.
  5. A

    Maximize forms

    Help, I'm losing it all I want to do is maximze all my forms at the request of the client from hell Naively I thought all i needed to do was docmd.openform blah blah docmd.maximize but Oh no that does not appear to gurantee success I have made all the forms popup poperty set to yes and...
  6. A

    Screen

    I have database that I would like to distribute. How do I make the forms adjust to differnet monitor sizes?
  7. A

    Forms Centre screen

    Please help me I new to the way forms etc are created in acces I am trying to create forms which will autocenter on the screen. I have used the autocentre property but it doesn't seem to centre it. does it make any difference if the forms are popup forms with no borders The forms just appear...
  8. A

    Select Specific record in recordset

    RpbertS I haveb't actually worked out how to select a specific specific record which I am now embarking. I resolved my earlier problem, which was to compare to fields on two tables and put the comparison text into a third and so I only needed to access the records sequentially I did this by...
  9. A

    I am Stumpted - Parsing Nightmare

    Hi Ricky, How far have you got so far I have had a similar sort of nightmare, I have some code which may be of some use to you but you will have to amend it I used the following to convert this ",1,19,24,29" to individual integers and fill an array. I got the code from a book if it helps...
  10. A

    Selecting Specific Records using For i =

    Access Gurus, I have an array it looks something like this (1,4,5,6,20) these are record numbers I want the next button on my form to show the next record in my array. Any ideas TIA Ayesha
  11. A

    Access Equiv of XL Evaluate Function

    does any one know of the access equivalent of the Evaluate function. I am trying to get this to work Sub makearray() Dim x As Variant x = Evaluate("{1,5,9,15,16,17,25,29,30}") 'makes it a variant array For i = 1 To UBound(x, 1) MsgBox x(i) Next End Sub
  12. A

    Importing Text

    That the one Iused thanks min, I'll find my way round access eventually
  13. A

    Filling Arrays

    Many thanks Drew
  14. A

    Filling Arrays

    Hi all, I have a string variable which goes something like this "1,4,13,15,19,23,29" I would like to fill an array with the values seperated by the commas. The glitch is how do chop the string and subsequently fill the array. VBA Solutions please Thanks in advance, Ayesha
  15. A

    Select Specific record in recordset

    Thanks bones01 but really I need VBA solution and I think I may have found.
See more
Top Bottom