Re: jet automation error
will try it out
Thanx
Re: jet automation error
will try it out
Thanx
Hi
I have a program...which gives automation error on the following line
The error reads " The specified module could not be found"
This happens only on a few computers...works on others
....tried reinstalling office, installing jet SP2 form the windows site..still no solution
Re: Help needed for Search and Delete
i made a mistake it shd be one line ablove clear contents, but neway where is it giving the error
Aadarsh
Re: length of array
Thanx
Re: accessing textboxes by variables
works perfectly thanx
Re: Updating VBA code if sheet name changes
Hi
A small question on the same topic...
If i have multiple workbooks defined with different names, say one of the being wkbook
Now neither of the below codes, when replaced to the new format(in bold) work
Set wksheet = wkBook.Sheets("ReportSheet")
[B]Set wksheet = wkBook.Sheet1[/B]
wksheet.Activate
[B]wkbook.Sheet1.Activate[/B]
Aadarsh
Re: lock all the columns in a single row/cell
Here is the code
Just change it based on how many columns u want
Assuming wksother is the name of the worksheet
Re: Advanced filter criteria
try the folowing code
If u hv a worksheet name just replace avtiveworksheet with it
ActiveWorksheet.Activate
ActiveWorksheet.Range("C:E").Select
Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:="" & ActiveWorksheet.Cells("B4").Value
Selection.AutoFilter Field:=2, Criteria1:="" & ActiveWorksheet.Cells("B4").Value
Selection.AutoFilter Field:=3, Criteria1:="" & ActiveWorksheet.Cells("B4").Value
Aadarsh
Re: setting tab controls
Can anyone tell me if tab controls(moving box to box by tab key) is allowed for forms on worksheets
Aadarsh
Re: setting tab controls
Hi
None of the above method seem to work since the data is not entered in cells but in text and combo boxes
Aadarsh
Re: setting tab controls
Yeah i want to do that , move through by tab key
Aadarsh
Hi
I need to setup tab controls between the different text and comboboxes on the sheet which is attached
Could neone tell me how to
Aadarsh
Re: removing blanks from combobox
Thanx will try it
Aadarsh
Re: removing blanks from combobox
i am populating the combobox from a recordset got from a database...the recordset might hv nething between 2 to 100 values
Dim combovariantlist(100) As String
strsql = "SELECT [Neighbour] FROM Cell_NeighbourParametersGSM where " & _
"[UtranCellId] ='" + TextBox2.Value + "'"
rs1.Source = strsql
Set rs1.ActiveConnection = MyConn
rs1.CursorLocation = adUseClient
rs1.Open
neighbours = rs1.GetRows
For i = 0 To rs1.RecordCount - 1
combovariantlist(i) = neighbours(0, i)
Next i
ComboBox11.List = combovariantlist
Display More
hi
I am using a combobox which has been assigned to an array by
combobox1.list=abcarray
Now, the array length is 100 but its contents may vary from anywhere between 2 to 100 values
Is there anyway of limiting the length of the comboboxlist to include only these
Thanx
Aadarsh
Re: running a module from access files
basically i have a macro in excel called macro1 and one in access called macro2
if i hv to run macro1 from macro2 or viceversa which is the easiest way
Aadarsh