Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    681

    Re: Table Compare

    I understand what you are saying.. However, the data comes from the same sources each time it is pulled. The names themselves can/will change, as we are dealing with a 5000+ user domain. But,, the...
  2. Replies
    7
    Views
    681

    Re: Table Compare

    Though the names are fictitious names, the format shown are the exact format when the data is output from the pulled source.
    I like the thought of matching only the data before the comma,...
  3. Replies
    7
    Views
    681

    Re: Table Compare

    Though the names are fictitious, those are exact examples of the raw data format when output from the different sources.
  4. Replies
    7
    Views
    681

    Table Compare

    Hello all,
    I am working on an addition to the massive dBase I have, a query that compares two different tables, linked by a name field in each, and performing a datediff function.

    For the most...
  5. Replies
    2
    Views
    650

    Re: Remove conditions

    Never mind, I got it.
  6. Replies
    2
    Views
    650

    Remove conditions

    Okay, I am having a total brain fart and should be able to figure this out.. This is part of the code for one function in my massive dBase. As you see it's a Yes, No, Cancel call. I want it to...
  7. Replies
    4
    Views
    1,006

    Re: Failing to import data to tables

    Hello, sorry for the delay in replying to you, been crazy.

    I do not get any import errors of any type, just empty tables.

    You are correct, this is not being done directly thru an import...
  8. Replies
    4
    Views
    1,006

    Failing to import data to tables

    Hello all,

    Recently I have noticed that my dBase has not been importing all data from the excel sheets into the dBase tables. After examining the dBase, the tables and the raw data sheets, I see...
  9. Replies
    3
    Views
    945

    Re: Date parameters

    Thanks for the input Joe4 and xenou. Was able to figure out what was going on. It was a combination of the other source being partially incorrect and my filter missing a "and not" parameter due to...
  10. Replies
    3
    Views
    945

    Date parameters

    Happy Friday.

    In my dBase, many queries have a >= or <= parameter, like such <=(Date()-365)

    Is there a more accurate way to write this? One of the queries using this is missing one item that a...
  11. Replies
    5
    Views
    589

    Re: Table Export Issue

    I think I got it all fixed now.
    It was exporting the tables, but it wasn't opening them automatically like it should. When I tried to open it, there were errors, come to find out the date/time...
  12. Replies
    5
    Views
    589

    Re: Table Export Issue

    Thanks Joe4, that partially fixed it. Now the data that was being exported as .xls is output as .xlsx
    However, now other data isn't exporting correctly. Let me dig into it some and if I can't see...
  13. Replies
    5
    Views
    589

    Table Export Issue

    Hey all, having a bit of a hiccup up with my table export function from my dBase. It's set to export to .xls, but I would really like it to be .xlsx since we are running Office 365/2016. However,...
  14. Replies
    13
    Views
    1,336

    Re: Change query parameter with vbscript

    That works! Thanks so much Joe4!
  15. Replies
    13
    Views
    1,336

    Re: Change query parameter with vbscript

    Not sure if it will change anything, but there are a few other fields within the query that have filters on them. These are not changing in any fashion though, they will stay hard coded within the...
  16. Replies
    13
    Views
    1,336

    Re: Change query parameter with vbscript

    Yes, I do know how to link multiple tables, by fields in a query. I have a couple queries in the dBase built like that.

    Here is a modified example of the raw data set. The format is the same as...
  17. Replies
    13
    Views
    1,336

    Re: Change query parameter with vbscript

    Good morning Joe4, I think I am following you, but not sure how to set one of these up, do you have any pointers?

    Currently every site runs their copy of the dBase locally, as the information is...
  18. Replies
    13
    Views
    1,336

    Re: Change query parameter with vbscript

    Because my data changes monthly (though the format does not) my table gets purged when the data is refreshed. The data contains user account info for multiple sites, but needs to be filtered down at...
  19. Replies
    13
    Views
    1,336

    Re: Change query parameter with vbscript

    No, unfortunately a "Parameter Query" isn't practical in this instance.
    In this case, once the Query Parameter is set, during the initial setup of the dBase, it won't change again.
    I know I could...
  20. Replies
    13
    Views
    1,336

    Change query parameter with vbscript

    I've searched the wonderful world of Google for a simple answer and wasn't able to find one.

    Is there a simple way to have a standalone (manually executed) vbscript to change an Access query...
  21. Replies
    1
    Views
    173

    Re: Code addition

    Well, I am a little closer to a solution.

    I was able to get the parent script to create a column named properly, every time the script is run and the workbook is created.

    Now, I just need to...
  22. Replies
    1
    Views
    173

    Code addition

    This may not be the proper forum to ask, so I'll apologize up front, but I am hoping someone may be able to help. I have the following code extracted from a large VBScript. What I'm trying to do is...
  23. Replies
    1
    Views
    436

    Script to change query parameters

    In my dBase, I have three queries that have a parameter that is coded Like"*TUC*"
    The dBase is designed to be used by various locations with different location coded. Is there a way to change the...
  24. Thread: Query Filter

    by juneau730
    Replies
    4
    Views
    567

    Re: Query Filter

    Score! I was able to get it working..

    If I add the criteria filter in design view vice SQL view, the string would look like

    Like "*Users*"

    where the * is wildcards before and after the key...
  25. Thread: Query Filter

    by juneau730
    Replies
    4
    Views
    567

    Re: Query Filter

    Good morning, thank you for the suggestion. After trying both strings you provided, unfortunately neither of them worked.
Results 1 to 25 of 62
Page 1 of 3 1 2 3