Members Login
Username 
 
Password 
    Remember Me  
Post Info TOPIC: Access *Genious*


Proud House-Owner




Status: Offline
Posts: 1139
Date: Jun 30, 2004
Access *Genious*


For weeks now I've been entering clients into a database I've (partially) built and couldnt figure out why the client name wouldnt copy from the main form to the subform since that was the field the two forms were linked on. So every day I type in all the other information, then go to the table and put the ClientID# in the blank field... very frustrating!


So today I decided to take another look at the subform and it turns out that in my infinite wisdom, the drop down menu on the subform was set to unbound and had no control source. Hard to make two fields equal if the second field doesn't know what the first one is supposed to be..


I think someone needs to take away my right to build any more databases... cuz that was just silly of me


 



__________________


I am the Jammie King!




Status: Offline
Posts: 12736
Date: Jun 30, 2004

I should think so to. 


I, myself have decided to give up building databases on the basis that they're bad for my health.


I get far too many requests to build the things with no requirements to work from at all:  "Oh, we'd like and 'Intelligence' database please.  To hold... you know, Intelligence."


Won't have to be too big then!



__________________
The King has spoken... But nobody listened.


Proud House-Owner




Status: Offline
Posts: 1139
Date: Jun 30, 2004

I understand... I once quit a job at a mortgage company because I was convinced the mortgage industry was fattening

__________________
Joe


Ah Pity Da Foo!

Status: Offline
Posts: 602
Date: Jun 30, 2004

I wish i could give up databases for a while - the change would do me good - too much vb has given me a sore head - im off for a cuppa and a biscuit

__________________
What was i doing before i came here again?


Vice JDK
and Man of the People





Status: Offline
Posts: 5453
Date: Jun 30, 2004





Psst, I hate Access!

__________________
You can't polish a turd


I am the Jammie King!




Status: Offline
Posts: 12736
Date: Jun 30, 2004

Did you see that, did you?  Joe ran so fast, headlong into that cup of coffee that he vaporised on impact.


Ahh, Joe   you will be missed.



__________________
The King has spoken... But nobody listened.


Tickle me, Elmo!

I'm Roger Moore's Stunt Double!



Status: Offline
Posts: 4936
Date: Jun 30, 2004

And not even a ripple on the surface of the coffee...

__________________
Don't you just love it?


"I'm Lois!"


Status: Offline
Posts: 4979
Date: Jun 30, 2004

I've been tasked with building a database that "Predicts Risks" - the ones we dont know about yet or havent had before.... based on what? how much they havent had before?

Who knows - anywho I agree with Nate (as always) it does indeed suck a bit.......

But when you're boss knows nothing about Access you can always throw something together in a couple of hours and say it took days - which is why I spend my time tutting and frowning when on the Bored Board!!!!!

__________________

I'll take arrogance and the inevitable hubris over self-doubt and lack of confidence.

"Everyone has a plan, until they get punched in the face" - Mike Tyson



I am the Jammie King!




Status: Offline
Posts: 12736
Date: Jun 30, 2004

Oh, you do that too?

__________________
The King has spoken... But nobody listened.


Proud House-Owner




Status: Offline
Posts: 1139
Date: Jun 30, 2004


usually i just leave an impressive looking table open on my task bar (something with a lot of information).. then when i hear my boss about to walk by, i pull up the table and stare at it puzzled. Really, I bet he never knew names and phone numbers were so confusing!



__________________


Tickle me, Elmo!

I'm Roger Moore's Stunt Double!



Status: Offline
Posts: 4936
Date: Jun 30, 2004

Hahaha.  I'll keep that on up my sleeve for desperate times.

__________________
Don't you just love it?


"I'm Lois!"


Status: Offline
Posts: 4979
Date: Jul 1, 2004

Bosses are great - 99.6% of the time they have to hire us to do things that they CANT which makes life a lot easier - because.....


They dont know how long it will take


They dont know that we dont really need FULL internet access to do it -


They dont know that I dont need to take long lunches to chat problems over with other Access experts


They dont know that I have probably got a database somewhere from one of my last jobs that I can just re-badge to use !!!!!



__________________

I'll take arrogance and the inevitable hubris over self-doubt and lack of confidence.

"Everyone has a plan, until they get punched in the face" - Mike Tyson

Joe


Ah Pity Da Foo!

Status: Offline
Posts: 602
Date: Jul 1, 2004

quote:

Originally posted by: Andromeda

" usually i just leave an impressive looking table open on my task bar (something with a lot of information).. then when i hear my boss about to walk by, i pull up the table and stare at it puzzled."

Hehe, i do this but i just keep the code window in the task bar, cuz my boss knows a little about access - enuff to be dangerous (typing that word made me think of Dangeresque)

__________________
What was i doing before i came here again?


I am the Jammie King!




Status: Offline
Posts: 12736
Date: Jul 1, 2004

Haven't looked at homestarrunner for ages!  I shall have to pay a visit this evening!

__________________
The King has spoken... But nobody listened.


Baaaaa.
No, really - Just Baaaaa.


Status: Offline
Posts: 1561
Date: Jul 1, 2004

quote:

Originally posted by: Joe

"Hehe, i do this but i just keep the code window in the task bar, cuz my boss knows a little about access - enuff to be dangerous (typing that word made me think of Dangeresque) "

I do the same - always keep a code window on the task bar!!

__________________
Argh Snake.


Vice JDK
and Man of the People





Status: Offline
Posts: 5453
Date: Jul 1, 2004

Yep, the VBE's always ready to go here. Freaks my boss right out whenever he sees it!

__________________
You can't polish a turd


Cpt Acorn Short of An Oaktree


Status: Offline
Posts: 2225
Date: Jul 1, 2004

To be on the safe side I have been known to set some code running & be stepping through it specially for my boss

__________________
Razzlesnarglezzvrmptzz


Vice JDK
and Man of the People





Status: Offline
Posts: 5453
Date: Jul 1, 2004





__________________
You can't polish a turd


Proud House-Owner




Status: Offline
Posts: 1139
Date: Jul 1, 2004

Step through code? Too much effort


Of course, there's always this



__________________


Vice JDK
and Man of the People





Status: Offline
Posts: 5453
Date: Jul 1, 2004

I have seen this, think I had at one point... I might need to reaquire it!

__________________
You can't polish a turd
Joe


Ah Pity Da Foo!

Status: Offline
Posts: 602
Date: Jul 2, 2004

boo, blocked by dopey hpss firewall

__________________
What was i doing before i came here again?


"I'm Lois!"


Status: Offline
Posts: 4979
Date: Jul 2, 2004

quote:

Originally posted by: Andromeda

"Step through code? Too much effort Of course, there's always this"


This is possibly the greatest thing ever invented - with the exception of


Pants


Toast


Deodrant


MP3


That silver trail that snails leave.... its like jewels and stuff



__________________

I'll take arrogance and the inevitable hubris over self-doubt and lack of confidence.

"Everyone has a plan, until they get punched in the face" - Mike Tyson



I am the Jammie King!




Status: Offline
Posts: 12736
Date: Jul 2, 2004

Not bad.


What I really need, though is something that looks like the blue screen of death followed by a really slow restart on demand!



__________________
The King has spoken... But nobody listened.


"I'm Lois!"


Status: Offline
Posts: 4979
Date: Jul 2, 2004

Just install Windows ME on a separate partition....... boot up from that - it'll provide the Blue Screen and re-boots with startling regularity........


 


Windows ME..... loads of old poo.......



__________________

I'll take arrogance and the inevitable hubris over self-doubt and lack of confidence.

"Everyone has a plan, until they get punched in the face" - Mike Tyson

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Post to Digg Post to Del.icio.us


Create your own FREE Forum
Report Abuse
Powered by ActiveBoard