Search results

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

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

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

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

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

hie....I'm unable to enter data in my form! Rather i keep getting the message: "Control can't be edited; its bound to unknown field:" please help me fix this error!

I have a form which does not allow me to input data in the text fields! Rather I get the message: "Control can't be edited; its bound to unknown field:"