Recent content by Philip Jen

thank you sir I will try this. Also I tried to operate the file with just the access runtime and it works great no problems. It only has problems when I work with it in the full access program. Any Ideas on that? I am confused about that. Anyways I will try what you suggested and see...

Also To answer your question, the Database Just Freezes and does not respond to anything. But now that I have removed the macro button, it seems to work. Even on my full Version of access 2007.

thanks For your Reply sir. The database I am using is mainly a stand alone database for purpose of traking Audit reviews. The one that everyone has access to is one that I Import information into from the main database. It is not linked to any tables from the main database. The purpose of...

Hello all. I have DB in access 2007. I have a report that is uses a select query to generate the information for the report. It has been working great, But however lately like maybe with in the last month, it has been causeing Access 2007 to crash. I am having the same issue with another...

Hello all I am a novice at Access Database. I am Trying to Make a Login form for a small database. I want this login to bring up that persons information only. There is only one person with complete access. I Made a table with the login name and passwords but I have no idea how to create...

I am assuming I can put this string into the "Validation Rule" Of the Table in Design View?

Well they are not on the sam form this is what I have typed in =IIf([Assessment Query]![Txplanupdate1]<=[Assessment]![Dischdate],"NA","NN"). The Txplanupdate is in my assessment query and the Discharge Date is in my Assessment table. The results are going into my assessment completed table...

Hey Everyone. I have another question here. I have a form that is linked to table that requires my response in it. However I would like to automate the answers that I would have to put in. Waht I would like to do is place a value of NA in a feild when I place a Date in another field in...

Okay I am still stuck with this I Am screwing this up and I am sure that it is a little something I am doing. But do not know?

Hey There paul thanks I think I have it Figured out I will let you know sir.

Hey Paul I think I understand what you wrote Forms!Form Name.Text Box Name . Not Sure where to put them. Here is my string from the 1 st part of the union query. SELECT Assessment.[Client Name], Assessment.[Client ID ], Assessment.Status, [Assessment Query].[Primary Counselor], [Assessment...

Not yet I was thanking you for your help. I am trying to figure out how in SQL how to put in Parameter Promt. I am currently reading an article. But still unsure. So TO answer your question, Not yet.

Thanks philip

Okay I am unsure how to refere the textboxes to my union query.

This is Philip I have a Quetion to help Simiplfy my Database. I have a Union Query that is supposed to give me dates from 20 other queries. what I wanted to do is select a Specific range date. I determined to do that by using < 05/31/2012and >05/01/2012. This will give me want I...