Search results

  1. S

    Running sum performance between subquery VS. domain function

    I have been reading about the performance between subqueries and domain functions when applied in a query although both are slow, I've always found that in the discussion it is the subquery that has an extra edge in terms of performance aspect. However, recently I've created a running sum on a...
  2. S

    Action queries vs looping through recordsets?

    I have these two sample snippets that practically accomplishes the same thing; I haven't noticed any difference in speed whatsoever. Both are fast enough and does the job really well. What does it do: Both snippets will perform a reset values to fields: TotalDays, Debit and PayDate on an...
  3. S

    Is there a problem with access world forum server lately?

    It's been awfully hard to get in this website lately. It started a week ago, I had to try and attempt multiple times just to get in. And then if I try to post, i had to do it multiple times as well. This is not normal as I can surf and get in to every website so far. So maybe there's a...
  4. S

    On Trapping Refresh Key and Escape Key.

    Hi! I have bound forms all over my database and it's causing some significant unwanted updates every now and then; even when users does not intend to. I have discovered that the two main culprits so far are the: 1. Escape key (when it can't detect dirty event.) 2. Refresh key (when user...
  5. S

    Memo to Text Data Type

    Good Day! I have a couple of fields spread across the database named "Notes" which is currently set as memo data type, I would like to change it to text data type. What I already know: 1. Text data type can only have a maximum 255 characters. 2. Memo data type can store up to 1000 characters...
  6. S

    Is this doable in MS Access Query?

    How do i make an update query in order to update all blank fields below with each of the letters above it? I have below an illustrated sample of what I'm trying to achieve. (I need to update the left table to become the right table.) (left)Table1 Letters A...
  7. S

    Notepad that supports VBA?

    Hello! Can anyone suggest a notepad alternative for windows 7 that supports VBA with some features like syntax highlighting and line numbering at the least?
  8. S

    Found a Bug!

    I am not sure if this is something new, but I am just concern about the danger of it. If you have got a vba code inside events of a control before putting it inside a "TAB control", please be very sure to re-check it again as it has a very good chance of losing all of the hard coded events you...
  9. S

    Question How safe it is to develop an existing MS Access 2007 Database to MS Access 2010?

    Kind sirs and ma'ams just a quicky. I am trying to continue developing a fully working MS Access 2007 Database to MS Access 2010. So far so good. But a lingering question remains at the back on my mind: Would it be completely safe to further develop my fully working database which was...
  10. S

    How to optimize this Query to be faster and more efficient?

    An Access 2007 SQL recordsource for a query named qryTransactionList below is completely working but it is very slow. I am hopeful that there something that can be done here to make it more efficient and a little bit faster.. Any suggestions are welcome. Thanks in advance. SELECT...
Top Bottom