Search results for query: *

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

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

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

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

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] " & _...

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

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

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

I am trying to figure out how to automate a word doc to pdf without having the user to intervene. At the moment i have an app that open word tempates, populates them with data from an access db using vba. They are then automatically printed onto the correct prints (sometimes some editing is...

I am trying to figure out how to automate a word doc to pdf without having the user to intervene. At the moment i have an app that open word tempates, populates them with data from an access db using vba. They are then automatically printed onto the correct prints (sometimes some editing is...

I have a access db that is getting data by executing pass thru queries to documentum (Oracle database). This is executed in a vba procedure, which joins a few separate tables. If I open access and run the pass thru straight away it works 99% of the time successfully. However, if I run it...

I have an Access db that uses vba to select type of printer to print word documents to (letterhead/duplex/etc). Recently the server has been upgraded to W2k3 and the code does not select the correct printers. I made sure that the printer names were left the same and thought that all that i...

I have a database that uses linked tables and linked text files. At startup I need to relink the tables to tables/files in the same directory as the application db. The procedure runs fine if run the both are executed separately or together (in one macro), but if I put one or both into an...

I have been asked to investigate whether a document updating system written in MS Access could be used on a much larger project and think it may push Access to its limit. I was hoping to get some impartial advice based on any experts experience with similar projects: The main document...

I have got the standard windows file dialog API: (This code was originally written by Ken Getz) I need to set it so it display images as thumbnails. Does anyone know if this can be set with this function? Thanks in advance. Andrew

I am trying to update a field within a linked table, but get the error message: "Operation must use an updateable query" I have a table (tblPOline) that is linked, and my update query is using another nested query to "filter the records that need to be updated. The SQL is: UPDATE...

I have a form (continious style) that is bound to an uneditable query. What i want is for users to be able to select one of the two radio buttons which will allow them to edit one of the fields (which is unbound, but will update the appropriate table on update of the record). My main issue is...

I have been issued with the challenge of creating a procedure to take data from one database and effectively split this into separate mdbs. I have written a procedue to create the appropriate tables in the source db and export them each to the destination db. The issue i have is that the...