Search results

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!

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 !

try this website as well...

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!

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?

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!

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

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

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?

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

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

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:

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

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

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

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

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

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

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!

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!!!