Search results

  1. K

    Can't figure it out

    are u bored and trying to waste your time as well as others!? OK the answer isn't there...what is your problem sir..you can very well ignore it!
  2. K

    Can't figure it out

    Thanks for the complement RICH the websit that i provided does the same damn thing....it gives you exaples with reports and its functions dear !
  3. K

    Can't figure it out

    try this website as well...
  4. K

    Printing Forms

    this might work! In the Command Button Wizard, choose the category> RECORD OPERATION, then the action PRINT RECORD. This will print only the the first page of the form!
  5. K

    count problem again!!!!

    hmm.... I tried to make the reports using the queries....but it does not allow me to use anyother query along with the Count query! is there a way to solve this?
  6. K

    count problem again!!!!

    yup you were right! It wont let me count the fields in the same query so I guess I will just run it seperately....I was hoping that it would let me make a report with pulling both the queries but that dint work either so this is it a sepearate query for count! Thanks a bunch!
  7. K

    count problem again!!!!

    Sorry folks have asked this question before but I could not solve it the right way so will appreciate some more solutions! SELECT Count([Work Orders By Today's Date].[WorkOrder#]) AS [CountOfWorkOrder#], [Work Orders By Today's Date].Craft, [Work Orders By Today's Date].Description, [Work...
  8. K

    problem with count!

    hmmm....:( would u tell me how to do that!! can't figure out how:confused:
  9. K

    problem with count!

    help help! well....now it is giving me all 1's. It dosen't increment with every work order I enter! what should I do?
  10. K

    problem with count!

    WORKS Thanks a bunch.....it works just the way I wanted it to !! Great:)
  11. K

    problem with count!

    problem with count! another prob! I have a query which sorts all the "Work Order for today's date" SELECT WorkOrder.[WorkOrder#], WorkOrder.Craft, WorkOrder.Description, WorkOrder.Zone, WorkOrder.Building, WorkOrder.[Room#], WorkOrder.TypeOfRequest, WorkOrder.Priority FROM WorkOrder WHERE...
  12. K

    help me fix this SQL query!

    ThankYou All Thanks a bunch got my problem fixed....and will make sure that i check the typo's little more carefully next time:rolleyes:
  13. K

    help me fix this SQL query!

    hi DOC and RV I tried both of your solutions and both times it gives me an error "syntax error" These are the two eg: (DOC'S SUGGESTION) SELECT WorkOrder.[WorkOrder#], WorkOrder.Craft, WorkOrder.DateRecieved, WorkOrder.DateCompleted, WorkOrder.FollowUpComments, WorkOrder.CraftPerson FROM...
  14. K

    help me fix this SQL query!

    Ok, here's the query that isnt working the right way. What I'm intersted to do is to be able to type in the last name of the person or the first name and bring up ONLY that persons work orders! What is happening right now is that it pulls out all the CarftPerson! SELECT...
  15. K

    Open report in "landscape"

    Thanks... I was having the same problem! Now got it fixed!
  16. K

    Auto NUmber fields...

    I have a table where the "Work Order#" is a Auto Field. Then I have a form and for some reason the work order # always starts with no. 30 or so.....I checked it is not set on Random numbers either! How can I fix this problem! The Work Order # field is a foriegn key in 8 other tables as well...
  17. K

    using the tab key in Forms!

    Hi there.... I would like to know if I can have the cursur jump from one field to the next immediate field using a tab key in a form!? Similar to the way we can have the cuursor jump to fields in EXCEL FORMS... Right now when I hit the tab key the cursor just jumpes from one field to another...
  18. K

    Problem

    thanks!:) Wil try and hopefully find the duplicate :o
  19. K

    Problem

    I had my DB running all well...with the forms and queries and links in between them! However, now it gives me an error everytime I try to use a button on one of the forms to open another form Error message: Ambiguous Name Detected I some how cannot seem to figure out the problem!
  20. K

    Need Help!

    I can see the form feilds in the Design View "Detail Section" but not in the form view !!!!!!!!! If i copy and paste the fields in the "header section" then it does show up in the FORM VIEW but does not allow me to enter any values in the fields!!! I'm totally confused!!!
Back
Top Bottom