Search results

I have a memory problem generating reports in Access. I have a functionnality which it is going to be run in daily basis by the user to generate the reports for records created on that day automatically and export them to pdf files. This works fine but on a day can be until 250 reports to...

I have a program where I am calling an application programmed in C#. When my process finish, it writes a value on a table on my Access database which a want to read. I am using a recordset to get this value on my code VBA. But the problem is that sometimes I am not getting the value updated if...

I have two continuous sub-forms with calculated textboxs on the form footer. The formula it is just the sum and product of the values of every record. I haven't had problems until a user complaines it is getting on the textboxes this "#error" message on both sub forms. This happens randomly and...

I have a query by form which copies the content of a Memo type field to another record, but the text gets cut when the length is over 510 characters and weird symbols are added at the end of my text. This happens in Access 2003, I'v tried in Access 2007 and my update works fine. This is my...

I've been using this code from lebans website http://www.lebans.com/imageclass.htm. to resize picture. I needed this because i was linking pictures to my database by saving the path in the database and the pictures on a folder. Besides I was having problems with memory when showing pictures on...

I'm trying to hide or disable the close, minimize and maximize buttons on Access Window. I have found different ways working with API's but they just work in early versions like Access 2003. When I test them on Access 2007 nothing happens. Any one knows a way to do it in Access 2007? Thanks...

Urgent! I need code to resize jpeg images to a smaller size. What i have found till now is an application that i have to install and run it from vba. but what i really need is to code inside my application without having to install anything else. Thanks for your help

I have a report which display one or more pictures. I load the pictures on formating event of the report. The path is stored on a text field in the database and the pictures are saved on a folder. My pictures are jpeg's. I asign the file name to the picture property to the image control...

I am sending information from access to excel creating a workbook in VBA, and sending the data from a recordset but it takes to much time creating my Excel File. Someone have an idea about how to optmize my process??

Hi, I have a query to fill a recordset in my code. This query requires parameter values that I take from a form. I managed to make it work in Access 2007 using the following code. Set qdfQuery = currDb.QueryDefs("rql_Filtre_Rapport_General") 'Parametres pour la requête...

I want to disable the double click in the title bar of Forms, I don't want users to be able of resizing the window, Control buttons are disable but I can't find any property to disable this function. Thanks