Search results

Hello everyone, i have 2 tables, tbl_Task and tbl_Worker. They are connected using a 1-n relationship over the "TaskID" and "TaskID_F", so one Task can have multiple workers. What i want to do now is, i want to show the names of all the workers, seperated by a comma for each task. So i need to...

Problem solved. Thank you very much!

PERFECT! This is exactly what i was looking for! Thank you very much!

Hey. Thank you for your response. I already have a caption on the form to differenciate different tasks from each other. I guess changing the tab label is impossible then :) For neuromans post: My boss wants to be able to open multiple tasks at a time, and then switch between them. And what the...

Hello everyone. I have a database with a form called frm_Auftrag. After pressing a button i am creating a new Form instance of frm_Auftrag using this code: 'Creates new Form instance Dim f As New Form_frm_Auftrag 'Module Collection to store the form, else the form will be destroyed once the...

Hey everyone, i am getting the "ambigous outer join" error after running my query. But i dont understand why. My query design looks like this: How can i remove this error? If necessary i can also send in the content of the Subquery or provide other informations you need for debugging. Just...

I know this post is really old but i can not find an explanation either, and i really need an answer on how to embed a word document in a access report OLE.

Okay i found a solution. I added the following line: Private Sub Detail_Paint() Screenshot.Picture = Me.ScreenshotLink Screenshot.Visible = Screenshot.ImageWidth < 6000 And Screenshot.ImageHeight < 6000 MsgBox ("Width: " & Screenshot.ImageWidth & ", Height: " &...

Hey everyone, for my current Access Project i need to create a report and show/hide an image based on the size of the image. For this i used the Paint and Print Event of the Details section of the report. My code looks like this Private Sub Detail_Paint() Screenshot.Visible =...

Hey everyone, we all know that little message that pops up when you want to delete a record, but the record is connected/in a relationship with another existing record. "The record cannot be deleted or changed, because table X includes related records". Now for this i imagine access doing some...

Hey, thank you for the link. Finally it is working using the basGDI Module! Thank you very much! For future viewers: i changed the code Public Sub LoadImages(imageId As String, ByRef Image) Set Image = LoadPicture(CurrentProject.Path & "\Icons\" & imageId) End Sub to Public Sub...

Yeah but PNG images are not supported by the LoadPicture function. The file name of the graphic to be loaded. The graphic can be a bitmap file (.bmp), icon file (.ico), run-length encoded file (.rle), or metafile (.wmf).

Hello everyone, for my current project i created a custom Ribbon Bar using XML. For that i want to use custom icons, as you can see in this screenshot. Basically my goal is to load an image (Red circles with numbers from 1-10) and display one of them, depending on a variable. I created a...

Hey, sorry, that was not clear at all. You know, when you create a report that continues over multiple pages you get the control box, as you can see at the bottom of the screenshot. When you click on the arrow on the right you can cycle to the next page. When i add a subreport to a form though...

Hey everyone, so I am trying to create a subreport on a form to preview the report before printing. The problem is i can not bring the subreport to split into multiple pages, it will always show one continous page. Because this is not how the subreport will be printed i need to change that...

Yeah, but i noticed this was the first result on google, so i wanted to add it after i found a cleaner solution :D It is not that i wanted to "help the author", but everyone who will stumble upon this in the future

An easier approach for this case without a recordset would be DCount("*","tbl_Of_Desire", Me.Filter)

I know it is annoying that you can not use labels but textboxes work fine. If you do not want the user to be able to edit the values you can set the enabled property to false and the locked property to true. Cheers

Hey Ksabai, if you want to add parameters from different queries you can edit the form source property! Just open your form in design view, property sheet -> form -> data and then edit the record source using the 3 dots. With right click on the big area you can add your tables and queries you...

Thank you very much for this info. As you probably already guessed i try to link outlook emails in access. Then i will just pass the email as a MailItem from Outlook to Access, get the Entry ID and then store this. In addition to that i can retrieve the email again by using the GetItemFromID...