Recent content by LGDGlen

@jdraw thank you for your response and yes i do know my requirements better than the readers so i will try to elaborate a bit more the users have a form where there is a drop down selection that they can use, if they use it that can specify the override to the calculation by fixing which Value...

this may not be the best way to do what i want to achieve but i'll detail it out here and we'll see where we go. I have a process that generates a CSV from a query but there is a need to override the default behaviour of a calculation within the query on occasion. the table has 3 fields which...

@ebs17 appreciate your response, not sure i understand the first bit about the query as i tried to follow your suggestion from a previous comment but Access when i saved the query created what i had above with the select from bits, anyway i think the whole "simplest solution is probably the...

@ebs17 I have a bit of an issue with the solution you have supplied, not the solution as such but i guess my implementation. Every time i use the parameter query to write to the table any field that appears after the first memo field ends up being blank. i have stepped through the code and...

@ebs17 thank you for your suggestions and guidance i am still on a learning path with all of this so the vba building was how i initially did the queries before they were parameters and then when the issue of special characters came up i just extended them i will use what you have given above...

Hi All I am logging changes to tables by copying updates to log table and have hit an issue with a memo/long text field in that when it is used as a parameter to a query built using VBA if the field it is copying from is more than 255 characters it throws an error. I believe this is a bug with...

@Gasman thank you, that web page i've been to before and helps with getting to controls on sub forms etc but not sure (unless i've misread something) describes the event trigger order and when data from a record populates fields on sub forms etc @Uncle Gizmo adding my code to the current event...

Hi All I have a form that is currently linked to the main form as a pop up form but the users would like to move it from a pop up into the form it pops up from. So i have created a subform version of the pop up and added it to the main form. All good ...... but...... When the pop up form...

Clannad Cocteau Twins Portishead Massive Attack (maybe) unless this thread is being taken over by ironicness saying MJ is new age.......... then i'm lost

@arnelgp yep totally makes sense, actually reduces the queries required to 2 as well, thank you

@arnelgp thank you for the examples, i'll download now and take a look

@plog thank you for your response. to answer in turn: - no fields have spaces in the names this was just in my example above so apologies for that it was to make them more readable/descriptive - CMR and SalesOrder are yes/no fields indeed - thank you for the query i'll take a look tomorrow...

Hi All I have a situation where I need to consolidate parent/child records into 1 line for a view of the data. The data looks like this: Consignment ID Delivery ID CMR SalesOrder 1234 1 Yes Yes 1234 2 No Yes 2345...

Multi line messages can be built in HTML like this Dim OutApp As Object, OutMail As Object, greeting As String, HtmlContent As String, subjectLine As String, attachmentFileName As String Dim folderSelected as String Set OutApp = CreateObject("Outlook.Application"): Set OutMail =...

reminded me of this from back in the day - http://www.toodarkpark.org/computers/humor/shoot-self-in-foot.html