Search results

I have a form in which there is a combo box which inserts customer addresses. So if i type in '8' it will list all client street addresses starting with eight and i can click the right one. I have another field which i would like to autofill with the corresponding customer name but I just cant...

I have a database with a table of customer details and then a table of service calls to those customers. Following advice from these forums I used an 'autonumber ID' for the customer table as the PK In the service calls table there is an 'autonumber servicecall ID' field as the PK, and has...

When enforcing referential integrity, does access get angry about capital letters? Or just in general, if an address gets put in with a capital letter in one instance and then without in another does it make a difference? thanks for your time

Hi. I'm no expert on access, but i'm giving it a go. Just wondered if someone would check over my plan to spot any holes in it before i start trying to put it together. I have attatched a plan below. I am creating a system whereby our company can monitor aftersales service calls. Our company...

Hi, I am trying to create a system for my window company, whereby the boss can monitor visits to homes where we have installed windows and had to go back to fix various issues. I'm not a complete novice when it comes to access but it has been a very (very) long time since i used it. The boss...