Search results

  1. K

    Populate Continuous Forms

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

    Upadate continue form problem

    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)...
  3. K

    Date format problem on update table

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

    Search Between Date and Time

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

    Less than on time

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

    Duplicat data on year

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

    Allow adding serial numbers from to

    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...
Back
Top Bottom