Search results

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

dcx693: Thank you for taking the time to help me with this problem. One of your suggestions, did I redo the links got me to think. I had re-entered the path in the query properties "Destination DB". What I finally did, and now it works, is: Make my query a Select query and than remake it a...

This database holds several tables that are created by make table queries. These tables are later used in Word merge. The main application is on the Network - shared by several users. The merge tables are created on each user's C: drive. Win 95 (Access 97 and Word 97) had no problems with...

dcx693, Here's the answers to your questions: 1. I tried both ways (double click and from code) I get the same messge. 2. I do not have security enabled. 3. I selected the upgrade option when I opened it with XP. I then ran the compiler on each module and made all corrections necessary...

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

Thanks for your response - but I was hoping there was an easier way to do this. Like some magic flag I could set and it would solve all my problems;)