Search results

Tried your solution and it works really well, I have also been playing about setting up an Invoice Table and Cost Table and using a query append to transfer the quotation to the Invoice Table from the Quotation Form which means that as your pro-forma that it can only be changed at the...

Spot on as expected, and yes I did make a slip referring to it as a form, it has taught me a lesson as well in trying to make a form do what it wasn't designed to do. Many thanks once again. Paul

This looks spot on, I will try it out at the weekend. Many thanks once again. Paul

Aha! I didn't have them touching, I haven't tried it yet but I'm sure it will work as you suggest, what about other fields alongside, do you mean anything that is on the line acros the full width of the form or just next to it. Paul.

It certainly does give me ideas, can you expand on: "I would have a button that converts a quotation automatically to an invoice ... locking the invoice (so it can't be altered once issued)" If I can get this bit right the rest of what you suggest is straight forward. Paul

Didn't work all it does is not show a text box outline, it doesn't move an empty line up and still leaves the gap. The boxes are: Companyname Address1 Address2 Address3 Address4 Postcode so if there is nothing in say Address4 it moves Postcode up to print below Address3 and no gap. Paul

Hi Rich@ITTC, Thanks for that ........... I will try this later Gratefully yours Paul [This message has been edited by ptaylor-west (edited 10-10-2001).]

Thanks for all your help, if I create the report will I be able to get it to move up empty lines and if so how ? Paul [This message has been edited by ptaylor-west (edited 10-10-2001).]

Hi Rich! The form is used to create a quotation which stores the input into a quotation table which can then be accessed from a customer form yo view all quotes for that customer. It seemed logical to format the form so that it could be just printed off rather duplicate a lot of work in...

Thank you, thank you, Now Rich I don't think you can be classed as that new ! Ischeer hit the right button, printing out in draft is the perfect solution. By the way Rich did you see my Topic in Forms "I need help in planning forms and linking tables " I am going round in circles trying to...

You can also use this option as an On Click event, just rename the [E-mail Address] to what field name you used Dim StrInput As String StrInput = "mailto:" & Me![E-mail Address] Application.FollowHyperlink StrInput, , True

I have Name and Address fields on my form as Name, Address 1, Address 2 etc which are taken from a Look Up Combo box. If say Address 3 and/or Address 4 are empty it leaves big gaps in the overall address when I print it off. Can I get it to move fields up if they are empty ?

No I never did find a way round it, maybe someone new will see this and have the answer

This is not easy if you are fairly new to follow but here goes: You need to set up a query to list all the fields you need named say All Company Names on Database fields being Company Name, Address 1 etc etc. Next set up a Combo Box from the toolbox that takes it's info from the query, it...

Normally I would suggest that you have only one description per key number using the key number like a unique ID but I think you are looking for some flexibility in choosing the description after the initial key selection in which case set up a combo box with the choices of description for each...

Thanks Chris, in this case costs will probably always be variable because of current market price ie: old stock/oldprice so I agree I will need a table but should I put this in the Invoice Table as the costing sheet needs to be like a backing sheet to the Invoice and therefore costed at the time...

I have a form which raises a Quotation which grabs information from the main Customer table and I enter prices and quantities and it totals everything up with taxes etc. I now want to generate an Invoice which contains exactly the same information as the Quotation but store it in an Invoice...

When the hyperlink opens say a Word doc, Access minimises onto the toolbar and when I close the Word doc I expected Access to maximise but it doesn't. I have tried CoCmd.Maximise as a LostFocus event but no go and also AppActivate as VBA on Document Close in the Word doc, again with no luck.

Your answer lies with the setting up of the query, you need it to ask for the info needed on whatever the field is in the query as an example enter in the Criteria for a Field names Students Name: Like [Enter Students Name] & "*" When you run the query it will ask you for the students name...

Thnaks Rich, It worked perfectly. Paul