99chan

File
Removed

Basic, access, and shame Anonymous 12/11/28(Wed)02:49 No. 367

Hey crew.
I feel really embarrassed to have to ask this, so please don't make me feel any worse.
I had graduated 2 years ago, and haven't programmed since, getting more into the networking and managed services type roles. Today, my manager gave me a 2 minute assignment, that I cannot complete. And am too ashamed to admit it.
Here goes:
Create an access 2003 database with 1 table, two collums. A (primary key) and B.
Create a form, with an input box, button and label that techs can run in a corner of the screen. Then enter a value in the text box, click the button, and if it matches something in Col A, it will spit out it's related value from Column B.

In 30 minutes I got as far as creating the form and table, and on button click, a new variable will be assigned the value from the text box as a string, and the lable caption will change to it.
Whoop-de-fucking-do.

Could someone here, please take the time to help me with this?

Anonymous 12/11/30(Fri)13:16 No. 369

Well i'm sure it's a little late now.

That said; I would use button on-click event macros.
http://www.keystonelearning.com/resources/articles/access_2003_attach_a_macro_to_a_command_button/

When creating macros there are a bunch of drag+drop commands you can call that should be able to do what you want.

Also, don't stress - no real job should contain any trace of fucking Access. Tell your boss to grow a dick and use a real database system.

Anonymous 12/12/02(Sun)06:17 No. 370

>>369
Thanx, I did manage to complete it after all. Took me like 5 business hours.
But we were light on work, and since no one else had a clue how to do this either, no one batted an eyelid.
But yes, I do need a new job.

On a side note, I discovered, that for some reason, running the set focus command, does not trigger the on focus command. Just found that odd.

Name
Subject	(reply to 367)
Message
File
Password	(for post and file deletion)

¯\(°_O)/¯
Supported file types are: BMP, GIF, JPG, PNG Maximum file size allowed is 10000 KB. Images greater than 400x400 pixels will be thumbnailed. Currently 317 unique user posts. View catalog Blotter updated: 2015-09-02 Show/Hide Show All 09/02/15 - New team is here to develop the site and chew bubble gum --- and we're all out of gum