Search results

Dear Folks, in my DB i have tblProtocols (it stores informations/measurements collected by technicians), for each protocol there should be criteria to check if the measurements are OK or not. There are several types of criterias acc. to which we can evaluate it: 1. International Standards...

Hi Folks, I have continuous form which shows the result of the measurements made by technician. You can add measuremnt by clicking Add Measurement, then Pop up form appears to input data. I want to add possibility to that user will duplicate selected record and further edit/adjust it in the same...

Dears, I have form with list box. Depends on the selection in listbox I want to create a new record by vba recordset. Record will be filled with information from a listbox. After thath I want to fire the form for this record in edit mode, so that user can input the rest fields. Will it be fine...

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

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

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

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

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

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

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