Recent content by ATB

I mean open the front end in design mode and change forms. reports, queries Etc. Thanks

HI can any one tell me if this is a known issue. We have a access DB which has linked tables. when ever we try to administer the database front end the network response is very slow. this seems to speed up if everyone comes out of the databases. Is there a problem with administering tables...

Thanks Hi Rusty That looks good but i am not looking to do a mail merge of the data. I simply wish to place a button on my customer form which when clicked opens a new word doc and pastes in their Name and address at a certain place. any further idea's Thanks Graham

HI, I am sure this is simple question for your clever people. I simply want to copy my customers details from my customers form and into a word doc so i can send them a letter quickly. The data i wish to export is just customer name and address Etc.. How can i do this. I have a basic...

HI clever pepole I am working in a filter form to filter the results of a report. I have managed to get this working for one field but i want to filter on at least two. can anyone help me with this code to add the second field. This is the code i have used so far: Private Sub Command8_Click()...

Rich, you are indeed a genious. Thanks you so much for coming to my rescue, It worked a treat. Regards Graham

this is as you say. The field displays OK in the table and query. Do you know how to format the feild from the text line?

Thats exactly what i do have!! my question is how do i format the field to return the value to 2 decimal places or in curenncy

I have a seperate field in the table and query, I simply just want to call this from the text box on the report to allow for the text to flow around the changing field ammount. Cheers

I have a query called say Q_invoice This query contains a field called say [ammount due] which is a currency field and displays OK in the query. I have based a report on the query and added a text box which contains this text. ="you owe me" & [ammount due] & "please pay" when i open the...

text too.

If i change the propoties of the text box to currency it interfears wiht the text in the box but chnages nothing for the number fields. The text above is all listed wihtin a text box. Thanks

HI I have a simple report with a text box simalar to this, = "You owe me" & " " & "[ammount owed] & "please pay it" The trouble is the curentcy field is not formating correctly. I have chacked the formating of the query and this is OK. Is there a way to format the field wihtin the test box...

Same Problem I am having the same problem, I have tried adding the DOA 3.6 as suggested but still get the same error as above. if i add the Doa.recrodset code as detailed above the error stops bu the code doesn't seem to work. any oher ideas would be welcome. Cheers

I would like to add and timer to a form thats starts a timer at the click of a button and stops at the click of another button. like a stop watch, any idea's please. thanks