Dear all, I have designed a database with a Receivable Table and a Payment Table to keep track on the rental income and receivable. The Receivable Table is...

anyone know how to have one field for say author and then swop the text round as in enter john smith and save and display as smith, john

I have fields set up as 'Title' and 'PubDate' there can be many pubdates for the same title, i would like to be able to pull off/quiery and report showing...

i am trying to select critiria using the event procedure behind a button (visual basic/access basic?) i have 3 fields for the user to enter requred criteria,...

I have the following code which checks the ISBN check digit to ensure a correct ISBN no is enter for a product. This works fine, however, if the user enters...

i am using two tables on one form, one table being a subform of the main form. i need to be able to fill in a record on the subform from a record on the...

I have created a Database in Access 2003 in which I have created a report that i would like to have automatically emailed - using an email address field....

i have exported some fields from a database to excel using a query and a macro, one of the fields is set up as a memo to allow the user to enter title blirb,...

I'd like to supress a system message ie 'unable to copy record due to duplicate unique key' or words to that effect, and replace it with my own message telling...

i need to set up a report based on the user selecting (from a select list) one or more options from the same field - ie 'Enter Licensor/s Required' and have...

i have a query which selects from my original table all with a price of zero. this is then passed to a form to allow the user to enter a price. after this...

i'm trying to convert a currency field ie £125.00 to a word field ie one hundred and twenty five pounds, anyone know how to do this please. found something...

i would like to be able to move focus to a field depending if another field is ticked. i can do this on the same form but can't get it to work with a...

i have created a database which has huge table, i need to add more fields to this table (really does need to be in the same table as i have some very complex...

Do you have a copy of a Microsoft Access 2003 DB for the Construction Business?? I would like to use it as a template for my business.

Hi, I recently wrote a Screen Scrape for Microsoft Excel, but now my job requires me to change the same Screen Scrape Macro into an MS Access Screen Scrape. I...

Hello all, let me give you a small bit of history. I designed a MS Access 2003 Database that would allow tracking attendance and provide easy reporting....

I have created a database that holds information about different land properties. It holds such info as location, owner etc. Now I need to include information...

I have implemented a combo box lookup on a dealer name. When I select an individual dealer, I want his Account number and address to be automatically inserted...

I have two tables (tblClients and tblEmployees). Field in tblClient uses the PK of tblEmployee as a lookup. Currently, the PK is a text field containing the...