Search results

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

Like this? Private Sub Filter_Click() Dim strSQL As String, intCounter As Integer ' Build SQL String. For intCounter = 1 To 5 If Me("Filter" & intCounter) <> "" Then strSQL = strSQL & "[" & Me("Filter" & intCounter).Tag & "] " _ & " = " & Chr(34) & Me("Filter"...

Row Source: Project: SELECT DISTINCT [Project Name] FROM Projects ORDER BY [Project Name]; Task: SELECT DISTINCT [Title] FROM Tasks ORDER BY [Title]; Status: SELECT DISTINCT [Status] FROM Tasks ORDER BY [Status]; Assigned To: SELECT DISTINCT [Full Name] FROM Employees ORDER BY [Full...

It appears the attachements were included in the post after all :-)

Hi all, I am quite new to Access and have been working with a sample DB from Microsoft. I have been looking for some ways to filter a report based on the values in some comboboxes, and have followed the instructions on a website (can't post link yet) I also looked at this file (**can't post...

Same here! Greetings from Norway!