Search results

i rearranged the code as you indicated, but still it is not working :( exactly Port is the name of the field that i am copying from and pasting in the next record. if isnull(port) then rs!port=0 end else port = rs! port end if if isnull (vessel1) then rs!vessel1=0 end else vessel1 = rs...

hi still it is not working, i am missing out a point. can you please check this code underneath..thanks if isnull(port) then rs!port=0 end else port = rs! port end if if isnull (vessel1) then rs!vessel1=0 end else vessel1 = rs! vessel1 end if rs.movenext rs.edit rs!Port= Port rs!Vessel1 =...

Copying Previous data (cloning) hi, thanks for your help, but still it is not working, and i can't figure out where is the mistake. if isnull(port) then rs!port=0 else port = rs! port if isnull (vessel1) then rs!vessel1=0 else vessel1 = rs! vessel1 rs.movenext rs.edit rs!Port= Port...

Hi, i need help regarding copying previous data in a table (as a cloning method). i have a form with continous records. near each record, a button was created that opens in another form which contains various fields. in order to facilitate time, i created a button on the second form to be...

Hi , i need help regarding exporting specific data from a report to spreadsheet.. is it possible to choose which data to export from a report into a spreadsheet document? thanks any help will be much appreciated.

filter list hi thanks for your help.. but the main issue is that i have a whole list of data in a form, which the user will have the possibility to search by for example country, date, order no etc and only that related data is displayed. so i wish to create if it is possible something as...

Hi, i need help regarding filtering a whole form, like the auto-filter used in spreadsheet.. that is i have a continous form with a list of data, and I would like to filter all the list headings so that if the user for example wants to view data only related to a specific country, he/she can...

hi thanks that worked... now if i want to delete the whole record, by creating a delete button, I have to include code as well? as when i created a delete button and tried to delete, it re-appears when the form is refreshed.

Hi, no it is not a sub form on the main form, it is another form on the main form linked by pressing a button..

Hi, i need help regarding linked forms.. i have a combo box in a form, where one has to select a country for example UK is chosen, then there is a button that when clicked it opens in a pop-up form and displays all the information related to UK. so there are two tables : Country (CountryNo ...

Hi all, i need help regarding linking Access to various Word documents.:confused: the task consists in choosing a particular Country, Year and Month from Combo Boxes and then view the related reports in Word. for example : United Kingdom, 2006, January more than one report can be related...

link Access to word documents Hi John, thanks for all your help, your example will definately help me a lot in my work. THANKS ;)

link Access to word documents HI John, I am resending the database with the tables and correct Forms. Now I can manage all the documents (obviously having different names for example H:\Documents\CountryFiles\England.doc or H:\Documents\CountryFiles\Saudi.doc) under the same folder (with the...

link Access to word documents Hi John, can you please take a look at my form named : CountryInfo. where i set a combo box Country. Now when the user chooses for example England and wishes to view the related word document bY clicking on the button LINK TO WORD, it opens that document only...

Hi thanks for your help but I still have a problem cause : the user will be provided by a combo box where he can choose a country from a list of countries. So Word files will be stored according to each country. For example if: England is choosen from the combo box - there is a button that...

Hi all.. I am new to Access and currently implementing a small company database. Is it possible to link Access to Word documents? I wish to create a button on a form that when clicked it opens the word document according to what have been selected in the combo box in the form. thanks :o