Recent content by NeoNemesis

Cheers mate, will try it out in the morning!

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

40 is valid as a computer can have two chips, one 32mb and one 8mb chip in it, together make 40mb.

eh? Any chance someone could write the expression for me...pwetty pwease!

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

Thanks, i have it sorted now: Private Sub MaxLicenceNumber_AfterUpdate() Dim i As Integer Dim turn As Integer Dim curdb As Database Dim strVal As String Dim SQLSTmt As String Dim PackageID As String PackageID = Me.PackageID turn = 1 For turn =...

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

Can anyone out there lend me some help?? Please?!

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

The parent - child relationship stuff.

Thank you for the reply, is there any chance that you could expand on that a little bit. I have trouble understanding the database theory concepts.

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

Private Sub Max_Licence_Number_AfterUpdate() Dim i As Integer Dim turn As Integer Dim curdb As Database Dim strVal As String Dim SQLSTmt As String Dim PackageID As String turn = 1 For turn = 1 To Me.Max_Licence_Number strVal = GetLicenceInc(turn) Set curdb = CurrentDb() SQLSTmt = "INSERT INTO...

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

Im sorry, i feel so stupid, I am trying research on the side in an attempt to get this to work but i just cant. It appears that everything is ok, but evidently it is not. What do you mean by the provision in your routines etc.? Neo