Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 413
Search took 0.06 seconds.
Search: Posts Made By: Frothingslosh
Forum: The Watercooler 10-11-2019, 01:47 PM
Replies: 61
Views: 1,227
Posted By Frothingslosh
Re: Prince Harry, Duke of Sussex

Nope, I don't like you. I've known for a while, now, however, that your anti-Americanism is 90% trolling, but I have zero tolerance for racism (including calling Markle 'half-caste', even if you...
Forum: The Watercooler 06-20-2019, 01:02 AM
Replies: 20
Views: 3,967
Posted By Frothingslosh
Re: I'm OK with this particular use of firearms!

I always love how the same people who argue that 'disarming the people leads to fascism' always ignore the existence of the many nations with strict gun control that are also functioning...
Forum: The Watercooler 06-19-2019, 01:39 PM
Replies: 20
Views: 3,967
Posted By Frothingslosh
Re: I'm OK with this particular use of firearms!

Tera, actually, right now the laws in most, if not all, states forbid firearms on public school property or at school events, along with many, many other locations (like anywhere alcohol is sold). ...
Forum: General 04-10-2019, 08:32 AM
Replies: 13
Views: 381
Posted By Frothingslosh
Re: Urgent!! 2013 to 2016 Stops All Functionality

They shouldn't, but anything is possible with Microsoft. When I upgraded, all my document extensions got unassigned, and I had to go back and manually fix all of them.

I asked because the...
Forum: General 04-10-2019, 06:15 AM
Replies: 13
Views: 381
Posted By Frothingslosh
Re: Urgent!! 2013 to 2016 Stops All Functionality

Were you asked to enable macros? Is the database or its folder listed on the Trusted Documents page?
Forum: Politics & Current Events 04-04-2019, 09:09 AM
Replies: 2,301
Views: 140,655
Posted By Frothingslosh
Re: Shootings in US schools

Saying that Americans just accept gun violence is much like saying that Brits just want a hard exit from the EU.
Forum: Modules & VBA 04-04-2019, 04:58 AM
Replies: 34
Views: 561
Posted By Frothingslosh
Re: Different Saves

In fact, here's what I'm talking about. Note that this is NOT design mode.

Changes users make to the display here prompt a save dialog when they attempt to close the form (unless you take steps),...
Forum: Modules & VBA 04-04-2019, 03:08 AM
Replies: 34
Views: 561
Posted By Frothingslosh
Re: Different Saves

I've never had to do this, since my department's policy is to have users download a new copy of the front end every time they open the app, but I can think of one case where this would be acceptable:...
Forum: General 04-01-2019, 05:15 AM
Replies: 45
Views: 1,106
Posted By Frothingslosh
Re: Matching logic

MajP, you absolutely should put that FuzzyFind database from post 13 into either the code repository or the sample database subforum.
Forum: Tables 02-22-2019, 05:07 AM
Replies: 11
Views: 284
Posted By Frothingslosh
Re: Import queries and UPEND operation

The word you want is 'hasten'. 'Fasten' means something completely different. :)

Indexes covering your WHERE clause *MIGHT* speed things up - it depends on whether the search speed enhancement...
Forum: Code Repository 02-20-2019, 06:26 PM
Replies: 17
Views: 11,394
Posted By Frothingslosh
Re: Progress Meters (Including Dual-Bar)

After checking on Colin's suggestion, let me ask you this: did you actually import the clsMeter module from my files into your database? If you copied the code from it instead and just pasted it,...
Forum: Queries 02-14-2019, 07:05 AM
Replies: 11
Views: 340
Posted By Frothingslosh
Re: Changing the Quarter year to a fiscal year

Damn, I left the backslash out. Updating my original post.
Forum: Queries 02-14-2019, 06:34 AM
Replies: 11
Views: 340
Posted By Frothingslosh
Re: Changing the Quarter year to a fiscal year

Try this:

Format$(DateAdd("q", 1, [Hours].[WeekEnding]), '\Qq yyyy')

Edit: Accidentally left out the backslash.
Forum: Modules & VBA 02-06-2019, 08:28 AM
Replies: 29
Views: 468
Posted By Frothingslosh
Re: Cannot assign a value

LOL You're fine.

Just always a kick in the pants to answer a post, only to find someone else answered it while you typed!

The irony here is this just came up at work for a co-worker. It was...
Forum: Modules & VBA 02-06-2019, 08:21 AM
Replies: 29
Views: 468
Posted By Frothingslosh
Re: Cannot assign a value

DBGuy:

https://access-programmers.co.uk/forums/attachment.php?attachmentid=73820&stc=1&d=1549470103
Forum: Modules & VBA 02-06-2019, 08:21 AM
Replies: 29
Views: 468
Posted By Frothingslosh
Re: Cannot assign a value

Does the table have a primary key? If it doesn't have one and one isn't assigned as part of the linking process, then Access will treat it as read-only.
Forum: Politics & Current Events 02-05-2019, 12:02 PM
Replies: 615
Views: 30,630
Posted By Frothingslosh
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

Yeah, I wasn't taking that bait. :p

https://access-programmers.co.uk/forums/attachment.php?attachmentid=73790&stc=1&d=1549396912
Forum: Politics & Current Events 02-05-2019, 08:04 AM
Replies: 615
Views: 30,630
Posted By Frothingslosh
Re: NASA Study Indicates Antarctica is Gaining More Ice Than It's Losing -

AAARGH

For the love of the FSM, it's 'toeing the line', not 'towing the line'!!!

:banghead::banghead::banghead::banghead:
Forum: Politics & Current Events 02-05-2019, 07:51 AM
Replies: 2,301
Views: 140,655
Posted By Frothingslosh
Re: Shootings in US schools

Apparently the actual phrase used in ancient Hebrew was Lo tirtzach!, which literally translates as 'Do not murder'. A treatise on it written by a rabbi is HERE...
Forum: Modules & VBA 02-01-2019, 07:49 AM
Replies: 29
Views: 468
Posted By Frothingslosh
Re: Cannot assign a value

Putting in code tags with appropriate indentation to make it easier to read.

Private Sub Form_Current()

If Me.NewRecord = False Then

Me.cmbCustomer.SetFocus

...
Forum: General 01-24-2019, 10:23 AM
Replies: 17
Views: 111
Posted By Frothingslosh
Re: New to Access

I have to agree with the others - unless there is a documented business need for calculated data to be saved for some reason, you should avoid doing so since it just wastes space.

In the example...
Forum: Forms 01-24-2019, 06:50 AM
Replies: 37
Views: 1,271
Posted By Frothingslosh
Re: Login Form

I've seen them online in a number of places, so I can't attribute them. One location you can pull them from is https://en.wikibooks.org/wiki/Visual_Basic_for_Applications/String_Hashing_in_VBA. I'm...
Forum: Modules & VBA 01-18-2019, 07:55 AM
Replies: 22
Views: 638
Posted By Frothingslosh
Forum: Modules & VBA 01-18-2019, 06:24 AM
Replies: 3
Views: 155
Posted By Frothingslosh
Re: BeforeUpdate Cancel Not Returning to OldValue

Cancel simply cancels the event that was triggered.

To undo the change that was done, you need to use the Undo event:

txtStartDate.Undo
Forum: Queries 01-15-2019, 07:30 AM
Replies: 8
Views: 199
Posted By Frothingslosh
Re: Opposite sql of innerj join

OR in JOIN clauses are perfectly valid, although it's far more common to see in a WHERE clause.

It's most commonly done when you want to restrict the records being pulled in to the temporary table...
Showing results 1 to 25 of 413

 
Forum Jump



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