Recent content by jam

I've got it set to double as it kept rounding up. Typical digits are 100.00Limit 87.56Usage Thanks

Both numeric. 2 decimal places.

I have a table. BackupTbl The table has 2 fields I want to compare. Limit Usage I obviously want to know when they are over their limit. Tried using expressions but I either return all results or none. I tried a bit of SQL SELECT * From BackupTbl WHERE Limit < Usage This returns...

Data is entered into a form. The user selects the customer from a drop down box. (2 fields in this box Customer ID & Customer name. CustomerID is hidden by virtue of 0cm size. Bound field is Customer ID from customers table). The rest of the fields come from InternetTbl. As the rest of the...

Thanks all, pr2-eugin this returns every record as yes. Even for dormant accounts who have no internet. I'm using the on focus event to drive it. Internet = IIf(DCount("*", "CustomerTbl", "[CustomerID] = " & CustomerID) = 0, "No", "Yes") Thanks for your help so far.

Same error as before Microsoft Access cannot find the object 'IF([CustomerID]=[InternetTBL]![CustomerID], Yes,No).' IfIF([CustomerID]=[InternetTBL]![CustomerID], Yes,No) is a new macro or macro group, make sure you have saved it and that you have typed its name correctly. I have...

Hi All, Haven't been on in quite a while whilst I've been working for an MSP and concentrating on their route to market. I'm trying to setup a DB to track all the customers we have and what they take, so far so good. However we have a policy whereby the customers who have our ISP...

This may verge on queries rather than forms but HELP!!!! OK I have the following tables. Requirements RequirementsID 1 Junction AgentID oo RequirementsID oo Agent AgentID 1 / 1 AgentEmployee AgentEmpID oo What I have is a query that looks up Requirements, Junction and Agent. This...

Thanks to those who posted up answers to my problem. I did a slight work around but had to start a new form to do so. I created a query based on all 3 tables. No criteria (at present) so it'll show me all records. I created the Agents table as a subform in datasheet view (which is fine for...

The problem is my list box would be massive. Theres so many agents out there is ridiculous, so having a major list box where I can select multiple values although great isn't going to be feasible. The second thing I need to know is how do I get it to create the record in the junction table...

OK I follow what your saying but I need to do it slightly different. I don't need the many-many relationship represented in this form I only need to see a 1-many side at this point. IE I have 1 requirement (the requirement is for land in a particular area) and there MAY be more than 1...

Hello everyone, I have a many to many relationship as such... tblRequirements RequirementID (Autonumber) tbljunction1 junctionid (autonumber) RequirementID AgentID tblAgents AgentID (Autonumber) The main form will be based around the requirement table and infact is already setup. Now...

As above really. I'm trying to create a form to store requirements. The answers are either A1, A2, A3, A4, A5, B1, B2, B8, C1, C2, C2A, C3, D1, D2, Sui Generis, High footfall, Shopping Centre, High Street, Neighbourhood Retail, Out of town, Near major road ect ect ect The answers can be...

Yep just typing them in directly into the field.

Table - Ownertable OwnerID - autonumber .... .... .... E-mail address - Hyperlink Sample data from table... jam86@hotmail.com a@a.com b@b.com I'm pretty sure this is how I did it back in V2, but obviously it doesn't work now.