Search results for query: *

I have created a pass-through SQL query in my Access application and I would like to fire this query using a command button. How can I call this query in the "On click" procedure in my VBA code? Thanks much!!!!

Thanks so much John... That helped partially... Actually I'm trying to Validate an ID that will be entered by the user. So, what I would like to do is have a command button called Validate which when clicked should fire the pass-through SQL query that I have already created and based on the...

Hi, I have a function written in the Oracle database that I'm using in my MS access application. How can I make a call to this function using VBA? Thanks very much!!!

Thanks for your response Steve... Actually, I do have various other unbound fields in my form and those fields get updated perfectly when I make a manual change. because I do bind them in a module e.g. DHM_ID_TYPE.ControlSource = "DHM_ID_TYPE" Even the field2 I was talking about has...

Hi, I have a form where I'm trying to update a field (field2) using the data from another field (field1). Both the data fields have been created as unbound data fields in the form. What I would like to do is, use the 1st character from field1, which is a drop down box and update field2 with it...

Thanks SteveR77 It works !!! Thanks a lot again

Hi I am trying to convert a pl/sql query in MS ACCESS query. SELECT student_name FROm student s WHERE EXISTS (SELECT * FROM math_club m WHERE m.student_id = s.student_id) NOw How do I write this in MS Access? Please Help Thanks

In fact I did not know about existance of telnet utility. I tried Telnet and logged in. Once I logged iN I typed Shell script name with exten. .sh and it started executing. Previously I was trying through ftp connectivity. Thanks for you help. All.

Thank you very much. It works

OK Thank you for your reply. But let us say, I have username/password access to th unix machine and I want to run a shell script,(Which is already written) , How do I run that? Please advise.

Hi : I am a new unix user. I am using ftp to connect to unix server. Now I need to run a shell scrip How do i do that? Please help. Thanks

Thanks John . It works

Hi : I am trying to write a query in MS Access. I need to concatenate 3 to 4 fields. How do I do that? Please help Thanks

Hi Blorf : I really thank you for your support. I have typed the query as follows SELECT K.ID, K.Program, K.State, K.Quarter, K.NDC, K.NDC_DC, K.Tot_Dis_Reb, K.Tot_Dis_U, K.ToT_Disp_Re, K.Tot_Disp_U, K.Tot_A_Reb...

I have following query (Table and Column names are changed) . It takes hours to run. Please help to Improve performence. SELECT [k].[ID], [k].[PROGRAM], [k].[STATE], [k].[QUARTER], [k].[NDC], [k].[NDC_DC]...

Thanks for your response. I was wondering that Index could have any effect on select statement. In other words I do not know what is the impact of index on select statement. Thanks G

Hi : I have an issue of performence in one my oracle pl/sql procedure. This procedure gets data from oracle view and compares it with existing table. Depapnding on the comparision , it writes results to an un indexed table. The volume of data is very high and procedure takes hours to run In...

I am having trouble in installing oracle 9i on XP op. sys. It is getting installed but I do not know , what are the steps to configure the server. Please help. Thanks GYS

Begin IF nvl(mv_xyz_id,'A') = 'A' then if (nvl(mv_rec.sec_b_id,'B') <> 'B') and (mv_rec.sec_b_id_type = 'XYZ') then m_b_end_date_2 := to_char(sysdate-1,'YYYYMMDD'); end if...