Recent content by Gouda42

  1. G

    Many to Many Relationships Displayed in one Row

    Yes any way would work doesnt need to be in separate columns. at most it would be 5 columns but hundreds of rows, they wouldnt have more that 5 strategy's. That VBA is a little hard for me to follow.
  2. G

    Many to Many Relationships Displayed in one Row

    I have looked for this online before but wasnt able to find anything. I have a many to many relationship and i want to display it in on single row, right now my many to many table looks like this LegalID1 - Strategy1 LegalID1 - Strategy2 Legal ID2 - Strategy3 etc.. I want it to look like...
  3. G

    moving text boxes

    So Decided to get rid of lines becasue it became too much of a headache, but going back to where you said set the text box to grow, and give it no height. When doing that it does shift up but only till it hits where the txt box above it would be. on the pages of the report where the text box...
  4. G

    moving text boxes

    so i have already turned all my labels into text boxes because i have seen a thread before addressing visible labels, i have changed the height to zero and when i go into report view i do see it shift up but the problem is that i have a customized report where i have inserted lines around a...
  5. G

    moving text boxes

    what i was sort of thinking was If IsNull(Me.Eur_Intructions) Then Me.FFC_Account.move(500, 500, 0, 0) it obviously doesnt work but thats what i thinking
  6. G

    moving text boxes

    I also don’t know what sort of sub it should be under as well. I am going to eventually export them to pdf
  7. G

    moving text boxes

    Yea just move them up.
  8. G

    moving text boxes

    i have a large report with lots of text boxes, based on the criteria some text boxes are set to visible and disappear. I have other text boxes below and would like to get them to slide up on the report. I know about the textbox.move method but I haven't been able to get it to work any advice...
  9. G

    Export Report Into Individual PDF's based on field

    so the first thing i would say, is that i dont know anything about VBA and very little about access. I just know the basics, tables, forms and reports. So i probably need a more visual guide
  10. G

    Export Report Into Individual PDF's based on field

    I have a report linked to multiple tables that list an account and different wiring instructions. Each report is one page long and is manipulated with the legal entity(name of account) and each report is filled out accordingly. My problem is i need to export the report and I can either export...
  11. G

    PDF export issues

    I am trying to export my form which has many different pages and filters for each page. It is exporting properly, all the different forms are there but when when I open it , there are blank pages in between each one and a grey rectangle appears and pushes the following form down screwing up the...
  12. G

    Form combo box

    I am trying to use a combo box to completely filter my form. Right now I am using a filter on a txt box related to my primary key to filter the form and it works it’s just not that user friendly. My main form is called fund list and my primary key that relates to all my tables and the one I am...
  13. G

    Form Error

    Hi I am a new user to the forum! I currently work with creating forms for wire instructions. I will try and lay out the different tables and how they relate. Essentially it is very simple, there are multiple acounts with all basic information and each account has separate wire instructions...
Top Bottom