Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by NeoNemesis

  1. NeoNemesis

    VB and Table Structure

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

    INSERTing and Removing records

    Thanks i found it in the end. I appreciate your help greatly. I understand why i have to break that code up. Do i have to break it up wherever it appears in the database? I am assuming so. Can you lend me any help with the coding, i hope that you can code as well as you can teach database...
  3. NeoNemesis

    INSERTing and Removing records

    The breakdown of the Key is MSW [Microsoft Word] 00 [2000] 1 [I dont actually know why i put the one on...maybe that should go] 001 [the licence identifier] Ok so the breakdown is now MSW [Microsoft Word] 00 [2000] 001 [Licence Identifier] The extra "1" did break up the zeros...
  4. NeoNemesis

    INSERTing and Removing records

    Ok i think i know what you are getting at. In the LicenceTable i have these fields: ProductID Autonumber and make them composite keys. so i will basically have my MSW001001 just spread out into two fields?
  5. NeoNemesis

    INSERTing and Removing records

    I have to have these details collected together because they are creating a unique identifier for each Licence. I just decided that the ID should not just be a random code.
  6. NeoNemesis

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

    INSERT INTO, isnt!

    Goodness me, this is going to be far more mammoth than i first thought. You seem like you know what you are doing and i am a complete amature that has unfortunately been thrown in at the deep end. I hope you dont mind if i pick your brains further?
  8. NeoNemesis

    INSERT INTO, isnt!

    PaulBricker: Thank you very much! At least i can see how the code inserts things into the table. It doesnt insert what i want it to as yet but I will try to develop it. If i need any more help then i know where to come!! cmmrfrds: So by saying this do you mean that for each seperate Software...
  9. NeoNemesis

    INSERT INTO, isnt!

    I have substituted the piece of code that you wrote into my script so it looks like this... Dim turn As Integer Private Sub Max_Licence_Number_AfterUpdate() Dim curdb As Database Dim strVal As String Dim SQLSTmt As String Set curdb = CurrentDb() For turn = 1 To nMaxLicenceNumber strVal =...
  10. NeoNemesis

    INSERT INTO, isnt!

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

Part and Inventory Search

Back
Top