Search results

Oh yeah, that works brilliantly Thanks for that

Hello everyone I am just trying to write a query by a code of table i would like to pick up any record with id number betwee 1-99 and 200-299 i try typing them in manually but access wouldn't cope any idea of how i can achieve it please Many Many Thanks Si

Hi everyone I have a part of the form with the following fields Title Name Address1 Address2 Area ... Address2(street) field is a drop downbox, once selected the area text field will be automatically shown what I got in AfterUpdate event on Street is as below Me.txtArea =...

I can't open the file as I am using 97 unfortunately, Any how can I get this done on Access 97?

Version What version is this access file please? Si

Hey there there is a function that I wanted to do on my form but can't think of a way what I want to do is to show up a flag after 14 days and 28 days of a date with missed appointment being ticked say there are two fields in the section AppointmentDate Missed Will I be able to do this in...

what version of access is this please

done it!! Cheers Si

Thanks One more thing if you still there, can I add value from 2 subforms together please!

Thanks very much it work out well Cheers Si

Hi everyone, I am having a bit of problem here, I have a sub form which listed all the calculated equipment cost For this I created a query to sum up all the cost field in the sub form I want to show the sum of those field on the Main form? As the control source of the main form is a table...

Thanks Thanks it work out well Cheers You save my life Si

No Hi There No the spending aint from other calculation its inputed by a person thanks Si

Yes Yes Spending is a text field I Just want to update the last two digit to 00 rather than other random number! Thanks Si

Happy New Year Everybody Can Anyone help me with this please I have a Employee Table with the following columns EmpID Name Address Telephone PostCode Spending What I want to do is to update the spending column, for eg. I have the following data in spending 1233 1555 1665 I want to set the...

Happy New Year Everybody Can Anyone help me with this please I have a Employee Table with the following columns EmpID Name Address Telephone PostCode Spending What I want to do is to update the spending column, for eg. I have the following data in spending 1233 1555 1665 I want to set the...

Thanks Cheers Mate it work out great!!

I am having a large table like below Employee_Record Log FirstName Surname Gender DOB LogIntoBuilding LogOutBuilding What I want to do is to creat a Employee table like below ID FirstName Surname Gender DOB which will be separated out from Employee_Record table while automatically creating a...