Search results

Post stripped down database? Thats strange, i have used that method on a number of reports within the same database and i have never had any problems with it, admittedly not to a zebra printer. Since Fifty2One got it to work as well it would seem to indicate that it must be a problem within...

Or have you tried setting your reports to a specific printer from within the Report Page Setup: With your report showing, select File - Page Setup On the Page Setup form select Page At the bottom select "Use Specific Printer" and set accordingly. Alan

Hi, Have a look at this, i use it and it works with Adobe 7 http://www.lebans.com/reporttopdf.htm Alan

Dreamweaver, That looks very impressive. I have been asked if i can produce a Management database in work although i don't believe it will be to the level of complexity as shown in the pictures you posted. However i would very grateful if you could email me a copy. Regards Alan

Windows Themed Buttons? Gemma, Do you mean Windows Themed buttons? Via Tools - Options - Forms/Reports and selecting "Use Windows Themed Controls on Forms". Alan

Pat, I got it working in the end by doing just that - different name for module and function. Thanks for taking the time to respond - much appreciated. Alan

RG, Many thanks, looking at your version it is obvious to me now why my version wouldn't work as i wanted. Appreciate it you taking the time to help and respond. Regards Alan

Hi, I have the following code associated with the onclick property of a button that is (supposedly) designed to check if the Date box is empty and if it is brings up a message giving the user a choice of whether to accept the empty box or cancel the Close Form to allow them to update the...

Found It!! Gemma, Found the cause of the problem. There was nothing wrong with the code being highlighted, the error / typo lay in the coding attached to the OnClick of the 'Transfer Selection' button. All seems to be working fine (for) now. Many thanks for taking the time to respond to...

Gemma, Thanks for the response. Will need to read up on how to carry out your suggestion - never done that before. What surprises is that it can give an overflow error when there are only 3 items in the list box and only about 5 test records containing either 1,2 or 3 entries in the...

Hi, I am attempting to implement the 'Retrieve selected items in a multiple selection box' contained within the Microsoft Knowledge Base Article 827423 to allow a multiple selection and passing of selected data to a text box. Initilly it seemed to work really well, but for some reason it has...

Rich, Simple eh - wood and trees:rolleyes: Many Thanks Alan

Hi, I have a need to include a Date in the format of yy i.e. 06 in the Page Footer of a report. Simple you would think but for the life of me i just can't seem to get it? If i have a text box with =Now() its fine, if i try to change it to Date() it asks for a Parameter Value for Date, if i...

Gemma, Many thanks for your reply. That works, strange thing is is that i am certain i tried that :confused: but anyway it is working now:) Alan

Hi, I have been using the following code (thanks ghudson) to backup and zip a database. Public Function BackupAndZipit() 'This function will allow you to copy a db that is open, 'rename the copied db and zip it up to anther folder. 'You must set a reference to the 'Microsoft Scripting...

Miguel, You might to have a look at this link http://support.microsoft.com/kb/827423/en-us Alan

Undefined Function Error As you will see form the above threads i had a problem getting a Public Function to operate. I thought i had cured this but when i now open the database it comes up with the Undefined Function 'RoundCurrency' in expression. i have checked for missing references but...

Rich, Resaved it as RoundCurrency and called that function and appears to be working. I take it then that module names cannot contain numbers? Although default names are Module1 etc!! Anyway, as i said it now appears to be working - many thanks Alan

Rich, Yes saved it in the modules section and saved as Round2CB, just a thought but would using numbers in the name affect it? Alan

Round2CB Function - Undefined function in expression Hi, I have aproblem with rounding currency values and a search of this Forum brought up this thread and in particular the Round2CB Public Function above. I have a problem in that when i attempt to use this function within a query i get a...