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!
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
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...
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...
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
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
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.