Recent content by kmkland

Thanks LesPaul for the document. It actually helped quite a bit. I just needed to step back and approach the design a bit differently. I have been so wrapped up in constructing the tables properly and focusing on the end result that I got tunnel vision and couldn't see how to do it. Thanks...

My field names are actually similar to the ones I listed, but not exactly the same for simplicity purposes. Field names are not my problem; constructing proper relations and number of tables are the problems that I am having. The date and time must be stored differently; they are unrelated to...

I am at a loss on how to develop tables pertaining to a procedure. In my table (we'll call it tblProcedure), I have a Date field, which is never duplicated so it is the primary key. Other fields include: Time, Shift, Auditor. On a particular date, I could have a non-compliance on a Form...

Remou: Sorry I didn't let you know sooner the result of your suggestion. It worked brilliantly! Cheers for everyone's help! Rgds, Kmkland

ID Date1Stat Date2Stat Date3Stat Date4Stat 1 Bad Good 2 Decent Not Good Bad Rgds, Kmkland

I need ALL of the fields that do not contain "OK". Rgds, Kmkland

Then, it will produce no results. Rgds, Kmkland

Leslie, I had forgotten to remove the combined fields.... Now, I feel quite silly. :) Unfortunately, I'm still getting the same results. Rgds, Kmkland

I have created a statement using Not Like, but I am not getting the results that I need. Here's the code: SELECT [tbl7-10Procedure].Date1Status, [tbl7-10Procedure].Date2Status, [tbl7-10Procedure].Date3Status, [tbl7-10Procedure].Date4Status FROM [tbl7-10Procedure] WHERE ((([Date1] & ' ' &...

Remou: I am having network issues and printer settings. I will try your suggestion with sending the reports directly to the printer, instead of displaying a preview. I am sure that it will work. I will let you know how things go. Thanks for everyone's help. Rgds, Kmkland

Here is the code: Private Sub btnGenRpt_Click() Do Until Me.txtCopies = 0 DoCmd.OpenReport "rptNonconfFrt", acViewPreview, , , acWindowNormal Me.txtCount = Me.txtCount + 1 Me.txtCopies = Me.txtCopies - 1 Loop End Sub I have the report in Print Preview to review it before I print...

So, do I continue to use the codes at all? The original idea that you had posted? Rgds, Kmkland

Remou: I am confused. Do I still use the codes you posted earlier? Is the second text box on my report visible? I made the query the control source for my template. I am guessing that I do not need the codes now (?). Please, advise what I need to do concerning this. It is now generating...

I don't know. It is only printing 1 copy of the ending number that comes after the last sequential number I want to print. If anyone has any suggestions, I would greatly appreciate it!! Thanks for any and all help on this matter!! Rgds, Kim. Rgds, Kmkland

Hi Remou, Thanks for your response. I tried your suggestion. I will enter "501" for the number and "3" for the copies and only 1 copy will print with "504" printed on the report....instead of 3 sequential copies from 501-503. Rgds, Kim. Rgds, Kmkland