Search results

Hi, I have 2 tables with similar data. However I need to compare this particular field called CompanyName in both tables. Reason being human error/exposition data errors. For example, Chef Kitchen Holdings Limited, in one table it is Chef Kitchen Holdings Ltd while the other table is Chef...

Good day people, I have done up a database for the very purpose of printing a directory listing of all our participating clients. I split up the page into 4 columns and I have 3 categories (1 main and 2 sub). Fairly self explanatory. However I do encounter some formatting problems. 1. I...

Hi, can someone help me out with this? I have 3 tables, namely assignment table, employee table and job table. assignment table contains fields: assignmentID, employeeID, NumHrsAssign, Remarks employee table contains fields: employeeID, firstName, lastName, jobID job table contains fields...

Not sure if I worded my subject correctly. Here's my problem.. I've used query to combine 2 tables of data.. Here are my fields.. I've assignment_num field, project_num field, project_name field, emplyee_name field. here are my data.. assignment_num field: 1001, 1002, 1003, 1004, 1005...

hi, i've a form with 2 combo boxes (month and year) and 2 buttons "save" and "get". I'm trying to figure out how to use that button to perform 4 tasks. task 1: when i select the month and the year from the combo boxes and i click the button "get", the form should populate the number of...

Hi there, I have a question to ask with regards to the mentioned subject. Scenerio: I've a sample database with 3 tables and 2 queries. 3 tables masterlist tbl - contains information of a school of students consisting different grades (primary 1 - 6, secondary 1- 5) grade tbl - I...

Subject: [Access 97] Creating form interface to select fields from a table and Exporting (filtered) data into Excel spreadsheet. Greetings, I will like to consult the experts here on A) how to create a form interface (as shown in the image) for people to select the +fields they want from...

Hi, I've a problem here regarding the use of continuous form and checkboxes. Scenerio: 20 people receiving apples, 10 receiving pears, 20 receiving oranges. So what I want in the form is that I can select the fruit type. Then it will trigger all the people's name in my database with a check...

Hi, Just wondering if someone is kind enough to generate VB codes to validate form. Basically, this is what I need: 1) convert all data in text boxes to uppercase 2) to ensure that users key in all fields. 3) compare the new data with the database date to ensure no duplication, else it...

Hi, is there any way to downgrade my database version using MS Access 2000? I'm currently working a database system for my company. My company computers use Access 97. Many a times, I have to bring my project back home to complete but I realise that I can't open my project using Access 97 in...

Hi guys, pertaining to the earlier post, http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=218772#post218772, i have another few more burning questions which I need help. I have many excel lists to be imported and all these lists are of different headings. So after I import...

Hi guys, I have a problem. My boss has 4 sets of attendance list which uses Excel to tabulate. However, she mentions that the 4 sets of attendance list have duplicate set of values, meaning to say that there could be same names appearing in 2 or more sets of attendance list. Instead of manual...

Q1) How do I do a form validation to make sure that all fields are filled in and I want to display friendly messages to let users know what they have to do? Q2) Is there a faster way to 'empty' the form fields if users decide not to save records? Q3) How do I change the text input into upper...

How do I program the database to generate the data mentioned below. current month/year display as september 2003 0309 October 2003 0310 December 2004 0412 January 2005 0501 the 4 digits are part of the unique...

In conjunction with the earlier post, http://www.access-programmers.co.uk/forums/showthread.php?s=&postid=214253#post214253 I will like to make some clarification. Perhaps, I have misword-ed my problem and would genuinely like to rephrase my problem again. I have 5 options in an option group...

It's me again. I have an option group with 5 options and 5 disable textboxs. If I select any option, the corresponding textbox will be enabled while the rest of the 4 textbox will be disabled. I have a sub procedure to do tt but I find that coding is cumbersome. Anyone has an easier solution...

I have a problem here. Scenario: I have an option groups with 5 option buttons. Some option buttons, upon clicking, will enable the disabled textbox for data entry. However, if say, I click on the first option and I enter data for the 'enabled' textbox but I have a change of mind and I click...