Search results

  1. N

    equivalent of Trunc

    Iam trying to run a query in MS Access which has tables linked to Oracle. The resultant of the query fetches a Date field. This field is in the format yyyy/mm/dd in Oracle. But in Access, I get it like yyyy/mm/dd 9:18 AM etc. why am I getting the time appended even though I do not see it in...
  2. N

    Make Table Query-Doubt

    I have a couple of tables which were created from 'Make Table Query' I then refer these 2 tables in other sets of queries in my Access application. My question is: The query that I wrote to create 'Make Table Query' references linked tables. Will the 2 new tables that created using 'Make...
  3. N

    Query in VBA

    I have an Access report and all fields are populated from a query in the report except 1 field which needs to be evaluated from a separate function that needs to be coded in VBA. How do I write the query? It is nothing but a select statement like: "select * from table A where <condition>" how do...
  4. N

    Update Problem

    Thanks for the Reply...I checked this and there are no events in the Code.If I look into the Link Table and try to update any record directly in MS access, i still get the same error:Another user has changed the record.Copy to the clipboard or drop the changes.But Iam able to insert a new record...
  5. N

    Update Problem

    I have an MS access application whic has link tables to a SQL server database.I have added a new column wiht property:Yes/No to this table and I have linked the new table to my Access database.I use this column as a check box in an MS Access Form.WHen I update this checkboz, I get an...
Back
Top Bottom