Search results

Hi David, Since the data in each file are not consolidated in 1 worksheet but placed here & there ie. in sheet1, I need to get data from C12, B15, AE71...in sheet2 I just need A105, B32 to B45, AC17 to AF32...and from many other sheets. Thanks! Robert

Sorry for not making it clear! Actually I want to have codes that help automatically open all files in a folder (c:\temp\...) & execute a macro (which had been created, named "Tranferring_data" & stored in "c:\Master data file.xls"). This is to import data from individual file to a "master data...

Hi all, I have a a macro in a separate excel file and want it to automatically run on all excel files in a certain folder (c:\temp). As I have so many files that need to be excecuted with the same command, if I have to manually open each file and run the macro, it will be very time consuming...

Hi All, I have a list of picture file names on column A and would like to have a cript to insert all the pictures to the respective rows of column B. ie. A1=c:\pic1 ==> pic1 will be inserted to B1 A2=c:\pic2 ==> pic2 will be inserted to B2 Thank you very much for any advice! Robert

Once again, thanks Kafrin a million for your time! Your codes work very well now. So fantastic!

May I know the solution for stopping data entry once the quota is reached? ie. male=150 & Female=110. Thanks a lot!

Dear K, It's very kind of you! I couldn't think that the second code can also link to the 1st Query. So great! After updating the query name accordingly, the second code does not show any error message. However, It seems not to stop data entry given the quota has reached. I have 17 male and...

Thank you very much for your codes! It workrs very well for the first point of summarizing the achieved quota, however the second code cannot run (even after I change OpenRecodrset into OpenRecordset). It yellow-shaded the [ Set rs = CurrentDb.OpenRecordset("Quotas")] Could you please...

Hi all, May I seek your advice on how to create a summary in a form to show the total number of quota achieved & stop data entry if the quota is fulfilled: Ie. Out of 1000 students in my data base, I just need to interview 150 male student & 110 female student (filed status="done" means...

Thanks a lot again! It's really kind of you to give me advice and offer some help! I will try myself to write query...I like to learn more about Access but have limited reference to this software. I'm looking out for more read-ups. Have a nice day! TH

Thank you so much for your code and advice! As I import the data from Excel to Access, I will have 2 more tables with the same structure as in the existing tables (1 without subdata & 1 with data). My difficulty lies at this point. I really don't know how to join these 2 sets of access tables...

Hi all, I currently have 2 link tables in Access (1/ MAIN table without subdata - all student info ie. name, age, gender... & 2/ CLASS table with subdata - link to MAIN table, these 2 tables came from 1 excel database - Part1). Now I have another list from Excel (identical structure - Part2)...

Thanks a lot... Based on your advice, now I can import the list into 2 tables in Access and apply your method of marking other members in a class if 1 student of the same class is interviewed. Great great!!!... However, sorry I face another problem that I'm given the continued lists of the...

Thank you very much for your patience! I'm trying it out but seems like your method requires 2 separate tables: 1 for class & the other for student list. However the list i have at hand is a combined one, from your suggestion I may have to split it into 2 tables so that the "check" can work...

Thank you all very much for your advices! Sorry as time & cost constraint, I'm requested to interview only ONE student in a class. Hence I can only manually click or mark "closed/ interviewed" for the very student that I already interviewed. However I want access to help me also mark for all...

Hi all, I'm stuck, appreciate your guidance! I'm doing a project of interviewing Only ONE student in each class of a school. I have a file with the list of all 1000 students (name, gender, email... class) and 10 questions: Q1-Q10. These 1000 students belong to 20 different classes. I don't...

Thank you very much! This really does what I want. You are my life saver!

I'm really grateful to your help! Sorry for not giving you enough info! I use the group option for Single answer question [v4] (how satisfied are you with the service on the scale of 5: 5=very satisfied; 4=satisfied; 3=neutral; 2=dissatified & 1=very dissatisfied). Before that there is a...

Thank you very much for your patience. Now I've got to now the rule of on lost focus. For the group option, it does not support the on lost focus. I tried this it it did not work: Private Sub v4_beforeUpdate(Cancel As Integer) If IsNull(Me.v4) Then MsgBox "please select 1 option", vbOKOnly...

Sorry I had problem of log-in. It's very kind of you! the codes works perfectly. May I have another question: How can i write a code that can check the missing/ redundant for: Option group (1/ everybody must answer; 2/ all v2=2 must answer else must skip) ==> this check should be poped up...