Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    75

    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...
  2. Replies
    3
    Views
    788

    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...
  3. Replies
    3
    Views
    788

    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...
  4. Replies
    5
    Views
    536

    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...
  5. Replies
    5
    Views
    536

    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...
  6. Replies
    5
    Views
    536

    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,...
  7. Replies
    13
    Views
    1,163

    Re: Change query parameter with vbscript

    That works! Thanks so much Joe4!
  8. Replies
    13
    Views
    1,163

    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...
  9. Replies
    13
    Views
    1,163

    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...
  10. Replies
    13
    Views
    1,163

    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...
  11. Replies
    13
    Views
    1,163

    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...
  12. Replies
    13
    Views
    1,163

    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...
  13. Replies
    13
    Views
    1,163

    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...
  14. Replies
    1
    Views
    142

    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...
  15. Replies
    1
    Views
    142

    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...
  16. Replies
    1
    Views
    397

    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...
  17. Thread: Query Filter

    by juneau730
    Replies
    4
    Views
    519

    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...
  18. Thread: Query Filter

    by juneau730
    Replies
    4
    Views
    519

    Re: Query Filter

    Good morning, thank you for the suggestion. After trying both strings you provided, unfortunately neither of them worked.
  19. Thread: Query Filter

    by juneau730
    Replies
    4
    Views
    519

    Query Filter

    I have a field in my dBase that contains the Active Directory Distinguished Name, that I need to filter on to separate account types. The data string in the field will look like this for a user...
  20. Replies
    3
    Views
    509

    Re: Strange Issue

    Hi, thanks for the information. I tried changing the code on the referenced line to your suggested code and it didn't fix the issue.

    The new tabs/queries only filter out other data points based...
  21. Replies
    3
    Views
    509

    Strange Issue

    Good day everyone, need to pick your brains on a strange Access vbscript issue I am having. I have two dBases, one original and one modification of the original.

    I used all the same vbscripts...
  22. Replies
    4
    Views
    431

    Re: Access Query Date Range

    For the between 90 and 365 that worked! Thanks so much..

    What is the proper string for today >= 90

    I have been trying a bunch different ones and some give too much, other give none.
  23. Replies
    4
    Views
    431

    Re: Access Query Date Range

    Correct, I am looking for dates in the past (older than today). Does it matter in which order the -365 and -90 are? Will it work if written as such? (just curious)

    Between (Date()-90) And...
  24. Replies
    4
    Views
    431

    Access Query Date Range

    Hi all, I have been racking my head, searching the wonderful world of Google and haven't had any luck finding a solution to my dilemma.

    Is there a way to filter a query where a specific date field...
  25. Replies
    0
    Views
    137

    Correct string

    Hi again,

    The scripts I had working have evolved due to the change in data sets. I was able to get the majority of them tweaked and working except for one area. In the code snippet below, in...
Results 1 to 25 of 55
Page 1 of 3 1 2 3