Search results for query: *

Thanks.... In IE works fine , However NS7 realy does not like it..:(

Not sure were to post this.....*lol* I need to have a MAIN workbook query a DATA workbook (usually closed) and update with the new records added. That is User1 enters data in DATA.xls User2 opens MAIN.xls and can update his MAIN.xls with any new records added in DATA.xls. Long story short, I’m...

Thanks steve ! will try and repost

Not sure were to post this.....*lol* I need to have a MAIN workbook query a DATA workbook (usually closed) and update with the new records added. That is User1 enters data in DATA.xls User2 opens MAIN.xls and can update his MAIN.xls with any new records added in DATA.xls. Long story short, I’m...

thanks the set up you gave me works great...! :) However the results are deleting not adding to the range I send to.....xlInsertDeleteCells is this the problem ?

Would like to use a variable insteat of the hard code for the time " '2004-01-24 16:23:06' "criteria in this query..... With ActiveSheet.QueryTables.Add(Connection:= _ "ODBC;DSN=Excel...

Using the following sub to act as a filter.... I have about 5000 records. This sub is low...! is this the fastest way to show and hide rows based on the same logic of the below cod ? can I incorporate the logic in a filter ? Sub OptionButton3863_Click() Dim rr As String...

Thanks DreamerZ FINALLY found this...*lol* ListBox1.List = Array("One", "Two", "Three", "Four") ComboBox1.List = Array("Red", "Green", "Yellow", "Blue")

Basic silly question...how can I pop a list box with Jan, feb, Mar...etc ?

Thanks !

How would I get a calendar so a user can pick a date from a user form and pass date to a variable ?

Thanks Skip...! :)

getting a error when I try to incorporate....Sub OptionButton3862_Click() Application.ScreenUpdating = False For Each r In Sheets("Master").Range("A:A") If r.Row > 4 Then If r = "" Then Exit For If IsNumeric(r) And r >= 2000 Then r.EntireRow.Hidden = True Else If...

Thanks...works great... PS: I need a function to determine if a value of a cell is numeric and if not just extract the numbers in order from left to right ....:)

Hi Skip...thanks for the reply.... I put 3 optionbuttons on my worksheet(forms/optionbutton) I would like the following : Sub OptionButton3861_Click() if OptionButton3861 = true do nothing else ActiveSheet.Cells.EntireRow.Hidden = False End Sub

I would like to use 3 option buttons to hide/display rows depending on which option button is selected..... How would I trigger macro ? how would I know which option button is checked ?

Thanks the Edit > PasteSpecial > Add worked great !

Working with a worksheet which has numbers preceded by '. Ex: cell content = '123 which makes the number seen as text...how can I remove the ' to get all my data as numbers ?

Newbie in Acces.... How would I incorporate this code ?

How would I call a function from an Excel cell ?