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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: cygne
  • Order by date
  1. cygne

    How do you stop In-Place Activation

    Found a way. I added the following statement before the "Me.oleWordDocument.Action = acOLEActivate" statement: Me.oleWordDocument.Verb = acOLEVerbOpen Thanks, Jim
  2. cygne

    How do you stop In-Place Activation

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

    Query using unrelated tables

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

    textbox properties in code

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

    How to populate list box with user-function

    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 ;
  6. cygne

    Create report grouping by "buckets"

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

    Create report grouping by "buckets"

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

    Show Date of Last Change on Report

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

Part and Inventory Search

Back
Top