Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: MSAccessRookie
Forum: Modules & VBA 07-31-2015, 07:27 AM
Replies: 12
Views: 1,516
Posted By MSAccessRookie
Re: run-time error 13 type mismatch

In case you were wondering why the change worked, and if you should always use "&", I would imagine that each has their own place, but in this case, the difference probably was in the Instance where...
Forum: Modules & VBA 07-31-2015, 07:13 AM
Replies: 15
Views: 1,236
Posted By MSAccessRookie
Re: Create Disable Alphabetic Keys Function Based on Case Statement

Is there any particular reason for using the Select/Case Statement Here? I offer my apologies in advance if I misunderstood your intent, but I believe that the following could be a simpler approach:...
Forum: Modules & VBA 07-28-2015, 07:47 AM
Replies: 3
Views: 264
Posted By MSAccessRookie
Re: How to get Null and IS NULL combine (Third Condition/All Data)

Since the general purpose of a Filter is to Exclude items that do not fit the desired criteria, and the first entry represents all items, It is difficult to see why a filter would be needed. Try...
Forum: General 07-24-2015, 11:02 AM
Replies: 11
Views: 1,010
Posted By MSAccessRookie
Re: How to use Stock Tickers

Once again, Uncle Gizmo is asking a legitimate question. A Stock Ticker is used like a Database Primary Key to obtain information (price, volume, etc.) pertaining to a stock from another application...
Forum: General 07-24-2015, 10:14 AM
Replies: 4
Views: 498
Posted By MSAccessRookie
Re: Grading

I believe that what Uncle Gizmo meant was that how you do it with a computer is directly related to how you would do it on paper.

You will need a multiple Case Operation, so use google to look up...
Forum: Queries 07-23-2015, 09:57 AM
Replies: 6
Views: 863
Posted By MSAccessRookie
Re: Left Funtion with 2 static characters

There a Function named Mid() in MS Access which allows you to extract characters from within a target string. There is also a Function named Instr() that will allow you to find specific characters...
Forum: The Watercooler 07-22-2015, 10:42 AM
Replies: 59
Views: 5,275
Posted By MSAccessRookie
Re: Will you upgrade to Windows 10?

The company I am working for has issued an executive order not to upgrade any workstation or laptop that is to be used in the Corporate environment due to "incompatibilities to be named later". As...
Forum: The Watercooler 07-21-2015, 10:03 AM
Replies: 28
Views: 2,026
Posted By MSAccessRookie
Re: Resign from Site!

Or possibly you know what
:banghead:
Forum: Queries 07-20-2015, 05:39 AM
Replies: 5
Views: 575
Posted By MSAccessRookie
Re: Query Union Criteria

And we have another satisfied customer! Please feel free to let us know the details of your solution if you have time to do so. It is helpful to know the final solutions of issues presented in the...
Forum: The Watercooler 07-17-2015, 02:03 PM
Replies: 5,702
Views: 494,082
Posted By MSAccessRookie
Re: Story

about craters in
Forum: Macros 07-17-2015, 06:26 AM
Replies: 5
Views: 822
Posted By MSAccessRookie
Re: compare dates?

Knowing absolutely NOTHING about your Database, it is hart to be specific, but when you break down your question into smaller pieces, it seems to answer itself. As you can see, the answer should be...
Forum: The Watercooler 07-15-2015, 01:10 PM
Replies: 5,702
Views: 494,082
Posted By MSAccessRookie
Re: Story

left nothing behind
Forum: General 07-10-2015, 07:50 AM
Replies: 11
Views: 698
Posted By MSAccessRookie
Re: Copying from Excel to Access

If by "Email" you are referring to Microsoft Outlook, then perhaps you can remove the middleman entirely. Microsoft Access has the ability to open Outlook style emails and read the contents. I...
Forum: Queries 07-07-2015, 06:36 AM
Replies: 3
Views: 431
Posted By MSAccessRookie
Re: Function LEFT

Other Functions worthy of consideration are

Right(YourString, 1) will get the last character

Left(Len(YourString) - 1) will get all but the last character

-- Rookie
Forum: Forms 07-02-2015, 12:46 PM
Replies: 3
Views: 402
Posted By MSAccessRookie
Re: IIF Syntax Problem

Unless there is a typing error, I think you might be missing a pair of parentheses (see above). Let us know if that makes any difference.

-- Rookie
Forum: General 07-02-2015, 09:07 AM
Replies: 10
Views: 1,114
Posted By MSAccessRookie
Re: MonthName misspelling "June"?

I see that you are using the Function as MonthName ( MonthNumber ) while the actual Function has two Parameters MonthName ( MonthNumber , [AbbreviateorNot] ). The second Parameter is Optional and...
Forum: The Watercooler 07-02-2015, 05:30 AM
Replies: 4
Views: 597
Posted By MSAccessRookie
Re: A good anime or movie

I am not an Anime Buff, but maybe this link can give you some ideas.

http://www.bing.com/videos/search?q=top+animes+2014&qpvt=top+animes+2014&FORM=VDRE

-- Rookie
Forum: The Watercooler 07-01-2015, 12:53 PM
Replies: 2,998
Views: 580,945
Posted By MSAccessRookie
Re: What's your best/worst joke?

You get 1/2 credit. A quick Google search will show you that it could be 2015, but it also could be 1991. That's what makes it amusing.
Forum: The Watercooler 07-01-2015, 10:59 AM
Replies: 2,998
Views: 580,945
Posted By MSAccessRookie
Re: What's your best/worst joke?

WHAT YEAR IS IT?

A movie about a place called JURASSIC PARK is #1 at the Box office.
A movie about a machine called THE TERMINATOR is set to be released soon.
A New Edition of the FINAL...
Forum: Queries 06-29-2015, 08:57 AM
Replies: 7
Views: 1,074
Posted By MSAccessRookie
Re: Please help with a single T-sql line...

If that does not work, you can also try:
SELECT Sum(CASE [dato]
WHEN null Then 0
WHEN >[Kursadto] Then 0
ELSE
[kapitalnedsettelse]
END)AS kapitalned
Forum: Queries 06-29-2015, 06:40 AM
Replies: 7
Views: 1,074
Posted By MSAccessRookie
Re: Please help with a single T-sql line...

Your MS Access Condition to Test is made up of two Logical results combined with OR. The first is the IsNull, and the second is the IIf(). In the previous response, I addressed the IIf() only,

In...
Forum: Queries 06-29-2015, 06:00 AM
Replies: 7
Views: 1,074
Posted By MSAccessRookie
Re: Please help with a single T-sql line...

In General, The Simplest form of IIf() is similar to what is posted below. A representation for this that is compatible with SQL Server Views or T-SQL follows. Of Course, more complex examples may...
Forum: The Watercooler 06-22-2015, 12:43 PM
Replies: 18
Views: 5,275
Posted By MSAccessRookie
Re: Microsoft has made it so that Windows 8 approved PC can only run Windows 8

I would love to be able to have something like this, but the only Windows 8 PC that I have left crashed with disk errors and I do not have any way to check the disk for reason of failure.

I...
Forum: Introduce Yourself 06-22-2015, 09:25 AM
Replies: 2
Views: 436
Posted By MSAccessRookie
Re: Pleased to join with you

Welcome to the Forum! Feel free to search and Browse the library of existing content to obtain ideas and directions for how you can proceed. If you are not able to find ideas from the experiences...
Forum: Queries 06-22-2015, 08:18 AM
Replies: 8
[SOLVED] Union Query
Views: 1,039
Posted By MSAccessRookie
Re: Union Query

As pbaldy said, because you have used spaces in the name. the reference to your master table needs brackets ( [master estock report] ).

In addition, to prevent any issues regarding Field contents...
Showing results 1 to 25 of 500

 
Forum Jump



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