Search results for query: *

Hi, I'm working for an organisation who have a quite stringent IT policy which effects ActiveX and in turn disables some the built in functionality of MS Office. I have got work arounds for most things I need - however I need to process a lot of spreadsheets of different sources through MS...

Hi I am simply trying to open a form with the following but I have tried all sorts and cannot get the syntax right. stLinkCriteria = [Exclude] <> 0 The Exclude is a yes/no as a tick box and all I want it to do is show all records with a tick - I would get round it by entering the criteria in...

Hi I obtained code to help me with this, but I cannot get it work as the backend database is locked when it tries to run the compact and repair. It will close all forms but the backend .ldb file is still resident while the code runs even after all forms are closed therefore moves to the error...

Hi I have a form that has a list of records with a button next to each for checking data linking criteria to another form. Once the user is happy with the data they return to the form and click a checkbox on that record. I have a release button at the top of the form that I want disabled until...

Hi can someone advise what is wrong with the following - I have fiddled with it and just cannot get it to work. Private Sub cmdViewTxns_Click() On Error GoTo Err_cmdViewTxns_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmKE5ZList"...

I have an append query to populate a table from a couple of key reports in excel - it performs a few calculations and lookups during the import. Everything imports as it should but there is one field that does not get populated. The data shows on the query preview, but does not transfer to the...

Hi, I can find information to share calenders with Exchange accounts and publish online aswell as sending snapshots via email. Is there a way to simply share with other user profiles on a standalone machine running Vista? Thanks Richard

Hi I have a database to analyse financial data by month/period. I have a main data/transaction table (increasing by avg 20,000 records each month) which looks up various details from other tables and performs quite complex calculations to produce end of month reports for cost deferrals to the...

Hi I added the following into the Click event of a command before the Exit Sub If RecordCount = 0 Then MsgBox "No records found?" DoCmd.Close End If It works but will also return the msgbox and close even when records are found. Please advise. Many thanks

Hello I have a project to process a lot of financial data and produce reports for each period (and overall) in a financial year. Loading the database with a years worth of data pretty much puts it to a max capacity, but where it still performs efficiently - therefore I have decided it best to...

Hi I have a set of data where the the first column header is a reference to respondent names (Respondent ID) and all the other columns are references to questions, ie Q1, Q2, Q3, Q4, etc. The data under these question headers is the response to that question from the respondent, which will...

Hi I have a form with a list box showing a lot of records. I have set up a text box to enter start of field data to requery the list box and reduce the matches. I can get this to work fine with a seperate button with a requery macro on the OnClick event. But is there anyway that I can get the...