Search results

Hi everyone, I need your professional guidance to modify my database from the beginning to achieve desired goals in future. I am working on database for employees which is my access training as well as first project. I need historic transactions in database for employees like (Contracts...

This code did not execute the job properly. frmAddnewRecords open with cboOptions filled with "Employee" but not limited to this value i want users should not be able to change combobox value if they are navigating from origin form button. Secondly when you select normally any value in...

Thanks guys i got it what i required, this code is working now and i am happy that i achieve something. Private Sub CboOptions_AfterUpdate() If Me.CboOptions.Value = "Employee" Then Me.Subform.SourceObject = "table.tblEmployees" RecordSource = "tblEmployees"...

Text boxes are on main form their is no subform now before I try it with object property subform but it became more complicated that's why I drop subform, now I am trying to link my 3 unbound text boxes which is 1,2,3 on main form to get control of tblEmployees [EmpID],[Fullname],[Surname] but...

No more tblDatasheet directly calling from tblEmployees. I don't know the exact calling method from table in event codes. Just need to correct my code.

I am sorry if i make things little difficulte to understand. I need to make new entry regardless of serial in table new entry will come at button itself, i just need fields control with new entry mode not before not after and not first or last only new entry to enter. I am really struggling to...

its working but, textboxes filled with first record, but i wanted new record (Blank to add new). Since EmpID is number field and not autonumber this might be the issue. How to solve it, i cannot change EmpID field to Autonumber because their is jumping in serial without actual use i don't want...

tblDatasheet is on same form where i am calling various table at same Datasheet object just to avoid too many subforms. Upon selection of my cobobox relevant table will appear in tblDatasheet object which is coded perfectly no worries about that, i need the first 3 fields for each selected...

Hi i am struct with following additional version of my code. I am trying to call first 3 fields of table upon after update event of combobox on my form, but it gives me error i think i am missing some quotation marks around the reference in below code or may be more. Private Sub...

Thanks for your help really appreciated. Now i need 1st four fields of table in datasheet should be control of unbound text boxes in form for example if i select employee in cboOptions the tblEmployee will appear in datasheet that is done now, but i need 1st four fields of tblEmployee let say...

I have posted demo. on the other hand i could process to do it with individual forms which is quite easy, but i need it in one form for all the tables to open and added at same place rather then making individual subforms for adding new records. Thanks for your help.

Thanks for your help. however, the row source in my combobox is values which is "Employee";"Resident ID";"Passport";"Qualification";"Contact" and row source type is values, control source is empty this is the trigger point i think. my datasheet name is tblDataSheet (Unbound) which will show...

I give a try to following after update event in combo box but somewhat what criteria i need to add in below to call the table on my datasheet on form it should be changing as per the combo box value its first step for now. Option Compare Database Private Sub CboOptions_AfterUpdate() If...

What coding is required in combo box events? How you will link child and master fields in datasheet? i need this all options in one combo box value list, do you mean that i have to create 10 combo boxes, sorry but your answer is not clear?

Hi Dear, I am trying to make option chain on Access form that pull the individual tables data based on option selected on form. for example i have 10 option lets say (Employees, contacts, ID's, Sponsors, Qualifications, payments, Vacations etc) and their is unbound datasheet on form why...

It is somewhat ok with editing purpose, but when making new entry same problem is their he is asking "Index or primary key cannot contain the null value" that means it is not taking new entry in tblemployees? Anyways i have reached half way, remaining is new record entry in this form. I think...

It has text boxes also which cant be used in cascading combo box, i need amendable information upon main combo selection which will store the information in table based on my changes in combo box as well as text box in same form. for example if i select employee ID 1 in cboEmpID than all his...

Hi I want to update table's field based on combo box selection, all table fields are on same form of combo box. First when i select combo box text fields and other combo boxes on form should be update/change as per cboEmpID selection and in same if i need to change in any of text field data...

Thnx for your help... its working.

I did try but nothing came up in VBA (Ctrl+G button) bottom window appear but blank. Anyhow, i have attached the strip version of my database, to see what exactly not working. thanks.