Search results

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

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

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

to gemma-the-husky, all my textbox and combobox are unbound. to jdrwa, my EmpID field is indexed (autoNumber). What is PK? What I'm trying to achieve is to have a space between the FName and LName on the popup msgbox. In my MsgBox it shows as JOESMITH already exist!, I want to show it as...

ScanCount = DLookup("[FName] & [LName]", "[tblEmployee]", "[EmpID] = Forms!frmAllStaff![EmpID]") MsgBox (ScanCount) & " already exist!", vbInformation, "Verify Duplicate Record" The code above works OK but don't know how put space between FName and LName in Msgbox. help

Hi jdraw, I used DLookup to check Duplicates in my table before saving and it worked OK then it showed a message (example: SMITH already exist!). I would like to include also the the last name [LName] in my codes and msgbox. Is it possible in DLookup to check two fields (Text) or its better...

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

I already found the solution.

could you show me a sample code..please:o

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