Search results

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...

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...

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...

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...

Good afternoon all. Here is my question. I have a query with 60 fields retrieved. Ideally I would like to see all 60 columns for every person in a continuous form however this is too unmanageable and besides, the access has a width limit of 22inches. I did think about using a tabbed form...

Good afternoon all. I am seeking assistance with a more complex query that maybe needs nested iff statements. I will try and explain the scenario. This all works / background My main form contains simple data about a customer. When the user clicks on the communications tab there is a sub form...

I am quite new to VB coding but I do understand some of the basics. I want to create a loop that checks the value within 8 text boxes and enabled a tick box next to the respected text box if it not blank. I am not quite sure on the syntax. I have 8 text boxes called Textbox1 : Textbox8 and 8...