A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 1.10 seconds.
Search: Posts made by: MikeR
Forum: Database Design May 31st, 2010, 01:45 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 1,946
Posted By MikeR
Thanks

trip_to_tokyo wrote:
Mike, no need to miss it.

To the best of my knowledge things are just moving to he-

http://social.answers.microsoft.com/Forums/en-US/addbuz/threads



...
Forum: Database Design May 30th, 2010, 12:38 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 1,946
Posted By MikeR
Thanks

Thanks to all those who contributed their time and knowledge is such an unselfish
manner. I'm really going to miss my daily read here.

Mike
Forum: General Discussion May 30th, 2010, 12:38 PM Posted to microsoft.public.access
Replies: 0
Views: 230
Posted By MikeR
Thanks!

Thanks to all those who contributed their time and knowledge is such an unselfish
manner. I'm really going to miss my daily read here.

Mike
Forum: Database Design May 8th, 2010, 10:32 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 4
Views: 424
Posted By MikeR
Microsoft Responds to the Evolution of Online Communities

Fred wrote:
Typical Microsoft - if it works, mess it up.

I'm hoping this will let me read the forums as if they were still NNTP.
https://connect.microsoft.com/MicrosoftForums?wa=wsignin1.0

Mike
Forum: General Discussion May 8th, 2010, 10:28 AM Posted to microsoft.public.access
Replies: 5
Views: 106
Posted By MikeR
Web Interface to this Forum

I'm hoping this https://connect.microsoft.com/MicrosoftForums?wa=wsignin1.0 will
allow me to continue too use my newsreader. I hate the online forum format. I can't
believe MS thinks maintaining...
Forum: General Discussion May 6th, 2010, 12:32 PM Posted to microsoft.public.access
Replies: 4
Views: 101
Posted By MikeR
Access 2007 w/VBA

Jeff Boyce wrote:
AHA!

Note to self (and any others interested): If I use a "Subject:" for a new
post, and that subject is identical to a "Subject:" already used by another
poster, the...
Forum: General Discussion May 5th, 2010, 03:07 PM Posted to microsoft.public.access
Replies: 2
Views: 137
Posted By MikeR
How do I get the date to display a Julian date? (yyddd)

Jacobs33Ladder wrote:
I am trying to get the date to show up as a Julian date, yyddd. In my form
and report I need to have both regular ddmmyyyy and yyddd fields. they are
the same day so...
Forum: General Discussion May 5th, 2010, 03:04 PM Posted to microsoft.public.access
Replies: 3
Views: 101
Posted By MikeR
Microsoft Responds to the Evolution of Online Communities

wrote:
Date 5/4/2010
Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...
Forum: General Discussion April 27th, 2010, 12:36 PM Posted to microsoft.public.access
Replies: 4
Views: 104
Posted By MikeR
Select query help

John W. Vinson wrote:
On Mon, 26 Apr 2010 16:32:30 -0400, MikeR wrote:


Thanks, John.

After playing with your SQL, it's not quite what I want. I think I...
Forum: General Discussion April 26th, 2010, 09:32 PM Posted to microsoft.public.access
Replies: 4
Views: 104
Posted By MikeR
Select query help

John W. Vinson wrote:
On Sun, 25 Apr 2010 22:50:01 -0400, MikeR wrote:

I have tblLog. It's fields a
Call: text
Freq: single
Mode: text
CID: text
...
Forum: Database Design April 26th, 2010, 02:53 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 18
Views: 656
Posted By MikeR
Who is This STEVE... ? Does he really help.. Others

PieterLinden via AccessMonster.com wrote:
Ahmed, John Vinson routinely violates these rules. He routinely violates the
principles for what MVP stands for. Ignore him!

Hmm... he does this,...
Forum: General Discussion April 26th, 2010, 03:50 AM Posted to microsoft.public.access
Replies: 4
Views: 104
Posted By MikeR
Select query help

I have tblLog. It's fields a
Call: text
Freq: single
Mode: text
CID: text
QSL_R: text
Credited: T/F

I need the SQL to return all records where 'Credited' is false, 'QSL_R' NULL or
blank, and...
Forum: Database Design March 25th, 2010, 02:38 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 5
Views: 662
Posted By MikeR
Database Runtime Question

MFulton via AccessMonster.com wrote:
So basically once the runtime is installed, runtime users will have access to
any changes made to the actual database as they are made. For example, lets
...
Forum: General Discussion March 8th, 2010, 01:32 PM Posted to microsoft.public.access
Replies: 6
Views: 167
Posted By MikeR
Create a button to find the next record

There's a built-in button for that. Hint: It probably has the word "Spell" somewhere
on it............. ;-o

Mike

John... Visio MVP wrote:
Please stevie, learn how to spell. When you are trying...
Forum: General Discussion March 8th, 2010, 01:28 PM Posted to microsoft.public.access,microsoft.public.access.3rdpartyusrgrp,microsoft.public.access.activexcontrol,microsoft.public.access.commandbarsui
Replies: 6
Views: 98
Posted By MikeR
password and user name

david wrote:
i have set this sysstem informer last year and forgot all about it, now
i cant remember password and user name, help?

Google Recover password

Mike
Forum: General Discussion March 1st, 2010, 01:28 PM Posted to microsoft.public.access
Replies: 6
Views: 115
Posted By MikeR
SQL syntax help please

Sue wrote:
Hi all

I had an update sql statement working setting a value to true (boolean
field) on a set condition, but I am now trying to update a 2nd field also
which is text type and...
Forum: General Discussion January 27th, 2010, 12:53 PM Posted to microsoft.public.access
Replies: 5
Views: 75
Posted By MikeR
Select query not being saved

Daryl S wrote:
Mike -

Yes, ascending is the default for ORDER BY, so it is not necessary in the
statement.

Thanks Daryl.

rant on
For documentation/clarity of intention purposes, it...
Forum: General Discussion January 27th, 2010, 12:48 PM Posted to microsoft.public.access
Replies: 5
Views: 75
Posted By MikeR
Select query not being saved

John Spencer wrote:
That is the reason that Access removes it. I would like to see it
retained if it is entered, but that is very minor to the rest of what I
would like Access to allow in...
Forum: General Discussion January 26th, 2010, 03:58 AM Posted to microsoft.public.access
Replies: 5
Views: 75
Posted By MikeR
Select query not being saved

MikeR wrote:
In Access 2000, if I build the following SQL, it runs (from the query
builder) and gives the expected results.

When I save the query, Access deletes the ASC part.

How can...
Forum: General Discussion January 26th, 2010, 03:54 AM Posted to microsoft.public.access
Replies: 5
Views: 75
Posted By MikeR
Select query not being saved

In Access 2000, if I build the following SQL, it runs (from the query builder) and
gives the expected results.

When I save the query, Access deletes the ASC part.

How can I have it saved?

Thanks,...
Forum: General Discussion January 17th, 2010, 01:54 PM Posted to microsoft.public.access
Replies: 7
Views: 115
Posted By MikeR
Clarifications for a Newbie on your Site

Gil, in addition to what Tom said, I'd suggest you use a newsreader to interact with
the groups, rather than the (to me) horrible web interface. Outlook Express,
Thunderbird, Xananews to name a...
Forum: General Discussion January 8th, 2010, 02:43 PM Posted to microsoft.public.access
Replies: 3
Views: 106
Posted By MikeR
SQL help

Dirk Goldgar wrote:
"MikeR" wrote in message
...
For my Jet database I have a query that almost works, but I can't get
the...
Forum: General Discussion January 8th, 2010, 05:36 AM Posted to microsoft.public.access
Replies: 3
Views: 106
Posted By MikeR
SQL help

Dirk Goldgar wrote:
"MikeR" wrote in message
...
For my Jet database I have a query that almost works, but I can't get
the...
Forum: General Discussion January 8th, 2010, 12:35 AM Posted to microsoft.public.access
Replies: 3
Views: 106
Posted By MikeR
SQL help

For my Jet database I have a query that almost works, but I can't get the last piece
right.

SELECT C_List.CID, C_List.LName FROM (C_List LEFT JOIN Alias ON C_List.CID =
Alias.CID) LEFT JOIN AWARD...
Forum: Database Design December 28th, 2009, 02:18 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 137
Posted By MikeR
auto number

brian duffy wrote:
hi all !!

i need to have an auto number in a new table but i need the auto
number to start from a certain number not zero.
how can i do this ??? any help would be...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 05:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.