Search results for query: *

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

Use either: YourTextBox = "what you want there" or YourTextBox.Value = "what you want there" Good luck...

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