Search results

If you want to show an actual additional bar with a Totals Row (TR) you might need to do a union query. I put zTotal rather than total so it would sort last. If you don't have any words that would sort after Total, then you could remove the z. You probably will need to play around with this...

Something to try, if the file is text format such as csv, you can import with UTF-8. Use the wizard to set this up. When the Import Text Wizard pops up, Click on Advanced, then Click on Code Page and choose UTF-8, then you can save the spec and use it to upload the file in the future.

Regarding post #5 It is actually Larry. "Hi, I'm Larry, this is my brother Darrel, and this is my other brother Darrel"

I have code that will do some of what you want, but you will need to experiment and edit parts of it to work with your existing excel layout. I'll see if I can locate and post tomorrow.

Agree with Micron to name objects on the form to not be same as the field names from table or query and also since users won't see, it shouldn't matter as much if the vba shows upper or lower. Wanted to mention though that in my test, it was a new db, turned off auto correct and only created an...

I tried too and looks like however you first entered the name of the control is the way it stays. I created a text box with all upper case and then changed to lower case and it stays upper case. Seems to keep the case format of the way it was originally entered, however, if you change the name...

I had seen some of those links a while ago and couldn't quite seem to get them to work with my code. Decided to revisit and try again. Eventually I found an example at the DataNumen site, while similar to the other examples, had some keywords that helped me sort it out. One was that it...

some random examples: delete, copy, paste, add a formula, specific cell using Row number and Col Number rather than LetterNumber: .Rows(2).Delete .Range("F2:G" & lastRow + 1).Copy .Range("S2").PasteSpecial xlPasteAll .Application.CutCopyMode = False .Range("I2:I" & lastRow + 1).Formula =...

Another option might be to change the point size of the font in the text box. If it is Calibri 11, try Calibri 08? Of course if the name or path are very long, that still may not be sufficient to display the text.

Colin: So Microsoft expects their software works 365 days rather than this being the 365th version????? So first was numbered: Access 1, then year: Access 95 and now days: Access 365, so the next progression would be minutes: Access 1440? Micron: Does that mean they will charge 4 times the...

Ypma, Glad you were able to make the code work for your situation.

ok. good to know not the only one who can't use the software. Too bad I decided to try it and wound up worse off than before since office 365 is acting slower than 2016. Maybe office 370 will sort it all out?

In your post #1 I would guess to place it after the To? Here is my code block example: With Mailobject .bodyformat = 3 'Late binding in lieu of olFormatRichText .To = fwdto .CC = ccto If sentfromshared = True Then...

my set up uses what theDBguy suggested and it works. I have code to allow it to be an option as follows. If sentfromshared = True Then .SentOnBehalfOfName = "person@email.com" End If In a previous job, we used a command line to achieve the effect, but would be better if can do it within vba.

zeroaccess, in March went from 2013 to 2016 and then yesterday from 2016 to 365 and wanted to roll back to 2016. To my knowledge, don't have 2019, unless it is another way of saying 365. Based on what I see, the screen says Microsoft Access for Office 365 MSO (16.0.11929.20740) 64-bit Colin...

A couple months ago, our company was upgrade from 2013 to 2016. Seemed to go fairly smoothly. Today I wanted to try the compare database feature. After I provided the two files and clicked the button, it told me it was missing a component support file. I don't recall the name as I'm writing...

Thanks for the update about the recordings. Planning to start on Friday afternoon. Glad they were able to edit out the non-Access materials.

This might answer post#29 Copied as is from my code, so there is a default pattern, but the code allows for providing your own pattern. First function finds the start position and second function returns the length of the text. Examples: intDatePos = RegExPatternStart(Me.txtSubject)...

Thanks Crystal and Colin for the status update. Hope that they decide to release the recordings to a wider audience.

Are only original attendees going to be allowed to view the recordings or will the other topics also be open to AWF members to see?