Search results for query: *

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

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

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

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

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

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

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

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

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!

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

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

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

I am using the following "output to" line but when I try to open the resulting spreadsheet it gives an "incorrect file format" error although it clearly displays it as an Excel.xlsx file. Using Access 2010 / Excel 2010 DoCmd.OutputTo acTable, "tblData", acFormatXLS, "s:\Data".xlsx", , "" I...

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

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

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

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! (

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

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

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?