Search results

hej Guys, I am running an append query through VBA code that appends massive amount of data to one table. After query runs for a while it gives error 3035 that it is out of memory. How could i handle this situation. Please help? Thanks is advance.

Thanks very much Richard I tried everything but your solution worked perfectly .... Thanks heaps

Hi guys, I am totally stuck with Access crashing every now and then. Actually when I try to set source for a sub form object. Pressing the combo box crashes Microsoft Access 2003. I have tried repairing and compacting etc but to no avail. I have treid deleting and rebuilding form but it did...

Hi guys, I am trying to create a form or subform that should be created after a button is pressed and some complex filetering is occured and records are saved in a multiple arrays so I need to generate a form and controls according to those array values. Please help. Actually I can not get data...

Hi guys, I am trying to create a form or subform that should be created after a button is pressed and some complex filetering is occured and records are saved in a multiple arrays so I need to generate a form and controls according to those array values. Please help. Actually I can not get...

but Problem is another now Yep I got rid of it, Thanks fofa but some time we ignore so simple things while trying to do realy complex stuff. Now I am stuck again when I am trying to count number of records returned through rst.RecCount It is printing the wrong value. If I take it within an...

HI I would like to design a form where user could be given an option to browse a database .mdb file and then select a table from that database that appears in a combo box and then a query should retreive all values from that selected table. I have tried with recordsset thing but error comes as...

Thanks Pat, I think you are right. I need to change behaviour about that. Actually Access is need from my job. But I find it very limited but anyways. Thanks much

The problem is I want to import it to a table anlready there that a user can select from a combo box and If I try to do that I will have to deal with Specification file. SO it wont be an automated procedure as the specification need to exist there. So is there anyway of doing this without...

Yes thats right and it is a task at job need to be finished by tomorrow. Could someone help please?

Hi Guys, I am willing to design a form where I could browse the files and a button should read from text file and insert values into my Table. Please help me in this regard. I want to have a function with parameters like text file name and destination table. Any clue will be highly appreciated...

Hi guys, I am new here in this Forum and in Access as well. I am wanting to use recordset on a form and two buttons that I want to program manually for navigation of Records. How can it me made possible keeping my code professional. I have tried to declare the Recordset as Public and it works...