Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 11.41 seconds.
Search: Posts Made By: The_Doc_Man
Forum: General Today, 05:15 AM
Replies: 2
Views: 74
Posted By The_Doc_Man
Re: Clinic software

It is possible that someone on the forum has something they will sell to you. You might also find one or more members seeking to write a contract for creating such a thing as you request. However,...
Forum: Modules & VBA Today, 05:09 AM
Replies: 18
Views: 284
Posted By The_Doc_Man
Re: Dsum Not Working

ThisMonthWeekdays = DSum("[TotalSales]", "QryYTDSales", "[Event] = No And [date1] BETWEEN #" & StartDate & "# AND #" & EndDate & "#")



OK, the experiment shows it wasn't the way you formed the...
Forum: The Watercooler Today, 04:48 AM
Replies: 6
Views: 118
Posted By The_Doc_Man
Re: I'm OK with this particular use of firearms!

Tera, not all of us carry guns. I own a gun but it is always in the house. The government allows it because our history in the USA is based on the image of the hardy pioneer going out into the...
Forum: General Yesterday, 06:47 PM
Replies: 5
Views: 114
Posted By The_Doc_Man
Re: Change 64 bit Access to 32 bit

The only time I ever saw a 32/64 dual install, the app specialist fought it for close to a month before giving up because they never quite got it right. Not disagreeing with Colin, just telling you...
Forum: Theory and practice of database design Yesterday, 12:11 PM
Replies: 4
Views: 77
Posted By The_Doc_Man
Re: Backend database is suddenly getting inconsistent stat

Typically, "Inconsistent state" comes about when someone closes their application in a way that doesn't correctly preserve data being written back to the back-end file. For instance, rebooting a...
Forum: Modules & VBA Yesterday, 09:05 AM
Replies: 18
Views: 284
Posted By The_Doc_Man
Re: Dsum Not Working

MajP, I also thought DateSerial was "smart" about such things - but I proposed a simple test to see if the problem is in the start/end dates or in the data. If the problem doesn't change, then we...
Forum: General Yesterday, 09:00 AM
Replies: 8
Views: 134
Posted By The_Doc_Man
Re: Question:Timeout, or similar function possible?

Splitting the database allows you to edit contents of tables. But if you want to hard-code anything in the forms and then change them, splitting and distributing the front-end copies multiplies your...
Forum: General Yesterday, 08:57 AM
Replies: 8
Views: 134
Posted By The_Doc_Man
Re: Question:Timeout, or similar function possible?

Asilzade, you can open your own thread. In fact, it might be better if you did because your details will probably not match the details of this thread. We won't get your setup confused with the...
Forum: General Yesterday, 08:54 AM
Replies: 18
Views: 376
Posted By The_Doc_Man
Re: Data Protection Different Levels

Asilzade, you are permitted to start your own thread. You didn't have to re-open the topic.
Forum: Modules & VBA Yesterday, 06:35 AM
Replies: 18
Views: 284
Posted By The_Doc_Man
Re: Dsum Not Working

Public Function ThisMonthWeekdays()
Dim StartDate As Date
Dim EndDate As Date
StartDate = DateSerial(Year(Date), Month(Date), 1)
EndDate = DateSerial(Year(Date), Month(Date) + 1, 0)
...
Forum: The Watercooler Yesterday, 05:56 AM
Replies: 6
Views: 118
Posted By The_Doc_Man
Re: I'm OK with this particular use of firearms!

According to the article, there were TWO uses of firearms. Surely you don't condone BOTH of the uses, Uncle G.
Forum: The Watercooler Yesterday, 05:54 AM
Replies: 2
Views: 51
Posted By The_Doc_Man
Re: A New member

Glad you chose to join us. New members are always welcome.
Forum: Modules & VBA 06-15-2019, 08:34 PM
Replies: 18
Views: 284
Posted By The_Doc_Man
Re: Dsum Not Working

The "EJECT" functionality is good because it forces an internal "Dismount" function. On a home system, you never (well... hardly ever) mount or dismount anything explicitly. On a server, there is...
Forum: The Watercooler 06-15-2019, 08:27 PM
Replies: 6
Views: 133
Posted By The_Doc_Man
Re: USA Holiday - Father's Day

I agree. It is exactly that attitude of uncertainty that makes you continue to strive for the good result. By never believing you've done quite enough, you don't stop. And there is where the...
Forum: The Watercooler 06-15-2019, 01:40 PM
Replies: 6
Views: 133
Posted By The_Doc_Man
USA Holiday - Father's Day

To all of you out there who are fathers, grandfathers, or even higher generations, I salute you. Sunday, June 16, 2019 is the USA Holiday celebrating fathers. (3rd Sunday in June.)

It takes a...
Forum: Queries 06-15-2019, 09:19 AM
Replies: 16
Views: 242
Posted By The_Doc_Man
Re: Join with more than 15 fields

The way I read the "specifications and limits" articles, and based on my understanding of the nomenclature, a JOIN between two tables with more than one field to test between each table is merely one...
Forum: Queries 06-14-2019, 09:08 AM
Replies: 16
Views: 242
Posted By The_Doc_Man
Re: Join with more than 15 fields

jaryszek, the JOIN limit is on how many TABLES you can JOIN in a single query but a different limit applies to how many fields you can have in a query. You can only generate a recordset with 255...
Forum: Modules & VBA 06-14-2019, 08:59 AM
Replies: 2
Views: 63
Posted By The_Doc_Man
Re: Webcontrol issues - One for the masters :)

First thought coming to mind is the file permissions and ownership. Get to Windows Explorer on the VP's machine and find the files. Then check via right-click >> Properties >> Security. On that...
Forum: Modules & VBA 06-14-2019, 08:52 AM
Replies: 8
Views: 125
Posted By The_Doc_Man
Re: VBA to load all the tables with sql server data

Just remember if you do what theDBguy suggests, disable the buttons. Turns out there is a trick that you can put an enabled button on top of something even though it is invisible. I used to do that...
Forum: Introduce Yourself 06-14-2019, 08:49 AM
Replies: 8
Views: 122
Posted By The_Doc_Man
Re: Dale in Pennsylvania

Hi, Dale. I've got two local grandkids that kept me active for a while (they are older and more mature now) plus one living three states away.

Here's hoping you don't have to correct us too many...
Forum: Modules & VBA 06-14-2019, 04:47 AM
Replies: 8
Views: 125
Posted By The_Doc_Man
Re: VBA to load all the tables with sql server data

Definitely possible. You want to make the old button transparent and disable it.

https://docs.microsoft.com/en-us/office/vba/api/access.commandbutton.transparent

That link points you to a page...
Forum: Modules & VBA 06-14-2019, 04:42 AM
Replies: 9
Views: 126
Posted By The_Doc_Man
Re: How to close specific excel file from access?

The question to be considered is to determine how the file got opened if your code wasn't the way it got opened.

Normally, if YOU opened the file, you could try workbook(n).Close to do it.
...
Forum: Modules & VBA 06-14-2019, 04:35 AM
Replies: 15
Views: 214
Posted By The_Doc_Man
Re: only allow correct data input

Simple and straight-forward. Often that is the best method, murray83.
Forum: General 06-13-2019, 07:15 PM
Replies: 18
Views: 376
Posted By The_Doc_Man
Re: Data Protection Different Levels

And it is NOT impossible. But what IS impossible is for us to plop a pile of code down in a post and expect it to work correctly in your context when we don't know anything about your context. ...
Forum: Modules & VBA 06-13-2019, 01:53 PM
Replies: 15
Views: 214
Posted By The_Doc_Man
Re: only allow correct data input

True, he doesn't - but we were suggesting he SHOULD, and were discussing that point.
Showing results 1 to 25 of 500

 
Forum Jump



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


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