Search results

Afternoon all, I have word document letter template called 'Warning'. There are fields within the letter that are linked (mail merge way) to my database, including ID, name, etc. This creates each letter perfectly for each ID. However; Can I change my command button, that opens the letter...

Hi all! The last time I used my daily database was 24/12. Since 29/12 the database will crash and restart when attempting to put in a hyperlink in a form field. This is a new issue and has never happened before. Hyperlinks that are already added work perfectly fine. It is happening on all forms...

On my form I have a checkbox called "owner" and when it is checked a button is shown. The code I use is: Private Sub Owner_AfterUpdate() If owner = True Then Command2162.Visible = True Else Command2162.Visible = False End If End Sub This works; however, when I leave the form, and that record...

Still getting used to codes and would like a command button to do two things, tick a box and run a command to insert a hyperlink. I have plenty of separate ones doing these for other things but how do I join the two in one click command? When the "Email" button is pressed I would like it to...

I am still learning VBA so please bare with me on what seem a simple question ;-) I have a button called "copy". When this button is pressed I would like it to copy (just to clipboard) the text in a field called "address". Its as simple as that. I have tried various methods in the On Click...

Hi folks, looking for help on what may be a simple matter...... I have a text box called "Serial" that is bound to a table called "Enforcement1". I would like to place a list box, or similar, next to the "Serial" box on the form, that will show any duplicates it finds in the "Enforcement1"...

Afternoon all, Would someone be able to guide me on the type of code I would need to ensure a text box is not left blank when someone ticks a check box? I have a check box called "complete" and once this is ticked I need the user to complete a box called "NAFN" before the form can be closed...

Is it possible? Is it daft? I have a text box in a form (linked to a table) called RegistrationNumber. This registration may be in other records too; therefore, is it possible to allow the form to display matches when the text box is completed? I am thinking a small box showing the ID of other...

Learning newbie here..... still I have a text box called 'address'. In it goes the full UK address of an individual. I know I can create a button to open a web browser to show Google Maps, however; how can I get that OnClick button to open a map based on the address details in the 'Address'...

Afternoon all! I'll try and ask/explain as best as I can......... Is there a way to have a small section on a form that shows matching completed forms to certain details being entered in the current form? For example if I were to enter a serial number into the section it will automatically...

Hello all! After my first post I thought I should say hello.... I am relatively new to Access and have learnt a reasonable amount through trial and error and certainly from this site!! My main use for Access is the recording enforcement activities in Nottingham City. The previous program I...

Morning all, I think I may be struggling with such a feeble task. I have a text box within a form and I would like to make it case sensitive, i.e nottingham city become Nottingham City if entered incorrectly. Is this a simple thing to fix? Thanks in advance Marcus