Search results for query: *

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

I am trying to automate access to invoke a 3rd party application and am trying to figure out what commands can be sent via tcp. Is it possible to script hyper terminal or telnet commands to start up this software using vba. Does windows have a default telnet utility or are there any free...

I am new to matrix reporting, andam trying to recreate a piviot table report with counts of number of documents by location, pivoted against doc type (horizontal axis). I have created this ok but there are two outstanding issue; firstly i cannot get the group total to diplay at the bottom of...

Thanks for your reply Ed, In answer to your questions: The bandwidth is being looked into with the network guys - pretty sure the server has a 1Gb network card, although it is a very overutlised server that many users are connected to as a file server. There are approx 20 tables, with the...

I have a large access db, which is around 170Mb compacted. It is split into front end backend. The backend is on a server. The performance has decreased drastically - if more than one user is accessing it. (ie a basic search takes around 15 seconds as opposed to 2 seconds). I am trying to...

I have an access database which i have set up linked tables for the front end. I have a query that is appending to a table the records from a large union query. This part of the procedure worked fine, but now using linked tables it comes up with the following error: Reserved error...