Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.37 seconds.
Search: Posts Made By: The_Doc_Man
Forum: General Today, 10:43 AM
Replies: 16
Views: 168
Posted By The_Doc_Man
Re: How to enable a button if any of controls changed

If you were worried about a bound form leading to duplicates, you could have placed a unique index on the field that was getting duplicated, then just trap the error. You lose more than you gain by...
Forum: Modules & VBA Today, 10:40 AM
Replies: 2
Views: 45
Posted By The_Doc_Man
Re: If Then Statement or Dlookup?

I'm not sure the syntax you listed is correct for a chain of comparisons.

Try:

If ( (JobStatus >= "1" ) AND (JobStatus <= "4") ) Then
Forum: General Today, 06:00 AM
Replies: 4
Question System Resource
Views: 83
Posted By The_Doc_Man
Re: System Resource

Arthurdent1949, there is another question. Normally, Access doesn't have this problem. We HAVE seen it before, but it isn't so common as to be an everyday occurrence. Usually when this occurs, you...
Forum: General Today, 05:48 AM
Replies: 16
Views: 168
Posted By The_Doc_Man
Re: How to enable a button if any of controls changed

Here is the big question. You wanted a button to allow you to do an update on an unbound form (and you say you have a way to load the form with values initially). Are you perhaps trying to simulate...
Forum: Modules & VBA Yesterday, 06:32 PM
Replies: 19
Views: 198
Posted By The_Doc_Man
Re: Sending Outlook Emails from Access

I always used the Outlook App Object to create and send mails, so I didn't have to diddle with the implied "SentObject" method that is essentially a black box. When you use the direct App Object...
Forum: Modules & VBA Yesterday, 06:28 PM
Replies: 20
Views: 196
Posted By The_Doc_Man
Re: refresh with code after update

There is another possible event you could use to place a test... the LostFocus event is a good place to test for having accepted a duplicate (using the DLookup method) and if you find that you HAVE...
Forum: Tables Yesterday, 05:54 AM
Replies: 8
Views: 90
Posted By The_Doc_Man
Re: excel to table

Here is your problem.

1. Linking to Excel as an external table, you can see changes to the table when they are made. I.e. manual updates to the table are visible within moments after the...
Forum: Queries Yesterday, 05:37 AM
Replies: 5
Views: 80
Posted By The_Doc_Man
Re: Multiple queries run from VBA code

If you have done some reading on the db.Execute method, you will understand that if you have a "dbFailOnError" option, it UNDOES (rolls back) the effect of the failing query, so you have the...
Forum: Queries Yesterday, 05:24 AM
Replies: 2
Views: 54
Posted By The_Doc_Man
Re: Adding an Employees Data into a "Total" column

1. Is it possible? Yes. Queries are the typical way to format, reformat, add, average, or otherwise compute things from tables.

2. Is it the right course of action? Maybe not.

This sounds...
Forum: Modules & VBA Yesterday, 05:17 AM
Replies: 19
Views: 198
Posted By The_Doc_Man
Re: Sending Outlook Emails from Access

Just as a thought...

Is there a chance that your actual source of subject line ends with a formal line break character? Like vbCrLf (Carriage return + Line feed)?

Are you actually putting in...
Forum: Introduce Yourself Yesterday, 05:08 AM
Replies: 3
Views: 45
Posted By The_Doc_Man
Re: Hello Community, I'm New Member!

Hello and welcome. Always room for another member.
Forum: Introduce Yourself 08-15-2019, 12:04 PM
Replies: 4
Views: 58
Posted By The_Doc_Man
Re: Newbie on board

Ah, Alan, you state things as a true USA "country boy" would state them. You discuss, in order, "my dog and beloved, sipping cider." A true USA redneck puts his "huntin' dawg" first, wife/sweetie...
Forum: General 08-15-2019, 09:41 AM
Replies: 9
Views: 176
Posted By The_Doc_Man
Re: Can I link photos stored on Office 365 (OneDrive, etc.) with an Access Database?

OK, the question is "What protocol is being used?"

Whole file transfers can be managed by Server Message Block (SMB), File Transfer Protocol (FTP), and a couple of others, plus the secure versions...
Forum: Introduce Yourself 08-15-2019, 05:20 AM
Replies: 6
Views: 72
Posted By The_Doc_Man
Re: Hi from Steve, found here needing help and hoping...

New members always welcome. Hey, Steve, glad you're with us.
Forum: Introduce Yourself 08-15-2019, 05:20 AM
Replies: 4
Views: 52
Posted By The_Doc_Man
Re: Hello From Maryland

Hi, Dan. Welcome.

Given your account name, are you clipper or do you find four-part harmony to be your thing? I had a couple of friends who were glee club and quartet members. They invited me...
Forum: The Watercooler 08-14-2019, 03:14 PM
Replies: 19
Views: 330
Posted By The_Doc_Man
Re: Me as a developer and how my apps are used.

There is a thing called an "action point" as a concept in programming, a place where you have a decision or choice or alternative or SOMETHING where human input is involved in some way. Not even...
Forum: Modules & VBA 08-14-2019, 10:52 AM
Replies: 8
Views: 367
Posted By The_Doc_Man
Re: Strange behaviour - hands free switched between vba window and access window lost

Just for the record, I saw you had updated this. It is possible that some tool your IT group is using could cause issues but I would need to know more about what they were doing - and how - before I...
Forum: Theory and practice of database design 08-14-2019, 05:55 AM
Replies: 22
Views: 1,826
Posted By The_Doc_Man
Re: Normalizing (and fixing) a large, messy DB

One-to-one relationships are actually quite rare and this doesn't sound like one of the cases where such a relationship is justified. While this fine point is not always fully appreciated, it is...
Forum: The Watercooler 08-14-2019, 05:41 AM
Replies: 19
Views: 330
Posted By The_Doc_Man
Re: Me as a developer and how my apps are used.

My biggest Access system for the Navy had that logging idea, though it didn't silently e-mail me the logs. The security guys were pretty cool about a lot of things but they shut the door on the idea...
Forum: Introduce Yourself 08-14-2019, 05:36 AM
Replies: 3
Views: 78
Posted By The_Doc_Man
Re: Hello from Accra

Glad you chose to join us. Welcome.
Forum: The Watercooler 08-13-2019, 08:20 AM
Replies: 19
Views: 330
Posted By The_Doc_Man
Re: Me as a developer and how my apps are used.

MANY years ago I worked for a company that made specialty control systems with a display and a keyboard with a ton of special keys. We had a brand new system and were ready for a phase-one customer...
Forum: Introduce Yourself 08-13-2019, 08:11 AM
Replies: 5
Views: 78
Posted By The_Doc_Man
Re: Hello!

Hi, ChrisC, and welcome from a (typically) soggy New Orleans summer day.
Forum: The Watercooler 08-12-2019, 02:35 PM
Replies: 42
Views: 2,695
Posted By The_Doc_Man
Re: Laugh of the Day - 5.25" Floppy

For my money, a Motorola 6800 series was the best of the microchip architectures at the time. The company for which I became a manager of tech in-house support services worked with several chips...
Forum: Queries 08-12-2019, 09:40 AM
Replies: 10
Views: 150
Posted By The_Doc_Man
Re: Can not open attachment loaded by other users

Ah, I read it the other way... but if you don't put the attachments in the same place as the back-end file (or a child folder thereof), then you have a REALLY serious permissions problem - an...
Forum: General 08-12-2019, 09:37 AM
Replies: 10
Views: 148
Posted By The_Doc_Man
Re: Degrees and employees

More specifically, the reading topic is "compound index" - which you want to make unique. It does not have to be the PK of the table for that to work.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 04:39 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