Search results

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

I have tried the dlookup feature using the code dlookup("[TheFieldIWantToFind]", "TheQryItIsIn", "[ID] = me.currentRecord") I am expect it to return the value in [TheFieldIWantToFind] when the currentrecord number = the Current ID thus only returning one result. Do you think i should be...

I am so nearly there. I just need a bit of code that will replace the value of an unbound text box with a value from a different field of the current record. THis code is then run by a oncurrent event. Just stuck!....

It is very difficult to picture what your spreadsheet looks like. Is the spreadsheet separated into suitable columns? Do we need to split certain data separate columns first? It sounds like most of the work needs to be done in Excel first.

I have a main tabbed form of which the data is selected by the query as i have many different search parameters / criteria avaialbe on screen or inside the relevant tab. The user identifies the learner in question and chooses the tab where the marker can check off what has been marked or passed...

OK I will try and be a bit more specific. There are 15 tasks within a course. For each task I need to see who marked it, the grade and when it was last marked. On the main master form you will just see the task number and it will contain a simple code only. When the user clicks on the task code...