Search results

Thanks jdraw for you reply. My copy is not a "cut and paste". I have a button "copy" wich takes my current record and copies some fields to a new record. The user choice weather or not to copy the notes (stored in my memo field), so, once I have created the new record, I verify if user wants...

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

Hello. Yes, I am running Windows XP. Thank you for the link. I was already read that article, so I was just hopping to find someone who already have another solution for this problem. Thanks

Yes, my application is a trusted location. This is one of the functions I am testing. It disables the three buttons on my Windows application. In Access 2003 I can disable the minimize button and the close button, but in Access 2007 i just get the minimize button hidden. But the close button is...

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

Thanks for your answer Well, in that case, that means i am going to need to resize the pictures. Somebody knows how to change size of jpegs with vba code?

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

SOS : Thanks for your reply. I tried to programm your suggestion getting the size of the window. The problem is that my windows has its property to a pop - up windows because i need it to overloap the access windows. That's the purpose of the maximize function. So, the problem is that the...

SOS, thanks for your reply. I had tryied before in the Resize event to run the Docm.Maximize, that works but I was asked to change that because it shows the window to minimize and then maximize again. On the other hand, I would like to try your suggestion to see if that can work better, but...

I tried your suggestion but it doesn't work :( I tried the four options indeed. Maybe I have to say that when I open this form I run a command in vba to maximize it. Docmd.Maximize I want the form remind like this so I do not want users to be able to double click the title bar. Thanks

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