Search results

Thanks chapz! Sorted

If I am using 3 buttons and the first button is to be disabled - am I going to have write a routine to force focus to the second button? And in those instances where the the second button is to be disabled force focus to the previous enabled button???.... there has to be a neater...

I am using a switchboard similar to that used in the Northwind sample database. What I need to do is restrict access to certain buttons on the switchboard. To do this I have a table that lists all switchboard captions, thus the form structure is built 'on-the-fly'. The table also specifies the...

Unfortunately not, the Save action simply saves table design/form design /report design changes........

? - Save what? What command do you use?

For printing labels I have a form bound to a table. I only ever need 1 record in this table. This record holds the label data I wish to print on the label. On the form is a print button that calls the Label report. I do not have / wish to have, record navigation buttons and therefore I am...

Thanks Pat - your a life saver!

I have a requirement to create a labelling facility in my database. On the old DB - an AVERY label sheet is manually fed into the printer and we are able to print off exactly the right number of labels by entering the start / end positions on the sheet (working from left to right) 3 columns / 7...

Simply set the control source property for the listbox to the table containing the names of your clients.....

Unfortunately, using the currency type is not really an option, as this form is designed to work in all currencies not just sterling.....

I have come across a confounding problem....!!! i have an invoice form that displays the sub-total / VAT / and Total fields. All of these are text boxes having the 'Fix' format type and 2 decimal places. Using the following values : Sub total = 4547 VAT (@17.5%) = 795.725 this displays as...

your solution seems to hardcoding numbers into the controlsource property for the control! This is not acceptable. Also, I am working with decimal numbers i.e. 37.7533659 in this instance : How could I get the desired figure 37.75 ?

Thanks. But what about when its not 0.5 i.e 0.364 OR 0.747?????

I have a textbox on a form that calculates VAT for transactions whose controlsource property is : =([txtSubtotal]*0.175) The trouble I am having is with the rounding that seems takes place in the control. If the fractional part of a value is calcuated it is rounded in accordance with the...

Sue Thats just the ticket! Thanks...... dont s'pose you can help with this old'n can you ? Old query

Sue Thanks for your help - I am using Access 97 - can you send the DB in this format please? Thanks

Rich Sorry form is definitely a bad choice of word in this context - should be report.

I guess I havent made myself too clear ....... i have the dialog box coded. everything works just fine - but I currently print one report which is formatted exactly the way i want it. Except I want it to print another report same as the first but with a different label i.e. advice note instead...

Sue I am priting these reports from a dialog box where the invoice number gets entered once and press OK i.e. what I want to do is with one button press - print the two reports . Rich I do not want to duplicate the form, that is a MESSY solution! Much nicer to have code do the work for you...

Hi I want to 'cleanly' be able to print out multiple instances of a report with a small variation between each print. eg. I need to print an invoice report and also an advice note. The advice note mirrors the invoice in all ways except that the header reads 'advice note' as opposed to...