Recent content by vid

Hey , thanks a lot . got it to work Thanks again Cheers

Hello , I ve made a macro so that every week a master excel file gets updated with daily data. these daily data are in individual excel files named 140610 , 150610 and so on .. depending on the date . Currently if in the folder there is the master file and 3 individual date excel files (...

hey , thanks a lot . sorry i was not too clear . but i got it settled . thanks again .

Hi everyone! I have a word document with some drop-down and some text fields in it. I'm facing a problem when i want to delete some of the text fields while the document is still locked, as the drop-down field doesn't work unless the doc is locked. Some of the text fields are optional, to...

Hey , Please help if possible. i need to map cells from an excel file onto a pdf which is then used to create a pdf form of the format xdfx. how do i do this at one go ( is there some thing for a range of cells to be copied from excel to the pdf file . the excel page says this : Appx2...

Thanks! its works perfectly.. just removed the ; Thanks a ton!!! :D

CurrentDb().Execute "DELETE * FROM [Temp]" Sql = "(INSERT INTO Temp ([Warranty ID]) SELECT DISTINCT * FROM [Search Results Query] WHERE ' " & strWhere & " ')" CurrentDb().Execute Sql This is the code I've managed to come up with.. everything else is working fine now! i just don't know the...

Thanks for all your help :) this is the query i'm trying to use but its giving me an error.. Could you please suggest why this is happening! CurrentDb().Execute "INSERT INTO Temp ([Warranty ID]) VALUES (" & Me!WarrantyID & ") WHERE strWhere" I just don't know how to refer to all the...

Could you tell me how to "append all the filtered unique values for [Warranty ID] into a temp table"... That would be a great help :)

Thank you for your response :) It makes complete sense... I figured I needed to do something on these lines just wasn't sure exactly what I should be doing! I will try this out and get back to you if I have more doubts :) Thanks again!!

Thank you for your quick responses! I know that the search form has no sub-form.. The edit claims form does... That is the form which is supposed to open up when you click on View All.. Its the form to which the filter is StrWhere is being applied.. Please have a look at it again... Meanwhile...

please refer to this link! I'd posted my question and came across this thread later. If someone can help me I'll really appreciate it! Its driving me crazy... http://www.access-programmers.co.uk/forums/showthread.php?t=193812

Hi! I need to do a similar thing for a db i'm creating... Could you find a solution to this problem?? Thanks!

Ummm.. I don't think you understood the problem properly.. Try this: Chose a requestor and click on View All.. It works perfectly. Then unfilter everything and chose a technical team feedback. Again click on view all.. It has problem... Even though it lists the correct records, it doesn't open...

Hi! I've been breaking my head over this problem for 2 days now and haven't managed to find a solution! please help.. I am attaching a sample db. The problem is that when I search by a field (eg. Technical Team Feedback) in the subform of the form being opened(search form) the "view all"...