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 avivit

  1. avivit

    menus and javascript

    Hi, I found a great menu, but encountering a probelm when trying to In order to use the menu, I have to include the javascript file from each page on my website (unless I misunderstood): <script language="JavaScript" src="menu.js"></script> and some other js files as well. But when I insert it...
  2. avivit

    Copying a record, before deleting it

    Thanks. Two questions: 1. How can I know (and keep) what is the CURRENT primaryKeyField? 2. As far as I understand, this will copy the fields from the form, and not from the table. One of the fields I have to copy is a field that only exists in the table, and not in the form (ID=AUTOnumber)...
  3. avivit

    Copying a record, before deleting it

    Hi, I would like to copy a record to another table, before it is being deleted from a form, to a 2nd table with all it's content. Of course, only when the deletion is confirmed by the confirm delete box. I would like to use VBA for that. I guess I need to use the event...
  4. avivit

    cursortype and locktype parameters

    Terrific so far. Tarwn , Following your instructions, I used the following, in order to avoid opening a recordset to a perferct results (so far): sql update query (lets call it "sqlUpdate1") another sql update query (lets call it "sqlUpdate2") insert query (lets call it "sqlInsert")...
  5. avivit

    cursortype and locktype parameters

    Thanks, 1. I will check the execution part. 2. I still do not want to write directly to the first database, as there are more than 1 people handling it. And that database is in great use by many users. 3. As for excel, I can visit once a month of course, it looks the easier solution. I...
  6. avivit

    cursortype and locktype parameters

    Thanks for approving to abuse the db. :-) Actually I can not use one update, as I should update more fields that just the hits in one of the cases, nlike in the other case, but thanks for showing the syntax, I may use it someday. I guess I can not check if the update query updated anything or...
  7. avivit

    cursortype and locktype parameters

    Ok. I appreciate you help very much. I have learned a lot. 1. I use total hits. 2. the first database holds all the links that are displayed in the asp page. The asp page is taking the data from the 1st database, so there s no way that a link is clicked and is not in the 1st database...
  8. avivit

    cursortype and locktype parameters

    Thanks for explaining. I know much more now. I should explain more about my files, so the purpose will be clearer. I am making a statistic report (which is perfectly working in the local host, i.e. - on my pc only), counting the number of hits each link in certain pages is clicked: I have an...
  9. avivit

    error when submitting a form through CDO

    Thanks for searching an answer. I found that too, before opening the thread, but no answer there actually. Besides, that person has a permanent problem, and in my case it works once and then it doesn't. And this is how it is in all pcs.
  10. avivit

    cursortype and locktype parameters

    Hi, I am using ms-access, a database which is updated frequently (actually all the time) by users. Each use of an asp page by any user updates one record in this database. In order to keep multiple updates to the same record, when occur, up-to-date (and of course to other records as well), and...
  11. avivit

    error when submitting a form through CDO

    Hi, I have some forms, that are submitted to mail through CDO component. They are sent by using an asp page that contain the following code. Frequently, submitting one of these forms results in error msg, and afterwards it works again, and vica versa. Sometimes it can work from one pc but not...
  12. avivit

    CDO - and remote SMTP server

    1. I wonder, why do I need to add the following lines when sending forms through mail, using CDO component? 2. If I remove these lines and the form is still submitted as it should, and I get the mail as a result as it should, does it mean I do not need these lines? 3. In other words - How do I...
  13. avivit

    adding field to table 1 from table 2

    I found a site that explains the above problem in ms-access, and I think it can help me but I am not sure what to do. Can it help? http://chrishiller.net/archives/databases/ms_access_operation_must_use_an_updateable_query.php Thanks
  14. avivit

    adding field to table 1 from table 2

    Well, In the proerties of the database - it is not read only. *.ldb file is created all the time, when I open the forms. And I do not know how to write permission to the table. When I use permissions, I define them in the asp files, which is not the case here, as I am only working on the...
  15. avivit

    adding field to table 1 from table 2

    Thanks, A great solution. But - It does not work for me somehow. I built your query in the queries module, and tried to run from there. I get an error:"Operation must use an updateable query", and I am working on my local pc, not on server. The field that is compared (in the where clause) is...
See more

Part and Inventory Search

Back
Top