Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 137
Search took 0.03 seconds.
Search: Posts Made By: tinyevil777
Forum: Sports, Health & Fitness 06-29-2013, 09:51 AM
Replies: 20
Views: 13,215
Posted By tinyevil777
Re: Kilimanjaro Trek - August 2012

Thanks Richard, your support is appreciated, I just do what I can.
Forum: Sports, Health & Fitness 06-29-2013, 02:11 AM
Replies: 20
Views: 13,215
Posted By tinyevil777
Re: Kilimanjaro Trek - August 2012

Not particularly bothered if you report me or not. This forum means more to you than it does to me.

I could easily report you for the multiple Welsh comments that you've made. They could be...
Forum: Sports, Health & Fitness 06-27-2013, 12:32 PM
Replies: 20
Views: 13,215
Posted By tinyevil777
Re: Kilimanjaro Trek - August 2012

On the contrary, I made it to the top after 6 days and 50 hours of trekking. The photos are here if you or anyone else would like to take a look: http://www.flickr.com/photos/94131876@N03/

The...
Forum: Sports, Health & Fitness 01-22-2013, 02:10 AM
Replies: 20
Views: 13,215
Posted By tinyevil777
Re: Kilimanjaro Trek - August 2012

The trip was postponed from August 2012 to February 2013. To be exact, I have 31 days until I go. My training is going well, I've raised awareness for my local hospice and over 1,000 in the process....
Forum: The Watercooler 01-14-2013, 03:51 AM
Replies: 2,659
Views: 219,716
Posted By tinyevil777
Re: Gun laws do they work

So you genuinely believe that Germany's extermination of jews, and genocide as a general happening, would have been avoided had the victims been provided with arms?

Wow.
Forum: The Watercooler 10-18-2012, 01:49 AM
Replies: 8
Views: 964
Posted By tinyevil777
Happy birthday BrianWarnock

A quick thread to wish Brian Warnock a happy birthday.

A very helpful and genunie member of AP.
Forum: Modules & VBA 08-03-2012, 07:34 AM
Replies: 1
Views: 723
Posted By tinyevil777
Wildcards with Form Filters

Hello,

Dead simple one i'm sure... I'm using the following code to filter a subform depending on the contents of a text box:

If Nz(Me.SrchDescription, "<All>") > "<All>" Then 'Invoice...
Forum: Modules & VBA 08-03-2012, 06:56 AM
Replies: 2
Views: 1,250
Posted By tinyevil777
Re: Filtering related data on a subform

Any help on this whatsoever would be greatly appreciated... Thank you!
Forum: Modules & VBA 08-03-2012, 01:19 AM
Replies: 2
Views: 1,250
Posted By tinyevil777
Re: Filtering related data on a subform

Also, if it's any use, below is the Record Source for the subform:

SELECT DISTINCT dbo_POHeads.ID, dbo_POHeads.OrderNo, dbo_POHeads.Supplier, dbo_POHeads.OLDID, dbo_POHeads.Removed
FROM...
Forum: Modules & VBA 08-03-2012, 01:15 AM
Replies: 2
Views: 1,250
Posted By tinyevil777
Filtering related data on a subform

Morning all, hope everyone is dandy.

I've implemented some code taken from this old post http://www.access-programmers.co.uk/forums/showthread.php?t=121662

I am using Access 2007, and I have...
Forum: The Watercooler 07-27-2012, 07:17 AM
Replies: 5
Views: 1,030
Posted By tinyevil777
Re: Any Formula1 fans on here?

I'm a big F1 fan! In fact, a few weeks ago I had a single seater driving experience at Silverstone... Very very good!
Forum: Web Design and Development 06-11-2012, 04:36 AM
Replies: 5
Views: 4,552
Posted By tinyevil777
Re: Hyperlink Issue

<a href="www.yourlink.com/yoursubdomain/nameoffile.pdf" target="_blank">Click Here to view our Latest Product Software</a>

Whenever you get a new Product Software file/download/page, simply...
Forum: Hardware Questions and Answers 05-18-2012, 06:59 AM
Replies: 4
Views: 6,484
Posted By tinyevil777
Re: Fn Key on Gigabyte Laptop

When you first set up Windows, there's an option to choose your Keyboard Type. I recall there are 'English','English - Extended' options to name a couple. Might the 'Fn' facility only be available on...
Forum: The Watercooler 05-11-2012, 12:40 AM
Replies: 24
Views: 3,288
Posted By tinyevil777
Re: What mood are you in today?

In pain - thanks to my 5 month old kitten who decided to BITE my heel this morning.
Forum: Macros 04-20-2012, 03:55 AM
Replies: 3
Views: 950
Posted By tinyevil777
Forum: Macros 04-19-2012, 08:15 AM
Replies: 3
Views: 950
Posted By tinyevil777
Re: How do I bulk amend data in a table?

Hello Pete,

You might want to a little research on 'Update Queries', this will do what you need.
Forum: Forms 04-18-2012, 07:37 AM
Replies: 5
Views: 695
Posted By tinyevil777
Re: Bery basic question about text boxes

Try setting the field/data type to 'MEMO' rather than 'TEXT'
Forum: Forms 04-17-2012, 01:15 AM
Replies: 2
Views: 962
Posted By tinyevil777
Re: ActiveX Calender Control not requerying Subform

Thanks for your reply Spike, yes, that previous post answered my question perfectly.

I do always use the 'Search' option for related posts before posting a query; my terms must've been well off.
...
Forum: SQL Server 04-13-2012, 06:13 AM
Replies: 3
Views: 2,752
Posted By tinyevil777
Re: Use same derived table twice as virtual source for UNION queries, how?

Might the VIEW function be an avenue to explore?
Forum: Forms 04-13-2012, 06:12 AM
Replies: 12
Views: 1,997
Posted By tinyevil777
Re: I just can't figure it out!

You need to add a "Me.Requery [MyControlName]" for any fields you want to refresh (display the updated data)
Forum: The Watercooler 04-05-2012, 02:24 AM
Replies: 17
Views: 1,943
Posted By tinyevil777
Re: What watch do you wear?

I wear the Rotary watch i was given as a 21st birthday present, not too snazzy!
Forum: Forms 04-05-2012, 02:23 AM
Replies: 2
Views: 962
Posted By tinyevil777
ActiveX Calender Control not requerying Subform

Hello all,

I have a table called 'Tasks', where a date is entered along with a short description of the task.

I then created a form with an ActiveX 'Calender' on. I also created a subform,...
Forum: Reports 03-06-2012, 09:00 AM
Replies: 4
Views: 788
Posted By tinyevil777
Re: add date to title of report

The 'DateAdd' function might also be worth exploring...

http://www.techonthenet.com/access/functions/date/dateadd.php
Forum: SQL Server 02-14-2012, 09:26 AM
Replies: 15
Views: 3,983
Posted By tinyevil777
Re: Percentage calculation

Of course not, i appreciate all feedback.

Usually, yes, i'd not store calculated values in a table. However with this example, i actually have a temporary table which is created every night using...
Forum: SQL Server 02-14-2012, 09:02 AM
Replies: 15
Views: 3,983
Posted By tinyevil777
Re: Percentage calculation

Yes, yes and YES!

Happy days, thanks alot for your help! Finally got there eh?

The final working SQL Update query...


UPDATE REPConversion
SET Conversion =CASEWHEN (GoneLive >...
Showing results 1 to 25 of 137

 
Forum Jump



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


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

Sponsored Links

How to advertise

Media Kit


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