Search results

  1. C

    Question general question

    one table is approx 25000 records, and at the end of each session it has to put records in two other tables payment and credits, generally messes up doing this. because of the amount of the update.
  2. C

    Question general question

    I recon i can, but I want to create a new database from scratch. will import tables as required. Wot im looking for is a way to do, when a job is paid for, at the end of that year when i run a year end it takes the completed jobs, creates a new table "eg jobs 2010" and moves the record here. but...
  3. C

    Question general question

    standard enough tables, there are approx 30 tables not sure wot u mean about front and back end, I tried to import the database to 2010, just kept corrupting database, button didnt work etc. I want to remake the software to have additional functionality, emailing linked to word etc. also there...
  4. C

    Question general question

    the database was created in 1998 the company is doing a repair and compact on a regular basis the size and of the database is approx 160,000 kb there is a small bit of code running, helped with decimal point with 17.5 rate of VAT
  5. C

    Question general question

    I made a database years ago for a local company, it is slowly dying. It has approx 30000 invoices, and more or less the same in clients and jobs details. I have been instructed to make a new database to do the same thing but in the latest version of office. the main problem is the number of...
  6. C

    new form with data from a previous form

    Table "tbla" "tblcntcmpynme" Field "flda" "cmpynmeid" Long Integer Form "frma" "frmCntCmpyNme" Table "tblb" "tblCntCmpylctn" Field "fldb "cmpynmeid" Long Integer Form "frmb" "frmCntCmpylctn" frma is already loaded with data displayed and I need to Load Frmb and put the value from cmpynmeid...
  7. C

    new form with data from a previous form

    I have a Table and a form "a" with a contact ID Field with various fields displaying various information about the names of a business. I want to open another form "b" from the original and input address details about the contact. When the second form "b" opens i need the contact ID field to be...
  8. C

    total of an invoice to a table

    invoice information each line of the invoice will have date wash--washset--cut--perm--water_colour-- mens_cut"or similar" 1-12-06 6.50 0.00 0.00 0.00 0.00 etc 12-12-06 0.00 5.00 etc there is a total at the end of each line and then a total in the...
  9. C

    total of an invoice to a table

    I would like to create a table which stores the of all an invoice. at the press of a button. I want to use this to see how much I am Owed
  10. C

    value from a main form to a sub form

    I have a main form that has a field name client id with a value from the client details table there is a subform on this form which is linked by the invoice number. When i create a ne record the invoice number is copied into the new record but the client ID is not. Can this be fixed I have...
Back
Top Bottom