Search results

Hi All I have multiple reports that are generated which i want to have the same text appearing at the bottom of each page in the footer. This text, though, is dependent on the report data as in, if the data is UK based data then the text will show our UK office details and terms, if its...

decided to tell the users they needed to update the maintenance prior to creating a new consignment and if they found they didn't they'd have to cancel entry do the maintenance and go back, too much hassle with the subform having focus causing the main form to write, thank you all who responded...

@CJ_London the buttons are in the header and footer not on the continuous part @isladogs i'll keep it in mind, but in my testing everything has worked as expected and i've removed all the greyed out button controls and the processing is now alot simpler and much less VBA, but thank you it is...

@CJ_London thank you for your input and help i have taken on board what you are saying........ but......... @Gasman 's answer works much better than what i was attempting to do by enabling/disabling the button instead of switching between 2 buttons one grey one not, means less controls on the...

@Gasman well thats certainly a way to do it and what i really should be doing instead of having grey buttons and hide/showing them as appropriate.............. tried that and it definitely works so i'm going to go through ALL my forms now and do that instead thank you

@CJ_London the lstSupplier is not hidden or disabled so i'll take a look at tab order/tab stop to no and see what happens thank you

@Gasman apologies, i saved and then thought i'd expand what i said with an example so edited

can you not add criteria to your controls query? select the combo box, click on data property and select row source and then select the field and add a criteria e.g.:

Hi all I have a continuous form where the user can select a record and click a button to delete it as there are a number of processes i'd like to carry out when they delete the record. After the delete process has ended i want the button go grey out until another record is selected. I have 2...

Hi All thanks for the updates, i didn't realise that the main form would save if focus goes to the subform, that makes sense now you've described it and it certainly explains what is happening. The reason for this process is that we get new suppliers once in a while send an email to say they...

Hi All I have a form with 2 controls on it that are sourced from a table. The table is companies we work with and the controls determine which of the list to show depending on Yes/No fields on the record. Control 1 - Suppliers Control 2 - Freight Companies The Companies table is defined as...

seems in my cautiousness not to disrupt things i didn't think to do that and was just about to post that thats what i did and it seems to work

In the latest iteration of my database i need to repoint the linked tables to a new source location. The steps i have been through are as follows: Step 1 - Create an MS Access database with forms and tables Step 2 - Test out functionality and sign off Step 3 - Split database into Front End...

@Ranman256 worked like a charm, thanks

@Ranman256 awesome thanks i'll give that a go

Hi All I have previously setup some VBA within an Excel sheet that builds and email from sheet data and sends it out to a set of recipients so I understand the VBA code necessary to build an email. The issue is that at the time of generating an email the user needs to do a review of the email...

@The_Doc_Man thank you for your in depth update, really helpful as have all above who have made suggestions, based on what you've suggested i'm going to put together a solution that works in the process we have but the SQL bit is REALLY helpful because the way i would have done it because i know...

@arnelgp i had looked at that but the code that it refers to i couldn't find the download. i think i'll set the locking to edit and see what happens and if it becomes an issue maybe add the process i outlined in that a user name is added to the record

@Minty this is i am trying to understand because i have set the database to lock when editing but have tested by having the same record/form open and making changes on both computers but nothing happened. the other issue is the opened form has sub forms where the user can add/amend data which...

@June7 the database has been split into FE and BE with each user having their own FE. I am currently looking at implementing a timer/refresh process anyway to cope with any additions/deletions