Search results

  1. G

    Searching in related field

    Hi Folks, When the table field is related to another field in another table then mostly the easiest way to choose a value is to use combo box. When there are available five, ten or even few dozens of values to choose, it is no problem with clarity of using the form. The problem arise when I...
  2. G

    Solved Salary cost for specific date / Valid From issue

    Hello Folks, I work on application to keep the worktime of employees and to calculate their costs. Employees have different salaries depend on the date. In below table it is clearly shown: Worktime is keep in separate table I create the below query to list what salaries should be assign to...
  3. G

    Input of Work Time in Unbound Form

    Hello to All, I am preparing database application which will be storing worktime of each employees. In the form to add the worktime a prepare 2 options: a) add single worktime to specific date (e.g. 5 hours on 02.08.2021) b) add a series of worktime for range of data (e.g. user input 10 hours...
  4. G

    Adding a record only after clicking OK button

    Hello folks, the easiest way to add new record seems to be opening a bound a form with a below code and just enter data. DoCmd.OpenForm FormName:="frmAddNewCustomer", DataMode:=acFormAdd But this method creates a new record when just even one field will be filled. I want to create a new...
  5. G

    Continous form vs List Box. Which is faster/better?

    Hello Folks, I am considering two options for design of my forms: continuous form vs listbox. Form is the part of control tab and the whole database is a splatted to front and back end via server in my Company. Have already somebody had any conclusions about using one or another? 1. Continous...
  6. G

    Solved Get value of a textbox on the parent form from subform

    Hello Folks, I have a parent form frmStatement. It has subform sfrmGeneral, which is placed in ControlTab. In the header of frmStatement there is txtbox named txtDisplayMode. It receives values 0 or 1 from OpenArgs. This control is unbound. For sfrmGeneral, on Form_Load event I cannot read...
  7. G

    Separate or common forms to manage Offers and Orders database?

    Dear all, I am developing access database to manage Offers and Orders in my company (add items, calcutate prices and to automate process of generation reports, purchase orders and other documents). I have already create a part dedicated only for Offers part. The simplify structure of already...
Top Bottom