Recent content by Willem2904

i have now managed to populate the PDF forms with data from the access database (so the "Write" part is OK). Now I just need to figure a way to to the "reading part".

Hi Everyone, I found the following code very useful to populate PDF Forms from an excel spreadsheets, and the other way around, to populate the Excel spreadsheet with data from the PDF Forms: https://www.myengineeringworld.net/2013/10/read-and-write-pdf-forms-from-excel-vba.html However...

Because I want to see a report, not a form.

Hi, I have a report which I want to sort based on the values in textboxes and comboboxes. The code below does the job, but only for 1 textbox/combobox at a time... I want to apply the filter based on several boxes simultaneously... Could you guys help me? :) Private Function ApplyFilter() As...

I did see that video. However, as I said, the image should be stored inside the database, not as a hyperlink. :(

Hi, I have built a report consisting of tasks. Each task gets an "ITP" code. If the report code is "B" for example, I want to show an icon for "Budget" If the report code is P, I want to show an icon for "Plan" If the report code is A, I want to show an icon for "Approve" (See image above, I...

Thanks a gazillion!

OMG, now I feel stupid... :( That was the reason why... I now added an existing field ("Full Name") to the report and it works!

For the new collumn, I tried the following code: SELECT DISTINCT [FullName] FROM Employees ORDER BY [FullName];

The field "Full Name" is a calculated field, using [First Name] & " " & [Last Name] I also added a new collumn to the table "Employees" called FullName. I added FullNames manually, and tried with that field. Still doesn't work...

See attached file :)

OMG that did it! GREAT! Now just one issue left, and that is the "Full Name" This one still shows a pop up. Could that be due to: 1. A space between "Full" and "Name"? 2. the fact that this is a calculated field?

Please have a look at the 2 files attached. The table "Projects" contains the field "Project Name" which I used in the row Source. The Table "Tasks" contains the fields "Title" and "Status", which I also used in the Row Source. So if Status works, why doesn't title work? :(

Here's a screenshot.

When I enter the code like I did above, nothing happens