Search results

Hi friends, I really like this forum. I found right answers each time I posted. Thanks for all your help so far. I appreciated that. I have another question: I created a table like this: TableA id student class -- ------- ---- 1 john his 2 ray eco 3 lisa his TableB Class Stu_id Name...

Hi friends, Thanks for all your help so far. I appreciated that. I have another question: I created a table like this: TableA id student class -- ------- ---- 1 john his 2 ray eco 3 lisa his TableB StuName Address phone -------- ------- -----...

Hello friends, Can any 1 please show me how to print a current record from form? I tried to create a Print button, but when I click on it, it just print all the records. Please help. Jenny.

Hello friends, I have a form with 4 buttons. 1st one is called baseball, 2nd is soccer, and etc.... this is the main form, when you open each button, it shows its own form. Right now, I am trying to create shortcut for each button on specified desktop. For example, Baseball button is at Desktop...

Query, Form HELP PLEASE. I have a table with 2 fields, baseball and soccer. I created a form that has 2 buttons, Baseball and Soccer. Then, If I click on Baseball button, then I'll see all baseball records. How do I do this? Please help. Thanks. Jenny.

Current DATE in Forms HELP PLEASE I have a table with 4 fields, Baseball, Baseball_Date, Soccer, Soccer_date. I create a form with 2 checkboxes, one for baseball and one for soccer. When I click on Baseball, and click on Save. Then, a checkmark is stored at the Baseball fieldname of the table...

Protect some fields from editing HELP PLEASE. I have a front-end form and back-end form from just ONE table. Front end form is for data entry. Back-end form is for Admin to use to approve or not approve. When I open back-end form, it list all data from front-end form and some empty field names...

Email current record as a Word doc or Report PLEASE HELP Hello guys, First of all, I'd like to thank you for all of your help so far.... I 've been trying to create a Review Data Form that lists all records from a table. If a record was emailed already, then it shows "Already sent", if a record...

MS ACCESS: AUTOMATIC NUMBER field help please! MS ACCESS: AUTOMATIC NUMBER field help please! HELLO FRIENDS, I created an AUTOMATIC FIELD and the format I want it generate automatically is like: TRAN MALE 01 TRAN FEMALE 02 TRAN LESBIAN 03 TRAN GAY 04 TRAN MALE 05 TRAN MALE 06 IS THERE ANY WAY...

MS Access - Option Group CHECK BOX HELP PLEASE. MS Access - Option Group CHECK BOX HELP PLEASE. My name is Jenny. I could not figure out how to do this, so please help me to figure it out. I created an Option Group with 4 check boxes, 1st Checkbox is "All", 2nd is "Baseball", 3rd is "Soccer"...

MS Access Query HELP PLEASE Hello, I am newbie in ms access, please help me. I have this table: Employee_Type Salary ------------ ------ Designer 35k Developer 40k Accountant 25k Designer 30k Designer 29k Developer 30k Accountant 22k How do I...

Hello friends, I created a form with AUTONUMBER for the first field. Every time user start filling out the 2nd field, the 1st field (autonumber) automatically increase by 1. However, when user fill out from 2nd field, but not saved yet, then close out the form, the number still increases and...

HEllo friends, I have this question: I have a data entry form. How do I protect users from skipping fields on the forms? I mean, how do I make sure that a certain field must be filled by user? (required field). I am new wit ms access, please help. Example: I have 3 fields on a form, student-id...

Access generated reports help Hello friends, Thank you for reading my message. I am trying to generate a report in Access 2002 but I am stuck in this one. Please help me to figure out. I have a data entry form, every time a user submit a form, then data is stored in a table. This table...

Hello, Thanks for reading my message. I have one question about ms access forms: I have 2 tables, 1. Student table has some fields like: stuID, stuAddress 2. REgister table has fields: stuID, stuAddress, claName, room I want to create a form based on these tables, so that every time users...

Hello guys, Please help me to setup security in ms access tables. For example, how to add users in db, how to set a specific user to view this table ONLY, ... Thanks.

How to get a notification message thru email when users submit a form? I mean, when users submit a form, a new record is stored on the table. I want to get a notification message on MS Outlook whenever users submit a form successfully? Thanks. Jenny.

How to get a notification message thru email when users submit a form? I mean, when users submit a form, a new record is stored on the table. I want to get a notification message on MS Outlook whenever users submit a form successfully? Thanks. Jenny.