Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sagamw
  • Order by date
  1. sagamw

    Resizing a Subform

    ...I want obviously), BUT even then if the picture object in my subform grows to hold a bigger picture and then I load a smaller one, I still get the unused/blank/scrollable space that the bigger picture covered earlier. *sigh* I can't understand what property changes, to find a way to control...
  2. sagamw

    Resizing a Subform

    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. :-(
  3. sagamw

    Resizing a Subform

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

    Referring to Controls on a Subform (BUT on SQL)

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

    Referring to Controls on a Subform (BUT on SQL)

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

    Getting the Old path of a backend before the re-linking of FE & BE

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

    Getting the Old path of a backend before the re-linking of FE & BE

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

    Getting the Old path of a backend before the re-linking of FE & BE

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

    Getting the Old path of a backend before the re-linking of FE & BE

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

    [Error 2017]

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

    [Error 2017]

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

    Changing the User-Agent (a newbie question)

    ...'GET', url: window.location.href, headers: { 'User-Agent': 'Mozilla/4.0 (compatible) Greasemonkey', 'Accept': '*/*', }, }); You loaded in greasemonkey and when you go to http://whatsmyuseragent.com/ the site reports "Mozilla/4.0 (compatible) Greasemonkey"...
  13. sagamw

    Changing the User-Agent (a newbie question)

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

    Changing the User-Agent (a newbie question)

    ...method: 'GET', url: window.location.href, headers: { 'User-Agent': 'Mozilla/4.0 (compatible) Greasemonkey', 'Accept': '*/*', }, }); But doesn't work. I'm "studying" this page for getting it work http://wiki.greasespot.net/GM_xmlhttpRequest. Maybe I need to do something with the...
  15. sagamw

    How can I "Quick print" a form (VBA, Access 2007)?

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

    How can I "Quick print" a form (VBA, Access 2007)?

    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??
  17. sagamw

    How can I "Quick print" a form (VBA, Access 2007)?

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

    How can I "Quick print" a form (VBA, Access 2007)?

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

    How can I "Quick print" a form (VBA, Access 2007)?

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

    How can I "Quick print" a form (VBA, Access 2007)?

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

Part and Inventory Search

Back
Top