Search results

Thanks "the_net_2.0" I tried your solution, but I still have the same error message. Also the excel spreadsheet is not protected when I run alloweditrange code.

Hi All, I am struggling a bit in Access VBA. I export files from Access vba and then open the file and do some formatting and then password protect that excel file. However I want the user to able to edit two columns. I try below code but it is not doing the job. It gives me runtime error 1004...

I have designed an application in Access 2003 that imports and converts a text file (which usually is about 14 MB) and then parses the data (analyze each record one by one) into the desired output. I have used VBA for this purpose and I am novice both in Access and VBA. After the data is...

Thanks a lot Paul

Thanks Paul, i had misppeled the form name and now I have got rid of the message. I have coded the information like this: Sub ttt() DoCmd.OpenQuery "qry_MS TNA (Comp)", , acReadOnly DoCmd.OpenQuery "qry_MS TNA (Series)", , acReadOnly DoCmd.OpenQuery "qry_MS (1) Holdings", ...

Hello All, Thanks so much for your replies. I am novice in Access and probably I am going round about to work out on my solution. I actually have designed 4 queries within database in design view to generate the desired results. All these queries are either select or union queries and...

Hello, I am trying to run a query through vba module in ACCESS 2003 but I get runtime error 2342: “A Run SQL action requires an argument consisting of an SQL statement”. I am not sure why I am getting this error. This is to code I have written: Set db = CurrentDb Set qdf =...

I am sorry for not having been able to explain my question well. I have again attached the excel spreadhsheet that shows the final results that I need to generate (it’s from row 20 to row 30 in the attached spreadsheet). After adding the new records to the existing records, I need to update...

Thanks for the help. I could finally run by using the Group clause in sql statement for queryc. Substituting Union to Union All couldn’t work as for some reason the number of records were less than I should have got. I have a final question on this query. I did not envisage this before so...

Thanks so much Guus2005. You have been a saviour. I ran the query suggested by you and it does work. However there is one glitch with queryb. In the example that I showed earlier , queryb should generate only three records. But when I run this query it generates 9 records in total, 3 are unique...

I need help with ACCESS query. I am not at all good with access queries and am unable to figure this out even though it may have an easy solution. There is an existing query designed by our company in a database. This query links different fields from 4 more queries and finally generates 16...

Hello Friends, I am totally new to the VBA world and I am not very thorough at Access as well. I am required to create a macro in Access that can enable user to parse the data that has more than 65000 records....The data is in in raw form in txt format. The macro has to start right from...