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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

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

Part and Inventory Search

Back
Top