Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 5.19 seconds.
Search: Posts Made By: The_Doc_Man
Forum: Forms Today, 02:24 PM
Replies: 14
Views: 502
Posted By The_Doc_Man
Re: Intermitttent - "You can't assign a value..", with a bound checkbox

Locking can always be an issue. Most of the time, we recommend setting forms to use "Optimistic Locking" if they use any locking at all.

However, this sentence tells me what I need to know:


...
Forum: Forms Today, 06:34 AM
Replies: 14
Views: 502
Posted By The_Doc_Man
Re: Intermitttent - "You can't assign a value..", with a bound checkbox

Look at highlighted code:


If initialNotify = False Then

If Me.chkFileInUse = True And Me.txtUserCheckout <> getUserName_check Then


MsgBox "Account is currently being accessed...
Forum: General Today, 06:22 AM
Replies: 20
Views: 288
Posted By The_Doc_Man
Re: Forms don't show in Split DB FE

@June7, I was covering all the bases I could think of, but your point is correct. If it works one place and not in another, this SHOULD be something other than naming. But I have to ask to be sure...
Forum: Gaming Yesterday, 12:34 PM
Replies: 99
Views: 62,799
Posted By The_Doc_Man
Re: What's the best/worst video game of all time?

Reviewing the list, I have one more game to add in the "plus" category: Skyrim.

When you have a powerful enough system and good, large-screen display plus a decent surround-sound system, the...
Forum: General Yesterday, 11:21 AM
Replies: 20
Views: 288
Posted By The_Doc_Man
Re: Forms don't show in Split DB FE

OK, let's split the concerns.



Not an issue. I've done that myself. No problem. There is nothing "magic" about a switchboard. It looks special only because Access has a template for it. It...
Forum: General 12-09-2018, 07:17 PM
Replies: 7
Views: 598
Posted By The_Doc_Man
Re: Formatting access cells for inputing data in hh:mm format

MajP - you see that format in navigation a lot. When I worked with the oil industry and they did underwater seismic imaging near certain Pacific islands, we would see longitudes between 160 and 180...
Forum: Forms 12-09-2018, 06:52 AM
Replies: 1
Views: 775
Posted By The_Doc_Man
Re: Problem with font changing using mouse move event

I have no specific answer for you, but will tell you that the more you try to do in an event routine, the longer it will take to run. And remember that one event CANNOT interrupt another event. So...
Forum: Tables 12-09-2018, 06:42 AM
Replies: 13
Views: 901
Posted By The_Doc_Man
Re: Does calculated fields cause database going slow?

Found this thread that is relevant to Colin's post. Go ahead and play with the MaxLocksPerFile value, but as he suggests, do the changes stepwise, not one huge jump.
...
Forum: Modules & VBA 12-07-2018, 03:43 PM
Replies: 5
Views: 157
Posted By The_Doc_Man
Re: Filtering Recordset

The problem may be WHEN you apply the filter.

In this article:

https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/recordset-filter-property-dao


...
Forum: General 12-07-2018, 03:38 PM
Replies: 10
Views: 326
Posted By The_Doc_Man
Re: Project Database Design

You are in a design phase. I'm going to pull out my old stand-bye advice along with explanations.

Old Programmer's Rule #1: If you can't do it on paper, you can't do it in Access.
...
Forum: Politics & Current Events 12-07-2018, 07:22 AM
Replies: 79
Views: 2,875
Posted By The_Doc_Man
Re: Population Control - An inconvenient truth

AB: Good point. Obama was "progressive" (is that new-speak for "socialist"?) and there was a backlash. Hillary was going the other way from the swinging pendulum of public opinion. DJT was going...
Forum: Tables 12-07-2018, 06:45 AM
Replies: 13
Views: 901
Posted By The_Doc_Man
Re: Does calculated fields cause database going slow?

As expected, Allen Browne has something to say on the subject, but he explicitly touches on the calculated field option that was introduced in Ac2010.

http://allenbrowne.com/casu-14.html
Forum: Introduce Yourself 12-07-2018, 06:37 AM
Replies: 10
Views: 2,064
Posted By The_Doc_Man
Re: Feedback form added

Don't know about unanswered threads, but there IS a "new posts" entry in the ribbon that starts with "User CP"
Forum: Modules & VBA 12-06-2018, 09:08 PM
Replies: 20
Views: 904
Posted By The_Doc_Man
Re: Hello Everyone

If (IsNull(DLookup("[userlogin]", "Login", "[userlogin]= '" & Me.txtLoginID.Value & "'" And _
(IsNull(DLookup("[userPassword]", "Login", "[userPassword]= '" & Me.txtPassword.Value & "'")))))) Then
...
Forum: Debates 12-06-2018, 01:39 PM
Replies: 37
Views: 10,618
Posted By The_Doc_Man
Re: Flat Earth and Hollow Earth Theories

Frothy, that image works for me. I'm surprised that the International House of Pancakes didn't make a breakfast bowl that resembled a baseball in a bowl of syrup to commemorate the opening day of...
Forum: General 12-06-2018, 01:34 PM
Replies: 6
Views: 197
Posted By The_Doc_Man
Re: Runtime Error 2105

Yep, got to watch out for those groups - they are additive BOTH ways. The "Grant" entries are added and the "Deny" entries are added separately. But a "Deny" overrides a "Grant" so that READ group...
Forum: Introduce Yourself 12-06-2018, 01:17 PM
Replies: 10
Views: 2,064
Posted By The_Doc_Man
Re: Feedback form added

Jon added that to try to boost the Mind Tavern site. He did so long before the post from MrLee123 so I would say that's not it.
Forum: Politics & Current Events 12-06-2018, 06:26 AM
Replies: 79
Views: 2,875
Posted By The_Doc_Man
Re: Population Control - An inconvenient truth

Col, I actually agree with you that a USA coup is HIGHLY unlikely. At the moment, our unemployment rate is the lowest it has been in 49 years. Many people have jobs and can make some money. When...
Forum: Tables 12-06-2018, 06:17 AM
Replies: 13
Views: 901
Posted By The_Doc_Man
Re: Does calculated fields cause database going slow?

You almost NEVER want to have a calculated field in a table. Offhand I don't know of any VALID reason to have one. EVERY TIME you open the table, if you have a computation, you have to develop the...
Forum: Modules & VBA 12-06-2018, 06:05 AM
Replies: 20
Views: 904
Posted By The_Doc_Man
Re: Hello Everyone

DLookup is a recordset-based query. It is a self-contained function that builds a dynamic SQL string from the three fields you supply then opens a recordset, does a .MoveFirst, picks out the value...
Forum: Introduce Yourself 12-06-2018, 05:57 AM
Replies: 10
Views: 2,064
Posted By The_Doc_Man
Re: Feedback form added

Not seeing it.
Forum: General 12-05-2018, 10:29 PM
Replies: 6
Views: 197
Posted By The_Doc_Man
Re: Runtime Error 2105

If this code won't create (and then travel to) a new record, it is usually something to do with folder permissions or form settings or opening issues.

I'm going to rule out form issues a priori...
Forum: Politics & Current Events 12-05-2018, 10:10 AM
Replies: 79
Views: 2,875
Posted By The_Doc_Man
Re: Population Control - An inconvenient truth

Col, I can no better predict a coup than I can predict the winning lottery ticket for the USA big-money drawings. (And hint: I haven't won a drawing yet.) As to who would lead the event? Again, I...
Forum: Debates 12-05-2018, 09:53 AM
Replies: 37
Views: 10,618
Posted By The_Doc_Man
Re: Flat Earth and Hollow Earth Theories

Matter phases depend heavily on both temperature AND pressure. Under pressure, some things will refuse to melt. That is why some folks think that even gas giants and smaller, colder stars may well...
Forum: Debates 12-05-2018, 09:49 AM
Replies: 37
Views: 10,618
Posted By The_Doc_Man
Re: Flat Earth and Hollow Earth Theories

We would have to see the front of these trousers to properly locate the promised land.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 09:32 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World