Search results

  1. N

    Getting Started

    I am creating a database in Access to store all of my customers that I do business with and also storing all the details of the visits that I make to them. I am planning to add bits extra to it after the main bulk has been done. Currently I have two tables as follows, Customer Details...
  2. N

    Multiples of 8

    I have created a database which catalogues computers and their components. I thought that a good validation rule for the Memory field. The only problem is that I dont know the expression to use. So.. what expression do i need to only allow numbers which are multiples of 8 eg, 8, 16, 32, 64...
  3. N

    INSERT INTO help

    I have the following code in my access project which takes a string (PackageCode) from my tblPackage table, and uses a loop to insert this string with a numerically incrementing suffix. The loop loops to the value in MaxLicenceNumber. EG. If PackageCode = MSE00 and MaxLicenceNumber = 4 then in...
  4. N

    VB and Table help

    First let me outline my problem. I am creating a database that will catalogue all of the computers at my office. It will also catalogue what software is installed IN them and what Software is installed ON them. I am having no problems with the hardware side of things. The software is a...
  5. N

    Inserting and removing records

    Hi, I am a complete novice when it comes to VB coding. I have managed to cobble together the following script so which adds records into a table called "LicenceTable". The problem. I am creating a database that will (hopefully) be able to catalogue the Software Titles that my company has and...
  6. N

    INSERT INTO not inserting

    I have had a lot of help cobbling together a script which is designed to perform a solution to the following problem: am making a database system the will catalogue all of the software that a company uses. There are many software titles, such as MS Word, MS Excel or WinXP. As this company wants...
  7. N

    VBA Newbie, please help!

    I have got a little bit of a problem, one that i would like some help getting my head around, it involves MS Access 2000 and its VBA.... I will attempt to explain it properly. I am making a database system the will catalogue all of the software that a company uses. There are many software...
Top Bottom