Search results

Pat, My apologies. Poor choice of words on my part. I know that the user has to type in the form. Miles gave me a line of code that did this for me. It put the name"John" in the first_name field then immediately erased it when the form was first opened. Thats what I am looking for. I...

We use our "RealWorld" client file number as the PK for our client table.(year plus number-ie 200501,200502,etc.) I reset the Access autonumber to automatically return this number. Miles gave me a line of code months ago that "dirtys then clears a field when I open my form so that the user...

that did it. Thanks.

I have a form that I use to both add new records and edit existing ones. I do this thru a combobox and two command buttons. One button opens form in add records mode with combobox visible property set to no. The other button sets the visible property to true. I am getting an error message...

Maybe if I post what I have someone can hekp. Here are the two tables and form. I know something is not right. tbl_client ----------- clientid fname MI LName StreetAddress tbl_zip ------ zipid(autonumber pk) city stateabbrev zip frm_clients clientid fname MI LName StreetAddress txtbox_city...

Doc, I love it(and your sense of humor) It sounds fancy as heck and I'd love to be able to do it but I'm just a little ole newbee who is just trying to make a db for my law office. I want to make it right and i want it to be as professional as possible. Thats why I;m taking the time to read...

No Wayne. I don't know who that is but I finally gave up.

Wow! Thanks. I must read your response 15 times now and each time I do I understand a little more. I am slowly getting there

I know there have been old threads on this issue. I have done a search and read them. That is how I got this far. I was able to search the Web, find a Govt site with a list of every zipcode in the country. It was a text file so I converted it in excel and then imported into an Access table...

My firm wants to become "paperless" We want to incorporate all sent and recieved correspondence into our db. All recieved correspondence is scanned into each clients directory each morning. It is saved as an image file. I have a form with 3 relevent fields-date of correspondence, author and a...

I am designing a db for our Law office. I want to have tables for different types of Civil Cases-ie Divorces, Deeds, Contracts, Personal Injury, Auto Accident, Slip and Fall, Product Liability, etc. The divorce, Deeds, tables are easy but I am having difficulty deciding on the personal injury...

I'm really afraid to ask this question. I was working on a database for our LawFirm about a year ago but it was a longterm project and low priority. For reasons beyond my control I got away from it and am just getting to back to it. Miles and many of you were very helpful to me in answering...