Search results

Dear valued friends, i am planning to design a payroll database system for a small company in ms. access. i have designed the tables and the entry forms. what i really can't figure out is that how to automatically update staff salary every month instead of typing everyone's salary and the query...

Dear respected colleagues, i want to insert a group of records into a table at once. i have three tables i.e. Group, Member, Saving. the relationship between tables is: group to member (1:M), member to saving 1:m and there is no relationship between group and saving. every group has maximum 20...

Dear valued colleagues, hope my post finds each one of you well. i need your guidance, please help me to sort out a piece of work. in my database, i have a list of groups i.e group a, group b and .... every group has a list of 20 members each. every group member saves some amount in the group (...

Dear Colleagues, Greetings! i have a continues form which lists members of a specific group, from this form, i want to insert some members (one by one) into a specific table which i already designed, but when i run insert command, i received an error. Private Sub Command34_Click() Dim sSQL As...

Dear valued colleagues, hope everyone is doing well, i have created a report in an access database, in this report i have placed a button which should export this current report to ms excel, it is to mentioned i have persian data in my database, but it does not allow me to export to excel(error...

Dear valued colleagues, i have a continuous form bound to a query which displays records, i open this form in dialog mode, but when i open this form sometimes it opens in a bigger size both horizontally and vertically that i can see my records, but sometimes while opening, it shrinks vertically...

Hello valued colleagues, i am new with VB, i have problems in writing some in-dept coding and sometimes even in simple ones, for example i am not able to write sql queries using vb, please help me find reference book(give me the link so that i would become well-familiar with vb syntax and...

Dear valued colleagues, please help me, i have a query returning values from multiple tables, based on this query, i have designed a form(tabular form) which is bound to this query, i have also included a combo box, which is looked up to the same query, after update of this combo box values on...

Dear colleagues, Hello to everyone, i have three tables named community, group and member. Community has one to many relationship with group, group has one to many relationship with member. i would like to have a query returning total groups and total members group by community. for example...

Dear Valued colleagues, Hope each one of you are doing all well, please help me to solve a problem, let me explain my situation: i have three tables (Group, Customer, Savings). every member of a group do savings once every 15 days and each group has maximum 20 members, group has one to many...

Loading only the tab page you require and disable others to speed up forms opening Hello Dear valued colleagues, please help me out!!! i have a form having too much data on it, so i have used a tab control to be convenient for data entry, but while opening this form it is too slow as all the...

Dear colleagues hope you all are doing well, i have created a login form and create user page form, the tblListofUsers has two columns, UserName and Password, on the log in form when a user enters username and password, it should be matched with the tbllistofusers if true then msgbox"Welcome"...

Dear friends, i really thank you all for your continous support, i have question, hope i receive a favorable answer how to add a multi valued fields in a form for example a student may have multipe hoppies, access can do this using using lookup option, but access stores multiple values in one...

Dear colleagues, please help me out, i want continuous form so that i can know what my prvious record is, but this gives me trouble i have some check boxes that based on some conditions they disable some fields, but when i do this on the first record, the same happens in coming forms for data...

i have form named home page in this homepage form in the form header i have inserted some fields from some tables like province, district, community etc. these fields are unbound and are used for filtering purposes, when i select a province all districts related to that province displayed and...

Dear colleagues i have searched the web alot but couldn't find my answer, Let me clear what problem i faced, i have a form named Member, this form has field named hobbies, this field has multiple values selection i.e. a user could select football, cricket, listening to music and etc. these...

Hello Every one hope you all are doing well! i have a problem in requery function i cant requery a subform from main form i have a table say table1 and a tab control say tab1 and in this tab control i have four pages on each there is a subform i want to refresh one of these sub-forms field, i...

Hello Friends Hope you all are doing well i have a bit problem in a query i have groups and members tables in which each group is formed from no. of members, each member can take loan and will return this loan in a no. of installments so here my problem is when i run the query to retrieve no. of...

hello friends wish you all are happy and healthy!!!! Dear friends i have a problem in form creation i have two forms one is group form which is the parent form and woman form which is the child form when i enter data in these child and parent forms individually there is no error but when i...

Hello my dear sincere and lovely friends hope each one of you are doing well!!! i just had a little bit difficulty...let me explain my scenario i have a list of groups these groups each have their list of members each member takes loan and repay the loan in a no. of installments my problem is in...