Search results

  1. M

    Find row where two cells equal some criteria

    Hello, I forgot to reply to your post- thank you VERY much for referencing the Evaluate function. I have never heard of it before and looked up the documentation for it after reading your post. It looks like a very powerful function. Thanks again. As for my problem- I ended up using just...
  2. M

    Find row where two cells equal some criteria

    Hello, thank you so much for giving this a shot. I was going back and forth between the find and filter idea and not succeeding at either. I am almost out the door to go home- I will tailor this to my needs and test it first thing tomorrow morning and post back. Thank you very, very much for...
  3. M

    Find row where two cells equal some criteria

    I am trying to just use the row number where the conditions in column A and B are met. I know this row is unique and therefore was trying to use Find but the method confuses me. All I need really is that one row number.
  4. M

    Find row where two cells equal some criteria

    Hello, thanks for the link. The find method with multiple columns seems to be more trouble than it's worth. What I'm really seeking is autofilter by these two columns and then get the number of the only visible row that's left after filter is applied. I remember having a lot of trouble with...
  5. M

    Find row where two cells equal some criteria

    Hello, This is I guess a purely vba in Excel question, but I'm trying my luck here anyway. I've been trying to understand how to use the find method in vba to locate a row where Column A equals something and column B equals something else. I know that in my sheet this row will be unique and I'm...
  6. M

    Syntax in query involving stdev and avg

    Hello, I want to get payments per employee which are over 2 standard deviations over/under the average. For this I have two subqueries below and the main query which picks out the individual payments. Both subqueries run successfully. The nested subquery in the FROM clause of the main query also...
  7. M

    Question SQL Server on shared drive- real experiences?

    Hello, Can someone provide a concrete explanation as to why exactly it is not recommended to create a sql server database on a network drive? If anyone has had an experience with sql server on a shared drive, can you please share what ups and downs you've had and would you, based on this...
  8. M

    With SQL Server back end, call failed error

    This is VERY helpful. Thank you. I did not see this thread before.
  9. M

    With SQL Server back end, call failed error

    Hi Michael, this is what I was dreading- having to re-create everything as pass through queries. After reading your post, I started reading up more on pass through queries and what syntax difficulties to expect. I posted on a similar topic a couple of weeks ago, before doing the SQL Server...
  10. M

    With SQL Server back end, call failed error

    Hello, I have found this week that after linking to a SQL Server back end I am having trouble running some queries- I get a 'call failed' error (with no error number). I searched the causes for this error and the first thing that I came across said that this may be due to not having the latest...
  11. M

    Question Data going to SQL Server Express- can still keep forms editable?

    Hi Paul, thanks for your reply. My gut instinct was to follow just what you outlined- to leave everything as-is at first and hope for the best. I am mostly concerned with the editable forms continuing to function as they currently do without extra time lag. Let's hope they do. Migration...
  12. M

    Question Data going to SQL Server Express- can still keep forms editable?

    Hello, We want to migrate the data tables only to SQL SE but keep front end the same, which I understand is not a overly complicated thing to do in itself. However, to make it efficient and not run into a lot of network-caused slowness, I understand that the queries that are needed for reports...
  13. M

    Filter based on multi-column listbox looks only at first criteria

    Hello, this is the actual code (the whole thing- there is nothing else in this click event): Me.FilterOn = False Me.Filter = "[FiscalYear] like '" & Me.ToFilter.Column(0) & "' And [Num1] like '" & Me.ToFilter.Column(1) & _ "' and [Num2] like '" & Me.ToFilter.Column(2) & "'" Me.FilterOn =...
  14. M

    Filter based on multi-column listbox looks only at first criteria

    Hello, yes, they are text and in my actual code they are enclosed in quotes- I just typed the code quickly in this post. THank you.
  15. M

    Filter based on multi-column listbox looks only at first criteria

    Hello, I am trying to filter a form based on a listbox selection made by the user: Me.Filter = "[FiscalYear] = " & Me.listbox1.Column(0) & " And [Num1] = " & Me.listbox1.Column(1) & " and [Num2]= " & me.listbox.column(2) This works for me ONLY if I have one column in the listbox by which I...
  16. M

    Question Scroll wheel doesn't work in only one table

    It was such a silly, weird thing. It was a linked table, so I deleted the link and linked the table over again and now it's ok. But I also tried what you suggested- creating a new table from scratch and loaded data. That also worked. Do you happen to know what can cause this sort of thing to...
  17. M

    Update doesn't hit table from form button even though recordset closed

    I am using exact strings, no wildcards. I know for a fact that the data is in there. I created a dummy record for testing and am trying the update using exact strings, but it won't update. Thanks.
  18. M

    Question Scroll wheel doesn't work in only one table

    Hello, has anybody had this happen- scroll wheel stops working in one table- the rest you can scroll in as usual? I know there can be issues with scrolling when you're missing some driver for your mouse, but this happened all of a sudden to just this one table, so I can't imagine that it's the...
  19. M

    Update doesn't hit table from form button even though recordset closed

    Hi Sketchin, I just tried adding the line that you suggested, but unfortunately, it still does the same thing- no error, no nothing, just says that it will update 0 rows.. Thank you for the suggestion!
  20. M

    Update doesn't hit table from form button even though recordset closed

    I tried it without the single quotes and also tried chr(34) instead of quotes. Didnt' do it... Thanks for the suggestion!
Top Bottom