Search results

A field in one of my tables an input mask which means the user must enter a value into (__)%. Now when i run my invoice report i need the discount percentage to be taken from the total. For this i could use the code: GrandTotal = SubTotal - ((SubTotal/ 100) * (CompanyDiscount)) However, here...

Hi, - I had a form where orders are shown and a subform within it where products can be selected for these orders as desired - All the records were displayed in the form Now i added another subform where the orders can be assigned to certain customers. This form works fine and the values...

I have a combo box where one customer can be assigned to one order. The after update event is: [CreditUsage] = [CreditUsage] + Forms![frmOrders]![OrderTotal] Refresh ...and the before update event is: Me.[CreditUsage] = Me.[CreditUsage] - Forms![frmOrders]![OrderTotal] Refresh The aim of...

Hi, I tried to search the forums for an answer but I still can't seem to solve the problem. I receive the "Not a valid bookmark" error message when attempting to open my database. I have tried the compact tool through access and also jetcomp but it just brings up the same error message on...

Hi. New to this forum but i searched and found a section of code, shown below: If Me.Dirty Then Me.Undo MsgBox "This would create duplicate references to products for this order. Your changes have been undone.", vbOKOnly + vbInformation, "Changes Erased" End If So, I have a form whereby...

Hey, I found this website on google and had a search around to see if I could find a few answers to some problems. It has helped a lot, however, I have stumbled upon the type mismatch error. I have used some of suggested ideas on other threads (such as using 's) but still can't figure out why I...

Hi. This is probably a stupid question but it is becoming annoying trying to figure it out. I have created two linked tables and then created forms to enter information into them. While i was working i tested several pieces of information by entering information into the tables and forms. Now i...

I have a table and in there is the names of sandwiches, their prices and also extra info which includes whether the sandwich contains nuts etc. The actual text is "MAY CONTAIN NUTS" . When searching through the query i have made, there is the text - Extra info? for the query criteria or...