Search results

This won't work databasedonr becasue you missed the GROUP BY clause. The SQL should therefore be SELECT Customer.membershipNo, MAX(Attendance.AttendDate) As MaxDate FROM Customer INNER JOIN Attendance ON Customer.membershipno = Attendance.membershipno GROUP BY Customer.membershipNo HAVING...

I make the caption on a button change for each record in my recordset. I want it to read Print Report for [Customer Name]. This is easy with the code cmdReport.Caption = "Print Report for " & [CustomerName] and it works unless the customer name has an "&" in it then the character displays as...

Yes build a query using that SQL and then create a report based on the query.

Why not try the following (plagerising the SQL from "databasedonr") SELECT tblMember.MemberID, MAX(tblMember.AttendDate) FROM tblMember WHERE (((tblMember.AttendDate)>Date()-14)) GROUP BY tblMember.Memberid;

You need unbound text boxes that use either the DCOUNT() function or build yourself a function to do it.

Thanks ghudson. I will try the search facility next time :rolleyes:

Is it possible to get a full list of all error numbers and their description??

It looks like "Rich" and I came up with the same idea at the same time. "Great minds think alike" Rich - or is it "Fools Seldom differ" :o

Another problem could be the datatype of filmlijst.status. You are testing it (in your IIF expression) for an integer. What is the datatype set to in the table? A long shot I know but it is just this sort of mix up that makes Access throw it's teddies out it's cot! :)

I don't understand why you would want to do this. In my view it goes against the principles of good database design. You need two tables that are linked. Something like: tblPrinters PrinterId Autonumber PrimaryKey PrinterName Text CartridgeID Number (Long...

I really think you need to change the data type for that particular column if you can. I created a test table (tblTestTexttoInt) and query. The table contained: id Autonumber and PK Codetxt Text (3) I select both columns for the query and added a calculated column...

Do you have a button on your form that is clicked to save the record or do you just use the Access Menus? If the former add it to the code in the on_click event of the button, if the latter then add it to the After_Update event of the form

Do you want to add a new record after the save command? If so then add the following after the save command: DoCmd.GoToRecord , , acNewRec

You are testing for the READYSTATE value to be READYSTATE_COMPLETE but nothing actually sets it to this therefore your code will continue looping. I admit I know very little about webbrowser coding structures but I wuld imagine your code needs to be something like: Private Sub...

use the expression =[Existing Tenure Intermediate] + [Existing Tenure Social] assuming they are the names of the controls on your form. This will add only the two fields of the current record. You could of course base your form on a query and have the calculated column in the query which...

IIF is a valid function in Access and can be used in reports. Your problem is certainly to do with the control you are doing the comparison on. What is "[filmlijst.status]"? As Pat states above this has to be part of the RecordSource behind the report. Can you post the SQL of the querY that...

I would suggest that you create a query that counts all opinions and groups by the opinion. something like this: Select Department,Opinion, Count(Opinion) from Satisfaction Group by Department, Opinion Order by Department, Opinion [Optional of course] You may of course have multiple...

You could try adding code to convert the string to an integer using the CInt function and sorting on the result of that I guess to do that the query behind report would need a column constructed something like this Contact:CInt([contactID]) You would then group the report on that...

Steve, Send me (or post on the forum) your MDB (zipped) and I will have alook at it for you. Keivn

I have tried to load the form but I keep getting the error: "Background image for form not found." I assume this is the file car.bmp which I have put into the same directory as the mdb. I even tried chaning the code so that the function call on form load sends the optional path to the...