Search results

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...

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 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...