Search results for query: *

Upfront, letting you know I might not have explained well or need to provide more code for context... This question is using MS-Access to run vba to modify an excel sheet. Found this code to refresh data in pivot at https://www.automateexcel.com/vba/refresh-pivot-tables/ It seems to work fine...

Was asked to take over maintaining a data pie chart. In the upper right hand corner is a table, currently, it appears to be a text box in which one has to manually click on it and key in the data. As I would prefer not to have to rekey in data that already exists in the spreadsheet, decided to...

Inherited an excel file. Was pretty messed up and have fixed many of the data issues. The person who transferred the file to me is no longer here and the instructions (rules?) were as follows: If are asked to: add a row, highlight the range in yellow "delete" a row, highlight the range in...

Hope I can ask two-in-one (these are separate issues, both relate to Outlook though). 1) How to ReplyAll or Forward: Cobbled together some code to perform a ReplyAll or forward an email. I was able to get the code to locate the message and display - as want to see how it looks rather than...

I have a column with formula that evaluates to True or False. I wanted to use the Find (Ctrl+F) to locate a row with False. It kept telling me that it could not find False. My initial search on the web suggested things like adding another col, filter for false, use conditional formatting...

I am using access to create an excel file and perform a save as. The only part that doesn't seem to be working is defining the starting directory. It does put in the file name correctly. I have reviewed some of the threads and tried the suggestions such as below and they didn't seem to alter...

I found code to hide the page numbers and date from powerpoint 2013, which I assumed would have the same effect as clickihttp://www.tek-tips.com/threadminder.cfm?pid=707ng on View, Handout Master and unticking Date and Page Number in the Placeholders section and then print the result to pdf with...

Thought this would not be tricky, maybe overlooking something. (Hope I'm using the bound terminology properly) I created a unbound combobox in the header of a form and code in the after update event adds new record using values from all the cols in the combobox. This works well for the bound...

I'm trying to locate a file or files that were given to me a year or two ago, can't recall the name(s), I do remember they had some text that was colored green. Is there a search mechanism that would allow me to find such files? I looked around and saw examples for searching within a document...

I have this working as intended using vba. however... was wondering if is possible to do within the combo box to have the default value be the highest(max value). The combobox row source is: SELECT DISTINCT mid([tblSurveyExtract_Course].[EventCode],2,2) FROM [tblSurveyExtract_Course] ORDER...

I'm pretty sure the issue is related to an intermittently slow internet connection. I've put together some code to make api calls to SurveyMonkey that returns data in JSON format and gets saved into a variable which then is passed to a function that parses out the data. I started...

I found code that creates email message. When I see the results in outlook, I noticed that the Font and Point size for the first line is Times 12 pt, while subsequent lines are Calibri 11. If I manually open outlook and click New Message, and paste stbody, it renders all in Calibri 11. I...

Trying to build an indicator to filter rows and am running into datatype mismatch. I have tried nz, isnull, val, and so far it persists. Hopefully someone will see what I'm not. This works fine without a where clause: ExtraCredit...

Maybe used the wrong search terms...Is there a method to find a bullet number the way you use ctrl+F to find words in MS-Word or do I have to convert bullets to text, which I'd prefer not to do since then I'd have to either close and reopen or reconvert to bullets. Example there are items...

Been using something like this to import certain data elements from a single col excel extract file, all was well as the data I was pulling from the query and parsing was either numeric or under 100 chars. Recently, it was requested to include some comments. The comments are being truncated...

I would like to find out if it is possible to delete rows in excel from access without having to loop through each cell as is the present situation because seems that it would be faster. I recorded the macro and copied the code into access, but it gets stuck on the autofilter line as well as...

Have put together various query templates for appending data that is imported. User now is requesting to have the query prepopulated with all the fields from the import table, rather than have to predefine or drag them onto the grid. I can through vba create a select statement that lists all...

Quotes are confusing, even after looking at various examples, didn't seem to get it working until now. Hope is useful... Using vlookup to get a title from another sheet. This is working. I have put into vba so that when a new csv file is ready, it will reformat to excel and insert the...

Couple of issues, first one (I've done a work around by doing a make table each time procedure is run to get one row per group, but if there is a solution to this to use the original table, that would be great, otherwise skip to second issue). 1: This probably wouldn't be an issue if using a...

Been using this construct to edit sql statements in code. ... ... stsql="Select....." If QueryExists("qryQuery") Then Set qd = db.QueryDefs("qryQuery") Else Set qd = db.CreateQueryDef("qryQuery") End If qd.SQL = stsql Would like to find out if this can be put into a function or if...