Search results

Hi, Is it possible to use VBA to format a text box control as a hyperlink when only certain conditions are met? Here is a snip from a continuous form I have which lists the tasks assigned to a user: What I would like to do is only format the 4th column as a hyperlink when there is a number...

That's brill! Thank you both (y)

Hi, I have a simple select query which is the data source for a combo box. The values which show in the combo box are from column 2 (Country). The query results are below: At the moment, the combo shows all the instances of 'England'. Is there any way I can get the combo to show only one...

Thanks @Gasman that would definitely be an option. Although, I don't think most of my users will be able to follow such a process and get it right consistently! I think it could be a few too many steps for them.

I had considered this but I need to be able to apply password protection to sections of the document before I email it to the recipient. The recipient then needs to sign it electronically and email it back. I have the version of Adobe Reader that lets me edit PDF documents but none of the users...

Hi, I have a mail merge query which allows me to pull all the information I need from one particular parent record on one table and add this to a word document. For each parent record there are up to 3 child records from another table that I also need to add to a table in the word document...

I had added an extra ‘y’ to MSysObjects so it read MySysObjects and I just didn’t see it the first time I tried it!

I have now managed to get the SQL working and it works perfectly! Something as simple as a typo was preventing it from working. Thanks all for your help :D

I've added this in the on load event of my form and it (sort of) works. The combobox is full and it's sorted a-z but there are some previously deleted reports showing for some reason and some are duplicated at the bottom. In the image below, the Yorkshire Members by LA report is no longer there...

This looks really straightforward but when I've added it to the code, the combobox comes up blank Also tried adding this but no luck. Not sure where I'm going wrong?

Thanks @Uncle Gizmo for your response and the feedback. I like the idea of adding the report names into a table and using a query for the combobox as this seems a little cleaner. Would I need to add in the report names manually every time I create a new report or can this be done automatically?

Hi I have a combobox on a reporting form which uses VBA in the On Load event to pull the values from the reports that I have in the database. Although the reports always show alphabetically from a - z in the navigation pane, they don't show in alphabetical order in the combobox. Is there any...

So it turns out I'm an absolute numpty! After deleting the checklist subform and setting it up again and it still not working, I figured the issue could be to do with the parent form and it was. Allow Edits was set to 'No' on the parent form!! Changed it to 'Yes' and it works fine! I've no...

There is no error, even when I disable error handling, the checkbox control in the subform just doesn't enable like it should. The subform control wasn't copied either as it's a separate checklist altogether with a separate table and subform and I have already checked that the name is correct...

Hoping someone can help. I have a number of checklists in my database which I have built using the fab tutorials from Nifty Access. All my forms have the fields disabled until the user edits this record via the click of a command button. I've included this to prevent unintentional editing and...

Thanks @ebs17 It works perfectly since I added in the additional comma to represent the specification name! :)

Hi All, I am trying to add the facility for my users to import a CSV file via a button on a form. The code in the on click event of the button is: DoCmd.TransferText acImportDelim, "ImportTempT", _ "S:\IT\1 - Testing\CSVTestTwo.csv", True But I keep getting the run time error saying...

Thanks for your help. I did get it to save making the changes but then I had other criteria to add in and I couldn't get it to work. However, I've managed to figure out how to get the results I need using design view in Access. :)

Hi All, I have a mailing list form in my database were I need to filter organisations by 4 geographical areas. i.e. UK region, local authority, constituency and combined authority. Sometimes I will need to search for and send emails to all organisations for a certain region or local authority...

Thanks @Gasman and @adhoustonj that's much clearer and will help loads whilst I'm still testing after my code review. :)