Recent content by MichaelintheUK

Hello PHV thanks for a quick and helpful response. Michael

Hello I have an export routine to create as new Excel workbook from Access VBA. The Excel reference is enabled. The following shows the declarations.... Dim xlapp As Excel.Application Dim xlbook As Excel.Workbook Dim xlSheet As Excel.Worksheet These all work alright. The page set line...

I am working with a series of dynamically sized ranges in which the contents are populated from an Access .mdb. The coding is in a Access module with a reference set to Excel. What I was doing worked fine until I tried using names. I would like to place a marker at the start of each range and...

There is an FAQ "better looking forms". What I wonder is are there any updated guidelines for form design in Access 2007. I also have the Microsoft Windows design guidelines and several books, articles on design guidelines e.g. forms are grey, text boxes, buttons should be a certain size etc...

HarleyQuin Thanks for your reply - You first posting has made me think again about my approach regarding the method of validating the text box entry. Thanks also Roy-Vidar and eveyone else that posted.

Hello I have a text box on a form into which is entered a 7 or 8 character id number. In most cases this is all numbers - however because of amalgamations with other sites they have id numbers with a prefix of A or B followed by the rest being digits. I have managed to provide checks for the...

Thanks Macro I will try and check this out. The problem is I have Office 2003 - it is the users/recipients who have Office 2007. I will check it out as soon as I find the mysterious and less than ovious 2007 eqiuvalent of "help about..." thanks

Hello everyone Apologies if this has been raised before. I work for an organisation where the vast majority of staff use Office 2003 but senior staff, managers etc. use Office 2007. I have to create a number of charts monitoring processes over time. In a recent example I sent a workbook...

Hello Glen Thanks for the tip. I find it incredible given the emphasis in modern computer texts on the human computer interface and usability guidelines that there is so little guidance available about these in relation to Excel. Given the widespread use of Excel that exists for all sorts of...

I am familiar with Windows design guidelines and use of the standards in Access re database design, naming conventions in VB etc.. What I am looking for are similar rules for Excel (the actual practical examples I come across often look bizarre). I have seen a couple of suggestions on an...

Hello ScottIan I had a problem importing a file when one field contained part numbers that were for about 75% of the part numbers were numeric digits only. Later part numbers preceded the digits with a single character. It accepted the digit only part numbers and rejected the ones starting...

Hello ScottIan I had a problem importing a file when one field contained part numbers. For about the first 75% part numbers were numeric digits only. Later part numbers preceded the digits with a single character. It accepted the digit only part numbers and rejected the ones starting with an...

Hello Remou Thanks for your tips. Michael

They are all linked to the same backend - the problem appears to be with a shared frontend.

Yes there is a front end with queries, reports and forms and a shared backend with tables