Search results for query: *

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!

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

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

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

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

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?

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.

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

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

I did that, but it is not wraping

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

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

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

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

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

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

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

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

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

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