Search results

Hi all, I have created an option group with two buttons (New, Used). The defaultvalue of this option group is being set to nothing being selected(i.e no option is being checked). How do I make sure that the user has to choose either one of these option before he/she is allowed to save the...

is it possible to use vb to write a program to automate task. WHat i mean is how to record the keystroke. Everyday, I've to clean record from Vantive Peoplesoft 8.20 and the steps are repetition. Therefore, I intended to write a program to capture the step(keystroke). However, really have no...

Hi all, I've 10 controls that take accept positive number n must be greater than 0. How do i make sure that the number enter must be greater than 0 immediately after the user enter the value. One of the way is to do the validation in the control (afterupdate event). However, if I was to do...

Hi all, How to open a fresh form without showing the existing records in the DB. I.E I've 5 records in the DB. When I click on the add new form command button Code: DoCmd.GoToRecord , , acNewRec I want to have a fresh piece of form + I dont want the records which is in the DB to be shown...

I have 2 forms Form A and Form B. When I click on the button on Form A, it will show form B Form A has 3 controls 1st Control is txtName 2nd COntrol is txtNric 3rd control is txtDOB Therefore, when I click on the button on FOrm A, the record shown on FOrm B must be associated with...

Hi all, I'm trying to count the number of record tha have start number with 123" Can i program the txtSum as shown below? txtSum.ControlSource = "Select count(*) from Car where "& "Car_number like 123" And suppose 123 is not hard code. I.E number = 123 number =245 etc txtSum.ControlSource =...

Hi all, Dim vAns As Variant vAns = MsgBox("Are you sure you want to delete this record?", vbQuestion + vbYesNo, "Delete") If vAns = vbYes Then DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70...

Hi all, Access has a function that allows us to print the current form that we are viewing. However, is it possible to print the form out without printing out the interface? I add a button on the form, when i click on the button, the function should allow me to print out the current record...

Hi all, Access has a function that allows us to print the current form that we are viewing. However, is it possible to print the form out without printing out the interface? I add a button on the form, when i click on the button, the function should allow me to print out the current record...

Hi all, I intend to populate a combo box with the value from the table. Therefore, under the combo box Row Source I write: SELECT distinct Tasks.Task FROM Tasks ORDER BY Tasks.Task; However, I also want to populate the combo box with additional value that is not found in the table n I dont...

Hi all, If I have 10 records in the DB How to write a prgm to calculate the number of records in the DB? Also, how do i write a prg that will detect the last n first record? I.E When i click on the navigation bar "next record"(I intend to program my own navigation bar) For instance, I'm at...

Hi all, If I have 10 records in the DB How to write a prgm to calculate the number of records in the DB? Also, how do i write a prg that will detect the last n first record? I.E When i click on the navigation bar "next record"(I intend to program my own navigation bar) For instance, I'm at...

Thanks Mark. However, there isnt OnRecordExit event in the form. I'm using access 2k. Is there other event that can achieve the same result? Thank you

Hi all, I've 5 fields in the form. Field1 outstanding amount Field2 current amount Field3 amount to pay Field4 paid amount Field5 Amount Pending Hwever, only field1 is being stored in the table. my question is how do i update field1? i.e outstanding amt: $25 current amt:$37 amt to...

Hi all, i've a field that contains the systemdate n time i.e txtDate.value = Now will give me this 11/30/1899 9:46:00 AM. How do i get rid of the second hands?? i want 11/30/1899 9:46 AM instead. Thank you

Hi people, May I know how to add 2 fields. i.e My table has 3 columns Field1 Field2 Field3 The value of field3 = field2 + field1 (the formate of field1, field2 n field3 are currency) how do I indicate that the value of field3 is depended on the value of field2 n field1 is it under the...

I've design a form as such when i FIRST add a NEW RECORD, I want the system date to be capture into the form. I have a table calls Register. And this table has a field "DATE" which takes the value of the system date(=now). However, when i open the same record the next time, the orginal...

Thank you KenHigg & ghudson

hi to all, does anyone know the code to close the access program. That is when i select the close button on the switchboard, the whole of MS access is closed. Thank

hi to all, does anyone know the code to close the access program. That is when i select the close button on the switchboard, the whole of MS access is closed. Thank