Search results

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...

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...

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...

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...

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

Hi everyone, I have a form I'm using to create Job Numbers. All of my table are normalized and everything, I'm just having trouble filtering. I have a Table called Customer Type and a Table called Customer Information. Customer Information has a Customer Type lookup. Customer Types are...

Hi everyone, I'm building my first ever database and need some help. I've created a Multiple Items Form called PurchaseOrderLineItems, and it is being used as a subform. It comes from a Table called Purchase Order Details. My columns in the form are Manufacturer, Model#, Description...