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, Rob, Thanks for your reply but I was wondering if there was VBA code that I could use to do the same procedure.

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

Functions & Modules Hi, I have managed to sort out my problem concerning searching for a record by clicking on a button. I had to make sure that Microsoft DAO 3.6 Objects was selected from the Tools then References. Private Sub FindRecord_Click() Dim rst As DAO.Recordset, strCriteria As...

Modules & Functions Hi, Thanks for the feedback !!! The code that I used was when I did a search on 'bookmark' on Microsoft Access 2000 help, and adjusted the code for my database. I created a button called "FindRecord" and copied the code. So why does the code not work ?

Modules & Functions Hi, The part which was highlighted when I clicked on the FindRecord was FindFirst. Regards,

Modules & Functions Hi, I am using Access 2000 version. I decided to use the following code to search for a record in the Players form which contains the following fields :- Players :- PlayerID,FullName,MemberID,Team,Address,PostCode,T elephoneNo,MobileNo. I created a button called...

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, It worked !! Thanks for your help !!

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, I have managed to sort out my problem with Combo Boxes. I hope that everyone had a good xmas !!:)

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

Date Calculations Hi Shay, Thanks very much for your help with this matter. The code that you gave me has now worked !!! Much appreciated for your help !! HAPPY CHRISTMAS !!!! :) :p

Date Calculation query Hi Shay, I am running Microsoft Access 2000 and tried the same code that you sent me and it came up with a compile error : syntax error. Maybe the code is slightly different in Access 97 to 2000. What a pain in the butt if it is !! Sorry I couldn't be much help, but I...

Date Calculation Hi Shay, I have used the VBA that you sent me and unfortunately it does not work. The result was a syntax error. DateDiff("yyyy", Me.DateofBirth, #9/1/02#) - IIf((Month(Me.DateofBirth) >= 9 And Day(Me.DateofBirth) > 1), 1, 0) The DateofBirth field is formatted to short...

H Shay, Thanks for your help with this problem. Yes your reply worked. Much appreciated. MERRY CHRISTMAS !!! :)

re help in VBA in Access 2000 Thanks for your reply !! I have managed to solve my 2nd problem but still need to resolve the date calculation. I need to keep the date constant because I need to know the age of the player at a certain date which is 01/09/2002. I have used the following VBA in my...

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