Search results

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

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

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