Recent content by Rakesh935

Thanks Pat, will surely consider your inputs while finalizing the development process. Just have one last question: In a form I have two combobox (e.g. Combo A and Combo B, and Combo B is dependent on Combo A's input), so post update of Combo A the population in Combo B takes a while (about 10...

Thanks for your reply Pat. I was actually bit confused with the .old value property. However, I got it figured and completed the development as well. Now, the only area of concern for me is the performance of the application since there are about 8 concurrent users of the application on a...

Hi, I've developed a MS Access application (UI) having linked tables from SQL Server. The application would be used by multiple users (about 8 users) for record creation, deletion and update through forms (TextBox and ComboBox controls). I was able to achieve/complete the development until...

Hi, I have a master table which has 2 columns i.e. Codata and Keyword, below: CoData -------------------------------------------- KeyWord BBNRM PRE UNIVERSITY COLLEGE FOR WOMEN ------------ UNIVERSITY NOVOFLEX MARKETING PRIVATE LIMITED ------------ MARKETING RAY LOGISTICS SERVICES PRIVATE...

This application uses Bing Maps to generate the GeoCodes for the addresses ingested into it. And Bing Maps offers 10,000 free searches per day. Your true for the statement "due to licensing issues, the addresses given by Google will be close but not always exact", and for the same reason...

Providing the code...if it could be of any help... Modules - mGeoCode Option Explicit Const LATITUDECOL = 1 'column to put longitude into Const LONGITUDECOL = 2 'column to put latitude into Const CONFIDENCECOL = 3 'column to put confidence indicator into...

Attaching the file again...

Hi All, My team uses the attached macro enabled file to identify the geocodes for the address appended into the tool and the tool does a perfect work. But now the requirement is in addition to the geocodes the team also needs the location address of the identified geocodes. Need your advise...

All, Many thanks for your suggestions...although the VBA code works perfectly, I was thinking if this could be achieved through SQL query. It would be great if anyone could give me some idea in achieving the same through SQL query.. Thanks, Rakesh

Thanks brother, this works....

This is gonna be a tracking mechanism by dates. And since the nature of the data would be incremental therefore it would be ideal to use the latest table for further processing.

Hi All, I have a .mdb file which has about 20 tables in which I need to rename the latest created table. Now to identify the latest created table I am using the below query: SELECT a.Name, a.ID, a.DateCreate FROM MSysObjects AS a INNER JOIN (SELECT Max( DateCreate) as Latest FROM MSysObjects...

Thanks June.... It works... My bad I didnt think about union... Have a great time ahead. Cheers Rakesh

Hi Guys, Need your help in cross tab the below table: Note: I would be doing in MS SQL Environment. ID Tel1 Tel2 123 1111 3333 456 2222 4444 into Id Tel_ID TelNo 123 Tel1 1111 123 Tel2 3333 456 Tel1 2222 456 Tel2 4444 Thanks guys for...

Apologies, I was not clear in my 1st thread. Actually, in my access form (Unbound) I have a button to browse and import excel file which is a template. And post importing rename it to Working. So now, if I have this table "Working" in the access file then the indicator is going to be in green...