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 derfloh 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: *

  1. ICCIIT

    MS Access Runtime 2010 quick question..

    Thanks strongm We were unsure if there was any dependency on having a standard version of Office installed as we were getting errors associated with a deployment. We were trying to use 2010 runtime for a Access 2010 database on a Windows 10 build and it seems that is where the problem was...
  2. ICCIIT

    MS Access Runtime 2010 quick question..

    Very quick question hopefully. Can you download and use Runtime without any version of MS Office being installed on a pc?
  3. ICCIIT

    Open selected file using file dialog

    Andrzejek The file could be of any format, I just want it to open once they select it...
  4. ICCIIT

    Open selected file using file dialog

    Access 2010 I am wishing to allow a user to navigate and select a file to open from within a form command button, the filedialog code below works fine but I cannot get the selected file to open! - all that happens is the file is selected and OK'd and then it all closes down. Thanks in advance...
  5. ICCIIT

    How do we send a report to PDF with a "Where" clause or Add Where Clause to "OutputTo

    Thanks Strongm After I posted I did find the same solution elsewhere and it works well but annoyed me when each loop previewed the document! so within the report I have added a docmnd.Minimize within the On Open event which did the trick! Its not the most elegant solution but it works, I am...
  6. ICCIIT

    How do we send a report to PDF with a "Where" clause or Add Where Clause to "OutputTo

    Access 2010 As part of a Loop procedure I have a OpenReport command that has a "Where" statement included so that it outputs each Looped instance to our printer as below:- DoCmd.OpenReport "rptrenewalinvite", , , "tblPolicy.LpPolID='" & PolicyID & "'" We are now wanting to create PDF files as...
  7. ICCIIT

    Email address input mask

    Thanks Andy, I thought about doing a validation like that but before I embarked on that journey assumed there might be some form of input mask readily available - but it seems not. Thanks again
  8. ICCIIT

    Email address input mask

    Using Access 2010 Does anyone have or know of an input mask for email addresses? trying to think of a way to include one but struggling to get around the protocols and variables that can be contained within any address. It seems a bit of a mine field given that the @ must be included...
  9. ICCIIT

    Access 2010 Runtime Ribbon - Complete idiots guide needed!

    Ohhhh wow..... this is so cool and so much more helpful, I wish I had asked here first instead of getting sooo stressed watching YouTube vids which were as clear as mud! Very much appreciated for this excellent kickstart... I will now dig deeper and explore! Star for you 1DMF!
  10. ICCIIT

    Access 2010 Runtime Ribbon - Complete idiots guide needed!

    Hi 1DMF Thanks so much for this, I had got as far as creating the USysribbons table but then got so confused about how to create/write/edit XML using XML editors or Notepad or Word etc that I just gave up. I will now copy and paste your xml in to the table and start to play... I think this is...
  11. ICCIIT

    Access 2010 Runtime Ribbon - Complete idiots guide needed!

    OK... I have read so many articles now that its confused the hell out of me... ALL I want to do is allow my users (Runtime versions only) to be able to have 3 standard options "filter by selection" "clear filter" "sort ascending" on a form. Of course in Access full version these are available...
  12. ICCIIT

    "Output to" Excel 2010

    Its ok... my mistake it should be acFormatXLXS doh....
  13. ICCIIT

    "Output to" Excel 2010

    ..."tblData", acFormatXLS, "s:\Data".xlsx", , "" I then tried the old format (which works) but that opens the spreadsheet in Compatibility mode rather than full 2010. DoCmd.OutputTo acTable, "tblData", "MicrosoftExcel(*.xls)", "s:\Data".xls", , "" Are there better ways of doing this? Thanks
  14. ICCIIT

    Access 2010 - Combo box values

    Thanks Andy... a deserved star....I can see many uses for this....
  15. ICCIIT

    Access 2010 - Combo box values

    Revised code Now in the Form Current event... Private Sub Form_Current() Dim datMonday As Date datMonday = Date Do Until Weekday(datMonday) = vbMonday datMonday = datMonday - 1 Loop With cboMondays .AddItem datMonday .AddItem datMonday + 7 End With
  16. ICCIIT

    Access 2010 - Combo box values

    OK.... I have now removed the .listindex=0 from within the With statement and its all working!! very elegant solution Thanks
  17. ICCIIT

    Access 2010 - Combo box values

    Andy OK.... some success... Its now in my FormLoad event it gives me error 7777 "You have used the Listindex property incorrectly" But when I end the error, the combo shows me the 2 dates.... so nearly there! (
  18. ICCIIT

    Access 2010 - Combo box values

    Hi Andy Cannot get this to work at the moment, I have placed this code in the on-click event of the combo but it does not populate the list... it does not error either so not sure what is happening.. The combo Row source is set to Value list and Rowsource is empty Bound column=1 Thanks
  19. ICCIIT

    Access 2010 - Combo box values

    On my form I wish to have an unbound dynamic combo box that is limited to 2 values only... The start date of the current week The start date of the next week (both being Mondays) Naturally as time moves on, the requirement is that these dates will move with it.. I cannot find a way to...
  20. ICCIIT

    Upside down format? - Excel 2007 text

    OK.... a colleague as made a request to be able to type text in to Excel 2007 cells in upside down format! naturally I went to the Text alignment options but that will only allow +90 or -90deg. Anyone know of a way to do this or is there an upside down font to use?

Part and Inventory Search

Back
Top