Search results for query: *

I can't understand what is the property that changes... It's not the subforms's width and height. If I set them with [forms]![myform]![mysubform].width it changes the dimensions of the subform object inside my form. (that's not what I want obviously), BUT even then if the picture object in my...

Hi TheAceMan1, and thank you for your answer but I tried all 5 options of the property of the subform (also the similar options of the picture object) with no luck. I tried setting the property in the properties sheet and through VBA by using .SizeMode = acOLESizeZoom, still the same behavior. :-(

I have this Form that has a Subform. This Subform is about 75% the area and has only 1 object: a picture. Let's say I change the picture with a bigger one (bigger than the subform's area). Obviously scroll bars appear. By moving the scroll bars I can reach the both ends of my (bigger) image...

Hi Duane. Yes it is. I have already use the same syntax inside my VBA code and it worked fine. I even copy/paste that part of my VBA code into the SQL query. I am using a non-english version of 2007 (source of many evil things) so I am guessing it has something to do with that. for example...

I know that a subform on a main form is not a form, but is a control just like a text box etc. and the proper way to refer to it, is Forms![MyMainForm]![MySubform].Form![SomeID] To my surprise I can't get this to work, as "criteria" in a SQL query (I have a report taking data from that...

By using the .connect function I get the following string MS Access;PWD=mypassword;DATABASE=c:\mydir\mydb.accdb I use the mid function to cut the first part MS Access;PWD=mypassword;DATABASE= and i finally have the string c:\mydir\mydb.accdb My routing checks at first if there is...

I found some infos here http://msdn.microsoft.com/en-us/library/bb221162(v=office.12).aspx but feel free to comment on my original question

I am sure it has something to do with the connect property, but I can't really return the string... :(

I have a db split in FE and a BE. I already have implemented a piece of code for relinking the 2 ends (with a select folder dialog) in case of the BE has moved. How can I get (through VBA) the OLD PATH of my back end? I mean if the BE was in "c:\dbold" and I move it to another location, how...

Hi genomon. I meant if there is a way to rename the form through VBA and keep my password.

Hi I have this "finished" db. I prevent the use of shift and convert it to acdde. I Know that there is no viewable VBA code after the acdde conversion and you can't reach the VBA editor because of the disabled shift. Nevertheless I put a password for my VBA code (so if there is another way to...

Hi again. :( Sorry! You lost me! Do you mean that the GM script works for you? // ==UserScript== // @name Set User-agent // @namespace http://www.w3.org/1999/xhtml // @include http://whatsmyuseragent.com/ // ==/UserScript== GM_xmlhttpRequest({ method...

Hi again. I have the script as it is (no additional code) loaded in Greasemonkey. Enabled for sites like http://whatsmyuseragent.com/ and the site reports my "original" user-agent and not that of the script. Do you mean the useragent is sent before the execution of the gm script? How can I...

Hi I am a newbie in JavaScript. I am trying to change the useragent string of my browser by using a Greasemonkey script. So far I have done something like that: GM_xmlhttpRequest({ method: 'GET', url: window.location.href, headers: { 'User-Agent': 'Mozilla/4.0 (compatible)...

Hi Duane. I have read in many sites comments like the following: "However, forms are not really optimized to print out records and you may wish to present your data in a more user friendly approach." To be honest I fail to see the benefits of using a report instead of a form, at least in my...

I did it with DoCmd.PrintOut ,1,1,,1,1 I am sure some 1s are unnecessary but anyway. I wonder why 70 in the first place??

Extremely weird!! Even if use DoCmd.PrintOut ,,,,1 I'm still getting 70 copies of my form. (Why 70?)

I intercepted the printing (by making preview before printing as default) and IT IS the same page (my little form) 70 times! That's weird. Any ideas? I will try to use the variant "Copies" of the DoCmd.PrintOut and set it to 1, but because this will be (soon) a commercial db I have fear that...

Thanks PHV but for some reason (after I pressed the button with the command DoCmd.PrintOut) Access tries to print ...70 pages! (I ran to stop the printer from printing!) I have my main form open, and over it is the (small) form with some of the data that I want to print (6-7 fields). The...

Yes, I know the argument "print a report, forms are not suitable for printing etc.) I was using a button (with the predefined macro for printing)to print a form. The result was satisfactory, but I have a question. How an I do this with VBA? (I imagine is somethink like DoCmd....) and MOST...