Search results for query: *

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

The organisation has upgraded to Office 2003 (a week ago!!!) and the Access databases now will only allow one user at a time. I have checked the options and they are set to Shared and locking to records. It worked with no problems before the update. I have done a fix at the moment by...

Is the problem that you have references to ADO and DAO? You explicitly declare the recordset as DAO. However the database is referenced by "set db = currentdb" and db is not declared as DAO. The lack of capital letters in dbopendynaset could be a clue. If it is not needed remove the tools...

Thanks Duane I agree with the comments in the FAQ. It is just that I was given a problem I had never encountered before where someone presented me with a problem based on an attempt to use lookup on a date field. thanks Michael

I am familiar with calendar controls and combo boxes in forms. My problem was based on direct work with tables in response to a request from someone working their way through a project. I should explain further. The colleague is trying to use a table for data entry with the use of several...

I was surprised today by a problem I had not come across before. A colleague was trying to use a look up/combo box to select a date. When the lookup tab is accessed the options are not visible. I have tried to work around it in 2 ways 1) by using an autonumber and a date in the lookup table...