Search results

  1. J

    Question Strange Access 2010 Refresh Issues

    No-one else has seen this?
  2. J

    Question Strange Access 2010 Refresh Issues

    Here you go....
  3. J

    Question Strange Access 2010 Refresh Issues

    Yeah, sorry about that, I don't have enough posts. You should be able to copy 'n' paste them into a new window...
  4. J

    Question Strange Access 2010 Refresh Issues

    Another one that is most likely related. I have a text box on my list forms that has a control source of... ="Total Count " & Count("*") This doesn't show anything, and the status bar constantly shows "Calculating...". If I turn on the navigation button for any of these forms, the record will...
  5. J

    Question Strange Access 2010 Refresh Issues

    Hi All I'm hoping someone can help me with a very strange issue that I'm seeing on a couple of clients machines. The versions are... Office Professional 2010 14.0.7106.5003 (32 bit) Windows Server 2008 R2 Standard Office Professional Plus 14.0.7106.5003 (64 bit) Windows Server 2008 R2...
  6. J

    Runtime Error '91'

    There's still no space...?
  7. J

    Runtime Error '91'

    There's a space missing in this line... Setctl = Me.EmployeeList ...should be Set ctl = Me.EmployeeList
  8. J

    Help: simple search form inside the navigator in MS access 2010

    Hi Bassam You need to change the criteria of your query, as the form is now a subform... Like "*" & Forms![MainPage]![NavigationSubform].Form![SrchText] & "*"
  9. J

    DSum Error

    Thanks spikepl That makes total sense, but doesn't hurt any less. The values are doubles representing percentages (0.4 = 40%). The code I am writing is trying to determine whether the total values = 100%, which they obviously do and don't at the same time. Would I be better storing these...
  10. J

    DSum Error

    The plot thickens (sorry for continuous replies to myself). If you initially enter the values into the table the other way... 0.1 0.2 0.3 0.4 ?DSum("num","Table1") = 1 - True aarrrggghhh!!! What???? :banghead: :banghead:
  11. J

    DSum Error

    Playing around a bit further... ?DSum("num","Table1") > 0.99999999999999983353 = True ?DSum("num","Table1") > 0.99999999999999983354 = False ?DSum("num","Table1") > 0.9999999999999998335399999999999999999999 (as many 9's as you want) = True
  12. J

    G'Day

    Hi There I've always been a bit of a loner when it comes to work related stuff, but it's probably time I started sharing a bit of knowledge and filling in a lot of gaps that I have missing professionally. I'm pretty much self taught, I completed a Diploma in IT a decade and a half ago, and...
  13. J

    DSum Error

    Hi All I'm new here, but fairly well versed in Access. I have a quick question that is driving me nuts. Here's how you can reproduce the problem. Create a table (Table1) with one field (num - Double) Enter in the following data... 0.4 0.3 0.2 0.1 Now, go to the immediate window and enter...
Back
Top Bottom