Search results for query: *

I am looking for some "rules of thumb" for opening and updating linked Excel files. I have numerous files so connected, with formulas such as COUNTIF, SUMPRODUCT, INDEX, MATCH, OFFSET, etc. involved. I'm in the habit of opening all these files together, as that usually facilitates the process...

I think I am not alone in working in an organization that has contracted for a "web-based" database that appears to be unable to handle relational database items well. Thus, a work-around is needed. Right now I am exporting the report results, running a query in Access, then re-importing to my...

Let me explain! I have an Excel form, with a command button that triggers some action, basically picking up values in a few cells and using that to create a file name, then outputting a pdf of the form. When I cloned this form/worksheet, I of course had to rename the worksheet copy, but then the...

I have an Excel form that uses vba to generate a pdf file, and display it. However for some users I want to place this form/dashboard file in a Read/Only environment and have the button on the form pull up the relevant pdf files (in a loop) that have already been created. My current code...

I am working with excel files, linked. in one cell of one of the files, I would like to display the original file creation date of a different file (possibly in a different location, i.e. with path info). The reason is that I am using my first file as a dashboard (e.g., dashboard.xls), and the...

For some time I have been looking for a way to do the above, in Index/Match or VLOOKUP type formula referencing in Excel. Basically I want my cell formula to reference a file such as FileSource.xls and one of many worksheets that are datename specific, such as 010513, for January 5th of this...

I have a formula such as the following, modified for simplicity here: =SUMPRODUCT((JAN!$D$2:$D1000<>"")*(IF(ISNA(MATCH(JAN!$D$2:$D$1000,UNITS)),1,0))) I'm expecting this formula to parse a column, and if the cell is not empty, to see if the contents of the cell match one of the elements of an...

My report has a page header with labels such as: 'Last Name' & 'Summary' and in the detail section my text boxes include txtLastName & txtSummary. Most of the time this works fine, but if the length of the text in a particular record's [Summary] field forces the txtSummary text box to create a...

Instead of designating my lookup array with something such as $A$10:$BA$10 in a particular cell, as part of an INDEX & MATCH combination (e.g., =VLOOKUP($A2,'Current Month'!$A$11:$BA$113,MATCH($A$1&" n",'Current Month'!$A$10:$BA$10,0),FALSE), I would like to be able to specify part of this with...

On a form I have a list box, whose value is a row source from a query: SELECT [Legend Query].Field13, Mid$([Field13],6,2) & "/" & Mid$([field13],9.2) & "/" & Mid$([field13],1,4) AS RightDate FROM [Legend Query]; Basically all this is doing is calling a single value from a table (whose value...

I have numerous subreports in a larger reports. Right now they are sorting by the item of interest name, but I would like to sort by the count of particular items in the reports query. Here is the query source for one of these: SELECT [Complaints-Verbal].VerbalComplaintNo...

I have some queries that I use on a form to generate reports, and an example of one is one I call qryBudgetNewJoined: SELECT Department, [Dept ID], [Job Code], [Job Description], [Total Regular FTE], [Total Overtime FTE], [Total Holiday FTE],[Total FTE] FROM BudgetNew UNION SELECT [Rpt...

I have a file with numerous worksheets. Every time I add new, imported data to the file, I must run a search and replace on one or more columns in one or more worksheets, or else my data is not "cleaned." I would like to automate this in case I forget! Surely there is an OnClose event in which...

I have a file with numerous worksheets. Every time I add new, imported data to the file, I must run a search and replace on one or more columns in one or more worksheets, or else my data is not "cleaned." I would like to automate this in case I forget! Surely there is an OnClose event in which...

Today I attempted to get another user on my database, after her computer was updated to Access 2007. Upon opening the database (which is split and linked), the first attempt to click on the Switchboard produced the following error message: "The expression On Click you entered as the event...

I have a set up that has worked for years for me that failed today (Office 2007 issue?). A Word document contains links to an Excel table. The table cells are Auto Row Height formatted and wrap text formatted, no merged cells, etc. Prints fine in Excel. In Word, the linked table appears fine in...

I made a copy of an active database, in order to make serious design changes. Now I'd like to update the tables in the clone, with the goal of switching users over to my "new, improved version." Various import and export options I've tried, including through Excel, leave me with things like...

I need to return the contents of a cell in a worksheet. The column number will be static (say, 1, or really, 4) while the row number will be a varying number of rows below a row number in the worksheet, and that reference row number I can obtain with the formula: =MATCH("UNIT: TOTAL",'current...

I have an Access 2007 report that works off a query whose parameters include texboxes filled in on a form, and also a few subreports. It loads very slowly, but it works, except for one of the choices among "departments" (actually "services") whose output would be a page or two more than the six...

I have an Access 2007 report, that contains a couple of subreport (actually, one or more subreports of subreports), and it is very slow to format, to print or even to output to pdf (though that is the fastest, oddly enough); it is even slow to toggle from design to view mode. I could live with...