Search results

Hi JHB, Thanks for answering my post. The problem seems to be with the WinZIP file. Do you or have you tried this out? Have you tried the WinZIP option? If you do so what version are you using? I think becase it is looking for winzip.exe and I have WinZip15 and it says winzip32.exe. I...

Okay now I understand. I put the code in "On click" which is the wrong spot. Now: I put the code in "On Load" for report right now and it is working. I will do this untill a form is created and use the botton to put the code in. Thank you kind sir!!!!!

Yes I opened in report view and still I see all records. How is it that you don't see it and I see it? Did you open the attached file where I changed the code? Wondering why it would be different. hmmm :banghead:

Yes I closed the report and repopened it.

Okay so I finally was able to add the code in the report: I still get all results. Did you get it to work? Am I doing something wrong?

Yes you are exactly right. The report is opened thru a form, from that point many options are available. Thank you again for taking the time to reply. All of this has been very informative. :)

I see what you are saying. No when I click the botton on the form I will only need the report when it's filtered. When clicking the button it opens 3 other reports as well. In the form while viewing each person it will show if they are over or under the weeks. This is why I needed the query...

Big thank you to Pbaldy and essaytee. Both have you have been very helpful. I will test these options out when I have some free time and I am back on my computer. I just wanted to say thank you for the replies, you guys are great!!!! :):):)

What does this mean?

Is there any FREE software out there where a person can: Backup Compact and Repair Multiple Databases. Would be great if I can backup around 30 days and than I can delete or it would automtically delete the older ones. Well I found such software and it looks great...

I can but I will have to do it later because I have to gut everything out. There is very confidential information on there and the database has my Companies name, etc. I would love to post here just need some time later to gut it if I don;t figure it out. Can I ask what do the 3 commas...

Okay so I typed in the code and now the code is not in red font which makes me believe that we are taking a step forward. The problem now is that it still does not filter any records. The same 200 records with Johnson are being shown. I would think that there would be some type of error...

Great idea jdraw, here you guys go: SELECT a.Data1, a.Data2, a.AgeData, a.FirstData, a.LastData, a.DOBData, b.SetDate, b.ReasonData, Date()-SetDate-2*Int((Date()-SetDate)/7)-IIf((Weekday(Date())-Weekday(SetDate))<0,2,0)+IIf(Weekday(SetDate)=7,1,0)-IIf(Weekday(Date())=7,1,0)-(Select count(*)...

Okay so I typed the following code into On Click Event Procedure: Private Sub CtlLastName_Click() DoCmd.OpenReport "rptBills", , , "LastName = '" & Me.<> "Johnson" & "'" End Sub When I did that it seems that it does nothing. The report still returns all 200 records. When I go back into the...

Okay so in Event Procedure I write: DoCmd.OpenReport "Bills", , , "LastName = '" & Me.NOT "Johnson" & "'" Do I need to type in End Sub or anything else? Thanks. Name of Report = Bills Name of Column that has the Criteria = LastName Criteria Needed = NOT "Johnson" (to include all records...

2 Questions I have query named Bills that has about 200 records. I need to make a report so I put a criteria in the query for the columns LastName and wrote: <>"Johnson" or NOT "Johnson" 1.) Do both output the same thing? I want to have all records in the query and take out any record...

Hi jdraw, You have gone beyond kindness to go this far to help me. Thank you very much from the botton of my heart,. I eneded up writing a query with a friend this is what we did and it worked. We ran a sub query with an inner join. The report over all checks the last status for each record...

Yes the purpose of this is to show someone that has a P01 status. If his status is idle for to long (more than 3 business days) than a query would be run each day to show that his status is idle and something needs to happen.) So if I get the last status or more recent status for each patient...

This will be very helpful. I am going to have an outside person help me with this as I have a deadline to get this out. I can learn from someone helping me with the code. I will show them this as this maybe a solution. Thank you very very much. :)

Okay i created a duplicate Query to find duplicated within the same recordid and Status. It seems to work for now. May have a question on the business days beging greater than 3 days, will do some research. Thank you very much for your time and efforts.