Search results

Hi guys. In my database i need two process in the database one is SOD(Start of Day) and the 2nd one is EOD (End Of Day). The purpose of these process to run multiple hidden queries in back-end. In both processes there are several queries to run. I need help to setup this.i have no idea that how...

Hi all. Could some one tell me that can we use functional keys F1, F2,F3,,,,,,,,,,,,,,F12 in ms access to perform commands like saving a form data , for closing form refreshing form, clear form. Or is there any way to make shortcut keys combination like[(ctrl+s)(ctrl+c) (ctrl+A)] in access to...

Hi friends, can some one like to tell me that how i can get a current user from a custom login form CurrentUser() this function always return a system user name admin as default. In my login schema i have a Hidden splash form that have a unbound field that holds user name from custom login...

thank you very much it works for me.

thanks for response, can you give me a example of a such query based on my sample.

Hi friends i want to write a query that display records for only last date entered in a table and i want to show all the records from last date entries in a table. sample attached. Thanks.

Dear plog i solved my problem.

one thing more that this query show only today,s sum of debit and credit, and closing balance, in case there is no transaction DR, CR will be Default null value 0. formula is calculating for closing (Opening + DR - CR = CLOSING) because i want that closing hold closing balance not only for the...

one thing more that this query show only today,s sum of debit and credit, and closing balance formula is (Opening + DR - CR = CLOSING) because i want that closing hold closing balance not only for the current day, closing show me according to above formula.

now i am giving you the sample of my database. where when a fee deposited the Fee main GL Credited and cash is debited these are auto entries coming from Fee table, ok and now look at my query that showing closing balance for today. here i need another field in this query that represent today,s...

Sorry for misunderstanding by me, dear i need your help now i am attaching screen shot that will show you the results i want to create , in first screen shot after calculating debit - credits closing balance and closing also shows in opening on next day,and DR and CR are Null, and then in 3rd...

dear if you look at my attachment file on top you can easily understand my requirements!

(show me what the data should result in?) i don't understand your question, kindly explain your question.

Dear i have a tbl_General_Ledger fields are GL_ID, GL_CODE, Description, DR, CR, TDate 1 1000100 Cash in hand 1000 0 24/04/2014 2 1000200 Cash in Bank 0 2000 24/04/2014 3 2500100 Fee Coll Main 0 500...

you can do this by using dlookup function.

Hi friends I have issue while making a query kindly help me. I want to perform in this query that Opening balance + Dr - Cr = Closing balance And the next day my opening balance will equal to the date() -1 closing balance. And when today’s movement DR and CR take changes it will also take...

i had solved my problem.

Helo friends i have an issue using dlookup function.i want a condtional dlookup. i the condition is true then dlookup works if condition false then stop. i have a tbl_accounts fields are GL_code, Description, Ac_Descp, GL_type, and other tbl_transaction both tbl have one 2 many relationship and...

Please Visit this. http://www.access-programmers.co.uk/forums/showthread.php?t=158973 hope this will help you.

I also have same issue with my qry and form.and i did not find any solution yet.