Search:

Type: Posts; User: PSSMargaret; Keyword(s):

Search: Search took 0.00 seconds.

  1. I think the easiest way is the path for me this...

    I think the easiest way is the path for me this time. Thanks so much.
  2. weejas, Is there a way to disregarding the...

    weejas,

    Is there a way to disregarding the report's OnOpen event from the other forms that use the same report but don't need to change the record source?
  3. weejas, My apologies for not responding...

    weejas,

    My apologies for not responding sooner. Your solution above works perfectly. I now need to alter some other form's code that utilizes the same report. Unfortunately, the awesome code...
  4. Thank you for your assistance. Attached is a...

    Thank you for your assistance. Attached is a sample database. My goal is to be able to print whatever records are displayed in the subform, whether records when the form loads, or after the first...
  5. weejas, Thank you so much for your assistance....

    weejas,

    Thank you so much for your assistance. It is so very close but I think I didn't describe the situation correctly regarding the third query.

    Query1 is the record source for the form...
  6. While I'm very appreciative of ranman256's...

    While I'm very appreciative of ranman256's response, I don't understand it and have noticed that he leaves a response and then doesn't follow-up with anyone who states they don't understand his...
  7. Print Records in Continuous Subform to an Existing Report

    I have a main form with an unbound subform. There are two date boxes on the main form that when entered will run a query and update the subform with any records within that date range. Then there is...
  8. Thank you for the response but I really am not...

    Thank you for the response but I really am not following your guidance. What do you mean by base query?


    There is no way to do it in combination with the code I provided for filtering the dates?
  9. Display Duplicates Records in Subform within Date Range

    I have a main form and an unbound subform. The main form contains two text boxes for entering a date range. I would like the user to be able to enter a date range in the text boxes and then click a...
  10. ranman256, Thank you for your response. In...

    ranman256,

    Thank you for your response. In the end, I utilized an OnFocus event on the combobox switching the RowSource to a query that included Offices that haven't been archived. I hadn't...
  11. Limit Selection in Combobox Without Affecting Past Records

    I have a form with a subform. The subform is in datasheet few and only displays one field (Office) and has a many-to-many relationship with the main form by way of a junction table. The field in...
  12. Datasheet Filtering Does Clear From Report Memory

    I have a main form and a subform. The main form contains a button to print the data in the subform whether it's all of the data or filtered data. Data is filtered by utilizing the standard filter...
  13. I think we have some confusion. My form has a...

    I think we have some confusion. My form has a command button titled "cmdInsertFile" that I want to be able to click to browse to a file, click the file for it's location to insert into the...
  14. I entered C:\ in the location field and then...

    I entered C:\ in the location field and then clicked the command button. I didn't receive any error messages and nothing was inserted into the location field.

    Thanks so much. I really appreciate...
  15. It's not working for me. Below is the code...

    It's not working for me. Below is the code tweaked to my situation. What am I doing wrong?

    I named the module "GetFileName(Location)"


    Function getFileName(Location) As String
    Dim...
  16. Thank you for your assistance and I apologize in...

    Thank you for your assistance and I apologize in advanced if my questions are dumb but I have been working this issue since yesterday and I'm exhausted. I need to clarify a few things. Does it need...
  17. As a follow-up I have attached a sample database...

    As a follow-up I have attached a sample database with the code.

    17337
  18. FileDialog to a File Name with a "#" in the Folder Path or File Name

    I have posted this issue on another forum at the link below but have not been able to resolve the issue.

    https://www.access-programmers.co.uk/forums/showthread.php?t=293224

    I am using the...
  19. Hoping you can help with a similar situation. I...

    Hoping you can help with a similar situation. I have a main form with a subform. I have added a command button in the footer. I would like to be able to click the command button to open another...
  20. You can disregard my last post. I have figured...

    You can disregard my last post. I have figured it out. Thanks.
  21. ranman256, I need to take this another step...

    ranman256,

    I need to take this another step further. While in the filtered form, I need to run a query to filter the results of the data in the subform while maintaining the filter. The query is...
  22. So simple. I love it. Thanks. I'm learning...

    So simple. I love it. Thanks. I'm learning every day thanks to the people on forums like this.
  23. Open Form With Only Data Based on Value Clicked on Another Form

    I have a table that contains all of the departments of the company with a few other fields of information for each department. Then I have a form that lists all of the departments from a query. The...
Results 1 to 23 of 23