Search results

Hi, Thanks for your reply... I use Button to perform this action... can i have the VBA code to do this?

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

Hello Galaxiom, I Love Access & VBA so i would like to do more challenging events Thats why... A Professional Programmer no need to show himself using paper :) //But it might help the holder get an interview with a prospective employer where they can convey their ability to...

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... :)

Birthday Remainder via email 1 day earlier :)

Hi Bob, This is what i expected, Working Well... is it possible to send via email? Just asking if can please let me know!!! Thanks Anbu

Hi pr2-eugin, I tried your code email notification, there is no email after that time... Can able to hide the form and able to insert into tbl_emailogger, any settings need to do to receive email? Thanks!!! :)

Hi Bob, Your sample Birthday remainder database Working Good, At the same time is it possible to come out message after you open the form rather you search one by one? if can more convenient for payroll or employee management users!!! :)

Messages one by one after we close the previous person or all the person names in one message box... :)

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, Noted, i make it clear the my previous code is bit trouble to run My amended code as follows, Run Time Error '3078' Private Sub Combo4_AfterUpdate() Dim conn As New ADODB.Connection Dim objMyRecordset As New ADODB.Recordset Dim strSQL As String Set conn = New ADODB.Connection...

Hello, what solution is there?

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, could you please paste the code for me? i tried also not able to look up... Thanks!!!

Hi, I tried this code the combobox just became empty, Anything need to add in? 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; Initial...

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!!! :)

Working Well :)

Hello, Yes But may i have any sample code for open record-set or any example? Thanks in advance Experts!!!

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