Search results

  1. M

    Hey Pat, i came accross a thread in which you talk about using RDP when using DBs over VPN. May...

    Hey Pat, i came accross a thread in which you talk about using RDP when using DBs over VPN. May i ask, what is RDP ?
  2. M

    Check where front end is installed

    I would like to be able to check whether my front end is being opened from the PC on which it resides or if someone is accessing it from a network. In other words, i want the front end to display an msgbox to a person if that person tries to access it from a machine other than the one the front...
  3. M

    Insert into field in current record

    Thank you sooo much, i see my error with the strResult, i had my dim incorrect. Works perfect.
  4. M

    Insert into field in current record

    thank you. I am getting a runtime error 3601 my code as follows: Table structure : Fields: ID;Activated;UnlockCode Id = number field (long number), set as primary key Activated and UnlockCode fiels are text fileds
  5. M

    Insert into field in current record

    Must be VB.
  6. M

    Insert into field in current record

    I would like to be able to insert data into a field in a table in an existing record. I need to be able to do this using VB, but am not sure how to. I know how to delete a record and how to add a record, but not how to modify 1 field in an existing table. Any help greatly appreciated.
  7. M

    Update to 2 tables

    Once a quote is printed a quote cannot be changed. Quotes must always reflect the original pricing as provided at time of quote. Should i need to reprint a quote for legal reasons, i will need to ensure the data is still what the client recieved. However, invoices can be adjusted after quoting...
  8. M

    Update to 2 tables

    One more problem with this solution : What happens if a client only takes part of the quote ? or prices change between the quote date and the invoice date. I need to ensure that once a quote is flagged as printed no alterations are made to prices etc. Should i then wish to change a price...
  9. M

    Update to 2 tables

    Also, yes the field are identicle except for a few extra fields on the invoice.
  10. M

    Update to 2 tables

    yes i have normalised the DB, primary keys and foreing kkeys, the whole shenbang. why i cannot use one table is because the quote No's and invoice No's must run in sequence and are not always the same, ie I may issue a quote but not make the sale, or i may make a sale without a quote.
  11. M

    Update to 2 tables

    I have 4 tables : tbl_Quotes tbl_Quote_Details tbl_Invoices tbl_Invoice_Details I also have 4 forms, 2 mains and two subs for the above tables. I want to create a button (Create Invoice) on the main Quotes form that automatically updates all the records for the quote and quote details to the...
  12. M

    2010 beta themes

    I have done a search for info on 2010 themes but no matches so i guess this is a new question, if not my appologies and a redirect to the appropriate thread would be great. I have an access 2007 DB that i am now working on in 2010. i cannot get any of the themes to work. I also cannot seem to...
  13. M

    Auto Install Front end

    No Acces to back end Hi I had a look at this utility. I have the problem whereby i do not have access to the back end. So i cannot change the "tbl_Version_fe_master" to the version number or the location. The back end is basically complete and I hardley ever make changes to the tables in the...
  14. M

    Auto Install Front end

    Hi I have created a split db for my father and his little business. Sometimes he asks me to make changes. I want to be able to email him the new front end, and when clicked, the file will install the new front end to the correct location along with any folders containing updated informatio...
Top Bottom