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 Mike Lewis 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: cadoltt
  • Order by date
  1. cadoltt

    proc doesn't work when called from trigger

    Hi Taupirho, Thank you for taking part in it. I was also thinking about a composite ID, but there two things which make it hard. First, the physicians want the treatment number to be a simple sequence reflecting treatments natural order. Second, dates might be incomplete (only the year is...
  2. cadoltt

    proc doesn't work when called from trigger

    Jimirvine, SantaMufasa, Yeah, this really turned out to be a mutating table error - at least now I know where to look at. Thank you very much for the tip! Alex
  3. cadoltt

    proc doesn't work when called from trigger

    Hello everybody, I am not experienced in writing table triggers and I'm stuck with something I don't really understand. I have a table which keeps track of treatments patients receive. It has a composite primary key pt_id + treatment_number. The treatments should be numbered sequentially...
  4. cadoltt

    Excel from Access:"Object variable or With block variable not set" err

    Roy-Vidar, Skip, Thank you for clarifying things. And what I really love is to simplify code :-) Alex
  5. cadoltt

    Excel from Access:"Object variable or With block variable not set" err

    Skip, It works now. 'i_Ex_row' was just a typo when I was simplifying the code for the post. Thanks a lot! Alex
  6. cadoltt

    Excel from Access:"Object variable or With block variable not set" err

    Hello everybody, I am observing a strange behavior of my Access (2003) VBA code. I have a procedure (in a form) to copy an Access table into an Excel file. The sub opens an excel application and a recordset, then loops through the recordset rows and transfers the values into excel cells. Here...
  7. cadoltt

    Fail to run JSP from ColdFusion

    Thank you, TruthInSatire, Not a good message for me, but I don't kill messengers :-) Guys, Is it too naive to ask if there is a way to put together CF with some of free JSP servers, such as Tomcat or anything else? Thanks Alex
  8. cadoltt

    Fail to run JSP from ColdFusion

    Hello All, I have CF MX 7 Standard installed on my desktop PC (Windows XP professional, IIS 5.1) for development purposes. From what I read about CF MX 7, I get that it can run JSP. To test it I created a simple JSP page (hello.jsp): <HTML> <head> <title>Test</title> </head> <body>...
  9. cadoltt

    2 users attempt to create accounts with the same ID: how to prevent

    KenCunningham, You are quite right. SantaMufasa, The star is awarded. I wish it was the Silver Star or Medal of Honor :-) Thanks again! Alex
  10. cadoltt

    2 users attempt to create accounts with the same ID: how to prevent

    Guys, First of all let me apologize. In my previous post where I said 'The way suggested by MikeyJudd...' I meant SantaMufasa - I just copied the name from a wrong spot. So my apologies to both SantaMufasa and MikeyJudd :-) SantaMufasa, Your first suggestion was already good enough and this...
  11. cadoltt

    2 users attempt to create accounts with the same ID: how to prevent

    Thank you for answering, guys. Everything is a simplified in my post, including the table structure, let's suppose it has just two fields (vc_user_nickname and vc_user_pw) and as I mentioned there is UNIQUE constraint on the vc_user_nickname field. Of course this constraint will not allow the...
  12. cadoltt

    2 users attempt to create accounts with the same ID: how to prevent

    Hello everybody, This situation has to have a standard solution but I couldn't find it so far. Imagine multimple users create their accounts and there is a table to store the personal data one of the fields of which is to keep the user nickname. Nicknames have to be unique. Here is a...
  13. cadoltt

    Requery doesn't work in form

    Hi TheAceMan1! 'How To Get Good Answers To Your Questions' - is a good compilation of what's needed to make people answer questions, I always try my best to follow the advices. And thank you for info in the quote. Alex
  14. cadoltt

    Requery doesn't work in form

    Ed, Honesly, I started playing with Recordsource before your post, I did this way: Call CreateQuery(sSQL, "qry_1") Me.Recordsource=qry_1 and it statrted working. However I took your suggestion because it simplifies things. Now, when you warned me about changing queries on the fly I'll...
  15. cadoltt

    Requery doesn't work in form

    Ed, It works. Surprisingly to me it works even if I remove Me.Requery. Thank Heaven there are always people who know more than you... Thanks again, Alex
  16. cadoltt

    Requery doesn't work in form

    Hello everybody, I have a form based on a query ('qry_1'). There is an option group in the form ('my_opgrp') clicking which causes the query to change (one option is to select all records, the other to select a subset). Here is the code (simplified) I use for the OnClick event of the option...
  17. cadoltt

    Autoform Tabular subform: how to reference controls in a certain row?

    MajP, It's getting clearer and now I almost see how to handle this. Thanks a lot! Alex
  18. cadoltt

    Autoform Tabular subform: how to reference controls in a certain row?

    MajP, Thank you, it works. The boxes get prepopulated all right. But how about the second thing, the button? Now when I hit it I get an error message "You can't assign a value to this object". Similar thing happens if I try to change the value in the box manually. Seems assigning the control...
  19. cadoltt

    Autoform Tabular subform: how to reference controls in a certain row?

    MajP, TheAceMan1, Thanks for joining. Actually I need both prepopulated unbound boxes and a possibility to change the value in a certain box after hitting the corresponding button. Yes, I am thinking about a function for the calculation because I will need, using the record values, query some...
  20. cadoltt

    Autoform Tabular subform: how to reference controls in a certain row?

    Hi Everybody, My main form has a subform, which I created using the Autoform Tabular option. The main form and the subform are underlined by two tables havind one (Main form) to many (subform) relationship. The subform has two text fields, one of which is bound to a table field, the other is...

Part and Inventory Search

Back
Top