Recent content by Graham1894

Majp Sorry I hadn't seen your post, I was busy working it out from Polg's post, and I came up with the same code as you. The reason I'm using tempvars is because I'm closing all open forms first and then opening the form that needs editing.

Hi plog I've never had to use a variable for a control name before and all logic seemed to be going out the window. Thank you for pointing me in the right direction, I just had to change the where clause to; TempVars!rstCode & " = " & TempVars!rstRecID It now opens the right form at the...

Hi plog, I know " TempVars!txtCode = " & TempVars!rstRecID is wrong but I just can't work out how to make it work. Could you help?

Hi, I hope someone can help because I can’t seem to make this work. When a user needs to update a record but do not have the authorisation to make the changes my DB sends a task to their line manager for them to complete the task. Currently, the line manager opens the task form which gives...

I’m not sure if you can do precisely what you have requested with macros, but depending on how many duplicates you may need at any one time you may want to do this a different way, which does work with macros. I’m also assuming you do not have all the duplicates open at the same time. Copy...

Open the table and move the courser to the shaded area next to the first row you want to delete and click the mouse to highlight the full row. Press shift on the keyboard and click on the shaded area next to the last row you want to delete, do not let go of the shift button. Keep the mouse in...

I have seen in databases a function that when you click a button it opens a box which lets you choose a word template from a selection available. Upon clicking the required template some information is passed to it via bookmarks. When the template is then saved under a different name a hyperlink...

I don’t know if this is loading an old page because I have never used the site but you might like to give this a try. I can’t put the full address in as a link as I have only made 7 posts so have broken it into lines, you need to put the whole address in the address bar for it to open the site...

I would just like to thank everyone for your advice. Missing contract numbers will not be a problem and now I know it will not cause any major problems I will use the ID. However, I was going to use the same system for invoice numbers and now know better. I did know the ID could jump numbers...

I’m putting together a database for contracts. The contract number needs to be unique but can just be a consecutive number so I was planning to just use the system generated ID and just change the label on the form to Contract No. However, there seems to be a consensus that the parent ID should...

Hi Ranman256 Thank you for the quick response. Correct me if I’m wrong but this just checks if on update the address has been made Closed, and if so a message box confirms the address has been closed. What I need it to do is check if any equipment at the address is still active and...

Hello, In the form for my Customer Address table I have a toggle button to show if the address is Active or Closed. In the form for my Equipment table I have the same for the items of plant, a toggle button showing if the item is Active or Closed. The Equipment table is linked to the...

I have some forms where it is important that some text boxes are completed. I do it through the on click event of the save and close button of the form (I only call it save and close because some people panic if they do not see save). All it does is check for blank boxes before it closes and...

Thank you for your reply, I will bear that in mind in future.

Hi, can anyone help. We undertake statutory inspections of machinery. I am in the process of creating a database Access 2013 which amongst others has a table that contains all the equipment we inspect (tblEquipment). Due to the regulations that apply to different types of equipment I have 60...