Search results for query: *

Hello Everyone, The attached Workbook has 15 years of freshwater flow data. There are three sheets. The two main sheets are SupplySummary and FlowData. On SupplySummary, column R is Max Day (MGD) for the year and column S is Max Day (Date). The day in that particular year that had the highest...

I'm sure this is easy but I've been staring at it for to long. I get the following error message in this line of code. DoCmd.OpenReport "Evaluation Due Dates R", acViewNormal, , "Division = " & rs.Fields("Division"), acHidden Can somebody open my eyes. Thanks

This is my first stab at a relational database and it works (I don't know the most efficient way to do things and wouldn't have gotten this far without google) but the user has asked for some tweaks. I created an Employee database that is used for general employee information, keeping track of...

I am trying to fix an Excel file that uses Power Query to import data from another Excel file into Power Pivot. This file was created by a former employee and I am not up on these features of Excel. This file was working fine until this week when it started generating a refresh error. The...

I have a database that keeps track of water utility repair digs. When the repair dig is complete the crew lead fills out a dig card. I'm scanning the cards (because the cards have hand drawn details of the repair) to pdf. The pdf will be kept in a separate directory and opened into the default...

Regarding thread 702-1753559 hyperlink/browse for file, Link The link above is exactly what I am trying to do. I know a bit about Excel VBA but very little about Access (365) VBA. I'm a little confused on how to link the code to the text box where the hyperlink would be entered. I assumed that...

We have a simple employee database, 1 table, names, addresses. work cell phone number, etc. A new cell phone list is distributed whenever there is a change. Some employees are widely known by a nickname which we have a field for. When printing the report I would like to replace the first name...

I have a file that is used to track employee time off without preapproval to see trends. It is attached below. It is set up to track for a calendar year. There are two main sheets in the workbook, Hours, where the unapproved time off is input and Summary where you see how many hours were...

I have a simple Excel macro that prints out vehicle inspection sheets. This is a chore that is done monthly at work. The macro prints sheets based on what vehicles are in a list. The sheets are named for each vehicle number and the list the macro refers to are the vehicle numbers to be printed...

I want to limit errors on item ID entry to this exact alpha numeric format: AANANANNN The entry will always be 9 characters. Example ID: WD5A4V336 I searched through the posts and found a problem similar to mine but don't quite understand the formula used and the formula is to long for data...

I have a master sheet "Penalties" that I need to update with monthly data. I need to do a lookup without writing formulas on the sheet. The data sheet "November1" has only a portion of the data that applies to the Month of November. More data will come in weekly. The "November1" (data) sheet...

This is the first userform I've done and it works but I would appreciate someone in the know looking at it and suggesting how it could be better. I've looked at various reference books and online sites and feel like I need a userforms for dummies book. I'm using a combo box to allow the user to...

At work we have a mix of desktop MS Office (various versions) and Office 365. I wrote an Excel macro that works perfectly on my desktop (Office 2010) but fails win I try to run it on Excel Office 365 (v.2108 build 14326.20238). I get a Run Time Error '13' Type Mismatch. I've looked at this...

Hi All, I know little to nothing about VBA in Outlook, but have found the code below that works pretty good except it outputs as an ics (icalendar) file. I would like it to output as a csv file or something compatible with Excel if possible. I also need it to pull the data from a public folder...

Is what I'm asking in the subject possible. I've searched google and can't find anything to help. Thanks for any help you can give.

I have a workbook where I need to update one sheet in the workbook (I'll call it Data_Feed) on a regular basis. I am just now learning about powerpivot. I have installed the Powerpivot addin for Excel 2010 and it seems to work fine. I have been able to get the same data from a data feed with...

I have four lists of employee initials, with each list assigned it's own color. When I type any initials that exist in one of the four list I would like the newly typed initials font color to be the same as the color of the list it exist in. I would like the ability to change initials in the...

I checked the forum and this question has been asked but the answer was too vague for my understanding. The macro acts on different rows depending on weather the enter key is used or tab or cursor up, down , left, right. I want whatever method triggers the event to have the same effect as...

I do OK in Excel VBA but Word VBA seems completely foreign. As the title says I want to select text in an open Word doc then with an Excel macro have it pasted into Excel starting at the selected cell. I want each line of Word text to be on a separate row in Excel. There is nothing fancy about...

I'm wondering is the following example of an excel spreadsheet formula possible and if so what is the correct syntax. Row 13: If(And(A13<>A14,G13<>G14),Sum(H & (Q13-(P13-1)) & :H13),"")) I have a sheet with 50000 plus rows. This is a customer list that covers eight years and each...