Search results

I'm getting sick of Access 2013 constantly doing this. I convert a macro to VBA form the ribbon menu then it doesn't run! I've uploaded a screenshot of the latest error to irk me. This ran perfectly well as a macro but sice i converted it to vba. (cos somethings i can do easier in vba than in...

The FollowHyperlink method is not available from the macro onclick event drop down list... i think you can only use it in vba and then have to use it with arguments. Re Forms: Firstly you have to use a hyperlink form control, which is in the Design part of the ribbon. That then presents you...

I will try your suggestions later and let you know. Thanks for your reply rgds Simon

No doesnt work in table or form. Everything else in app works fine, vba etc

I've got this table that had email address and website fields as short text types. I have created two new hyperlink type fields and cut/pasted all the data from the old fields into the new hyperlink types. They show up fine in the form and the cursor changes from an arrow to a hand when hovered...

Thanks How do i embed that into VBA?

It may be helpful if i add this. The combo's bound column, namely the DORP-ID field, is not a unique identifier. It forms part of a compound key with the CODE field, thats why i need both of them transferred to the form the key is DORP-ID CODE bound together. It seems that Access does not...

In my form my combo box displays a list from a query called DORP-HDR that has 3 columns DORP-ID | CODE | NAME and displays them like that is the drop down list The form field that the combo is bound to takes the numeric-id field as its value. In the combo control wizard i nominated that value...

I did not explain that the old field was to be deleted, no need for apol.. Your subsequent questions meant you were thinking like a programmer!:o

Well that makes sense, will bear in mind . Thanks

I'm doing a facelift on someones old database. There was a field that accepted Y or N or blank in a text field. I'm replacing that field with a YesOrNo field which on the form will have a check box, simply cos i prefer check boxes. So the old text field is going to be deleted once its Y or N...

Thanks Ken, but i have just managed to solve it by sticking in an IIF() to the Access Query Designer.

I'm inserting a new field into a large table and the value of that field is going to be either TRUE or FALSE depending on a value of an adjacent field that already exists... The new field defaults to FALSE but there are several hundred records where it needs to TRUE. Can i get SQL to handle...

Thanks for your reply. The user is now purchasing a 2010 license for me.

I'm using Access 2013. I'm intending to create a database with forms, reports and probably VBA. The organization I'm creating it for is using Office Pro 2010 with Access 2010. Will they have any issues running my Access 2013 file out of the box on their 2010 system? Before i posted this i...

Hello All, Glad to have found a promising Access forum. I'm doing some voluntary work for a charity and am reworking redesigning their Access 2010 database.. Its in a bit of a mess and needs a completed redesign and makeover. So thats a nice project for semi-retired me to get my teeth into with...