Search results

  1. V

    export chart to word

    Your question will be best served in an appropriate Word VBA forum. I would imagine that you just need to move a line down after the first pasted object, then paste the second object.
  2. V

    Problem Summing a Calculated Field in a Report

    =Sum(Qty x Price)
  3. V

    Query on dates

    If the original data is a date/time value why split it into two parts, only to bring it back together in the query? Whatever you do, the answer is to fabricate the records before using it in your charts.
  4. V

    How to pull one max date from the value in four different text boxes on cont. subform

    Just curious how you would keep handling that!
  5. V

    Print Label Format Problem

    A lot of explanation here without any visual evidence. Can you upload some screenshots that best describe your problem?
  6. V

    How to pull one max date from the value in four different text boxes on cont. subform

    And if a 30th reminder needs to be sent? You'll add 27 more fields?
  7. V

    Changing the character separator

    To be honest, this is your best bet:
  8. V

    reminder by date

    CJ, were you working on some code that does scheduling? I vaguely remember you mentioning this. Calling command prompt's schtasks command with the "/create" switch will enable you create the task. This can be run through VBA.Shell()
  9. V

    Call an Access(already running) macro from Word, Office 2013

    appAccess.DoCmd.RunMacro However, I would do it the function way like spikepl explained. Convert your macro to a Public function. There's a button that can do the conversion for you.
  10. V

    Using Combo box to pull data using "Like"

    If one or more of those fields is indexed, you've basically lost the benefit of indexing by combining the fields and by using the LIKE operator with the wildchard. Perform the search on each field by using the OR predicate: [Active1] = [Forms]![FormName]![FieldName] OR [Active2] =...
  11. V

    Reset autonumber after deletion

    Old IDs will be copied over from the Autonumber field to the Number field and the DMax()+1 numbering will take effect on new IDs. I.e. the gaps in old records will stay in tact. But I see your challenge.
  12. V

    update query not working

    Error highlighted in red. But mafhobb, I mentioned in one of your threads two days ago that you should be using Debug.Print to print the string to the Immediate Window and you will be able to spot your mistakes. These are basic techniques that all developers must know.
  13. V

    reminder by date

    I like the idea of creating a scheduled task in Windows and I think that you're able to send an e-mail via the task too; unless that functionality no longer exists, in which case the task could fire up the lone db MarkK mentioned (or a script), that will handle sending the email.
  14. V

    Create a new workgroup information file in Access 2010

    You're mixing ODBC with OLEDB. Where are you getting these connection strings from? See here: https://www.connectionstrings.com/microsoft-access-accdb-odbc-driver/
  15. V

    Vertical ScrollBar of subreport (on main form) Not shown

    What does this mean? And which options did you actually try?
  16. V

    Query on dates

    What is in the Excel file :confused: You fabricate the records using the table where the data exists.
  17. V

    Reset autonumber after deletion

    Because there are gaps doesn't mean that it cannot be changed, it's still very possible to switch it over to a Number data type. But since there are gaps, why then are you trying to fill in any gaps for future IDs?
  18. V

    Message error

    Good to hear!
  19. V

    Changing the character separator

    I would imagine that MS developed a mechanism for fast retrieval and fast data manipulation for this field, whether through indexing or some other sort of algorithm. And I think it's mentioned somewhere that it does index and create relationships. Of course I'm not advocating using multi-valued...
  20. V

    AfterUpdate for listboxes

    No. There's a miscommunication! Can you upload a cut-down version of your db so that I can see what you're trying to do.
Back
Top Bottom