Search results

this is my date validation code for "get" button Dim strDate As String Dim RetDate As String 'act as buffer strDate = "01/" & Me.ComboMonth & "/" & Me.ComboYear 'to capture the date =================== As for my "save" button it should perform 'multiple' add record function...

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

Error Hi, apparently your 97 version has some coding problem which I don't know how to rectify. Help me pls. :~~~~( I'm on the verge of breakdown

Do you have 97 version for your posted database? I'm using Win XP with Access 97. Sorry about that.

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

Many thanks. How do I use the Ucase()? WHere do I place the code? Afterupdate of each textbox?

I'm using Access 97 in Win XP env.. Please give me Access 97 compliant VB codes. Million thanks

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

Please help meeeeeeeeeeeeeeeeeeeeeeeee...............

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

The available version I have for Access is 97. Please do not ask me /my boss to upgrade the software. Hee

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

I lump them up together because I don't want to flood the forum. Maybe you can state the problem number then the solution. Thanks alot. Need the answers urgently

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

ABC would refer to the company initial which is fixed anyway. Does not have to be stored in the field because I can just use labelling in my report. 0309 is of course yymm 00x is the running number. Anyway, how do I merge the YYMM and the 00x together as one data to be stored in the unique...

How to show it and how to store it? I dont want users to meddle around with the fields. The values should be generated by the computer itself. Example, if the system time is september 2003, upon opening the form, the unique id should show me ABC-0309-00x. x denotes the running number...

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