Search results

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.

Thanks. It worked. 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...

wOH, THAT IS SIMPLE. BUT I COULD NOT FIGURE IT OUT. THANKS ALOT. JENNY.

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...

Can you please show me in details how to show the current row in report? And, please show me in details. Thanks.

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...

Well, that gave me a hint but I am too newbie in access. I am creating a form with 1st field called TRACKING #, with AUTOMACTIC VALUE. Where do I add yours from my db? I mean, from Table or Form, and Where on Form or Table? I tried to add right at the Format for Table, and Default for Form...

big thanks Thanks, guys. It worked fine now.... I appreciated your help. Big thanks.... Jenny.

hello I am sorry for duplicate posts, but that was accidentally posted. I clicked submit 3 times 'cause I din't know it went thru at 1st. Sorry for that. Please help.

Automatic Number Actually, that is not my question. My question is: I am creating a form for question and answer tracking system. One question may have multiple answers. How do I generate an AUTOMATIC field that include the question and answers together? For Ex: Q300-001, Q300-002, Q400-001...

Woh, goodie..... Woh, it worked.... WOH WOH WOH.... I like the way you showed me. It was in detailed. However, It didn't store the value in table. I tried to modify from control source, but it didn't work. Thanks.

Newbie in MS Access I will follow your idea by deleting... I think using Case statement is logical in this case. But I don't know how to do this? can you please provide me the code? I am newbie in MS Access, please help. Thanks.

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...

It doesn't work I tried both the lost focus and before update event, it shows an error. My field is not text box, but a combo boxes. Does it make a difference? Thanks.

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...