Recent content by Danny B

This has probably been asked MANY times before, but I can't seem to find a thread on it. Right. I have a table with fields in it called 'Current Stock' and 'Stock Used'. I don't know how this happens, but I want to enter a number (via a form) on 'Stock Used', and have that number deducted from...

Ok, this is going to make me sound really stupid. When any query-based form which reqiures a user-input parameter runs (i.e. searching for a name or something similar) it brings up a parameter box. If a user decides they then do not want to open this form, and clicks on cancel, how can I make...

Hey all, I'm designing a database that tracks conveyancing cases for a local solicitors. They want to be able to mail-merge client names, addresses etc in to template letters (already made). However, the only way of doing this that I can find is by selecting the table, then choosing mail-merge...

OK, this is the current code for the query run by the combo box: SELECT tblEstateAgents.EAgentID, tblEstateAgents.EAgentName, tblEstateAgents.EAgentTown FROM tblEstateAgents ORDER BY tblEstateAgents.EAgentName; Now, when I click on the combo box arrow, it still displays the ID number and not...

Hiya, On one of my forms, the user is supposed to select an Estate Agent (the database is a conveyancing properties system) from a pull-down combo box. At the moment, the combo box displays the ID number of each estate agent, since that is the unique key for tblEstateAgents. However, I need it...

Hey all, I posted a few days ago in an attempt to try a find out how to display a 'No records found' message when a query turns up no criteria-matching results. I got two replies. Unfortunately, neither worked for me (although I'm sure it did for them). Basically, a form (displaying the...

Right, sorry about this but I still don't understand. I'm designing a database to track conveyancing cases for solicitors. All I want to do is open the central form from the switchboard. This central form is opened by clicking on a command button (is this the 'event' you mentioned?) which runs a...

Uh...I hate to sound stupid, but I'm not entirely clear on what that means. I put in the if .recordcount <1 then msgbox "No records are available" line of code (although I had to take the period out), and a message box pops up saying 'no records are available'. Problem is, it comes up with...

Hey y'all. I'm trying to do a database for A-Level coursework, and I can't find anywhere how to get an error message to appear when a user type information in to a parameter box that is not matched in any records. It must be really simple, since many people must want to do it. All I get is a...