Search results

  1. D

    Dynamic Report based on Current Form Filter

    I am narrowing it down now. If I open the subform on its own (ie not on the navigation form), the filter pass-through works as expected. If I try it through the navigation form, I get Runtime Error 2450, cannot find the referenced form. This is the code I am using: Private sub...
  2. D

    Dynamic Report based on Current Form Filter

    Darn, I was really hoping this was the issue but they have the same source, called qryAmmo. I am just at a loss. ETA: So I just noticed that when I filter my form using my text box or buttons and then switch to design mode, the Filter property is empty. Shouldn't the filter be stored there? If...
  3. D

    Dynamic Report based on Current Form Filter

    I have tried it with acViewReport so that it didn't print, I was short on time and typed quickly and hopped over that bit in my examples here, sorry!
  4. D

    Dynamic Report based on Current Form Filter

    Yes, that was the first thing I tried and I was disappointed that it does not pull the filter over. Instead, it creates the report with all 8000+ objects.
  5. D

    Dynamic Report based on Current Form Filter

    I am driving myself crazy with this. I have a form with various filters. One is a free-form textbox where you can type in a word or phrase and it will search most of the controls on the form, another is a button that selects all items that have a certain checkbox checked, and another is a...
  6. D

    Search String to include variants

    Exactly, I realize what you are saying. A "fuzzy search function" was what I was after. Any tips on how that is achieved or where to look? I have been actually trying to solve this bit of a problem for a few years on and off without success (work on it a few days and give up again in defeat)...
  7. D

    Search String to include variants

    If I am using a text field on a form for users to be able to search in, are you saying I have to tell them to use the wildcard *? (we have another Sharepoint site where we have to use a wildcard search and I can say most users have a very difficult time with that still. I was hoping for a...
  8. D

    Search String to include variants

    I have a search string connected to a text field on a form and it searches many of the controls on the form and works very nicely. It is on another computer so I cannot copy and paste it here easily but it is in the form of strSearch = "SELECT * from qry where ((objID like ""*" & strText &...
  9. D

    Handling relationships between Documents and references

    I have been so busy with other work but I want to thank you for your reply! I am working on it and it is not done yet but this got me on the path and I am much closer. Thank you so much!
  10. D

    Handling relationships between Documents and references

    I had a hard time even coming up with a succint title to this question. I am creating a database to act as a searchable register of reports. These reports come yearly, about six per month, since about 15 years back. I am trying to make the database as searchable as possible to enable finding...
  11. D

    Query multiple tables

    Please excuse my ignorance, I am trying to wrap my head around this as someone untrained in VBA. When I tried to create a query with multiple tables before posting, it seemed to "blend" all data together in a horrid Philadelphia Experiment sort of way that actually made a list of results so long...
  12. D

    Query multiple tables

    I have a database with multiple tables I will call ExtAssist, AmData, and Library. The ExtAssist table is used to document "incidents" where agencies call us for help about an object. The AmData table contains the objects list that we have in our file system. The Library table is a database of...
  13. D

    Solved If Then and On Error GoTo

    Thank you for the me.Repaint suggestion, I will try that! I am not using a hyperlink data type in the table, but it is in a text field and I added the Application.FollowHyperlink code to it. Is that what you mean? I have heard a lot about the negatives of hyperlink data type so I have avoided...
  14. D

    Solved If Then and On Error GoTo

    Exactly what I needed, thank you so much! I realized as soon as I saw it that I had the Exit Sub earlier but had retyped and changed and forgot to add that line again. Thank you again!
  15. D

    Solved If Then and On Error GoTo

    I can't say I KNOW much about VBA but in this instance, I added it because after the auto-hyperlink is generated, it was not showing up until I refreshed the page. When I click the button, the text is generated and is filled in to the text box. Is there another/better way around this besides...
  16. D

    Solved If Then and On Error GoTo

    Hello again, I have, in relation to another post, come upon another error that is confusing me. I have the following If then statement: On Error GoTo ErrMsg If Len(Me.Referens.Value & "") = 0 Then [Referens] = "#.....Explorer directory path..." & Me.Arendenr Me.Refresh Msgbox...
  17. D

    Hyperlink subaddress

    Good afternoon all, I have a form with a "Reference" text box with a button. The button currently has VBA to open a specific folder where files can be found for each record as default, if the text box is empty. This part works without any problems. What I would like to happen though, is if a...
  18. D

    Error saving record, write conflict?

    Interesting. The affected field in this case is a long text field and not an identity field/number and not on an SQL server. As a workaround I will have my coworker create a new record and see if we can delete those that seem corrupted. However, the idea that information loss can happen without...
  19. D

    Error saving record, write conflict?

    I have never come across this before. The text in a long text field in our database shows #Deleted for two records. When trying to retype what was lost, an error message comes up. It is in Swedish but it says something along the lines of "Your changes cannot be saved because another user has...
  20. D

    Attachment removal

    We have a database with two tables that currently have an attachments field. My boss adores it and feels it is super easy and convenient, but I realize now that it is a problem I never should have created and that size will someday become a problem (The table after 3 years of use is 260,000 kb...
Top Bottom