Search results

Basically, the deisgn of my DB is very simple. 1) A user must first register a course by clicking on the Course button on the switchboard. E.g: Word, power point, Access... . Data are saved into Course table. 2) For a Word class, there can be few start dates. Meaning different starting dates...

Hi all, The duplication of results in the Cost Report only happens when in the Course_Details table, in the Course_ID field, there is two StartDate. Meaning to say, there wouldn't be any problem when generating the cost report when there is only 1 BCF2 in the Course_Details table, with the...

According to http://www.techonthenet.com/access/functions/numeric/round.php It says that the last digit after rounding is always an even number. How can I overcome it. Meaning to say if it's 13.75, it'll round to 13.8, if it's 13.85, it'll round to 13.9? Thx!

Thanks for your reply!

Hi to all, In my report, there is a calculated column called Cost that display as $13.13. The orginal value is 13.125. This column is used to calculate another field called leftover. The expected result is $16.00 - $13.13 = $2.87 The actual result is $16.00 - $13.125 = $2.88. So there is a...

Hi to all, I'm using a Access 2003 form to access a query that'll be used to generate a report. The example I'm following is found in http://office.microsoft.com/en-us/ac...CL100570041033. On my form, I have a combo box (Course ID), textbox (StartDate) and textbox (EndDate). In my query, I'm...

Ok, I have this field in my table called Discount (%). I set it to number field and in the format, I set it to percent. When I enter 50, it automatically converts to 5000.00%. How can I display it as 50%? In the report, I'll be using this field to calculate total. E.g: Total = Orginal Cost *...

Hi, I am using Access 2003. The problem is the password dialog box shows what the user is typing for password. How can I show asterisk when user is typing? Is there a better way to code a password, cos' i'm hardcoding it. strResponse=InputBox("Please enter password", vbYesNoCancel,"Password...

When user click on SAVE button, it will check if there are any existing EmployeeID. If yes, update the gender and address fields. If not, insert as a new record.

Will someone pls reply? This's really urgent! Thx. I have a table called EmployeeDetail. It has a auto number field name called EmployeeAutoNo. For instance, the last EmployeeAutoNo is 3. On my form, I have a textbox field called EmployeeID. When user click on the NEW button, it will take...

Hi all, My form has a SAVE button that will update an record should there be changes to a valid record in table. Everything about the employee can be modify except EmployeeID. This SAVE button should also can insert new record if there are no existing record in the table. 1) How do I check...

Hi DCrake, Thanks for the reply. Yes, that's what I'm precisely what I'm looking for. MaxAutoVal = Max("EmployeeAutoNo", "EmployeeTable")+1 rs(EmployeeID) = "ABC/" & MaxAutoVal & "/" & DatePart("yyyy",Now()) I wanted the max auto number (EmployeeAutoNo) and do some string manipulation and...

Dear all, In my table, I have a field called employeeAutoNo that has Auto Number data type. E.g: 5. I have another field called EmployeeID. E.g.: ABC/5/2008, where 2008 is the year & ABC is a contant. How do I get the get the value from employeeAutoNo and concat with the constant and year...

Problems with combo box Hi, I was following Example 2 in http://www.fontstuff.com/access/acctut10.htm. I have 2 combo boxes, namely cboCountry and cboCity. I have a table (tblAll) with 2 fields, Country and City. For cboCountry, the Row Source property is SELECT DISTINCT tblAll.Country...

Hi all, I've two listboxes. The first listbox contains Roses, lilies, Cactus, etc. When the user select Roses, the second listbox will display Pink roses, red roses, white roses, etc, and not all the other flowers that's in the table. What should I do? I'm using Access 2003. Thanks in advance!