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!

  • Congratulations strongm 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. adwanoy

    close window

    Missingling thanks, but how in the world do move the form to any position? I mean, it always starts at top left! and dont forget it is a continuous form!
  2. adwanoy

    close window

    adalger, thanks that works fine. I still have the other problem, how to start a form in a specific location, and if possible in specific height
  3. adwanoy

    close window

    hey guys, I think I have a anothe MS Access, even though it is 2003 but that what I had, docmd.quit but it always exit the form into the application window, I want to exit outside the application to the windows desktop
  4. adwanoy

    close window

    Hi all how can you close the window after you exit an application, in order to return to desktop. you the window it has "File Window Help" on top left
  5. adwanoy

    Date/Time data type

    Guys Thnks so much. I beleive I am not explaining my case. Majp, what you said is very nice. adalger: I do have a table with compond key, number and date, but access won't let me insert recors like: no(integer) e_date(date) --- ---- 1 6-15-2006 1...
  6. adwanoy

    Date/Time data type

    hi actualy, the table key is compond key(a:number,d:date) and there is a need to have multiple row at the same date, so I was thinking time makes it unique?
  7. adwanoy

    Date/Time data type

    hey guys Can I have a feild of type date/time as a key for a table, where I can enter multiple values for the same date but different time? I know Access store time with date, but how to minipulate it.
  8. adwanoy

    Form Height

    Thanks so much, but I had those property set to auto center = yes and auto resize = no only the first form has a fixed size, the rest they are continuous, where in the design they are realy small in height, but once it runs, it get big, but not big enough and for one size no matter how much data...
  9. adwanoy

    Form Height

    Hey guys I have an application consists of 4 forms. the first form calls the second ,...etc the forms view are "continuous form". the "Pop up" and "Modal" property of the forms is set to yes. the problem is that each form displays differently on the screen, where I want them all to be displayed...
  10. adwanoy

    Wrap text in field

    I did that, but it is not wraping
  11. adwanoy

    Wrap text in field

    Hey guys, I have a field which is text and its length 200 how can I wrap the text in a field within a form, say in 50 char field length, so the user can scroll within the field to read the whole text. thanks
  12. adwanoy

    Help with this query

    My man PHV thanks very much, here is the result CompID Priority Keyword Description 381 22 D Perform proper corporate record. 382 21 I Determine actions based upon. 401 11 P Uphold ARC standards and be 402 12 L Acquire full information for 408 11 P Develop action plan with...
  13. adwanoy

    Help with this query

    TheAceMan1, Thanks for your concern. the problem that we have many records with the same priority within the same keyword and other keywords. so what value would the function return. I mean if I link this query with the table that has the fields I wanna return, there are many of them. what I...
  14. adwanoy

    Help with this query

    Do you men min? well the query returns something like this: minimum keyword 11 A 12 B 11 C and so on the priority values are, 11,12,13,21,22,23,31,32,33 and 11 is the highest. I want the higest priority within each keyword. so if...
  15. adwanoy

    Help with this query

    Thanks, this is what I don't know how to do it. can you show how
  16. adwanoy

    Help with this query

    That doesn't work because it reurn all the keyword, where I only wants certain ones. here is me original query: SELECT Min(Comp.Priority),Comp.Keyword FROM Comp INNER JOIN ((Activity RIGHT JOIN (position RIGHT JOIN (Job RIGHT JOIN task ON Job.TaskID=task.TaskID) ON position.TaskID=task.TaskID)...
  17. adwanoy

    Help with this query

    I have a query that looks like this: select min(priority),keyword from table where condition group by keyword which it works fine, except that I want the query to return other feilds in the select, but I keep getting errors because of the aggrigate function min. any help thanx
  18. adwanoy

    How about this query

    GREAT, THANKS actually I forgot Table3 Activity, Task 1, 10 2 1, 130 2, 150 2, 151 3, 152 and againg activity=1 how the sql will be for the 4 tables
  19. adwanoy

    How about this query

    Hey, guys this is the case Table1 Job, Task 1, 101, 1, 102 1, 103 2, 104 3, 105 Table 2 Position, Task 1, 102 1, 130 1, 131 2, 145 2, 146 Table 4 is a repository of the 3 tables Task, Description 101, aaa 102, bbb 103, ccc 104, ddd 105, eee 130, fff 131, ggg 145, hhh 156...
  20. adwanoy

    Group Query

    Keyword Priority A 1 A 1 A 2 A 3 B 2 B 3 C 1 C 2 C 3 IN the above data, I want only the top 1 priority for each Keyword, so the results should be: A 1 B 2 C 1

Part and Inventory Search

Back
Top