Search results
-
M
Display Record in a subform based base on a combo box value
Good Day, I'm creating a database for my inventory. For now, my database have two tables namely tblSupplies and tblDetails. I have a main from (frmMain) and a subform (subDetails). On the main form i have a combobox (cboSupplies) and 5 textboxes, the cboSupplies and the five textboxes are... -
M
Question Enter a Date and it will deduct 1
Good Day, I'm creating s simple database to track my printer toner supplies, what i want is that..every time I select a date (using date picker) it will automatically deduct 1 from the total number of toners on stock. Right now, i have to input 1 in a field and it will update the remaining... -
M
Collapse and Expland Subforms
Good Day, I found (on the web) this very neat access DB with a collapse and expand subforms feature and i would like to use this feature on my DB. When I open the form the subforms are already expanded and by clicking a command button it will collapse. What I want to achieve is the other way... -
M
How to avoid duplicates before saving in an access table
Good Day, I have a Save button in my form to save new record to my table. I would like to have codes in cmdSave to check if the value that I type in LName and FName (unbound fields respectively) already exist in tblEmplyee table then it will display a message informing the user that the... -
M
How to display additional info from a listbox to another listbox
Good Day, I have an access form named frmManagers and within the form I have two Listboxes namely lstManagers and lstStaff. On my lstManagers listbox, my Row Source are EmpID, LName, FName, Manager (tblEmployee) and on my lstStaff listbox the Row source are EmpID, LName, FName and Manager...