Search results

Hi all, please let me know how to insert 5 blank rows after grouping & add some text after insert at the blank rows in excel? Ex: i have 10 rows A A B .... i want to insert 5 blank rows(Add some text after insert) after Group A is it possible? Thanks in advance!!!

Hi, Currently I am creating applications in excel and access using VBA & Macros, i would like to work in DotNet platform using VB... please advice me to do the necessary steps to develop applications in VB using my VBA knowledge... Any good study material or what i need to do? how to start...

Dear All, Just want to know that am currently developing application using access VBA and macros, so please let me know valuable certification for VBA developer or Macros Specialist and any specific Exam or course for this certification? Example: MCPD or Cisco something like that... :)

Hi All, I would like to have a birthday remainder on access form load event VBA... i have tblEmp with 2 fields, Name DOB A 22/04/1977 B 25/03/1965 C 17/08/1985 I would like to compare Date and month with my system date to show in the message box "Mr. A Birthday Today" on...

Hi All, I am getting this invalid use of bracketing error Anything wrong? Set objMyRecordset = CurrentDb.OpenRecordset("select itemno from " & Chr(34) & "[" & icitem & "]" & Chr(34)) Thanks, Anbu

Hi All, I Would Like to Look up SQL server 2005 table as Tbl1 to my access combo box as combo 1 Total 2 columns in the SQL table as Item & Qty Please Post any sample Code... Thanks in Advance!!! :)

Hi All, May i know How to open a Record Set For the combo-box? My Original Code as follows Dim conn As New ADODB.Connection Dim objMyRecordset As New ADODB.Recordset Dim strSQL As String Set conn = New ADODB.Connection conn.ConnectionString = "Provider = SQLOLEDB; Data Source=SDSACCOUNT...

Hi All, I Have one main form in access 2003 i want to use Dlookup function to 1 text box with 2 criteria is it possible? My Formula: Text67. Value = DLookup("Balance", "dbo_WbookEdit", "[Lotno] = '" & Forms![Edit]![LotNo] & "'" And " & [Description] = '" & Forms![Edit]![Description] & "'")...

Hi all, i have 1 combo box and 1 text box i look up 2 columns in the combo box from that combo box i want to look up 2 column to text box example: Table values: Col 1 Col 2 A 1 A 2 combo box successfully look up 2 columns but i look up to text box Formula...

Hi All, i recieved error on the following connection string in the combo box change event code as follows, Private Sub LotNo_Change() Dim conn As New ADODB.Connection Dim sConnString As String 'Create connection string sConnString = conn.Provider = "SQLOLEDB; Data Source=SDSACCOUNT...

Dear all, i would like to select combo box value that link to MySQL table field May i know the connection string? Thanks in advance!!!

Dear all, I am using access 2003 i would like to prompt message box should come out for adding the duplicate entry.. Example: ID:1 User:a i add this record to my MySQL table from my access form by clicking the submit button then text box value become null, if i type again the same ID 1 and...

Dear all, I would like to display message box in access VBA if the user forget to change the text box value after clicking the submit button... Example: 1 card contains 9 rows when they input the 7th row message box should come out "please remember to Change the card Number" Thanks in...

Dear All, I have 1 combo box contains 2 columns look-up directly from the properties(Not VBA) Now i want to select record from the list Example: i want to select PM-1234-1111 so i dont want to type starting letter PM to select but i want to type 234 or 123 or somewhere in the middle or end to...