Recent content by djkay2637

Thank you for everybodies suggestions. It now works!

Thank you arnelgp for your advice. I have tried using calling the function but not getting any joy. I was trying to call the function and pass though it's name by using the code. Private Sub Text169_LostFocus tbEmpty(Text169) End Sub CJ_London I like the idea of this loop it looks far more...

Hi All, Using this forum I discovered this fully working validation check, so first off, thank you. Private Sub TextBoxName_LostFocus() If Len(TextBoxName.Value & vbNullString) = 0 Then 'do something Endif End Sub I have another question to ask. I have quite a lot of text boxes that...

Hi All, This post helped me to get a fully working validation check, so first off, thank you. I have another question to ask. I have quite a lot of text boxes that can not be empty. I could simply copy the same code to all of the text box's Lostfocus subroutine however this is very messy and...

Thank you for spending the time to reply. In answer, not quite. You can only see one order at a time in the subform as it is quite large. By default I want it to load the most recent however, if there are more orders that that specific customer has made, i want the system to list all other...

OK Here goes! I will try and explain what I want to achieve by using a customer / order database example. The database I am actually adapting is a collage faculty ILP database but I think the customer/order database would be easier to explain. So I have a Customer form and an Order Subform...

But how would i get it include the next date in the MAX formula range if the customer ID is the same. in other words would need to to do the max value on an unspecified number of duplicates but only on the duplicates and not the whole dataset.

Good afternoon eclectic minds of database wisdom. Ok here is my query: I have a customer table and i have a communication table where we record all outbound and inbound communications. There are many communications for each customer. I want to run a query that displays the date the last time...

All tested and it seems to work. However, I have another challenge...... I think id better create a new thread!

Unique values seems to have done it! I will have to test it more extensively and i have included some more complex criteria but for now, thank you!

OK i have got something working now however, every record selected by the query is being repeated 184 times which is coincidentally how many different postcode parts are within the lookup table. Why might this be? Thanks again.

normally if i have created a calculated query field i would put the formula / expression in the column title. Is that what you mean by the string variable.

OK. Ill give it a go. By "string variable" you you mean just insert it into the title header? Thanks again.

Thank you for that. I am pretty sure i could do it within a form textbox but i an wanting to some some sorting and filtering too within a query. Is there a way to do this in a query expression? (using the GUI)

Right OK. I hope I explain this well.:banghead: I have a large table of customers that all have a postcode. I have 4 training centers in the country and i want a function that would suggest the closest center for them based on their postcode. What i have done is created another table with the...