Search results

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

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

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

First of all I'd like to thank those of you who have been helping me so patiently over the past few days, your advice and knowledge is so appreciated and I think I've given everyone positive feedback of those who have helped me. This website is brilliant, the helpfulness of members and no...

Hi everyone, thanks for your ongoing support. This flick back to access is really getting my juices going and I'm impressed by some improvements and mostly annoyed my 'improvements' over my beloved Access V2 lol. Anyway to the problem in hand... I want to store peoples e-mail addresses in a...

Its the same information thats being displayed. I just can't see why I shouldn't be able to the keys that link the master and child fields will be the same. Just wanted to check before I try it and destroy everything. Cheers jam

Hi all I have a query which looks at the status of a project (of which there are 4 options), however the query forces me to type the status in rather than using the 4 options. Is there anyway of changing the query to prompt the user with a drop down box rather than a text box? Cheers jam

Well I haven't played with Access since V2 and although queries don't seem to of changed much I'm affraid my memory retention hasn't fair as well. I'm constructing a query based on 2 tables, Owners and Ownersnotes Owners 1------oo Ownersnotes. My relationships are ok as they work perfectly...

OK got 2 tables (now downsized to one to many from many to many). I created a form with a linked form via the wizard for the tables. I couldn't get the linked table to store the key from the primary table thus loosing the relationship entirely unless I told it specifically which record it...

Hi guys, Got a problem with a many to many relationship. So much so I've started a new DB to test out whats wrong. got a table called land Got a table called owners Got a junction table Related them together using LandID and OwnerID via a many to many relationship using the junction...

Part 1 of 2 OK my relationships are setup and look really sexy so I'm happy with them. I have 1 main form called land. This holds all the physical info on the peices of land. Onto this I need a linked form for land owners. (this can be done under a normal wizard in Access). But i also...

Hello everyone. Sorry this is probably a real nooob post but please bare with me. I was trained many moons ago in Access V2 yes V2 on floppy disk. Since then I haven't used Access at all. However my boss has got wind of me being trained in access and has given me a project to complete...