Search results

Good Afternoon Everyone, So i've been working on this Death record review form (unbound) so that many people can access it based on their hospital at the same time. I'm having a problem with saving the values in the contols until I can update the batch at the end. I keep receiving an error...

for what you want to do I think VB code would be your best option.

What putting a criteria in the query? in the field where -1 is, place -1 in the criteria field...that way it won't see the 0. just a quick thought. :)

What is "X"? is that the number of days?

Thank you gentlemen!! I think I was over thinking it...I'll start a new thread for my other issues on this DB. Larry

I'll check it out... :D Thanks Bob!

Would you believe I had it like that before, then changed it... :( http://www.access-programmers.co.uk/forums/showthread.php?t=193907 I kept getting an error where I had to have something in each table and they wouldn't necessarily have the information yet. I'll give it another go...

In the query designer, under that field type "[Enter Facutly Name] " or whatever the criteria is

I can't open 2007 DB's but my first thought would be to add a parameter to the query generating the report for you to choose which faculty member you want to see.

Good afternoon, I am having a major internal brain explosion... I can't seem to get my head around "how to" get the cycles right for a problem. What I am looking for is something like this... user will open form and fill out the problem information (frmProblem) then fill out the...

Okay...corrected that. I'll have that connected to my contacts table (another DB).

I think I put this in the wrong section...Should it be under Theory and Practice? how do I move it? Thanks! whoever moved it... :)

Good afternoon everyone, Could I get someone to check my relationships? See attached picture... What I am tasked to do is create a PDSA database... (Plan, Do, Study, Act) For Every problem there can be "many" cycles For Every Cycle there can be "many" Plans For Every Plan there can be "many"...

Have you tried the default value in the table property? Look up Dlookup in the help menu for correct syntax. LWC

okay...I'll re-run / re-write some things and get back with you if I have any issues.. Thanks VBAInet!!!!

Didn't think about that...Thank you! I did try it...Now it doesn't show the error but goes straight passed everything to the Update query message. The message box appears and says "("This person already exists 0...would you like to update this contact?" When there isn't a 0 Id number...

Good afternoon, I have this little bit of code that when the person hits the button it will check to see if they already exist and if so then run and "update" query otherwise it will run an "insert into" (not written yet) query. I get an error message that says invalid use of Nulls... my...

Thanks Khalid...I am sure you'll be seeing me hanging around a lot until I get a grip on VBA. :)

@Khalid - Yes..they do, but I am looking to "re-vamp" the entire thing. I just need a better understanding of VBA to optimize my Database. I think First and Last are keyword that I'll have to deal with when I re-design this thing. Thank you for the reply!!! Larry

Thank you SOS!!!