Search results

thank you all , i will try a sub report

the report is taken from subform

hi all can you help me please , i have a report that shows many rows, on each row is a column showing the name of the person who signed it , and a column showing the persons signature (a png photo) , this can be signed by more then one person so i want to look at the row with the name of the...

hi all, and thank you for your input, i have tried a query update and this works fine as well ,

just thinking aloud

would an update query be better for this?

hi pat , i have changed the name of the field to " twelve month update"

there are a lot more fields on the subform, not just those two i have mentioned, but they are the only two i want to work with, the table is called "subform"

the fields in the table are [date](this is a date field) and [status] this field shows "active" or "expired"

hello cheekybuddha , can you show me how to do this please?

stopped working now?

how do i do this?

thank you arnelgp it works :)

can you help me please , i have a subform with two columns , one called [date] and another called [status], what i am trying to achieve is that if the [date] value in a row is <= todays date then the value in [status] will change to " expired", can you show me how i can do this please?

hi all, is it possible to create an excel template and use it when exporting a table using the external data, export to excel option? if so how?

hi theDBguy, thank you for your quick response , the report is on a form and is quite easy to open it just " open form2.show" you can put code on the onload, but i do not know how to go about this, if this was access it would be quite easy to to a open where clause , but i don't know if this...

hello can you help please , i have a form (frm1) with a button to open a crystal report to show all the data in a database what i am trying to do is get the report only to show the row of data on the (frm1), i have the button working and it opens the report but it is showing all data rows...

thank you all for your advice, I will try it without the unique id first:)

hello The_Doc_Man, what i am trying to acheive is this, in an existing datbasethaty we are using in work, one of our team is using an excel spreadsheet, he likes the way we do searches in the database and has asked can we link his sheet to it (this i have done) but i need place a primary id to...

thank you arnelgp, can i get htis to auto update as well?, if so how