|
|
Queries
I need help with this , it will not run, am i missing something.
Private Sub Worksheet_Activate()
Call Sheet5.getvalues
Call Sheet5.SortRange1
End Sub
Sub getvalues()
lr = Application.Max(2, Cells(Rows.Count, 1).End(xlUp).Row)
'MsgBox lr
Rows("2:" & lr).ClearContents
With Worksheets("Automated RAC")
slr = .Cells(Rows.Count, "a").End(xlUp).Row
'MsgBox slr
For L = 2 To slr
dlr = Cells(Rows.Count, "a").End(xlUp).Row + 1
' If .Cells(L, "L") =jone and not .cells(f, "F") = "Closed" Then
..Rows(f).Copy Rows(dlr)
If .Cells(L, "l") = jones Then .Rows(F).Copy Rows(dlr)
Next L
End With
End Sub
Sub SortRange1()
End Sub
Sub Fixit1() 'Use if event macro stops working
Application.EnableEvents = True
End Sub
--
Sherry
|
|
0
|
|
|
|
Reply
|
Utf
|
6/1/2010 6:00:01 PM |
|
|
0 Replies
244 Views
(page loaded in 0.013 seconds)
Similiar Articles: switching between open tables, queries - microsoft.public.access ...I recently upgraded to Access 2007 from XP and I'm frustrated by the inability to alt+tab between open tables and/or queries in a single database. ... How to Export "Empty Tables" +queries+forms+macros for ...How to Export "Empty Tables" +queries+forms+macros for new data base ? Follow Queries - stop repeating? - microsoft.public.access.reports ...I have the following query (for example): countofstates color 3 red 8 blue 7 ... Finding all queries that use a particular table - microsoft.public ...Hi--I have a table that is used in hundreds of queries in my database. When I run documenter for the table, I don't see these relationships. How ca... Unhide query - microsoft.public.accessAccess 2003 or earlier, with the database window active == Select Tools: Options == Go to the VIEW tab and check Hidden Objects == Click OK == Go to the Queries tab ... Select Queries in Macro - Close all windows - microsoft.public ...Hi I have created a Macro with 20+ "Select Queries". When the Macro is run with the "OpenQuery" action, because these are "Select Queries" it is open... Find Text in a Query - microsoft.public.accessDoes anyone know of a way to search thru AC2003 queries to find a text string? For example, I need to find all queries that contain the text "For... Parameter Criteria Date Picker - microsoft.public.access.queries ...I have some queries that give Start and End Dates in separate criteria text boxes to select a range of dates. Can these text boxes be replaced by Dat... Shortcuts to Queries in Custom Groups - microsoft.public.access ...When I add a query to a custom group, it is removed from the Unassigned Objects group, which is fine. But if I want to rename the query I right c... Variable Accros Queries - microsoft.public.access.queries ...If I wish to use a variable across mutliple queries, is this possible, and if so where would I declare and set the variable? ... Queries | Define Queries at Dictionary.comnoun 1. a question; an inquiry. 2. mental reservation; doubt . 3. Printing . a question mark (?), especially as added on a manuscript, proof sheet, or the like ... Query - Wikipedia, the free encyclopediaIn general, a query is a form of questioning, in a line of inquery. A query may also refer to: The Queries, a set of 31 questions outlined by Isaac Newton beginning ... queries - definition of queries by the Free Online Dictionary ...que·ry (kwîr) n. pl. que·ries. 1. A question; an inquiry. 2. A doubt in the mind; a mental reservation. 3. A notation, usually a question mark, calling attention ... Queries - Access - Office.com - Microsoft Corporation: Software ...Article This article explains how to create and run an append query. You use an append query when you need to add new records to an existing table by using data... Web search query - Wikipedia, the free encyclopediaA web search query is a query that a user enters into web search engine to satisfy his or her information needs. Web search queries are distinctive in that they are ... 7/26/2012 3:34:21 PM
|
|
|
|
|
|
|
|
|