Search results

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...

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...

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

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...

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...

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...

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

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. -...

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...

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...

Appreciate all your help!!!

IT WORKS!!!!!! :D what was the problem

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

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...

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

Still getting stuck (see attachment), This is the codes as it stands: Private Sub Command98_Click() DoCmd.Close acForm, "frmCandidates", acSaveYes Dim objAccObj As AccessObject Dim objProj As Object, openFrm As Boolean openFrm = True Set objProj = Application.CurrentProject...

Thanks pr2-eugin, But no goods, get stuck at: If objAccObj.IsLoaded() And objAccObj.Name <> Me.Name And objAccObj.Name <> frmMainForm Then

I have so many forms, any quicker way without listing them all!?

Im getting confused here. I need it back to front dont I lol. I need it If NO FORMS are open, then open main form

Not working unfortunately, This is my code: Private Sub Command98_Click() DoCmd.Close acForm, "frmCandidates", acSaveYes If CurrentProject.AllForms("").IsLoaded Then DoCmd.OpenForm (frmMainForm) End If End Sub Also Tried removing the quotes in the brackets: Private Sub Command98_Click()...