Recent content by RammerJammer1674

Hi everyone, I'm having problem calculating percentages. I have a Table that has fields for SystemPrice, PriceAdjust, PriceAdjustPercentage, and TotalPrice. All are Currency except for PriceAdjustPercentage which obviously is a percentage and TotalPrice which is a calculated field...

That's perfect. Thank you so much!

Hi everyone, I'm not real sure which thread to ask this question in, so I'll just put it here. What's the easiest way to track inventory? I have Tables set up of Products, Inventory, Orders, Job Numbers. Job Numbers will have Products particular to that Job. You can Order Products for a Job...

It worked OnLoad. I had to do a few SetTempVars but I manipulated it enough to make it work. Thanks a lot baldy! :p

I tried it behind the OpenForm Macros I have to open the second form, but that is giving me an error as well. I'll try it OnLoad and let you know if that works! :)

Thanks for getting back with me so fast. I've tried the SetProperty Macro. It keeps giving me an error. I tried putting the macro in the "On Open" part of the form, but it won't do that either. I may just create a button to make it simple on myself. :banghead:LOL

Hello everyone. I have a [New Job Number] form in my database. In this [New Job Number] form, I have a [Purchase Orders] subform showing all open Purchase Orders. I have a button in the [New Job Number] form to open another form called [New Purchase Order]. How can I transfer all of that...

Bump. Can anyone help at all? :D

Yes, I have. But that's not the line that is giving me problems. It works in some of my other macros. Just not this particular one. It's just my SetReturnVar that is giving me errors.

Hi everyone. I'm having problems with the very last line of my macro. It's a SetReturnVar. When I set the Expression= some arbitrary value it works. However, when I set the Expression = VendorName, the way it needs to be, it gives me an error saying the identifier could not be found. Any...

Ok, this is working out perfectly. Thank you so much. I do have a couple more questions though. I have a subform in my Purchase Order. It is for my line items. Can I force a new page when I get to so many records in the subform. Example: If I get to 18 line items, but still have more...

I believe that's what I'm looking for. Is there an easy way to copy/paste a layout? I haven't been able to figure that out... Do you just copy/paste onto a blank form? Sorry, nothing I do is working lol...

Emailing Form Record Hi everyone, How can I email one specific record of a form? This is for doing Purchase Orders. Thanks!

I keep getting a Page Not Found whenever I click on a few of those links. Do you mind modifying my database so I can sort of see a sample on how you did it? Just something quick and simple. I'm not creating this database to sort of RUN the company or anything, just to simply help make my job...

Here you go. Sorry, I had to make sort of a generic database. Also, my Purchase Orders Details Forms needs to be continuous which is no problem, and it will be a subform in the New Purchase Orders Form. It needs some filtering as well. The Items in that Forms needs to be filtered by...