Search results

This relates to a previously solved post but I have since had to make changes to the system which has inadvertently stopped things working how I need them. This is the old post for reference. https://www.access-programmers.co.uk/forums/showthread.php?t=298051 So, I have several cascading combo...

Thanks, you are correct my table design is rubbish and I have got into bad habits. I will take your advice and sort it out. Thanks

I have multiple text boxes on a form that are bound to different costs field in a table. I want to be able to sum all of the cost fields into one Grand Total field without having to explicitly write out each field in a query to total them all up. Is there a way of using the Tag property to...

Thank you so much works like a charm.

How do I remove the blank line from the end of the text file that this function is creating. The text file is created using the Docmd.TransferText method and then calls this function which opens the text file and inserts a header line at the top of the file but in doing so it is creating an...

Where is the property for the List box to change it to 'simple' or 'Extended'?

thanks for this; so when I am creating a new record (which has a unique reference) do I also need to create a new record in the tbl3 with that unique reference for all of the values in the list box?

Thanks Pat, I totally agree so I am going to take a step back and look to how I can change the design to remove the MV fields. I know that I need to have a separate table for the fields that require multiple values but how do I change list boxes so that the user can select multiple values and...

thanks I take onboard what you are saying. Just to answer your what you are saying about .value I am using that for other areas to the application so I am aware of how to query the values but in this instance I am not using a parameter on any of the MV fields, merely querying other fields in...

Apologies for the very long post. I know for some that as soon as they see 'Multi-Valued' field in Access they go "oh you shouldn't have used those" but I built my application without knowing really how many issues these can actually have. Now having read lots of posts on various different...

Thanks Pat that's very useful information and I will be sure to refer to this in future.

Just realised that I had some other code running on the 'OnOpen' event which was checking something else and updating the record unnecessarily. This was due to me copying another form and not removing this code. All working now and the 'Before Update' event is the correct event to use. Thanks...

Thanks but I didnt use the AfterUpdate event due to the infinite loop it would get into as per the post by Pat Hartman here https://www.access-programmers.co.uk/forums/showthread.php?t=165477

I am formatting Now() to remove the seconds as I dont want to store the seconds. I have the code on the BeforeUpdateEvent of the form but it is still triggering and updating the record even though I havent actually updated anything, merely opened form to the record. I have also tried the...

Is there a way of updating the 'LastModified' date of the current record only if the record is changed? I have the following code on the forms 'BeforeUpdate' event which updates the current record as soon as the form is opened BUT, I only want to run the update if the record is edited. I could...

This works perfectly now, I have so many combo boxes on the form so there was previously a short but noticeable delay when making a selection but doing what you said I can now control which combo boxes to check and therefore runs without any delay. Amazing, thank you so much.:D

Thanks I will give this a try tomorrow, never used the tag property before as never noticed it or wondered what it was for.

Thanks to everyone that helped me today. I have sorted out the final issue by just resetting the backcolor on the independent combo boxes back to what it should be (light blue) at the end of the code. Not ideal but it works. At least I know why it was doing it now (down to which column was bound...

Ive solved the issue of the formatting of combo boxes that havent had a selection made for them. It was down to them being a number field with a default of 0 and 0 wasn't in the list as an option. The other issue I have though is that there are two other independent combox boxes that are...

Just when I thought I was never going to find it. Below is some code that someone wrote for me a while back and I dont fully understand it but it does appear to work but with some issues. Public Function CheckValues(intTest As Integer) ' Put this code on the form that it is being called from...