Search results

Hi.. All :) I tried to write a query which can extract my data from Ms access database I have two tables namely dbo_users and dbo_SupplierUsers My question is : 1 ) I need to search SupplierCode in dbo_SupplierUsers, once it found it should return the UserCode (might be more than one user)...

Dear All Once again i need your expertise advise on the below issue I am new to Dashboards and i can create small graphs and other reports. I am very much familiar with Excel Formulas, Excel VBA and other MS office products. Now i got one problem that, one of my boss requested me to design a...

Hi..all I tried this to post in Outllook forums and searched a lot for getting solution. But I was unable to get the solution. So finally I decided to post this in this forum. If it is not compatible with this forum, then I request forum moderators to delete this post My problem was, daily...

Hi..all I am puzzled with one question. I need to prepare a planning Template, in which as per the production qty, inventory qty should be distributed equllay to other cells. For example I have a inventory stock of a item AA is 1000, and my daily production requirement is 100. So the 1000 qty...

Hi..all I am working on a project for my users who can create purchase orders by their own. Below is my quick summary of my project. PO Application tool, in which i am using ADODB connection to fetch details from another excel workbook which is situated at my desktop. I have created some user...

Hi..all I am working on a project, in which i create a button for New & Cancel option. I did on form activate, the button caption will be "New". When that new button will click, the new caption will change to cancel. But now i want, whenever this button again click that means for cancel...

Dear All I came up with strange question that how to round up 9 digits ? The question may be strange. Lets elaborate more.. In a cell A1, if the cell value is between the 1-9 then it should round up by 9 digits otherwise it should round down. For example 281 should be displayed as 290 9...

Dear All, Sorry if i post wrongly. I want to learn programming in Outlook 2007 & above. I googled everything, but lastly I found a book namely "Professional Outlook 2007 Programming" by Ken Slovak. I read this book (not all pages, some the pages) through google books. I tried a lot to get the...

Dear All, Can you please suggest me the best online training/tutorial provider for Ms Access 2010 including both beginners and advanced level. I have little bit knowledge in Ms Access 2010 through reading online blogs and books and watching online videos at youtube. But I can't able to apply...

Dear All, I have a sheet, in which lot of dates are there. I want to create a CF to highlight cells which contains specific year. For example if the cells contain 1-1-1908, 2-10-1908, 11-11-1908 (these three cells belongs to year 1908). Now if i put this year 1908 in CF, all these cells should...

Dear All Can you please share your favorite URL link which can explain Dasboard concepts and preparation very clearly. I want to learn dasboard preparation, but can't able to get proper sites. Regards vijay

Dear All I want to skip a file selection, when the file name starts with QP. Below is my code, The problem is that file names which are starts with after Q, then the files not selected, and code exit, So i need a code, it need to send all files except the file name starts with QP in that...

Dear All Please find below code. I want to use this as Task Schedular script. So i saved this as .vbs. When i have first executed it, it works fine & next time it gives error like "The extract range has a missing or illegal field name." in the specified file. If i open that excel file and...

Dear All Please find below code, i found this code in search engine. In this code why confirmation through msg box required to delete the hidden names & if i removed msgbox line then it gives error. Is there any to delete all hidden names without any confirmation required Sub...

Hi All I am trying to write a VBA code which can select emailid based upon filename and then send mails to the concerned person. So i am going to use Select Case Statment, but it can't work. I am unable to solve the problem as i am new to VBA. So please help to resolve my problem. I have tried...

Dear All, I want to try a task in excel, but can't able to acheive, so please help me to resolve it By conditional formatting, i am highlighting the entire row with Yellow color, now i want to put a vba code which can put 1 in a cell (any cell in a column) in that highlighted row. I am...

Dear all, I have inserted a Listview control in a form, but whenever i click custom option in properties window then it gives an error " class not registered" i m using excel 2007 Please help me to resolve this

Dear All I have read the below url, but whenever i run the code but connection can't open shows error: Run-time error-'2147467259 (80004005)': microsoft odbc driver manager datasource name not found and no default driver specified http://www.rondebruin.nl/win/s1/notes/notes3.htm i...

Dear All, I have read and inspired by Chandoo's "Using Excel as Database" http://chandoo.org/wp/2012/04/02/using-excel-as-your-database/, but i need to know that, in view sheet if we have updated some data, can it be possible to update that same in the source data i.e Raw data sheet? I know in...

Dear SirJB7 I am extremely sorry for the post, i will keep it in my mind about your instructions. In further i will not post/share any files which causes the illegal. I am a excel enthusiastic to learn new things, this leads to me to post this. Becoz i want to know, how the file controls the...

Dear All Please find attached Document. I find it in some where, Acutally it is a costing Data sheet from globalized team, to calculate cost of particular data. But i need to modify the code, there is a VBA Protect password, so i can't able to view & edit the code. I have tried HEX decoder to...

Dear All Can you please suggest me the best sites which can explain more about ADODB conn object. I want to learn the topic so eagerly I hope you all people help me to learn new concepts Regards Vijay

Dear Excel Ninjas I want to try, to open multiple connections at a same time through ADODB conn. by specifying multiple files to be accessed. Now i can able to open a single connection at a time (here i am using activeworkbook.path & application.pathseperator & activeworkbook.name) but i want...

Dear All, Problem phonomena is below 1. My Lookup value in cell V7 : *F2482* (by using formula i.e ="*"&IF(LEFT(J11,1)="9",LEFT(J11,11),MID(J11,5,5))&"*" (Result is *F2482*) 2. Getting position of the lookup value in the range (in cell V8): ="J"&MATCH(V7,J11:J171,0)+10 (Result is J161) 3...

Dear Blog Users, I need your help, in my work. As i have read and inspired below topic regarding excel as database. http://chandoo.org/wp/2012/04/02/using-excel-as-your-database/. But if i want to display the records as per heading i am putting in the view sheet, how to do that i don't know...