Search results

Thank YOU! Thank you so very much, This Forum has really helped me in the past and now. Thanks again.

I just cant seem to get my update query to correctly update my field. I have a field called Case_No in a table called REVIEW. The case_no field is currently in this format 00-000. Where the first two digits are the current calander year and the last 3 are just a number that starts at 001 and...

Thanks!! I will try that, I knew I was going about this the wrong way.

I have a DB that is currently being used by a few users and they would like to add a request date field to some of the tables. Here is the probelm. The tables hold info on Drivers license's and SSN's and things like that and the Primary Key is the DL# or the SSN#. The user would like to keep...

Sorry Here is sample Data Please use SSN = 111-11-1111 Sorry forgot to add that to my previous post. Thanks for all assistance.

I have attached a Zip File that holds 3 tables and my form which will appear on Startup. I have a field in the form that is where a user enters in a SSN. Here is the problem that I am having. When a user enters a SSN that is already in the Database my message appears alerting the user that the...

Still get the Error Message This is my Code and I still get the "The Value in the field or Record Violates the validation rule for the rule for the record or field." Error Message. For some reason it is not recognizing that it is an error message. Private Sub T_SSN_BeforeUpdate(Cancel As...

I have a form where the user enters a SSN and when the user tries to exit the field code makes sure that the SSN does not exist in the database. If it does the user is not allowed to exit the field untill the user enters in a valid SSN. However when a user enters in a invalid SSN a message that...

THANKS I cant believe that I didnt try that. Thanks so much. I feel like an idiot now. Thanks again.

I have a form where a user enters in a SSN. What I am trying to accompolish is that when the user tabs out of this field or tries to click anywhere else on the form that the table is checked to see if that SSN already exists. If the SSN already exists I do not want the user to be able to leave...

I have a form that the user enters in Case information on. That form is based on table. I also have a table that holds information on who created this individual case. This table just holds the Case Number and the Username. When the user saves the case I need the table that holds the...

Thanks Thank you very much, I will look into all of that as soon as I finish adding in extra system requirements that the users seem to come up with on a daily basis.

I have created application in Access 2000 and I am wondering what is the best way to go about installing it on users machines. For the test application I have completed the MDB. Then I split the front end from the back end, then I saved the front end as a mde file. (All of this is saved on the...

Control source didnt work, but when I added another "(" and set the text box equal to that in the On Activate event of the report it worked fine. Thanks for the help.

I could put that in the control source of a text box on a Report? I will try.

Like I said in the earlier post. I am not a very good programmer. Thanks for you help.

Thanks I didnt know that.

Go to tools, options, edit/find tab. Unckeck the confirm boxes and you will no longer get the question if you want the update to execute.

It is a query that counts the total of a field when it equeal a certain value. I will copy and paste an example. SELECT Count([Orig_Stat]) AS Orig_MIL FROM review WHERE [review].[ORIG_STAT]='MIL' HAVING (((Review.DATE_COMP)>=GetStartingDate() And (Review.DATE_COMP)<=GetEndingDate())); Sorry I...

Can I make a textbox on a report = the result of a query? I have tried numerous ways and I cant seem to figure it out. I am not very good with the expression builder either. I tried that but it did not work. Thanks