Recent content by gpoogles

Its working amazing man, thankyou so .......much��

This my coding Private Sub CormandButton1 Click () Dim conn As Object Dim objRecordset Äs Object Set conn = CreateObject ("ÄDODB. Connection") conn.provider = "Microsoft.ÄCE.OLEDB.12.0" conn.Open "D:\Database1. accdb" Set objRecordset = CreateObject("ÄDODB.Recordset")...

Thanks arnelgp, Its working, however when I press again the find button its not showing the other results with same search field

Its complicated mate, we cannot use access runtime or any other in our systems, also every system does not have ms-access installed, so I'm using excel userform as front end, if you can please give me a solution for my previous post, Thanks is advance mate....

Hello everyone... I'm developing a project with with some field need to be filled with the users (ie emp ID, emp name, case ref, amount, processing date and status) in excel vba userform. I'm using msaccess 2003 as a backend Same fields are used in access table (ie emp_ID, emp_name, caseref...

Can u help in this? how to pull the record using auto number field, when I tried its showing invalid or incorrect criteria found

Ms access is not available in all machines, so I'm using excel as front end and access as backend

My work is to allocate the cases to my colleagues, I receive work from the workflow tool, I pull the necessary data from that tool and put it in common network location ( MS access database table) file, the access table looks like Case ID - auto number field Received date - date time field or...

Hey plog, Thanks for your quick response. My project: I have access database table named PCRAWDATA which contains many fields like CaseID - auto number field Emp ID - text field Emp-name - text field Supervisor name - text field Excel vba form contains Emp ID - text box Emp-name - text box...

Hi All, I'm new to this forum, i request your help to get a code for getting next row data from ms access database 2003 using excel vba coding, To explain clearly-- I have userform created in excel 2003 which contains a two 2 command buttons named "next record" and "previous record" and...