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...
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...
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.
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...
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...
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...
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...
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...
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...
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...
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...
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 =...
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...