Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.10 seconds.
Search: Posts Made By: Thales750
Forum: Modules & VBA 11-08-2019, 07:09 AM
Replies: 12
Views: 251
Posted By Thales750
Re: Outlook Automation

Microsoft has done a disservice to the Access Communities with their lack of available documentation of Office Automation.

I think Patrick must have had some exclusive contact with MS to be able...
Forum: Theory and practice of database design 11-05-2019, 10:37 AM
Replies: 27
Views: 956
Posted By Thales750
Re: The pitfalls of VBA proficiency

Back to the topic.

Code is like a 2X4, or a plumbing fixture. Different methods or preferences are like different brands of the same kind of tools.

Pretty much it's what you make out of them...
Forum: Theory and practice of database design 11-05-2019, 10:25 AM
Replies: 27
Views: 956
Posted By Thales750
Re: The pitfalls of VBA proficiency

I didn't realize you had added the action query part.

I will take a look at your version, thanks.
Forum: Theory and practice of database design 11-05-2019, 08:38 AM
Replies: 27
Views: 956
Posted By Thales750
Re: The pitfalls of VBA proficiency

I think if someone were "of a mind", a combination of the things you did and what Gina did would be very useful.
Forum: Theory and practice of database design 11-05-2019, 07:52 AM
Replies: 27
Views: 956
Posted By Thales750
Re: The pitfalls of VBA proficiency

Did you make yours work with action queries?
Forum: Theory and practice of database design 11-01-2019, 01:44 PM
Replies: 27
Views: 956
Posted By Thales750
Re: The pitfalls of VBA proficiency

I built a database to organize my code. With key word searches and two layers of parent tables to filter it.

Over the years it has saved hundreds of hours.

For embedded SQL Strings I use...
Forum: Modules & VBA 11-01-2019, 11:48 AM
Replies: 12
Views: 251
Posted By Thales750
Re: Outlook Automation

The code I use came from Patrick Wood. Over the years I modified it to do exactly what you are wanting to do. I have permission to use it but not to share it on forums. Although, the parts that...
Forum: Modules & VBA 10-31-2019, 05:50 PM
Replies: 12
Views: 251
Posted By Thales750
Re: Outlook Automation

This Guy Darbid in Post #2 has the answer to the delete portion. It works perfectly well with whatever code you're using to create or get an Outlook Object. I use it with the Code Patrick wrote...
Forum: Modules & VBA 10-31-2019, 05:38 PM
Replies: 12
Views: 251
Posted By Thales750
Re: Outlook Automation

Hey Db Guy, It works on a one way street from Access to Outlook. I'm trying to make it work the other way.

Patrick Wood has the answer. I just tested a module from his Appointments.accdb.

...
Forum: Modules & VBA 10-31-2019, 04:33 PM
Replies: 12
Views: 251
Posted By Thales750
Re: Outlook Automation

The primary key comes from Access and we use it to delete or reschedule Outlook Items which were created in Access.

It's useful to us because Users are not using it.
Forum: Modules & VBA 10-31-2019, 01:56 PM
Replies: 12
Views: 251
Posted By Thales750
Outlook Automation

In multiple Outlook.com (Exchange) Calendars, on local Outlook.
Is there a way to propagate appointments that are rescheduled in Outlook back the the equivalent Access Record?

We're using the...
Forum: General 10-18-2019, 10:02 AM
Replies: 3
Views: 129
Posted By Thales750
Re: Set Value in Multi Select List Box

I was unable to make that work: but this version seems to fit the bill.

Dim lngRow As Long

For lngRow = 0 To Me!lstAttendees.ListCount - 1

If Me.lstAttendees.ItemData(lngRow)...
Forum: General 10-18-2019, 06:41 AM
Replies: 3
Views: 129
Posted By Thales750
Set Value in Multi Select List Box

Is there a property to use when externally setting the value (and selected row)
of a Multi Select List box.

I don't seem to be able to find it.

Thanks
Forum: General 10-18-2019, 06:38 AM
Replies: 7
Views: 246
Posted By Thales750
Forum: Forms 10-15-2019, 01:07 PM
Replies: 5
Views: 117
Posted By Thales750
Re: Set Mouse Cursor not SetFocus

That's a good question.

It turns out I had a development form open behind the Switch Board (Dialog)
And that causing the problem.

Sorry to waste your time. Thanks for helping.
Forum: Forms 10-15-2019, 12:09 PM
Replies: 5
Views: 117
Posted By Thales750
Re: Set Mouse Cursor not SetFocus

The form closes before the other opens.
Forum: Forms 10-15-2019, 11:05 AM
Replies: 5
Views: 117
Posted By Thales750
Set Mouse Cursor not SetFocus

Start condition: you have a button on a Form, or any control that will accept a click event, set to open a new form.

If the button is located in the same place on the screen as a continuous...
Forum: Forms 10-15-2019, 10:56 AM
Replies: 8
Views: 5,072
Posted By Thales750
Forum: Forms 10-15-2019, 10:38 AM
Replies: 8
Views: 5,072
Posted By Thales750
Re: Start in the first position the cursor!

Along these same lines, is there a way to make the "mouse" hover over a specific place when opening forms.

If a Control to open a Form is physically the same as a Subform that is on the opening...
Forum: General 10-03-2019, 10:54 AM
Replies: 7
Views: 246
Posted By Thales750
Taking Out the Trash

Well, where to begin, no, I mean really. Where to begin?

Bloat, bloat and more bloat.

I'm guesstimating there are about thirty percent extra components, in a database with over a thousand major...
Forum: Modules & VBA 05-08-2019, 04:06 PM
Replies: 12
Views: 330
Posted By Thales750
Re: Open Dialog Initial View

I guessing not so much. Her thinking is no one needs it. For everyday Email, I would agree.

But, this is a text message processor, text messages contain a lot of pic attachments. The truth is,...
Forum: Modules & VBA 05-08-2019, 05:13 AM
Replies: 12
Views: 330
Posted By Thales750
Re: Open Dialog Initial View

Hey DB Guy. I tried all different ways. Then I called my friend Gina Whipp,she said the same things. "They don't play nice together"

I have a laptop with win 10 and Office 2016. I will try it...
Forum: Modules & VBA 05-07-2019, 03:13 PM
Replies: 12
Views: 330
Posted By Thales750
Re: Open Dialog Initial View

There is a Microsoft Bug.
It doesn't work, and it may not be able to work.
Forum: Modules & VBA 05-05-2019, 06:39 AM
Replies: 12
Views: 330
Posted By Thales750
Re: Open Dialog Initial View

I lied.

These Properties seem to conflict.

With fDialog

.InitialView = 6
.InitialFileName = "Z:\OneDrive\Attachments"

It needs a "Change Directory" execution...
Forum: Modules & VBA 05-05-2019, 06:11 AM
Replies: 12
Views: 330
Posted By Thales750
Re: Open Dialog Initial View

Here's the deal.

The .InitialView Property must be the first in the list. Here is some code from Stack Overflow. I added the .InitialView to several place in the
"With Statement" and finally...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:45 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World