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: *

  • Users: avivit
  • Order by date
  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

    ...far): sql update query (lets call it "sqlUpdate1") another sql update query (lets call it "sqlUpdate2") insert query (lets call it "sqlInsert") ************The diagrem************* objDB.execute sqlUpdate1,affectRec,adCmdText + adExecuteNoRecords IF affectRec=0 THEN 'If no records were...
  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

    ...in error msg, and afterwards it works again, and vica versa. Sometimes it can work from one pc but not from another. It is not stable. Why is that? *****************The error message"******** 'error type 0x8004020E, "Cannot modify or delete an object that was added using the COM+ Admin SDK'...
  12. avivit

    CDO - and remote SMTP server

    ...In other words - How do I know if an SMTP service is installed on the local server, and not in another network (besides asking the admin)? Thanks *********The questionable code************** objEmail.Configuration.Fields.Item _...
  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...
  16. avivit

    adding field to table 1 from table 2

    In ms-access: I have 2 tables. Both contain "title" field. I would like to add to table 1, one field from table 2,when the title is the same. For exmple: table 1: title: title1 name: smith address: add1 table 2: title:title 1 id: id1 Wanted result in table 1: title: title1...
  17. avivit

    Opening a new window from asp

    I now recalled that one can use: if xx = &quot;blabla&quot; then %&gt; &lt;script language = JavaScript&gt; functionName(); &lt;/script&gt; &lt;% End if But I like your idea very much. This is totally new to me. I never thought to leave it...
  18. avivit

    Opening a new window from asp

    That's a good idea. Is it also possible to use response.write for opening a new window in javascript? I have a function in javascript that can open that window. But how can I use a response.write to get to this function, without a trigger?
  19. avivit

    Opening a new window from asp

    Hi, I'd like to redirect from a certain page, to an external page(an external site), with certain parameters. of that window. There is nothing to do if using response.redirct, but is there another option? For example, I would like to open a new window, that will have a cerain dimensions, and...
  20. avivit

    REPLACE method using vba in excel

    GlennUK, well I do not want to drag (Btw- is it possible to drag to whole column, or toa certain cell without actually drag? I think there is sone shortcut). I want, each time, to use a different data, and copy to the excel file, and exceute the replace part automatically as much as possible...

Part and Inventory Search

Back
Top