Search results

Hello, I want to send a quotation report with our companies logo on it via e-mail. How can I attach the logo I see on the screen to my email quote?

Thank you my friend found this works great. If DateDiff("y", [Dateq], Now) > 7 & checksum <> 1 Then MsgBox "Quotations over 1 week outstanding", , "Quotation Alert" End If Now I just need to work out how to put a tick box on a msgbox that updates the field name checksum in my quotations...

I added a combo box on the form before it opens the report it works great now, thank you guys

Can anyone help me with code for a 1 week flag I need in my database? I generate quotations, after a quotation has been submitted for one week I want it to flag up with a box on that customer and say this Quotation has not been chased up? anyone know how to do this? Regards Mike

sorry just the value contained within the varible or field name called "authorise" it's just a persons name stored in one table and I want it to copy to another table as I select it

Hello is there a way to copy the current record field name into a table field that is not open? If I use [Quotation].[authorise] = Me.authorise I can't get it to work? Thank you Mike

Can anyone tell me how to change the coloumn name around in Datasheet view? Just can't seem to do it Thank you

Yes this is good, but I just want it in a box before after I press the button for email or print, just for good looks.

No Authorised person is the person who would normally sign the quotation that is printed or emails to a customer, So I stored the basic first names in a combo box now I just need it to pop up with a box after pressing my print or email button so I have the option to select a persons name...

I have a form that prints quotations, before I print or email one I want a message box to appear that lets me type the authorised persons name. I have a field name defined but don't know how to get a box to appear promting for input? or pull down list anyone help? Thank you Mike

Hello Robin, I do not know how to re-write this database in VB. maybe you should try using Clipper, I use to program with at college you can compile to a stand alone EXE and the database is compatible with Dbase, you can write the database code easily in the dbase editor and compile the final...

The problem is that I store previous quotes and the buyprice in the table changes as stock is updated, so I need to store the quoted buyprice in a seperate table for later reference.

Doe's anyone know a command line to copy the present form data fields to a seperate table? e.g. [Customer].[Code] = [Code] but this don't work P.S. I guess I put it in the afterinsert section? thanks in advance Mike [This message has been edited by Xenix (edited 11-06-2001).]

Hello I had a very similar problem like this: maybe you can modify this code to work for you: Private Sub Form_BeforeInsert(Cancel As Integer) On Error GoTo Form_BeforeInsert_Err ' Set Line No to "Max" + 1 Forms![Quotation].Form![QuotationProducts]![Item] = DMax("[Item]", "Products", "

Thank you very much that was it )) under Form properties, Other, Pop Up.

Can anyone tell me how to make my active form come to the top? I have a button I click on that opens a new form but the main form always stays on top and will not let me click off it can only close it to see the form I want

Anyone know how to email a report in MS-Word format? I only get options like RTF, TXT or snap format?

Anyone know how I go about writing my own autocount function? I want an item number field in my quotation table that resets with each new quote for a customer?

Can anyone tell me what doe's the infinity sign and the number "1" mean next to the link set on my query? thank you

I wish to display one record in a Report as a customer quotation, I call in two tables, one of customer details and another called quotation which contains order enquiries there maybe several records within this report that may need to be displayed, They are linked with Customer Code. But when...