Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Arob
  • Order by date
  1. Arob

    Most recent date

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

    Select Query and Null Value

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

    Select Query and Null Value

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

    Opening a mail merge document from access form

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

    FMS Total Access Memo

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

    Display 0 when counting yes/no field

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

    Display 0 when counting yes/no field

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

    Display 0 when counting yes/no field

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

    Display 0 when counting yes/no field

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

    Existing Records

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

    Existing Records

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

    MSG box for duplicate records

    That worked like a charm, thanks for your help
  13. Arob

    MSG box for duplicate records

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

    Division Problem

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

    Import or Exporting Data

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

    Import or Exporting Data

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

    I have a simple query which looks a

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

    Windows 98 and 2000 incompatibility

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

    Run time error 2501

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

    I have a continuous form with feild

    Unfortunately I am using A97

Part and Inventory Search

Back
Top