Search results

Thank you and Merry Christmas to you as well!!! Okay I am trying to make this simpler since I am getting deperate here to come up with an answer. I need the query to have 2 status for each patient. If both status are the same for each Patient record ID, and is more than 3 business days...

I understand. I wonder if I have to code this. I can sho you my database if you could ghost on my machine or skype or something on instant messanger. Maybe clearer since pricture or video is worth 1000 words. I am thinking of asking someone on freelancer if they can help. I know this can be done...

Doesn't record ID (i know it's poorly named :( )bring them together? Record ID 1 which is John Doe shows a report date of 5/16/2014 and 5/19/2014? I'm so confused, and now am extremley worried cause I cant get this to work. Anything would help at this point.

I did indeed. Will be going thru these daily as I commute to work and back. Thank you soo much you have been such a blessing!!!

Hi jdraw, I am so sorry I do not mean it to be hard for you. I am trying to make it as simple as possible but looks like my efforts are failing. I cannot or do not know how to save it as csv every time I do it is not saving in right format. So for now here it is in txt file. I will be online...

Thanks everyone. I understand was just looking to see if anyone wanted more of a friendship type relationship. Just seems more closer of a relationship to be on a messanger together as we grasp Access together. Looking forward to knowing people here on the forums as well. :)

I only posted AA because I was afraid work may see it and I get in trouble. Right now I can go back and edit it. I have a question on the algo. What is there is a Status of: P1 on 12-01-14 A1 on 12-08-14 P1 on 12-14-14 Then the record should not be pulled into the query because the...

Thank you for responding. Yes maybe I am not as clear as I would like to be. So I will tell you my whole story. I have 2 tables. Patient Attribute The tables have a one to many relationship with record ID Each Patient has one record in Table Patient , but can have many records in...

Hi, Thank you for the fast reply. Yes I am looking for the latest most recent record to pull up only if it is a P1 status. With your code. It pulls up a record but only 1. Not sure yet why its pulling this one. If there are 3 records with the same record id of 001 and the first record has...

I have a query with a record id, report date and status. How do I pull the latest record if the status is AA? For latest record in report date I used Max in Totals. With just this max it is pulling the latest date for each set of records with the same record id. This is a start now how do...

Hi, I am trying to learn Access with my new job but sometimes have specific questions. Each day I am learning more and learning how to edit VBA and a little bit of SQL. I am watching youtube videos on Access and reading teh thread and using google. Was wondering is there anyone that is nice...

I am trying to do more research on how to take a record (persons address, Social security, etc) and de identify it. What I am looking to do is if a box is checked that means I can show the records information. If the box is unchecked each record would have some sort of value like X111111...

Okay great I will run a qry for each database. I have one backend database. I have 4 front ends each front end is to a Software. For instance 1. Sony has a Front end is Access 2. Sharp has a front end is access, etc. I want to combine all the font ends together but have to make sure the...

I have a master table located on the backend of the server with about 3 fields: Software Version Description I have 4 databases, one for each software on the front end accessing this master table. So far I have in the master table a dropdown to select 1 of the 4 software's, the version...

UPDATE: I removed the line and its working. So since I have the record soruce bound to the table that is how the form get's the data to the table. If I was using an append qry than I would have to open the qry to get the info to the table, right? I think I am understanding a little more...

The query is not an append query. It is a normal Query. I am not sure do I need the Qry? If I delete it I think it still works, I tried it before and it was working fine. When I click the cmd button doesn't or can the information just go to the table and the qry not be needed? I guess I am...

Thank you pbaldy again. I wish i could give you a hug for being so kind. Now when I hit the cmd button it opens "qrySuggestions" I know what code opens it up, but how else do i get the information to the table. Would like it to not open the qry everytime I hit the cmd button, wouldnt that...

Hi pbaldy Thank you for replying. I am so close. Thank you, thank you!!! I removed the Cancel event. Now when I put the code in below the information will submit to the table but will not close the form. When I click the cmd button it just sits there. It will say First Name or Last...

Okay I will try to remove the do.cmd cancel event. I have moved this into the VBA forum since that may be a better place for this. Ill take a look at the before update option. Thanks. http://www.access-programmers.co.uk/forums/showthread.php?p=1401404#post1401404

Okay I think I am almost there. I have a simple form to enter first name and last name. When I click the cmd button it opens the Query up. I don;t want to open the query up just for the First name and Last Name to go to the Table. The Tables are located on another server but I have it linked, if...