Recent content by HJAMES

Found the solution and now I feel really silly. The Criteria: Between [Forms]![frmDateRange]![StartDate] And [Forms]![frmDateRange]![EndDate] pulls the dates form 2 unbound fields. I discovered that the although the Input Mask was set up for date input, the Format was left blank. Once I...

The records are still in Oracle - linked to access DateValue(Format([time_stamp],"MM/DD/YYYY")) - returns only 2007 records Thanks for the suggestion.

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...

Thanks Peter - you're a life save:)

Thank you so much - I've been working with that all morning - it works great! I didn't think about it before but I will probably have the same problem with the middle initial since some of them don't have one. Can you please help me with that code.:)

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...

#Deleted# errors with linked ODBC tables I also have an ODBC connection to an Oracle table. I'm using Triggers to generate the Primary Key. Occassionally when inserting a new record into the database I get #Deleted# in all fields. We've tied using dbSeeChanges with no luck. Something about...

How would I do this in a query if I want to select only records that are greater than 0. I am now using >0 in the criteria. If I encounter a blank field I get "data type mismatch in criteria expression".

This is the code I'm using to accomplish basically the same thing: Private Sub ZIP_Exit(Cancel As Integer) Dim dbs As Database, rst As Recordset Set dbs = CurrentDb Set rst = dbs.OpenRecordset("tblZipCityCounty") rst.MoveLast rst.MoveFirst Do Until rst.EOF...

Thanks, we've been able to do that too. We're having problems with output. To be specific - the end of record processing.

I'm sorry but it's to complex to post - I was hoping someone already familiar with HL7 had already done this and could shed some ideas.

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:

This is what I did and it work great: behind a command button - I run a query that makes a table with the data I want to use in my merge document - then I hyperlink to the Word document: me.cmdGo.HyperlinkAddress = "location of document" This opens the Word document. In Word, link your...