Search results

I can't really post the database but my tables look like this or will do once everything is working (scaled down version) tblClientProfile ClientID - FirstName - Surname - DateOfBith..... 1 - John - Smith - 26/01/1980 2 - Mark...

Hi, I was wondering if anyone could point me in the right direction on this topic. I currently have a button on a form that views client information from the tblClients table. When this button is pressed, the user is asked to input information and once they've pressed 'okay' the information...

It's for the purpose of identification. Not for the solicitors but for the Legal Services Commision (who record all this data) They need a reference for each matter which shows the date we first made contact with the client and a unique number at the end hence 280709/002. The Surname and...

But with AutoNumber, as you said, doesn't repeat a number whereas I do need to repeat numbers but not always. That's the part I'm finding difficult. Maybe I'm not being clear on what I need to achieve so I will try and explain as clear as possible...

Thanks for your reply. I was thinking of something similar. I was thinking of having a table called FileCreator in which this kind of information was stored. Points I need to clear up on though is. The file isn't always opened on the first date of contact (it may be a couple of days after...

Hi, First, apologies about the title. I had no idea how to describe my problem properly. I'm currently at the beginning of creating a database. I think I have my tables, more or less, sorted and correct but I have a problem which I'm not sure how to get around. I'm pretty new at creating...