Search results

I have a small stock control database built around a Northwind example. I am trying to build a query that displays items low on stock. On my products form I have: Min Order Level field (stored value) Units on Hand (calculated value from products subform (units received-units sold)). Q1: Do I...

Hi, I am trying to integrate the excellent search facility (search multiple fields example) posted on this site by OldSoftBoss http://www.access-programmers.co.uk/forums/showthread.php?t=123219&highlight=advanced+search When I re-create it in my db, it all works ok until I double click on the...

Hi, I am a vba novice and in need of expert advise/suggestions: I have a products database. I wanted to show an image of the product (that users can update) on the form. The example used in the Employee form of the Northwind database fits my needs perfectly. I have copied/pasted all the code...

1 Subform record displayed in report Hi, I have a form (see attached image) that contains several subforms. I want to create a report that will display the info displayed in the current record. I can easily create a report to show all the details on the left of the image eg: company name and...

Currently my design consists of a table for customers and a table for suppliers. At first it seems logical. Or so I thought! As my design is evloving I have noticed a problem. What if a supplier calls and says "I want to purchase a..." they then also become a customer! Obvoius I know but do I...

The company I work for uses A97 throughout. Although on my laptop I have Access 2003. I want to design my inventory control database using A2003 not 97 for obvious reasons. I know A97 users cannot open a Acess 2003 db. My Q is: If I created a A2003 db and also built some data access pages...

Hi, I am building a stock control database. I have a form called [products]. On this form are two fields. One called [ProdReorder], the other [UnitsOnHand]. [UnitsOnHand] is displayed form a subform called [ProductsSubform]. What I want to know is: What code would I enter (& where) so if the...

Hi, This may sound like a real stupid question but here goes.. I have a customer comments page on my website and want to send out a "how was our service card" to my customers with a link on it. The web page I want them to visit for example is: www.mywebsite.co.uk/webpage.html I don't want my...

Hi, Most of my customers can use multiple addresses eg. Head office/delivery and invoice etc. I am looking for a way to display them easily without using the nasty Record selectors in the subform (see attached "current.jpg"). Datasheet mode looks poor too so if I can avoid this I will...

Just found this on the net http://www.ability.com/sales/products/database.php?ln=uk An alternative to expensive MS Office? Its about time. Has ayone used it? Is it any good? Is Ability Database (£20) a viable alternative To Access. I imagine old Bill is a little ticked off!

Can anyone see any obvious problems with this script? It is ment to process my web page form. If I fill out the form and sumit it, the thanks you page works, but I do not receive the mail. have tried using different mail addresses so not a problem there. any help would be great:)

I have read quite alot recently on Normalisation/relationships etc. I am building a customer service db (to replace a huge flat file db) to keep track of all our customers. For each customer I want to record information about repairs to their equipment, calls etc. I have however come a little...

Hi, I have looked through every book I have and spent hours on this but just cant get it right. On the "menu" tab, select a customer then go to the "Calls" tab. Within the top subform is the list of telephone calls. In the below subform is the detail of the calls taken. The problem: When I...

Hi people, I have an existing stock control database that has evolved over the years from the "Inventory Control" sample supplied with A97. We (until now) supplied spares from one manufacturer. The spares items list was provided to us in an excel sheet and easy to append to a Access table. We...

Database structure - it's not as easy as you make it look! Good afternoon all, Really struggling with my structure and have been looking at it for so long my head hurts so any advice would be great. (see attached) Basically, I want a DB for keeping track of service / repair of electronic...

Hi all, I am on my way to building my first relational DB. Is anyone able to look at the attached sample and tell me if I am on the right track? The DB is being desined to record Repair information carried out on a machine. (TblRepair) The DB will also eventually record refurbished machines...

Hi all, I have a subform within my form for quotations (see attached). A user will manually type in "Repair Cost" and "Accessory Cost". The subtotal field is calculated using this expression =Nz([Repair Cost])+Nz([Acc Cost]) in the Control Source box This is all Ok. I want to subtotal these on...

Good afternoon all, I have a A97 Db. On one of my forms (see attached screen pic) I have a field "Payment type" for either Cheque, card of Account. There is no code or functions behind it, it just stores a value. Trouble is my users keep forgetting to fill it in! My first (and easiest)...

Hi all, Does anyone have a definitive list of reserved words in Access? I understand certan words are reserved because they cause a problem when using vba. Is this correct? It would make sense because I used to have a field called "Name" and my controls never worked correctly. I have since...

Hello all, I am in the early stages of building my 1st relational database (see attached). Ones I have built in the past were built on a knowledge of the sample ones provided with A97. I have since realised (from this excellent site) everything I have done in the past was completely wrong! One...