Search results

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

nearly there Harry, Cheers, added the filed in the details area which works very well, the sum field in the report footer area returns an ERROR I have also tried to put it in the detail footer which is idealy where i would like the calculated filed but this returns a sum of how many fileds...

Dear Clever people, Having managed to resolve my lasy problem with your as always expert advice i find myself again with a problem beyond my limited knowledge. I have a report which hold the fileds [invoice ammount] and [over due] (Y/N) the [overdue field] has the sourcecriteria that if...

cRACKED iT IGNORE THE ABOVE. MANAGED TO GET IT TO WORK USING YOUR CODE THANKS A LOT

DON'T GET IT!! thanks for the reply but.. when you say put the code in the recordsource would this be the same as control source. I am using access 2K? Do i use the code just as you typed it or do i need to disect it. IE. do i need both calculations? thanks again

Hi all. Try this one for size, i have a report which holds the fields [invoice date] and [due date] [due date] = [invoice date]+30 I also have a check box [overdue] which i want to have the criteria that: If [due date] >date() then [overdue]= true or If [Invoice date] + 30 = or > date()...