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: *

  1. misscrf

    Access VBA Subform Dynamic SQL Parent Form Count Slow

    ...a SQL view, which runs way faster. That turned my filter code to the following: Private Sub Filters() Dim fSQL As String fSQL = "SELECT * FROM vw_MyView WHERE 1 = 1 " If Nz(Me.cboFilterTo.Value, 0) <> 0 Then fSQL = fSQL & " AND tbltable5.ID = " &...
  2. misscrf

    Access VBA Subform Dynamic SQL Parent Form Count Slow

    Well, I did that and it causes the entire form to take an entire minute to load. I have tried other ways, like taking the dynamic SQL statement and doing a recordsset.fields(0) count tally, but that is slow and doesn't seem to get the right count. Still looking for options. misscrf It is never...
  3. misscrf

    Access VBA Subform Dynamic SQL Parent Form Count Slow

    The problem is that the SQL is not 1 table. It's about 6 tables all joined together. I was thinking of making a 2nd sql, that would be the exact same, but instead of selecting the fields, it would be a select count. I'll try that and post back. misscrf It is never too late to become what you...
  4. misscrf

    Turn off filter and use form's finder combo

    Instead of using the form filter and filtering the recordset, pass the open args and find the record in the full recordset, like this: Dim rs As DAO.Recordset Dim Args As Integer Args = Nz(Me.OpenArgs, 0) If Args = 0 Then DoCmd.GoToRecord acDataForm, "frmCustomers"...
  5. misscrf

    Updating a main form field from an unbound sub-form field

    In the textbox control on your main form, set the Control Source, to the textbox control on your subform. It will look something like this, in the main form's text box Control Source property: =[frmSubForm].[Form]![txtCalcControl] misscrf It is never too late to become what you could have...
  6. misscrf

    Screen Flicker

    Did you try docmd.echo = false or application.echo = false? You need to make it true, when you want to update the results they should see on the form too. misscrf It is never too late to become what you could have been ~ George Eliot
  7. misscrf

    Close form and use VBA to refresh another open form

    Before you close the update form, in the vba, put this: Forms.frmFormToUpdate.Form.Requery If you are updating a subform, then this: Forms.frmFormToUpdate.frmSubformToUpdate.Form.Requery misscrf It is never too late to become what you could have been ~ George Eliot
  8. misscrf

    Access VBA Subform Dynamic SQL Parent Form Count Slow

    ...To display the count of the subform records on the main form, I put a textbox in the form footer of the subform, and it's control source =count(*) On the main form footer textbox, the controlsource is =[frmsubform].[Form]![txtCountrecs] & " Records" The count works, but it is so slow, even...
  9. misscrf

    Access Combo Change - Check Before/After Values and Other Combos Before Change (Update)?

    I have 3 combos. The first one is to pick the type of voting panel. Some of the options are a panel type (column(2) - hidden) of a person, the others are a group. If the type of voting panel chosen is a type of person, a person combo is shown. If the type of voting panel chosen is a group, a...
  10. misscrf

    SQL Database Diagram - SQL Server 2014? Visio 2010 Won't :-(

    I typically make a Visio database model diagram, doing a reverse engineer feature. My issue now is that I have Visio 2010, but I need a model for a database on a 2014 server. It seems the Visio driver in 2010 is not compatible for SQL Server 2014 database connections. I tried the generic ODBC...
  11. misscrf

    Access Subform Datasheet View - DateTime Field?

    I found if I typed a format (instead of picking General Date) the time shows properly. The format I typed in is the following: mm/dd/yyyy h:nn ampm In case it helps someone else. You can still use the standard date picker, but will need to leave and come back to the field to fix the time...
  12. misscrf

    Access Subform Datasheet View - DateTime Field?

    I have a subform with a datetime field (linked from SQL). It shows a calendar picker, but doesn't show the time. I switched the format to long date, and that didn't work. Anyone know what I'm missing? Users need to be able to pick or enter date AND time into the field. I've been...
  13. misscrf

    Analyzing/Documenting a Database?

    Thanks for the suggestions. I feel like eventually I will use some 3rd party, and some custom built, to create a complete documentation toolset. I wrote this simple function (below). I added it to a separate module, that I call Mods. It's where I keep the majority of my public functions. I'm...
  14. misscrf

    Analyzing/Documenting a Database?

    I found this, which is pretty helpful. http://www.accessdependencychecker.com/ I'm thinking of writing some code that will insert info into a table. I want to focus on getting all controls on every form, so I can be sure what events are in use, and what rowsources are calling what...
  15. misscrf

    Analyzing/Documenting a Database?

    When I try to run that query, I get this error: I run the documenter, close the useless formatted report, and try to run that. It can't seem to find the table. misscrf It is never too late to become what you could have been ~ George...
  16. misscrf

    Analyzing/Documenting a Database?

    Thanks, Duane! I knew about that documenter, but always hated that it just produced a formatted report. I'm wanting to be able to look up a linked table/view and find anywhere it's being used. I want to be able to convert queries to SQL views, and link them back in. But in order to do that, I...
  17. misscrf

    How can I format a bookmark?

    try this: http://www.vbforums.com/showthread.php?700021-Change-font-in-Word-bookmark-using-VB-6 misscrf It is never too late to become what you could have been ~ George Eliot
  18. misscrf

    Hyperlink on form behaving oddly

    ...with percent sign and hex value (address only.) strAddress = EscHex(strAddress, strcEscChar, "&", """", " ", "#", "<", ">", "|", "*", "?") 'Replace backslash with forward slash (address only.) strAddress = Replace(strAddress, "\", "/") 'Add prefix if address...
  19. misscrf

    Analyzing/Documenting a Database?

    I'm looking for a tool (preferably free or free trial) so I can document all objects and such in an Access database. I am looking at replacing a linked SQL view, and will need to know everywhere I use it. Whether it's a record source for a form, row source for a combo or listbox, or if it's in...
  20. misscrf

    Debug.print time between functions?

    No, you got it. I ended up realizing I could do the same, I just formatted it differently. Debug.Print "Start doing step N" Debug.Print Format(Now(), "hh-mm-ss") blah blah step n Debug.Print "finish doing step N" Debug.Print Format(Now(), "hh-mm-ss") Thanks! misscrf It is never too...

Part and Inventory Search

Back
Top