Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. kmkland

    Table Structure...

    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...
  2. kmkland

    Table Structure...

    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...
  3. kmkland

    Table Structure...

    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...
  4. kmkland

    Generate Sequential Numbers on Report

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

    Not getting Results!!

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

    Not getting Results!!

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

    Not getting Results!!

    Then, it will produce no results. Rgds, Kmkland
  8. kmkland

    Not getting Results!!

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

    Not getting Results!!

    ...[tbl7-10Procedure].Date3Status, [tbl7-10Procedure].Date4Status FROM [tbl7-10Procedure] WHERE ((([Date1] & ' ' & [Date1Status]) Not Like "OK*")) OR ((([Date2] & ' ' & [Date2Status]) Not Like "OK*")) OR ((([Date3] & ' ' & [Date3Status]) Not Like "OK*")) OR ((([Date4] & ' ' & [Date4Status]) Not...
  10. kmkland

    Generate Sequential Numbers on Report

    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
  11. kmkland

    Generate Sequential Numbers on Report

    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...
  12. kmkland

    Generate Sequential Numbers on Report

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

    Generate Sequential Numbers on Report

    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...
  14. kmkland

    Generate Sequential Numbers on Report

    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
  15. kmkland

    Generate Sequential Numbers on Report

    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
  16. kmkland

    Generate Sequential Numbers on Report

    I am trying to generate numbers on a report for which the user will enter the parameters (i.e. Number: 550 for the first report.....Number: 600 for the last report -->thus printing 50 copies of my report, each with a different sequential number). My report is basically a template. I print the...
  17. kmkland

    Problems with Expression in Crosstab Query

    ...Count(qryCountAbsJoin.EmpFileNo) AS CountOfEmpFileNo, qryCountAbsJoin.Date_of_Absence, Year(NZ(qryCountAbsJoin.Date_of_Absence,#1/1/1900#))*100+Month(NZ(qryCountAbsJoin.Date_of_Absence,#1/1/1900#)) AS YrMth FROM tblReasonsForAbsences LEFT JOIN qryCountAbsJoin ON tblReasonsForAbsences.Code =...
  18. kmkland

    Problems with Expression in Crosstab Query

    Just thought that I would include this bit of information: I have a similar crosstab query where I was able to accomplish what I needed - displaying & grouping the month/year as row headings on my report. Base query: SELECT tblEmpInfo.EmpFileNo...
  19. kmkland

    Problems with Expression in Crosstab Query

    DHOOKOM, I have a main table with employee information and EmpFileNo as the primary key. This is linked to another table which details the employees' absences. There is only an entry under Date_of_Absence if the employee has been absent. The relationship is 1 (Main) to Many (Absences). I need...
  20. kmkland

    Problems with Expression in Crosstab Query

    I solved the problem with the error message stating that the expression is too complex; I removed the following date format from the query upon which my crosstab query was based: CDate(Format([qryCountAbsJoin].[Date_of_Absence],"mm/\1/yyyy")) AS Date_of_Absence Unfortunately, I need this format...

Part and Inventory Search

Back
Top