Search results

Hi Guys, Its working with * meant.. statement in subquery ....when i replaced ' ' with * in select statement...i just tried it, and EOF condition works correctly when i used it... VBA does things differently..it needs atleast a column to be specified even though its a query with EXIST...:)...

You are right. I have used adopenkeyset in other part of the code somehow missed it here, , but even then the recordcount is 0 , when the query is actually returning more number of records, i dont know the reason for this ... I tried with what u suggested but even then its not working as it is...

Hi , I am using Access Application with Orcale Db as backend and this application is already in production. The problem is.. USers Complained that the system is slow, this is because there is refresh (requery) for each Insert (When they click submit, that particular record is inserted and then...

Hi, I am getting this error "The command or action 'Show all records' isn't available now", i get this when i try to do DoCmd.ShowAllRecords DoCmd.GoToControl ("ID") DoCmd.FindRecord Me!Text116 I am trying to do search on ID..but i get this error and i dont know how to proceed.. P.S...

i used what raskew had suggested... It works fine, but it gives type mismatch errors when i keep navigating thro records..i really dont know how to fix this problem since i tried declaring all the variables i use with almmost all datatypes that i can..but no use.. CAN U HELP ME FURTHER...

I am using ODBC with oracle tables.. My table has columns startdate and end date which are of type varchar(backend tables)..but when i display it in form it should display it as mm/dd/yyyy format, i tried setting format property as Short date but that doesnt work as my form is based on a...

When i try to insert data into a backend Oracle table (with ODBC) using a form, (i use docmd.runsql "insert....") Access gives me a message like"You are trying to append 1 row to the table are you sure you want to append?" i want to suppress this message as i have to insert into 2 tables and...

Hi, Do i have to give a commit statement when i update tables in backend(insert, delete,update) from a form, say when user clicks submit, it takes the data in fields and inserts it into the table , but till now i never did that but i could see all data when i queried the table, but i am not...

Hi, how do i make the fields in my form uneditable(cannot delete or add but can copy a field from form), i tried setting the properties..allow additions deletions by setting it to no, but even then when i open the form and when data is dispalyed , if i go jus delete (say address field)a field...

can i reassign the query (the one which i used to build my query for form load) to another query and use it.?? And BTW after update of what..? sorry can u be more clear.. i can put in my code for u .. actually the form opens up based on query, when the user enters search for the product id and...

Hi, I have a form with a subform, Both of them are based on a query.the form displays a productid and its details ,and the subform has matching productnames for that productid. Now i have a search on the main form wherein the user enters ( search for) the productid, once they click search...

Hi Ken, i have developed forms, but can u give me an idea of how to relate- clicking a box and capturing that row when a check box is clicked, since i think i have to capture the data dynamically whichevr is being selected , plz..!

Hello, My requirement is this... I have to use MS Access as front end with ODBC connection to Oracle 9i DB. The application(forms) should be able to update, delete ,insert records into oracle tables(backend). i have a main form,which has some unique id's and other info about the ids...