Search results for query: *

I have a table which contains records of customers. Customers can and will have more than one record in the table. Each record also contains a short date mm/dd/yy of when services are conducted for this customer. I am trying to write a query which would only give me the record for the most...

I finally figured it out. All I needed was to have the query show a value instead of being null. Once I was able to do this the rest was easy Thanks

I have a very simple select query which a user types in a record number, the query searches the database and if the record number exists, it pulls up a form that has data pertaining to this record number. However my problem is if there is no record number in the database, I would like a...

I am trying to open a mail merge document using the below code. It opens the word document, but it is no longer a mail merge document. Can anyone assist me with what I would need to change in order for the mail merge to work? Private Sub OpenWord(FileName As String) Dim WordObj As...

I am using a product from FMS called Total Access Memo. The product allows you develop report material in word and insert into an access report, via active x control. However the problem that arises is access is that occasionally, text can be "cut off" at the bottom of the report. I was just...

No luck, it still does the same. I will continue to mess around with it. If you happen to think of anything else let me. Thanks for all the help. Arob

It wants to always give me a zero. Just wandered if you had a clue as to why it wants to do this?

The query still comes up with no results when their is only false results, I expect since the yes/no is not a null function, than the Nz function will not work.

I have the below query which counts the number of true values in the exclude location field in the orignal list table. However, how can you get the query to display zero value for a yes/no field? SELECT Count([Original List].Excludelocation) AS CountOfExcludelocation FROM [Original List] WHERE...

I am getting a data type mismatch error in the criteria. I think this is because the orderid is a number field and there is "" around it. I am not the best at puncuation, so I am not totally sure.

I have seen several posts on finding duplicate records where If DCount([productid], "order details", "[orderid] = '" & Me![productid] & "'") > 0 Then MsgBox "Product number aleady exists" However I have two fields, product ID and Order ID. There can be...

That worked like a charm, thanks for your help

Have looked under validating data in the help and have had no success with my problem. I want to have a message box appear after a duplicate value is entered into a particular form feild. Basically I would like use an IF statement which if the ID number entered is a duplicate then display the...

I have a bound form for which I am trying to conduct caluculations that will be stored in the table. I want the calculations to be two decimal places. All the form fields sizes are set to double. All calculations work but the final overall total. This calculation always rounds the number up or...

I have ten field reps which all have a database on their PC's for which they complete their work. Once a month they export their data through Outlook. This is actually about 15 text files, each file is a for a sepearte access table. I then take this data and import into one centralized...

Currently I am receiving a text file export from one Acess database which I import into another Access database. The process I use is transfer text method. However, the data being imported/exported contains some Ole objects. Because of the transfer text method, these feilds are left blank. Is...

I have a simple query which looks at one particular date field within my table and gives me any records whose dates in this field are within 60 days of the current date. I am using access 97 with windows 2000. I copy the database over to a laptop which has just been converted to windows 2000...

I have an access database that was developed using windows 2000. However some of the end users are still operating under windows 98. When I try to run the query, SELECT tblchurchsuggestions.* FROM tblchurchsuggestions WHERE (((tblchurchsuggestions.lastupdate)>Date()-60)); within windows 98 I...

I have a simple command button to open a form. Below is the code Private Sub property_Click() DoCmd.OpenForm "frmhospitalpropertyedit1" End Sub However when clicking on the button, I receive this error. Run-time error '2501' The OpenForm action was cancelled You used a method of the...

Unfortunately I am using A97