Search results

Does that path exist, and can you create a file there? Does the report open manually?

No problem, but pay attention to what Josef suggested doing. Also make sure you can manually open the report after the code has run and failed to create a file. The "usual suspects" are either a bad path or illegal file name, or a data problem that prevents the report from opening.

I did get it and set it up. It was very frustrating; in real life I normally hit a draw, in the game I kept hitting big monstrous slices. One of the holes that comes with the game had water down the right side, and I struggled to keep it out of the water. I felt like Costner in Tin Cup; hit...

And for clarity, Adobe is not required at all for Access to create a PDF with that code.

I would pass the name of the calling form in OpenArgs and use that to return. Since you didn't post any of your efforts, we can't help fix them. ;)

Welcome from an occasional visitor to VA. :p

For clarity as it seems confusing and you use the term "frequency", are services repeated? In other words, if a machine requires the 100 hour service, is it done again at 200, 300, etc hours? Or just once at 100 hours and never done again?

Like I said, mine was a brute force attack. I suspect it could be done much easier with a Gantt chart, but I have no experience with them. Search on that and see what you find.

That doesn't seem at all like the original request. I did something along these lines a long time ago to display limousine reservations on a given day. If memory serves I used a brute force method of populating a temp table with reservations within a loop. I'm sure there's a better way, I did...

I had a discussion/debate with a son-in-law about this very topic a while back. His position was that with all the automation by Amazon and other big companies there wouldn't be enough jobs and we needed a UBI. His suggestion was $1,000/month for every man/woman/child in the country. I did...

What is your code now? Do you get an error, or the results aren't as desired? If the second, what are you expecting to happen vs what does happen?

Did you try the code from the link in post 2?

How about: https://stackoverflow.com/questions/39497486/is-correct-the-code-for-bring-to-front-or-send-to-back

Note this was posted in the SQL Server forum.

Welcome back aboard!

Did you try the method from the link? Given your example above: SELECT Invoice, Sum(Total) As SumTotal FROM DetailsTable GROUP BY Invoice That's just the basics, you can add the other table and fields as desired. The key is to group by the fields you want to be unique and sum the others.

I think you want what's known in Access as a totals query. Here's a start for SQL Server: https://learn.microsoft.com/en-us/sql/t-sql/functions/sum-transact-sql?view=sql-server-ver16

Happy to help!

Welcome aboard!

I can't even bring myself to click on the link. :cry: