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 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...
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...
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...
...to a laptop which has just been converted to windows 2000 and the query gives me an error.
The sql for the query is
SELECT tblchurchsuggestions.*
FROM tblchurchsuggestions
WHERE (((tblchurchsuggestions.lastupdate)>Date()-60));
When running the query I get the following error...
...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 get the following error.
Function isn't...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.