Search results

Hi I am new to using Access 2000 and have created a database for stock control. I would like to be able to order stock when the stock levels fall below a certain amount. I have a field called "stocklevel" and another field called "minimumlevel". When the stock level falls below or is equal...

Hi I am new to using Microsft Access 2000 and am experiencing problems using entry validations:- 1. Field Name Visit Date - entries only accepts current year e.g. 2003 2. Field Name Visit Time - only accepts times between 09:00 - 18:00. 3. Field Name Contact Name - First Character of...

Hi, I am new to using Microsoft Access 2000 and VBA and I want to create a global function (procedure) so that the user has to type in a password to access the database. Any help with my problem would be much appreciated.

Hi, I am new to using Microsoft Access 2000 and VBA !! I have created a database and a Switchboard. On my Switchboard I would like the user to click on the link on the Switchboard that would take him to a page of documentation regarding the database e.g. How to add records to a form etc. Can...

I am new to using Access 2000 and VBA and I require some help in my project which I need to complete by Wednesday 8th January 2003. I need to add three Sub Procedures or Functions to a Form Module and one Sub Procedure or Function to a Global Module. The database tables and forms that I have...

Hi , I am trying to write a Select Case program using vba. I am using Microsoft Access 2000. Below is my program that I wrote so far. Private Sub ProductID_BeforeUpdate(Cancel As Integer) Select Case ProductID Case "am" SupplierID = "1" Case "kk" SupplierID = "2" Case...

Hi, Merry Christmas Everyone !!!! I am having problems with a Combo box which I created using the wizard. The problem is when I select a person's name from the list form of the combo box information from another field the SupplierID is displayed in the contacts field. I have a separate field...

Hi I am new to using Microsoft Access and am having problems with creating SQL query using the yes/no field. e.g. list of people who have not paid their subs :-- SELECT managersname,team,fullname,address,telephoneno,subspaid FROM Players WHERE managersname="Joe Bloggs" AND subspaid="No"; Using...

Hi I am new to using Microsoft Access and understanding VBA. I hope someone can help me on my two problems with VBA in Access :- 1. I have two fields in my table Age and DateofBirth and what I would like to do is calculate their Age when someone inputs their DateofBirth. The calculation is...