Replies

That makes sense. Why didn’t I think of that? Thanks for your help.

About one year ago I switched over to webmail also. I primarily use Gmail, but I do have an Outlook.com account. Just this week (prior to reading this article) I started using Outlook.com a little bit. I’m not convinced yet, but have been favorably impressed. I now use Thunderbird almost exclusively for an intranet email with our SME Server.

OK. Thanks. I’ve been busy on a tech call most the afternoon, will try this tomorrow.

Yes, we’re running Microsoft Access 2010, AND all machines are left running all the time. I’m glad you asked the question about the backend. I did not present my problem correctly, it was misleading. I am actually decompiling my frontend, and compacting my backend. The frontend that I decompile is obviously an .accdb which I call GTDevelop. The backend is GTData.mdb. A friend recommended I keep the data in .mdb format so I just took his advice, but the frontend is .accdb. Everytime I push out an update, I publish it as an .accde and rename it DataEntery.accde. Every night a batch file also runs pushing out the .accde to each client so they have the latest version.

I have rarely used PowerShell, but that shouldn’t be a problem to set up on each client. I’ll do some research on what you suggested. Thanks!

Thank you! I never though to check that table. It either got corrupted or someone got in there and changed it. It had 4 blank records in it. I corrected the count and it works wonderfully now!

Merci beaucoup!

I do not get any error messages. I only get 1 label per record.

Sorry, I should have been more explicit. I am using this on a form, trying to get a Purchase Order ID from the date we enter the PO, plus the Product ID (minus the 3 first letters which indicate a category which for this form we don’t need the category), plus the printing code that gets printed on the product that tells us how many were in the printing lot. I realize that’s an awful long code to store, but I’m going to use it in my tblInventoryReceived to calculate how much product we did receive, as the product isn’t always delivered in one shipment. So, I will have a calculated field that will calculate how much of the product has been delivered, and once it equals the amount ordered, the Purchase Order will be closed.

Below is the code that I finally managed to get it to work. I had to use the full hierarchy with forms to get it to work.

Code:

[B]Private Sub tpQuantityOrdered_AfterUpdate()
    Me.tpPOID = Format(Me.tpDateEntered, “yyyymmdd”) & “_” & Right([COLOR=”#006400″]Forms![frmTractPurchases]![tpProductID][/COLOR], (Len([COLOR=”#006400″]Forms![frmTractPurchases]![tpProductID][/COLOR]) – 3)) & “_” & Me.tpPrintingCode
End Sub[/B]

This is the message I receive with that.

35141-RightErrorMessage

My apologies for not responding! We’ve been having some network issues and I’ve been involved with that.

I took what ruirib suggested and tweaked it to the code below and that works:

Code:

SELECT tblProducts.ProductID, tblProducts.ProductName, Sum([tblStockTake].[UnitsInStock]*[tblProducts].[QtyPerBox]) AS InStock
FROM tblProducts INNER JOIN tblStockTake ON tblProducts.ProductID = tblStockTake.ProductID
WHERE (((tblStockTake.StockDate)=(Select Max(StockDate) From [tblStockTake] where [tblProducts].[ProductID]=[tblStockTake].[ProductID])))
GROUP BY tblProducts.ProductID, tblProducts.ProductName;

I thank all of you for your help, I have been too busy at work to get around to this and am leaving on a business trip today. I’ll try to get back to this (I hate to leave jobs unfinished) when I return. Thanks, everyone!

Ooops. I guess I have to back up a little. With that formula, it finds the correct months, but now if a person’s birthday is between now and the end of the year, it adds 1 to their age.

Thanks a million, jmusgrove. That’s exactly what I was looking for.

OK. That ‘almost works’. What it does is gives me the months if a child is under 1 year, but not exact. It rounds up. For instance, a child whose birthday is 12/21/11, it shows as 1 year, and a child with a birthday of 8/25/12 it shows as 3 months.

I’m sorry, that didn’t work. I tried IIf(datediff…..) and I think it was that one that calculated years OK, but I never could get it to show “months”. I was on a deadline, so I finally exported it to Word and edited it in Word where I needed to add ‘months’. Thank you for at least looking at it. The crunch is off, but I’d still be interested in a solution, if someone has one.

Understood. Thanks again.