Found a way. I added the following statement before the "Me.oleWordDocument.Action = acOLEActivate" statement:
Me.oleWordDocument.Verb = acOLEVerbOpen
Thanks,
Jim
I have a form that has an OLE control on it. When I activate it, it does an in-place activation. What I want is for it to activate Word outside of Access for the document.
For example, if I bring up the table and double-click on the OLE field, Word is brought up outside of Access. This is...
You may not be able to get the data using 1 query if I understand you correctly. If you are getting similar data from each table you can use a UNION. Statement would be like:
Select a,b,c from tableA Where someconditions
UNION
Select d,e,f from tableB Where someconditions
UNION
Select g,h,i...
Instead of populating from a table, populate from a query. One method is to use UNION in the SQL statement:
Select column_name from your_table
union
select "All" from your_table
;
Use the DatePart function to determine the Week Of Year:
DatePart("ww",[DateHappened])As WeekOfYear
This function was made for that operation. I forgot about the DatePart function -- it should be used instead of calculating using the DateDiff function.
I would create a query first. The query here groups by "week of the year", "day of the week", and criteria summing on the number of instances.
DateHappened is a Date field
Criteria is a Text field
TimesOccurred is a Number field
SELECT...
I'm assuming that you want the latest date that appears for ALL rows in the table -- only display one date and that is the latest. If so, create a textbox and set its control source to:
=DMax("Updated","YourTableName")
An alternative is to add the aggregate function...
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.