Recent content by netsmurph

Jo Many thanks for your reply - I have tried this and have ensured that these are enabled, but no dice! I am sure it is done using vba code, but cannot see where in the beast it is done! Will keep on searching! A

Ive been asked to make some changes to an access app developed over the last couple of years (and of course without any doco). One simple request was to make max/min & close buttons visible. Have enabled them on the form properties, have tried a number of different functions to reset this...

Thanks for your reply - I have looked at the split function and understand that i can use it to take my values into a 2D array - can i simply call each value from the array from a query via a function? If i know the file number i guess i can pass this into a function which can validate if it is...

I am working on a database designed by someone who was put on my planet to make everyones life more difficult (or maybe he/she wanted to remain employed for life!). The database is a hash of complex coding to get around poor database design with regards to tables simple rules of normalisation...

Sorry - you are right, it is not populating the list box, but marking the entries as checked or not. The reason for this is so that the list box selection is effectively stored in memory so that one a user has selected their entries for analysis, they do no need select them each time they open...

have taken over on a project making enhancements to an auditing tool. It has one module that takes in stock entries and loads values into a list box to "remember" the last selected list. The code being used to popluate this list box on form load is below, but it takes an absolute age (maybe 60...

Sorry - posted this into the wrong forum - will post it into VBA forum

I have taken over on a project making enhancements to an auditing tool. It has one module that takes in stock entries and loads values into a list box to "remember" the last selected list. The code being used to popluate this list box on form load is below, but it takes an absolute age (maybe...

Many thanks both of you they both work - knew it was possible, but couldnt get the syntax right! Andrew

I have one query that is a counting the number of duplicate records where the date, amount and accNo are the same. The sql for this query is: "SELECT Sum(1) AS [Count] " & _ "FROM " & m_sAnomaliesTable & _ " GROUP BY [amount] & [date] & [accno] " & _...

Many thanks Zion - this was useful - what i realised was that the main form has been designed with tabs with related controls on each one - by clicking on the dropdown in design view - this brings up all of the controls for that tab! Makes life a whole lot easier! Thanks for your help Andrew

Zion7 Sorry for the delay in responding - this code is helpful to get a list of all of the properties on my form. The problem is that there are 577(!) on one form and what I really want to be able to do is see which of these controls have event procedures associated with them. Do you know if...

No - it is open in normal view (but if you right click on it properties is greyed out).

I am taking over a project to modifiy an existing ms access db. It has been designed nearly soley using code to manipulate forms and associated controls. It is proving hard to unravel it as there is no doco and objects are not named consistently. I need to be able to bring up the...

Remou Many thanks for your reply - am currently investigating. I have also found a 3rd party vba dll that allows Access to talk using telnet session - may be just the thing. Andrew