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 Chriss Miller 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
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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>...
  4. 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...
  5. 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...
  6. 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...
  7. cadoltt

    &lt;input type='file'&gt; to specify local directory for download?

    Hello everybody, I need to download a file from the server. I'd like to invoke in the form the file browser to pick up a directory where to save the file. I am wondering if I can use the tag <input type='file'> to specify the directory (and optionaly existing file). It works for upload, I can...
  8. cadoltt

    Problem to write something into one window from another via JS

    Hello everybody, Write something into one window from another with JS I've encountered a strange thing (hope the thing is strange just to me). Here is a simplified version of my application. There are two pages, I call them window1 and window2: <HTML> <head> <title>Window_1</title>...
  9. cadoltt

    VBA multi line expressions

    Hi everybody, In my VBA program I need to pass quite a few parameters to a function, so the line might be too long to fit into screen. Say, this is: myFunc(param1,param2,param3,param4) Can I do something like this: myFunc(param1, param2, param3, param4) ? I tried...
  10. cadoltt

    Simultaneous db access: difference between client and session variable

    Hi Everybody, I think the problem I need a help for is common for CF developers and experienced programmers should know the best solution for it. I am developing an application which intends to access the database (Oracle) by a few users. Each of them should be able to add records into some...
  11. cadoltt

    Trouble setting textbox value from within Click event of listbox

    Hi Everybody, On my form I have a list box and a text box controls. When a user clicks an item in the list box I need the value to appear in the text box. So I put the the following piece of code into the Click event of the list box: Private Sub lsb_myList_Click() Dim str_value As String...
  12. cadoltt

    'ORA-00905: missing keyword' problem

    Hi Everybody, Here is the simplified sutiation. I have two tables, t1 and t1 having three similar (same data type) columns each. First two colunms serve as row identifiers, and the third column contain some value. t1: T1_C1 T1_C2 T1_C3 ---------- ---------- ----------...
  13. cadoltt

    Getting table name for SELECT from formal param in stored procedure

    Hi everybody, I am trying to create a stored procedure which can process different tables. The general idea is to make something like this: CREATE OR REPLACE PROCEDURE my_proc ( field_name in VARCHAR2, tbl_name in VARCHAR2 ) AS value NUMBER; BEGIN ... SELECT...
  14. cadoltt

    SystemTimeToFileTime problem

    Hi everybody, Here is a simple code I am trying to get work: int main() { SYSTEMTIME st = {2000,10,15,0,0,0,0,0}; FILETIME ft; int intRet; LPVOID lpMsgBuf; char chrMsg[256]; intRet = SystemTimeToFileTime(&st,&ft); FormatMessage ( FORMAT_MESSAGE_ALLOCATE_BUFFER...
  15. cadoltt

    How to populate cfselect from array, not from query?

    Hi Everybody, Most cases I've found on cfselect explain how to populate it from a query. Is there a way to do it from an array? Thanks, Alex
  16. cadoltt

    Newbie: save a value from previous request

    Hi everybody, My problem seems very basic but I don't know how solve it. There is a form which has a text field to input a value and a submit button, and the form action refers to the same template. Besides the form the page displays two values: the entered one and [here I have troubles] the...
  17. cadoltt

    Image doesn't come up from the jar

    Hi Everybody, My program should show some stuff in the main area including an image (a gif file). It works when I run it from within Eclipse or when it starts from a command prompt window (OS WinXP). With Eclipse I've created an executable jar file but when I try to run the program from the...
  18. cadoltt

    How to change a textbox value in a form with a checkbox click?

    Hi everybody, There is a textbox in my form (frm_01) for entering numeric values (%). I also want to put beside it a checkbox (chkb_not_reported) which if checked, changes the textbox value (and corresponding table field) into -99. The textbox is bound to a table field, the checkbox is unbound...
  19. cadoltt

    Newbie: how to update two frames with a value from the third frame

    Hi everybody, My problem seems pretty basic, hopefully someone will find a few minutes to look at it. My simplified application screen is built of three frames. In one of them (controlFrame.cfm) there is a form having a textbox input control - TXBPTNO - (where a user can enter some number) and...
  20. cadoltt

    How to get rid of the record indicator at the bottom of the form?

    Hi everybody, By default Access forms have the record bar at the bottom. Is there a way to get rid of it? Thanks, Alex

Part and Inventory Search

Back
Top