Recent content by avivit

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

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

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

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

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

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

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

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

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.

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

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

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

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

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

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