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 Rhinorhino 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: SERT1
  • Order by date
  1. SERT1

    Altering the Shift startup option

    I know there have been threads on this before, but none have actually hit on what I would like to do. Instead of disabling/enabling the "AllowBypassKey", is there any way to alter the bypass key to be something like SHIFT+ENTER+E?
  2. SERT1

    Run a query from another database

    Lonnie, the answer you gave me worked great!!! Thanks so much. I'll post it below for others to benefit from. The only thing people should keep in mind is that if you are using a front-end, back-end application, this code must be written to the back-end. Here's the code: Public Function...
  3. SERT1

    Run a query from another database

    So far I've had no success in getting these methods to work. Any more suggestions? I'd greatly appreciate it.
  4. SERT1

    Run a query from another database

    Does anyone know how to run a query in another database? I.e. vba code in database1 runs query in database2.
  5. SERT1

    DAO Missing

    Thank you for helping. DAO was not on the list of options, but it did have a browse button in order for me to append the .dll file to add DAO. Thanks.
  6. SERT1

    DAO Missing

    I am trying to write some code in VBA, but when i specify a DAO.Recordset, i get a type mismatch. Does anyone know how to get Access 2000 to automatically reference DAO?
  7. SERT1

    MSchart?

    It's probably a trendline. You can add or delete trendline lines using the following code: GraphObj.SeriesCollection(1).Trendlines.Add GraphObj.SeriesCollection(1).Trendlines(1).Type = 1 GraphObj.SeriesCollection(1).Trendlines(1).Delete
  8. SERT1

    Access Graph Legend Colors

    Does anybody know how to change the fill/back color of a Access Graph legend that has been created using VBA?
  9. SERT1

    Dynamic Subform

    Does anyone know how to create a dynamic subform? I have 3 queries that bring back different information. There is an option box to select what you want to see. i.e. Qry 1: Date, # of Records Qry 2: Date, FailType1, Failtype2, Failtype3 Qry 3: Date, FailType, Cost What I would like to do...
  10. SERT1

    Multiple Page Form Problem

    If your subform is based on a query, you can use the [VenID] in your query. When this field changes, you requery the subform in code and it will bring back your data. On an &quot;AfterUpdate&quot; of the [VenID] field: <subformname>.requery This will update your subform.
  11. SERT1

    MSgraph Axes

    Does anyone know how to change the Y axis on a graph from &quot;Percent&quot; to &quot;Number&quot; using VB? I have only been able to find how to change the min & max scales using VB, nothing on changing the axis type.
  12. SERT1

    Username Table - How to use it using VBA

    I have created a username table in my database based on a network login. I have created VBA code that is supposed to look up the login ID in a table, but it's not working properly. Can anyone give me a code that will look up the &quot;Environ(&quot;Username&quot;) and compare it with a table...
  13. SERT1

    Color fields in forms based on ctl value

    Unless the &quot;select case&quot; part is different than an &quot;If..elseif&quot; statement, this does not work. What happens is all of the comboboxes in the continuous form turn the colour you've selected, regardless of the value in subsequent records. The &quot;conditional formatting&quot...
  14. SERT1

    Color fields in forms based on ctl value

    I have a problem with changing colours on a combobox field in a form based on a value. If am using Access 97, so it doesn't have the &quot;conditional formatting&quot; tool. To make it simple, here is the scenario. I have 3 records, each one with an Identifier and a combobox field. The...
  15. SERT1

    Change font colour in txt box when equals different values

    I have a problem with this also. To make it simple, here is the scenario. I have 3 records, each one with an Identifier and a combobox field. The combobox options are Yes, No, NA. When showing these fields on a continuous form, how would I be able to have record #1 combobox field show red...
  16. SERT1

    Control Source of a Graph

    I am wondering if you can change the control source of a graph through vb code and if so, how? Thanks.
  17. SERT1

    Linking Access query to a table in MS Word

    Does anybody know if it is possible to link an MS Access query to a MS Word table that will update when the query changes?
  18. SERT1

    Using DateAdd in a &quot;Between&quot; criteria in SQL

    Yes, it was already selected and the query still isn't returning the proper data.
  19. SERT1

    Using DateAdd in a &quot;Between&quot; criteria in SQL

    I tried it and it doesn't work. I'll copy a piece of my sql: ((Format([FIN_DATE],&quot;mmmm yyyy&quot;)) Between DateAdd(&quot;m&quot;,-3,Date()) And DateAdd(&quot;m&quot;,-1,Date())) I get 0 records, and there should be some.
  20. SERT1

    Using DateAdd in a &quot;Between&quot; criteria in SQL

    Does anyone know the syntax to query for data between 3 months ago and 1 month ago, ie. >=DateAdd(&quot;m&quot;,-3,Date()) And <=DateAdd(&quot;m&quot;,-1,Date()) or Between DateAdd(&quot;m&quot;,-3,Date()) And DateAdd(&quot;m&quot;,-1,Date()) I've tried both, and neither works. Can you use...

Part and Inventory Search

Back
Top