Question about Microsoft Office Access 2003 (077-02871) for PC

1 Answer

Access 2003 HELP PLEASE!

I am an expert user of Access but very green when it comes to code. I have a problem with a canteen databse I am designing. In short, each employee is listed in tblEmployees - they have a field (among others) for Username and Lunch Password and Visitor Allowed (some employees are allowed to order lunch for guests on the company account - I have made this a yes/no data type). I have created a parameter query as the source for the lunch order from so it that triggers the employee to enter their username and password. The subform contains the lunch order fields from tblLunchOrders. The problem is that - when this form is accessed from the switchboard - I need it to do 2 things...

  1. Check that they have entered a password that is on the list - If not it should bring up a message and not open the form. I tried adding this code to the main forms "On Load" property...
Private Sub Form_Load()
If IsNull(Lunch_Password) Then
MsgBox ("Incorrect User Name or Password. Please try again.")
On Error GoTo Err_Command67_Click


DoCmd.Close

Exit_Command67_Click:
Exit Sub

Err_Command67_Click:
MsgBox Err.Description
Resume Exit_Command67_Click
End If
End Sub

  1. If the password is correct they might still not be authorised to order lunch for a guest so after checking the password it needs to check and see if the 'Visitor Allowed' field is switched on - if it is... it must open the form... if not it must bring up a msg and not open the form. I tried adding the following code in conjunction with the above on the main form (it didn't work) so I tried adding the code to the "On Load" property of the subform...
Private Sub Form_Load()
If Visitor_Allowed = 0 Then
MsgBox ("You are not authorised to order lunch for a visitor. Please contact accounts if you have any queries.")
End If
End Sub

Any suggestions. This database needs to go live tomorrow morning! It's now 8:30pm in SA. I am desperate and feeling very blonde and out of my depth. Would really appreciate the correct code. Many thank for reading this. Sharon King.

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Legend:

    An expert who has written 200 answers of more than 400 characters.

  • Expert
  • 359 Answers

Sharon King:

Did you get this problem solved? I realize it is quite old, but I am willing to help if it is not solved. If it is, I would be interested to know what happened...

smartsolve

Posted on May 05, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Need radio code for ford fiesta serial no m112810


I am sorry we do not have access to the factory databse. You need to see the dealer on this.

Nov 01, 2012 | Ford Fiesta Cars & Trucks

1 Answer

Just put new batterys in safe . but safe will not stop bleeping what is the problem


Please follow these steps
Programming a user code
There are two ways to program a user code.
A 1. Press the Program key.
2. Enter the Factory Code. The green LED remains ON
while you enter the 5-digit user code of your choice.
After 5 digits are entered the green LED turns OFF.
(To enter a new User Code, repeat these steps.)
B 1. Press the red button inside the safe. The lock will
beep and the green LED will come on.
2. Enter a 5-digit user code.
(To enter a new User Code, repeat these steps.)
Keep your new user code secure.
For your records, please copy it here:
____ ____ ____ ____ ____
Programming a password
1. Press the Program key.
2. Press it a second time.
3. Enter your 5-digit User Code. The green LED remains ON.
4. Enter the 5-digit Password of your choice (any combination
except 00000.) After 5 digits are entered, the green LED
turns OFF.
(To enter a new Password, repeat these steps. To erase the
Password, press Program twice, enter your User Code and then
enter 00000.)

Battery replacement
Below When old batteries are removed for replacement, your Password will be voided; only Factory and User Codes will work. To
reestablish your Password, follow the directions above under
Programming a Password.
Key override
If your electronic lock fails or you do not have any codes
available, you may use a key override to access this unit.
1. Remove the battery cover, disconnect and remove the
battery holder.
2. Insert the skeleton key (second set of keys provided)
into the key hole inside the opening for the battery.
3. Turn the key to the right.
4. Turn the four bit key to the right.
5. Open the door.
Signals
Your electronic-lock safe communicates by means of several
audio/visual signals.
Red (Error) LED + three beeps indicates
one of the following:
1. You have pressed Program key out of sequence
2. You have entered an invalid code or password.
3. You have let 5 seconds or more elapse between key entries.
Green (Proceed) LED + single beep occurs
1. After entering each digit of Factory or User Code, or
Password
2. After pressing Clear key
3. After pressing Program key
Green LED only
1. Comes on after you enter a valid code/password and
remains lit during the 4-second period in which the safe
can be opened.
2. Comes ON in the Program User Code mode after you enter
the Factory Code and remains lit until you have finished
entering a 5-digit User Code.
3. Comes ON in the Program Password mode after you have
entered your User Code and remains ON until you have
entered a 5-digit password.
Yellow LED
Indicates low battery and will typically not turn ON until
battery has been in use approximately two years or longer.
Your electronic lock automatically performs a low battery test
during each lock use.
If a �low battery� condition is detected the Yellow LED will
come ON and remain ON during each subsequent lock
operation. (The lock will continue to function in a Low Battery
state, until battery failure.) The Yellow LED will turn OFF only
after three consecutive Good Battery readings or after the low
batteries are replaced. (Note: If the new batteries are installed
in less than 60 seconds the Yellow LED may come ON and stay
ON during the first lock operation before it returns to OFF.)
NOTE: It is recommended you replace the batteries after two
years, or when the yellow LED remains on.

Jan 09, 2011 | Safe International Electronic Digital Safe...

1 Answer

PLEASE HELP ME, I FORGOT MY LOCK CODE FOR N73 HERE MY IMEI


turn off your phone.when you switch it on hold the *,green and 3 button simultaneously .remember *(star),green and 3 button. hold these three buttons and switch on your handset, it will be formatted without the lock code option.your lock code will turn to default.
good luck

Oct 08, 2009 | Nokia N73 Cellular Phone

2 Answers

I want source code for canteen management system in C++ or VB.


The Canteen Management System is owned by Exultsoft Technologies Pvt.Ltd. www.exultsoft.com

I suggest you contact them directly regarding their source code.

Mar 01, 2009 | Computers & Internet

1 Answer

I want connet foxpro databse to visiual basic


Using a DSN-less connection to open a free table
'
cn.Connect = "SourceType=DBF;" _
& "SourceDB=C:\Vfp\Samples\Data;" _
& "Driver={Microsoft Visual FoxPro Driver}"

Jan 20, 2009 | Computers & Internet

1 Answer

Connectivity


CREATE TABLE users (ID MEDIUMINT NOT NULL AUTO_INCREMENT PRIMARY KEY, username VARCHAR(60), password VARCHAR(60


Registration


<?php
// Connects to your Database
mysql_connect("your.hostaddress.com", "username", "password") or die(mysql_error());
mysql_select_db("Database_Name") or die(mysql_error());

//This code runs if the form has been submitted
if (isset($_POST['submit'])) {

//This makes sure they did not leave any fields blank
if (!$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] ) {
die('You did not complete all of the required fields');
}

// checks if the username is in use
if (!get_magic_quotes_gpc()) {
$_POST['username'] = addslashes($_POST['username']);
}
$usercheck = $_POST['username'];
$check = mysql_query("SELECT username FROM users WHERE username = '$usercheck'")
or die(mysql_error());
$check2 = mysql_num_rows($check);

//if the name exists it gives an error
if ($check2 != 0) {
die('Sorry, the username '.$_POST['username'].' is already in use.');
}

// this makes sure both passwords entered match
if ($_POST['pass'] != $_POST['pass2']) {
die('Your passwords did not match.');
}

// here we encrypt the password and add slashes if needed
$_POST['pass'] = md5($_POST['pass']);
if (!get_magic_quotes_gpc()) {
$_POST['pass'] = addslashes($_POST['pass']);
$_POST['username'] = addslashes($_POST['username']);
}

// now we insert it into the database
$insert = "INSERT INTO users (username, password)
VALUES ('".$_POST['username']."', '".$_POST['pass']."')";
$add_member = mysql_query($insert);
?>

Sep 14, 2007 | Macromedia Dreamweaver MX 2004

Not finding what you are looking for?
Microsoft Office Access 2003 (077-02871) for PC Logo

269 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18357 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...