Recent content by willbo987

  1. W

    Display image (within attachment field)

    Ok so I got round it!!!! My problem was that I had two tables that were not linked but needed something from TABLE1 depending what was in TABLE2. So I created a seperate query and created a SubReport just showing the image based on the new query. Then on my report just added in the sub report...
  2. W

    Display image (within attachment field)

    Hi there, I have an image within the attachment field on a table. The particular table is not linked with the data within the report. I tried to use DLookup but found it only showed the picture name i.e. signature.png How can I display an image (in fact the only image) in the attachement...
  3. W

    Save Value of Field and use it once form closed

    SORTED IT!!!! Made the form requery before going to record :D!!!! Thank you THank you Thankyou
  4. W

    Save Value of Field and use it once form closed

    Ok start again, Made a few mistakes. On the MainForm I have this: Public Sub GoToID(CompanyName As Long) With Me.RecordsetClone .FindFirst "CompanyName = " & CompanyName If Not .NoMatch Then Me.Bookmark = .Bookmark End With End Sub On the Popup Form I have this...
  5. W

    Save Value of Field and use it once form closed

    Ok so i am a bit of a newbie... I have put this vba code on the main form. BTW the main form is called frmDCPCConsortiumMembers. Public Sub GoToID(CompanyName As Integer) With Me.RecordsetClone .FindFirst "CompanyName = " & CompanyName If Not .NoMatch Then Me.Bookmark = .Bookmark End With End...
  6. W

    Save Value of Field and use it once form closed

    Hi there, Thanks for any help you can offer, I have a MainForm. Using a button on the MainForm i open an PopUp form which I enter values. I want to save the value of a field (text), close the PopUp form. Then use the Saved value in the MainForm to find a record. So far I have this but not...
  7. W

    Curved Text?

    Hi again experts, Is there a way to make text fields or text labels curved? Is this even possible?
  8. W

    Png transparency!

    GOT IT WORKING But just before doing so I used Photoshop -> File -> Save for Web I then used these settings: (Sreenshot of settings) http://prntscr.com/6sikeg To summarise: - Exported image using Photoshop Save for Web - Insert a GIF-image/png (with transparent background) into Word. -...
  9. W

    Png transparency!

    RIGHT! Still looking and found this on another post: - Insert a GIF-image/png (with transparent background) into Word. - Right-click the image in Word and copy it. - Paste it in Access in a form (design state). - Right-click the image in Access and set backgroundcolor to transparent. THIS...
  10. W

    Png transparency!

    Hi experts, First of all I am using Access 2013 I'm sure you have heard this one before. I have spent hours looking for a solution over the net but cannot find one. I have a report. On the report is a standard .jpg image. This is not the problem. I also have a .png image of a signature which...
  11. W

    Check if All Forms are closed

    Appreciate all your help!!!
  12. W

    Check if All Forms are closed

    IT WORKS!!!!!! :D what was the problem
  13. W

    Check if All Forms are closed

    It closes the frmCandidates form im in. Nothing more :(
  14. W

    Check if All Forms are closed

    hmmm no hidden forms, I think simple is more in this case and just going to refer to the main forms that a user may use: DoCmd.Close acForm, "frmCandidates", acSaveYes If CurrentProject.AllForms(frmCompanies).IsLoaded Then Exit Sub ElseIf CurrentProject.AllForms(frmCourses).IsLoaded Then Exit...
  15. W

    Check if All Forms are closed

    OK!! The Form that I close closes without any problems. At this point there are no other forms open. However the main Form does not open. We are half way there :D
See more
Back
Top Bottom