Search results

  1. B

    How to find 'Balance'

    Hello, I prepared this video about finding balance in MS Access Query, I hop you like it. https://www.youtube.com/watch?v=9TeoA3-NvYM
  2. B

    Which one is faster?

    Hi, it's been about a long time I work on a db with MS Access 2010, Now I completed almost everything, but when I run my db it works very hard, specialy when I have lots of data on it. my db is too large and it included lots of calculation operation. Now my question is: is MS Access 2003 faster...
  3. B

    How to work with TempVars

    Hi, This video show you how to work with tempvars http://www.youtube.com/watch?v=hYdH0Xm4GSU
  4. B

    Convert number to word in ms access

    Hi, In this video I'll show you how to covert number to word, hop u like it :-) http://www.youtube.com/watch?v=7BsFRYs4Uv8
  5. B

    UPDATE, INSERT, DELETE, READ Record using VBA

    This video contains an MS Access database which is a sample of Update, Insert, Delete, and Read, records in MS Access. You can download and use the codes for your projects. http://www.youtube.com/watch?v=qzxvBor060c
  6. B

    Advanced login system

    Hi, please watch my login system and give me feedback :-) https://www.youtube.com/watch?v=Z-srzCXRImk
  7. B

    How to record everything that users do on db

    Hello everyone, I'm glad that I'm posting new tutorial after a while :-) in this video I would like to show you how to record everything that users do on db, I mean with this tutorial we can know that what user opened db and what else does he did. http://www.youtube.com/watch?v=LvgK9j_PeGs...
  8. B

    How to find profit for those two tables

    thanks alot man, it worked :D
  9. B

    How to find profit for those two tables

    all data I have is that what I posted, I can find 30 days total for buy and sale, and what in store remained but my problem is with coast change while buying itemA
  10. B

    How to find profit for those two tables

    Hi, I have to tables Sale and buy: Buy: InvID | Date | Item | QTY | Price | Total ------------------------------------------------------------- 1 | 1/1 | ItemA | 5 | 40 | 200 ------------------------------------------------------------- 2 | 1/1 | ItemB | 5 | 30 | 150...
  11. B

    Center Form Content

    Hello Is there anyway to center form content?? I have a form and I want t center its content:
  12. B

    Ms Access Query Run Slow

    All My problem is Just this, If you know other solution I don't create make-table query
  13. B

    Dlookup Problem

    All My problem is Just this, If you know other solution I don't create make-table query
  14. B

    Dlookup Problem

    because the query based on alots of other queries, and for make db fast, last query result move to a new table.
  15. B

    Ms Access Query Run Slow

    Yes, Sure there is the d
  16. B

    Dlookup Problem

    Hi, I have a query with 3 Column DLookup Function, the query is 'make-table' Type, and when i run it, all Dlookup columns will be null
  17. B

    Ms Access Query Run Slow

    Hello, I've a query that based on some other queries, when i run, it's slow, and even when i scroll down and right-left a los, is there anyway to make it better? I attached the file.
  18. B

    Calculate cell with cell above

    Hey I Did it :) with this Code: Total: IIf([IDD]=1,[Salary],DLookUp("Total","Query2","ID=" & [ID]-1)+[Salary]) Thank you Very Much
  19. B

    Hey, I did Somthing, http://www.access-programmers.co.uk/forums/showthread.php?p=1178911#post1178911

    Hey, I did Somthing, http://www.access-programmers.co.uk/forums/showthread.php?p=1178911#post1178911
  20. B

    Calculate cell with cell above

    Oki, John Big Booty Now I have ID column that sorted ascending and have not any bread, how can i do it with DLookup?? I tried a lot, but I couldn't I used this: Total: [Salary]+DLookUp("Total","Query2","ID=" & [ID]-1)
Top Bottom