Search results

Thanks recyan - I've tried it and got the same result again. Query works when I select any process except 'ALL PROCESSES' from the drop down box. I have a couple of spin buttons that have also stopped working....I'm thinking perhaps the munchkins have corrupted my DB. I forget how much fun...

Within the query criteria - sorry, nothing worse than a poster that doesn't give you the info you need! It's just started returning the error (on form open) - MS Access database does not recognize '[Forms]![frmModelling]![cboProcess]' as a valid field name or expression. Which is strange...

Hi Bob, The records are shown on frmModelling in a listbox, which I requery after cboProcess is updated. Cheers, Rob

Hi all, Sorry, this should be a simple answer. Have searched this forum and the web but have not been able to find a similar example. Here is my criteria - IIf([Forms]![frmModelling]![cboProcess]="ALL PROCESSES","",[Forms]![frmModelling]![cboProcess]) If cboProcess = "All Processes" show all...

Thanks - I get it now :-) Thought you had misunderstood the question, I had just misunderstood the answer! Appreciate your help :D

Thanks CazB - sorry I should have been clearer. The custom value does not come from a table/query - it's just a string (or multiple text values) that I want to specify. I could a table to house the data....but it seems pointless if there is an easier way? EDIT: To make it clearer, what I want...

Hi all, It's been several years since I last did anything with Access. I'm trying to find my feet again so please bear with me :D I have a basic SELECT DISTINCT query for my CBO rowsource. Is it also possible to add custom values to the rowsource? i.e. I'd like my CBO to look like...

Hi all, I'm hoping someone can offer me some advice on performance for a FE/BE database that will eventually be accessed by up to 60 people during the same day (usually only 3-4 people searching/writing at same time). The system is to process complaints at a call centre - built from the ground...

Hi all, Yesterday my database crashed. It is the 'DEV' version for my application - so all of the current fixes/changes are in there and I have forgotten to backup! It crashes when ever I try to enter the VBA editor, or build code. This occurred after a minor problem running some code (I...

Hi all, I have listbox based on a query and a textbox. When the user keys any value into the searchbox, the results of the query filter based on the value using a 'LIKE' query. I have been using this successfully to filter information based on either the first name or surname of clients. I...

Always the way....as soon as I post I figure it out :) PSOutstanding = DCount("*", "tblEnquiries", "[Owner] = '" & strPS & "'")

Hi all, I have scoured the net and these forums....although there is plenty of information on DCount I can't seem to find the answer to my question so thought it was time for a post. I am trying to get the following to work - PSOutstanding = DCount("*", "tblEnquiries", "[Owner] = strPS") or...

Hi all, I have read much about disabling the mouse scroll bar - but my problem is that while I want the use of the scrollbar, it is very jumpy. Does anyone know how I can control the functionality of the scroll bar? Cheers Robert

I am indeed using a combination of Access and Brio (actually Hyperion - which I believe is the latest version). I have not been able to find a way to get my data to Access directly, but am using the following process that may or may not help you - 1. BRIO emails a daily report automatically...

Hi Stevie, Assuming you have a control on your form that contains the client ID - eg a text box - pretty sure you can just put a criteria in the expression - [ID] = Forms!MyForm!MyControl Then when you click the command button, your query criteria will filter the results based on the user ID...

Champion! Thanks :)

Hi all, Just wandering if this is possible within vba by clicking a cmd button. 1. Import a spreadsheet into a new table (tblTEMP) 2. Run a delete qry (qryDELETE) 3. Run an append qry (qryAPPEND) 4. Delete the table that was just imported (tblTEMP) If so, could anyone give me any advice on...

Thanks both for the replies...the cbo problem is all fixed up (cheers Keith!) - unfortunately for the input masks they are required - so I will have to try to find a way around my little problem. Cheers Rob

Hi all, I am at the tail end of developing my first serious database, a customer enquiry management system. It has been a very long haul - and a very steep learning curve for me! I have compiled lots of feedback from my users after some testing - and have a number of things I am uncertain...

Problem solved! :D It was a problem with the ADO/DAO references in Access 2k/2k2. Instead of using Dim rs As ADODB.Recordset I needed to declare them explicitly as - Dim ADOrs As ADODB.Recordset - or DIM DAOrs As DAO.Recordset Just using 'rs' causes some conflict. More here -...