Search results

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

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

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

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

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

Hi there, I have a form that uses ADO to create a new record in a table. I have used the form successfully throughout the development of my database (with Access 2003), but am now having trouble with earlier versions. I get the following error - -2147352571 "Type mismatch" when attempting...

Hi all, Just looking for a little advice on data protection. I have a split database which is accessed from the front end (forms only). All data is stored on the back end, which is hidden away from the user. The database is password protected, and both sides use a login authentication to avoid...

Hi all, Just looking for a bit of help with hyperlinking on a form. Basically, I am adding a 'read more' function to a quiz program I am writing. I have a label simply called 'Read More' that sits on the form. I need to set a hyperlink to this label, that is looked up from the DB as the...

Hi all, First of all....my first access database and I'm still a VB newbie...so my apologies if this is a stupid question. I tried searching the web and this forum but could'nt find what I was looking for. Basically, I am developing an authentication script for a training tutorial. The user...