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

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

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

I have a continuous form with feild [date needed]. I want to change the backcolor of this field if the system date is greater than the date needed feild. Below is the code I have placed on the Form_current event procedure. Private Sub Form_Current() If [DateNeeded] < VBA.Date Then...

I just had my computer crash on me, I was using WinNT and now they have me on Win2k. This worked fine before, but now it doesn't. DoCmd.TransferText acExportDelim, &quot;Qrytablchurchsuggappend Export Specification&quot;, &quot;qrytablchurchsuggappend&quot...

I have a form that contains a subform. The main form has only one field. It is a data enty filled, but is automatically filled by a set default value. The problem I am having is the main form does not save this as a record unless I place another text field in the main form and actually type...

I have a query for which i am counting the number of records which meet the criteria I have entered. How do I get the query to return a 0 if no records are found instead of simply showing no records. Thanks

I am trying to save a report as a PDF File instead of a RTF File and am having some difficulties with the code. Below is my code for saving and Emailing the Report as an RTF. I have not been able to change the RTF settings to PDF and have any luck. Just wandering if anyone has a solution...

I have developed a database in access 97 which several tables are combined to complete a report. However the problem I have found in access is that the report is two large. Meaning I run out of room and cannot change the height property to more than 22. The question I would like to know is...

I am trying to develop a data input form in access an have encounterd a problem with the height property maximum being 22. Does anyone know of ways around this to either make the form longer or some other alternative. Thanks.

I have some code where the end user can automatically send out a report through MS outlook, by clicking a command button. However I was wandering, if instead of automatically sending the E-mail, can you get the code to open outlook if the user needs to send any additional attachments. Below is...