Search results for query: *

Can anybody tell me where to find the French, Italian and German Acess run time langauge sets. Microsoft tell me that they are available without buying the relevant Office copies but in spite of searching the country specific MS pages I can not find them. Thanks in advance Peter

Sorry for delay, I am in Italy and attempting to change telecom suppliers has resulted in no phone for 6 weeks. There are one or two error handlers in the application but there is nothing in this procedure and none of them return this message. Thanks for your response.

I have an application that functions as an access (2000) file on any computer. When compiled as an .mdb file it continues to function on the machine that created the file but crashes on another machine with the message “Execution of this application has stopped due to a run time error” Both...

Thank you very much for your thorough and easy to understand response.

I have an application with a custom menu bar (File Tools etc) and a custom tool bar. I am now trying to change the contents of the custom menu bar. I can not remember how I set it up and I can not "get into" it to add to the functions available. I right click the item and select customise but...

After using the Developer software to create an application is it possible to issue patches (as forms) that will not impact existing data? My application has import in the menu but I can not find a method to save a new form individually - only as part of the main database. Thanks for any pojnters

Thanks to both. Complete & SPEEDY

Is it possible to insert the equivelant of an IF - THEN statement into a query calculation, something like: If [FieldName]= false then.... else ..... All efforts so far failed. Thanks in advance for any advice

Thank you PaulBricker Your solution was not quite OK for my application BUT clearly close enough to play around with a little. Substituting DLookup into the if statement in the forms Current event box works perfectly. I didn't think of the Visible/Invisible switch for this problem so thank you...

Thanks to both. The form is an invoice. Some clients are registered to pay sales tax and it is then necessary to note the sales tax reference number on the form. Currently the set up is that if the client is not registered then the reference number is null and the field is blank but the local...

Is it possible to format the contents of a text box on a form according to the results of a DLookup to the contents of another text box on the same form? I should also advise that this form is populated from a query and goes straight to print It is never seen by the user. I am trying to avoid...

Thanks I tried to implement Count without success (probably my syntax) The DLookup function works OK Just by-the-way the too few parameters comes at the beginning of the code Set rsCheckClient The query uses data from a user form. It is impossible for there to be more than one line of data in...

Thanks to all. PHV - returns too few parameters, expected 2 Randy - I am not capable of answering the questions raised, I took the code from Access 2000 Developers Handbook and it works elsewhere in the same application. Forgetting about this code the problem I need to solve is to identify if a...

First thanks for your careful analysis. The code is taken from The Developers Handbook and, in fact, works elsewhere in the application however... My problem is to identify if a query has any data and if not return an error message. Any suggestions for this? Regards and thanks

My application has conventional client files, First Name, Family Name In addition it has students held in a separate table. I need to avoid the unlikely event of two brothers attending the same session. qryCheckClient works and returns required information. qryClientID updates the student table...

Thanks PH and Skipvought. Also made avoiding duplicates much easier.

I am producing invoices from the client table The client table currently uses First Name, Family Name. As these are sized for the longest names there is often a big gap between the First name and the Fasmily Name on the printed document for example Jo Coley Because Jo must also allow...

Thanks very much rjoubert and PHV. Looks OK (Extra thanks for very quick response. Not sure where you are (and so what time) but dredging through my bad code at any time and suggesting a response to help a stranger is very kind)

I have a loop that performs three functions in each loop. I want it to stop when it reaches a variable integer but it continues to the end of the loop and so (in this example) adds two steps before completing. I have tried initiating the variable -1 and this results in one short of the required...

Whoops!! Now found the stupid error that caused the problem - as always if done properly it functions OK.