Search results

Thanks DBguy. I've just sent off some screen shots to him and have put the ball in his court. Frustrating.

For god sake. Just got off the phone with IT. He made a mistake in telling me they were on 32-bit (i went and physically checked)......I'm now going to murder my IT guy. Sigh

I've all but finished working on this database and have rolled out the front end to a couple of users. They have been able to open the files no problem until this week. I rolled out a new version and now they are getting this error... "This database was created with the 32-bit version of...

Thank you to both of you!! Minty's suggestion worked great! It was so simple! I'm learning as I go and have just learned that it's easy to overthink sometimes....good lesson!!

Thanks for the suggestions!! I'll give it a try. Simple is usually better....LOL I'll let you know what happens. And Thanks to theDBguy for his help too!!

The command button is located on the mainform. The control QtyOrdered (and QtyReceived) is on the subform.

I'm getting a run-time error 3265, Item not found in this collection When I choose debug that's the line of code that's highlighted. I currently have the first code I posted in there, but if I try the other bit of code I get essentially the same thing happen. It just seems to be that one line...

I have developed a PO system in my database that works beautifully, however, i'm stuck on the proper code for a command button. I want the command button to "Receive All". I have a Mainform: Receiving that has a Subform: PORecSubfrm I have placed a command button on the mainform that I...

UPDATE! It worked!!!! Thank you arnelgp!! I had to change one little bit where you referenced lngPO = Nz(Me![Purchase Order ID], 0) Had to point this to the subform where the Purchase Order ID field is. I'm tickled pink!! Thank you so much!

This is awesome! I've been busy today, but will take a look at it tomorrow as soon as I get in. Thank you so much for the suggestion! I'm meeting with the managers next week to show them the database so would be nice to have this little bit of "eye candy" working! I'll check back when I've...

Thanks for the input! I haven't had time to work on it today (busy), but will take a look at this approach as soon as I can. I'll let you know how it works out.

The database is full of sensitive information (I've imported all our data and am using it to keep track of projects at the moment)....wouldn't know how to clear it all out to send to be honest. I've been mucking around with your suggestion though. So I've created a Totals Query and have it...

Thanks for the reply! I'll see how skilled I am at setting this up. Will post a reply if I either figure it out or get more frustrated.

First time posting here. Hope I've got this in the right place. My experience with Access is limited, however, with alot of "googling" I can usually get things figured out. I have used the Northwinds template db to create a database here at work that ties together Projects, Opportunities...