Search results for query: *

Hi, I have three fields: Currency, Cusip and Balance. I group by Currency and Cusip and sum the balance. I want to select the top 5 cusips and their respective balances per currency. Can you do several Top 5's in the one sql statement without having to do a union and a whole lot of select...

Hi, Ive written a simple module which I now use to log any errors that any event may trigger. Option Compare Database 'Provides simple error logging facilities Public Const strLogTable As String = "tblErrorLog" Public Function logError(ByVal strObjectSource As String, ByVal intErrorNumber...

Hi, I have created a user log by adding the users system ID to a table when they log in and deleting when they log out. The code that I used for the user ID is This code was originally written by Dev Ashish. ' It is not to be altered or distributed, ' except as part of an application. ' You...

Hi, I have an access database which is workgroup protected. The default user does not need a password. When the default user attempts to access an ODBC table via VBA access prompts them for their login and password as expected. For the users which enter a password when logging in (amdin...

Hi, I have an access database which is workgroup protected. The default user does not need a password. When the default user attempts to open an ODBC table access prompts them for their login and password as expected. For the users which enter a password when logging in (amdin, desginer...

Hi, I have a query which matches up pairs of Ids from the same table and samefield based on certain criteria. Once a match has been found I can no longer consider those Ids for further pairs. To do this I need to know both of the ids from the prior row. I have written a module (only stores one...

Hi, I have a multiuser database which creates a daily log in a word file. If the log file is already open a problem occurs as the db does not have exclusive access to it. Can I force a file to close if it has been opened by another user ? On another note does access have an option to only allow...

Hi, I need to link to a table in an access database that I have secured with a workgroup. I open the database with a shortcut using the /WRKGRP. When I try and link to a table inside it I naturally get a "You do not have the necessary permissions" error. How do you get around this ? can you...

Hi, Ive been tasked with setting up an internal web page at work. Basically the page will allow modification of underlying data in an access database. I have never done this before and was hoping someone could point me in the right direction. As its internal all users will have office and ie so...

Hi, I have three summary fields in my report header, each has a label and a ytd and mtd figure. client mtd ytd txtSumOfSwaps_YTD mtd ytd txtSumOfListed_Derivs mtd ytd client always has non zero values for mtd and ytd. swaps and derivs dont. If swaps has 0...

Hey, I need to write a comprehensive design document for an access database that Ive developed. Ive written an SRS before but never an access design doc. Does anyone know any good standards to use or have any examples of a good access design document, are there any design document methodologies...

Hi, Im having a problem with form sizes. Ive developed a database with several forms. All forms are a full screen size with no scroll bars. The problem is that on some pcs the form is a lot bigger than the screen size and to view it scroll bars are needed. How do I develop forms so that they...

Hi, Im having some date issues. I have a database which several users use. Some have there regional date settings set to English, others to US. I get errors because on several forms I programmatically build filters and modify querydefs depending on the date. Is there a way in VBA that I could...

Hi, a colleague of mine is having problems with access automatically saving queries when they are closed, meaning any unwanted changes he makes to the design are saved. He has not turned any features on or off. I have never had this problem. Is there an autosave feature in access related to...

Hi, I just tried to copy a paste a list box and a few buttons. When I attempted to paste Access just quit without any warning. It happens every time I try and copy and paste more than a few objects at a time, Memory Problem ?? Thanks Mordja

Hi, I have a module which parses each row of an input table to see that it is in the correct format. Details of rows which do not conform are written to an error table for review. The module works great. One problem. The database is used by several different users, who access it on a common...

Hi, I have a daily process where I append a data set to a table. Following the append I mark the data set as having been appended. The problem is that If I turn warnings off, the append can partially complete. If a record is missing a required value it is not appended. However my update query...

Hi, Ive been wondering for quite a while if there is something completely minute that Im missing. Why when you change an object name (query, table etc) or an object attribute (field etc) does the name change not follow through. Every time you change a name like in a query, you have to go and...

Hi, I have a list box. Initially it's rowsource is a table query. I populate it then change its rowsource to value list so that I can make additions to it. This process is going to be run on the on current and load events of the form, I want it to occur for each record. Firstly Private Sub...

Hi, Is it possible to change the text colour of an individual item in a list box, I can only change the colour of all items. Thanks MOrdja