Search results for query: *

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

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

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

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

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

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

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?

OK... I have one pivot table with a "Department" filter so that each of the 20 departments can see their own results from the orginal data source. What I would like to do is Have 1 worksheet for the pivot table (worksheet 1) Have another worksheet with a set of charts (1 for each department)...

I have a Excel Workbook with multiple Pivot tables, the data source is an ODBC connection back to an Access database table which is refreshed each month. The pivot data is not stored in the Workbook. Each month I download & update the data in the database and then refresh the Excel workbook so...

OK I am working within MS97 Access database....(yes its a bit of a joke now in 2012!) Anyway, I have some code that intialise MSWord97 dumps some bookmarks, prints and closes. I now need it to do exactly the same thing but instead of opening Word 97 I want it to open Word 2007 - can this be...

I am having to amend an Access 97 database to locate and extract cell data from multiple cells in an XL97 workbook kept in known location using a command button. The code I have searched for on this forum does not seem to fit/work so I guess its code for more up to date versions of Access. I...

I have two tables tblDuplicateItems (list of many unique policy numbers) tblPolicyData (many items with same policy no) I have tried to create a delete query to remove all the items from tblPolicydata that have related policy numbers in tblDuplicateItems It seems that Delete queries can only...

In a module I have a standard Docmd to print a suite of reports using DoCmd.OpenReport "rptMyReport" If I run this code it naturally outputs to my default printer or the "Specified" printer within the report page options. Is it possible to adapt the Docmd or add some code in the module to...

Is there an Is Like operand that can be used in module code? I want to pass a string variable through to a function and then get the the function to evaluate it using a like statement such as you might do a in a query criteria If MyString is like *"Hello"* then .... End if Thanks

I keep reading about the use of API's and DLL's etc within Access code, where can I find out how all this works and start to put it to use, Access help appears to be silent on this and I guess its a combination of O/S and application help that is required. A list of common API's and their uses...

I have a table in Access for which I wish to build a query, one of the fields includes a number of between 0 – 99 and another field is populated via a tick box on a form so is true or false. I wish to build the query to show all records >40 and all records that are true, I have built the query...

I have a problem with excel 97, I am trying to round up as follows:- If the result is between 0-49 then show 50 If the result is between 50-99 then show 00 i.e 201 would show 250 and 251 would show 300 Can anybody, help I have tried roundup but this only does the decimal place? Thanks

I have built my graph's within the forms option in my database as it is a pop up database and I could not get the reports to work this way. My question is I use the following command when printing docmd.runcommand accmdprint which brings up the print dialog box, however when the user selects...

I am new to access and am looking to have the print dialog box pop up to enable selection of a printer when the command button to print a form is depressed rather than the print going to the default printers, I am trying to print graphs that have been built within the form. Hope this makes some...