Recent content by Orbik

  1. O

    Writing to Text boxes on a Form variable /loop

    I figured it out i needed this line. Me.Controls("txt_" & i) = ThisLine
  2. O

    Writing to Text boxes on a Form variable /loop

    HI All I some code that is reading the first 32 lines of a text file and paste the results into 1 text box on individual lines. I would like each line to go into an individual text box. I have 32 text boxes named txt_1, txt_2, txt_3 I have a variable named ThisLine holding the line of the...
  3. O

    Linking Subform in Tab Control to Main Form

    Thank you that did it. I will leave you alone now. Thank you so much for your time.
  4. O

    Linking Subform in Tab Control to Main Form

    I have worked around it using the DoCmd.Maximize but unsure why I need to.
  5. O

    Linking Subform in Tab Control to Main Form

    Hi JHB Back Again, Everything works OK thank you, but any form that is supposed to be full screen isn't and when I go to create any new tables, forms, Reports etc... they are also in window mode rather than full screen. Any Ideas? I didn't know if you had pressed a button somewhere to enable...
  6. O

    Linking Subform in Tab Control to Main Form

    Thank you so much, I wouldn't have tried that. I started a new db with the same setup and it worked so I was well stummped. Any Ideas how it could get corrupted? I cant thank you enough. Kind Regards Chris L.
  7. O

    Linking Subform in Tab Control to Main Form

    Hi JHB thanks for the reply. Please find attached the db. The home page will open, press Customers. This is the form I have a problem with. I have resolved to switching between customers so no error appears. It is when I try to add a new contact or project from one of the subforms when the...
  8. O

    Linking Subform in Tab Control to Main Form

    Hi All Last night I was working on a new db and wanted to use a few subforms inside a Tab Control. One subform per Tab. I linked the forms last night and everything was working fine. but loading it today I am getting the following error: The LinkMasterFields property setting has produced this...
  9. O

    Error Handling, Loop, External Paths

    Hi pbaldy, Sorry I lost this post and couldn't figure out how to recall it in my preferences. Thanks for the reply, I have sorted it out and learnt what everything in the code meant as per your instruction. Thanks again.
  10. O

    Error Handling, Loop, External Paths

    Hi All I am setting up a form to send multiple attachments to an email. I have a query "qry_DwgEmail" that has an ID and a path column. On the form I have a button with the code below in the Click Event. The code below all works fine unless the path is incorrect, so I would like some error...
  11. O

    Query - Compare, Add, Change & Delete.

    Ok After some searching and playing I think I have figured out what you meant Plog. I have it all working and it is much easier now Thank you. However I still need a report telling me the changes between the existing and new table which I cant work out. I only need to see the changes to the...
  12. O

    Query - Compare, Add, Change & Delete.

    Why? I don't know it is the only method I could think of from what I have learnt so far :). Your answer sounds good but I don't understand what you mean sorry. Could you give an explanation on how to do this please. These will all eventually end up being displayed on a split form, one form for...
  13. O

    Query - Compare, Add, Change & Delete.

    Hi All I am new to access and don’t really know what I am doing with the queries. I thought I had sussed it after 3days of hardcore googleing but I havent :-( I have attached my database. Basically I would like all our stock records from our current system (Lakeview) in an Access database so...
Back
Top Bottom