Search results

I have a time stamp field from an Oracle database that I want to convert to a regular date field in my Access query so that I can pull data from the table base on start and end date. The time stamp field is formatted as: 09/19/2006 03:16:00 PM In my query I have tried the following...

In a Novell network I have an application (application 1) in a folder that requires user rights to access. I have recently created a 2nd application that resides in a folder that is shared by all, no rights assignment required. I have Name and Address table that has a company name field and a...

I am using the following statement in an update query (which by the way I found in this forum) to pull out the first name from the FirstName field. The field could have a first name or a first name and a middle initial. If the field has a first name and niddle intital: John P then I get...

:confused: I am trying to make a edit form read only by setting the allowedits = false if it meets a certain criteria. It works fine on a standard form but I have a form on which I have 6 tabs. One of the tabs is a subform. On this form it doesn't work. After opening the form and entering...

Has anyone been successful in exporting data from an Access Table/Query to HL7? We're pretty close but having problems with the creating actual records. Our data come from a flat table and we are trying to break it up into several acsii records using a query. Any suggestions? :confused:

I have just upgraded an Access 97 application to Access XP. I have a query that makes a table from selected record(s). When I attempt to execute the query I get a message: "The Microsoft Jet database engine cannot open the file c:\ContractMergeXP It is already open exclusively by another...

Can I make a linked table read only? My situiation: I want to create a new db with a linked table from the original application giving the user of the new db the ability to create their own queries and/or reports but not be able to modify the table. Everything I've tried lets me open the...

I recently got a new pc with Win XP and had Access 97 installed since most of the applications I support are on Access 97. Everything appears to be working except: If you attempt to print a report to an HP 5si that has any lines on it (e.g. a form) the text print where it should but all the...

My customer want me to keep a log of any change that is made to a record and to also record who made the change. I have a log in screen so I know who the user is. My problem is I'm not sure how to do the audit log. He wants to know which field was changed, the existing data and the new data...

My Access application is a front end for an Oracle database. My LAB_NO field is a key field so I can't have duplicates. I get an error message from Oracle when I try to save the new (duplicate) record. I want to check for duplicate right away. I know I can use a sql select statement but then...

In my application I am using 3 forms. Form1 is based on 2 tables, the primary key is LAB_NO. Form2 and Form3 are both base on sub forms which display data from 4 tables based on LAB_NO. My problem is this, I want to return to Form1 on the same LAB_NO I was on when I left. Currently I am using...