Recent content by Arob

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