Search results

I have code to calculate discount: Discount=([Discount1]/[Sum1]*[Sum]), but I want discount to save on table. I can't add discount on bound textbox, i try this: Me.CalculateDiscount = Me.Discount Me.CalculateDiscount.Value = Me.Discount.Value CaclcuateDiscount is Bound TextBox. This populate...

Hi there. I have Continuous Forms, to select article for customer, I have unbound text box to discount from total price. Example total price is $14, and I want to discount $4, after that i want $4 discount, to separate on article. I have code to separate discount, but I can't populate all...

Uncle Grizmo, to apply those principles in my database, I have to change the whole structure of my database. How would that be, thank you for your efforts. My database works very good except the problem that I have presented in this forum. So not updating all ranges when I save or close the...

This is inventory database. When I sell multiple goods, I want to update on tblInventory, when I save.

Hi there. I have inventory database. On continuous form, I filter multiple data, that data must updated on save or close, on tblInvenory. I have code to update that data, but not updating all filtered data (rows) on form, updating only first row. (code are designed to update only numbers)...

Thank You very much, JHB. That code is work. Thanks again.

I already remove input mask, on form, tables, also a try removing date format on vba, but no results.

Hi there: I have inventory database. The problem is on date. If I register new data, expired date on tblInventry, is ok, but if I update tblInventory with new data (Amount, or I change expired date, or i left same date), on tblInventory expired dates changes to time (30/12/1899, if click on...

Hi there. I find the solutions according to jdraw idea, i put the vba code on main form to combine date and time on single field. Query: Field: DateTime Criteria: Between ([Forms]![myForm]![srqStartDate] & " " & [Forms]![myForm]![srqStartTime]) And ([Forms]![myForm]![srqEndData] & " " &...

Does not work. Query filters only dates not the time. You can try attached example.

I tried those method not working, i tried this: Collected fields: Expr1: [Date] & " " & [Time] Criteria: Between ([Forms]![myForm]![srqStartDate] & " " & [Forms]![myForm]![srqStartTime]) And ([Forms]![myForm]![srqEndData] & " " & [Forms]![myForm]![srqEndTime]).

Hi there. Can someone help me solving problem Searching on query Between Date and Time I want to prepare report: 1. Report between: StartDate 11/02/13, StartTime 20:00 and EndDate 12/02/13, EndTime 08:00. 2. Report between: StartDate 12/02/13, StartTime 08:00 and EndDate 12/02/13...

Thanks MStef second exampla is exatly what I llooking 4, thank you very much.

Example: If Time1 is 23:30, I can't add Time2 = 00:05 or Time3 00:06. Time1 is on 20.03.12. 23:30 Time2 is on 21.03.12. 00:05 Time3 is on 21.03.12. 00:06

Hi ther. I have table to register some informatinos, and i want to manage times. Example: In my table i have DateInformations, TimeInformations, TimeSuite and TimeArrived. I want to stop user entering less TimeSuite than TimeInformations and less TimeArrived than TimeSuite. If TimeSuite <...

Hi nanscombe thank you very much, that was excatly what Im looking 4, thanks thanks. Good luck nanscombe.

I have tblRegister Column1: BillNr (123456) Column2: Date (17.11.11) How to restrict enterin same bill number on current year? Column1: BillNr (123456) Column2: Date (01.01.11-31.12.11) Restrict Column1: BillNr (123456) Column2: Date (01.01.12-......) Allow I us this vba code for duplicat value...

I have table to register filled receipt costumer,receipt are with serial numbers,book has 20 receipt, steward are charge with book, and are registred in another table, example Name: John Smith, receipt from: 202021 to 202040 Can u make code to allow adding receipt from 202021 to 202040 only yo...