Search results

  1. N

    Payroll system in ms access

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

    insert a group of records into table at once

    Can anyone please provide a response to my thread.
  3. N

    insert a group of records into table at once

    Nauticalgent, Can you please reply to my post.
  4. N

    insert a group of records into table at once

    Dear NauticalGent, in this post i attached the light version of my project ( i deleted some some table, forms, reports and also data for the purpose of being light). on the main switch board on database startup, please select incoming money, then the saving form will be opened.
  5. N

    insert a group of records into table at once

    NauticalGent, Let my shed light a bit more on the issue, First to tell u, my thread resembles payroll database, every month, all staff's salary is inserted in the salary tabletable using a function that will be either automacially triggered or manually, and companies will not enter every staff's...
  6. N

    insert a group of records into table at once

    In the other thread that u have mentioned it, i found some non related solution. Then i thought may be i have not clearly explained my scenario. So i tried in this query category section.
  7. N

    insert a group of records into table at once

    Dear Minty, Still i am waiting for the solution.
  8. N

    insert a group of records into table at once

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

    Creating a form for regular easy entry

    Dear both, thank you for your prompt reply, it is worth to say that Group table has 1:M relationship with member table, and member table has 1:M relationship with Savings table. what i really want is that all group members should be displayed in the savings form with a specific date that i will...
  10. N

    Creating a form for regular easy entry

    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 (...
  11. N

    Inserting specific field from a form into a specific table

    Dear both, thank you, for your guidance.
  12. N

    Inserting specific field from a form into a specific table

    Thank you for your both solutions, i forgot to remark that your reply to insert query worked and i will follow the links you have directed me. Sincere regards.
  13. N

    Inserting specific field from a form into a specific table

    Thank you both Respected JHB and respected sneuburg for your prompt response. kindly guide me a reference book on writing codes in access visual basic, i tried alot to learn writing access syntax. still i think i need to improve my coding skills in access visual basic. for instance in c or c++...
  14. N

    Inserting specific field from a form into a specific table

    It says, me.vslaid and me.memberid is not recognized.
  15. N

    Inserting specific field from a form into a specific table

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

    export report(persian data) to excel office 2007

    Dear Spikepl, thank you for the reply!!! i don't mean date i mean data i.e. that names, father names, and other things are written in persian language i.e. right to left language. and regarding your points i would like to say. a.if i open the report every thing is displayed, no problem is...
  17. N

    export report(persian data) to excel office 2007

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

    Continuous form shrinks automatically

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

    Not well-familiar with vb syntax

    thank you arnelgp and gemma-the-husky, dear arnelgp, i found some useful material in 4shared.com thank you again. Dear husky, the vba developer handbook is not available in hard copy in afghanistan, can you let me know about free soft copy link of this book, i searched alot but couldn't find...
  20. N

    Not well-familiar with vb syntax

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