Search results

I was just about to post that I had found the problem. It was as you suggest that the name of the combo box had not been set to Funds. Getting old and stupid. Thanks Robert Donald

After several years not doing things I am updating a 2007 database. I added a combo box which works fine together with calculated expression from the combo box result. The box returns a field Funds from table members and the calculated expression is =[Funds].[column](1). This brings up the...

Eventually found the solution. Access data type hyperlink is coded as the string structure I quoted in the original post. To make things work the query that populates the temporary table should select not the field (email in tblPerson) which contains the hyperlink but an expression...

The problem only appears in the Mail Merge stage in word. The query correctly inserts the email address to my temporary table. Clicking on that address in the temporary table does open up the email cleint with the address correctly in the To field. The problem only occurs after the ODBC...

I have an an Access database which allows the user to select data to be available for mail merging via Word 2007. It selects the required data into a temporary table which word connects to via an ODBC connection. This works fine for standard mail merge (letters, envelopes, labels) I have been...

Understood. As I said, simple minded Many thanks

You are of course correct in that the Asc function does return the index corresponding to the case of the character. I could alter the code to recognise the passwords as different if the case is different by using it. It just struck me as strange that the Mid function does correctly recognise...

In a routine I wrote to encrypt a login password for a database I have come across an oddity. For each character in the entered password I compare it in turn to each of the values of the chr function to obtain the index of that character in the Ascii table so it can be used to construct the...

Thank you for that. It looks as if it helps. I will need to look and see how many places in the rather complex database where it needs to be applied!

Thank you for this. I rather feared that might be at the root of the problem. I obviously need to learn something more about Access

I am creating a form that displays a chart. The Form is created via the Chart Wizard which uses a query to construct the data to be charted. The query requests 2 parameters from the user. If the user hits the cancel button on the parameter request form, an error message comes up. "An error...

Many thanks. I will get the charity IT group to try that out (I do not have an access 2007)

I have been developing a database for a charity. It is developed in Access 2002 but is to be run on machines some of which use access 2002 and some access 2007. For user convenience the action alerts need to be suppressed. In access 2002 this is done via Tools/Options then the Edit/Find tab and...

Permissions and tabbed control Many thanks. I was afraid that might be the case! Appreciate your guidance

May be an elementary question but I would appreciate any help available. I have a startup form made with a tabbed control, with separate tabs giving access to different facilities. Can I apply different permissions to the separate tabs of the control? So one person can access the Data Entry tab...

Missing dll's (I'm wrong!) Ignore my last reply! I had (stupid I know but I am a new user of Access) gone into tools/reference from the VBA window showing the compile error with the CHR function rather than going directly through the Code access butto. When I do this I can use Tools/Access, see...

Missing dll's Thanks for your reply. I had already done this but when I looked at Tools/Reference, it is grayed out. That is why I was hoping someone would know likely DLL's which I could check on the machines.

I am building a database for a large charity on a voluntary basis. My machine has Access 2002. The charity has just supplied me with a laptop with access 2003 to develop the database. Code which works on my access 2002 machine throws up errors on access 2003, (broken or missing references to...