| Author |
Message |
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4004
Location: Walsall, West Mids, UK
|
 MS Access: create macro to enter new record Now I know this question is stupid. I know I've done this umpteen times before for my Dad's company. However, typing in "new record" to google turns up lots of "record macro" results.
Anyway, Long story short, I'm making a database for the company I work for to allow us to log calls. All I want to do is make a nice big button that says "LOG CALL" so that even the moronic middle aged females I'm surrounded by can understand it.
However, When I go to create A macro that simply creates a record, I can't find the flippin' command to do it!
Does anyone know where it is?
_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts
|
| Thu Mar 01, 2007 10:59 am |
 
|
|
|
derf
Minor Diety
Joined: Fri Apr 11, 2003 2:17 pm
Posts: 7721
Location: Centre of the sun
|
No clue. I could probably give you pointer if you are using Oracle Forms, but obviously you're not. Might be better to just use a book to write this stuff for such a simple task.
_________________
"Well a very, very hevate, ah, heavy duh burtation tonight. We had a very derrist derrison, bite, let's go ahead and terrist teysond those fullabit who have the pit." - Serene Branson
|
| Thu Mar 01, 2007 3:04 pm |
|
|
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4004
Location: Walsall, West Mids, UK
|
That's exactly what I'm trying to avoid - people call in. someone writes it down. Book gets misplaced, taken away/whatever.
If it's on a centralised DB then there's none of this bull.
_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts
|
| Fri Mar 02, 2007 2:53 am |
|
|
|
Satis
Felix Rex
Joined: Fri Mar 28, 2003 6:01 pm
Posts: 16662
Location: On a slope
|
well, I hate access. I'd just build a web form using php/c# and write to a database (probably mysql or ms-sql).
_________________
They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.
|
| Fri Mar 02, 2007 6:44 am |
|
|
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4004
Location: Walsall, West Mids, UK
|
I hate access to.
But I can't install PHP on these computers. I can't upload from these computers. I can't garuntee that any website will work on these computers.
All I have is Access. And I guess I should be thankfull for that... I guess.
_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts
|
| Fri Mar 02, 2007 11:01 am |
|
|
|
derf
Minor Diety
Joined: Fri Apr 11, 2003 2:17 pm
Posts: 7721
Location: Centre of the sun
|
If the book leaves the phone-area, then you are working with retards. Lay the smack down on them. I'm sorry, all my studies have told me that these little problems aren't solved by computerising them. A DB is really overkill. You need to switch it on, load it up, find, create, save just to find some notes of a phone conversation belonging to someone in a 10 man outfit.
_________________
"Well a very, very hevate, ah, heavy duh burtation tonight. We had a very derrist derrison, bite, let's go ahead and terrist teysond those fullabit who have the pit." - Serene Branson
|
| Fri Mar 02, 2007 11:22 am |
|
|
|
Satis
Felix Rex
Joined: Fri Mar 28, 2003 6:01 pm
Posts: 16662
Location: On a slope
|
meh, I'm not quite on the boat with Derf. I think computerization would help... when you log it to a central db, you can do all kinds of fun stuff with the data. Like smack down the bish that never records any calls or keeps punting people.
But I don't know the answer to your dilemma, sorry.
_________________
They who can give up essential liberty to obtain a little temporary safety, deserve neither liberty nor safety.
|
| Fri Mar 02, 2007 6:54 pm |
|
|
|
Mole
Minor Diety
Joined: Fri Apr 11, 2003 5:09 pm
Posts: 4004
Location: Walsall, West Mids, UK
|
Agreed Satis.
Plus, Imagine that some dude calls up about a call that was placed months ago. Why page through a book when I can type in the date?
_________________
Games to complete:
GTA IV [100%] (For Multiplayer next!)
Fallout 3 [50%]
Rock Band [35%]
http://www.cafepress.com/SmeepProducts
|
| Sat Mar 03, 2007 8:36 am |
|
|
