Search:

Type: Posts; User: ice_531

Page 1 of 13 1 2 3 4

Search: Search took 0.26 seconds.

  1. Re: OutputTo not available ACCESS 2010

    Changing the commandline switch to get rid of /runtime seemed to solve the problem. Still have to make sure the task is opening just the database and not a macro though. Running the form via macro...
  2. Re: OutputTo not available ACCESS 2010

    Just an update here; in case anyone else is having this same problem.

    I've setup the database to run without any command line switch. this database in particular was using the /runtime switch. So...
  3. [RESOLVED] OutputTo not available ACCESS 2010

    Hey all,

    So at work lately, I've been converting all of our automated databases from a PC over to a virtual server. One big difference and time consuming process for me has been adjustng all vba...
  4. Replies
    1
    Views
    410

    Re: Date formatting

    I will mark this as resolved for now. I have come up with a solution for now.

    Just added a query into my automation macro, that links primary keys from the original table and then the return...
  5. Replies
    1
    Views
    410

    [RESOLVED] Date formatting

    Hey all,

    I have a spreadsheet that is sent to me with columns that have dates. However, these dates are in european format ( dd/mm/yyyy ). My settings are US, so its attempting to convert...
  6. Replies
    3
    Views
    4,161

    Re: Require Method VBA SQL

    Set r2 = CurrentDb.OpenRecordset("SELECT dealerid FROM dealerdata WHERE dealerid = ' " & Me.delident.Value & "'")


    Above line of code only opens a recordset that contains dealerid, in r2.

    But...
  7. Re: Automating search of entire database

    Thanks for the help TG,

    It seems i'm fairly limited with ACCESS, I've seen examples of it being possible for SQL SERVER and ORACLE.

    I was able to locate a function using VBA code and DAO that...
  8. Re: Automating search of entire database

    Just wanted to show what I've got so far with this issue. So I found out that there is a system table for MSACCESS called MSysObjects. I was able to now use this to query and get the names of all...
  9. Re: Automating search of entire database

    In other words; I don't want to have to go into every single query in every single database to see if it will require the change.

    I want a list to be generated for each database that will tell me...
  10. Re: Automating search of entire database

    The old field isn't being taken out, as it's been used for 10+ years. However the data will no longer be populated into that field, but instead will go into these other 4 fields. (But, yes I have...
  11. [RESOLVED] Automating search of entire database

    Hi all,


    Odd request here(or so i think!). I have a need to be able to locate all query names within an entire database, that use a certain field name in the query.


    a little background on...
  12. Thread: DateSerial

    by ice_531
    Replies
    1
    Views
    997

    DateSerial

    Hi all,

    Not sure if this should be in this forum, or the database development one instead...so if this needs to be moved, let me know.

    Soo, I've just confused myself a bit since I need to...
  13. Replies
    5
    Views
    686

    Re: Sub Query question

    Unfortunately parameters will not work within a subquery, I don't believe. Also parameters require manual interaction.

    This back end is fully automated. (Via task scheduling + macros).

    I was...
  14. Replies
    5
    Views
    686

    Re: Sub Query question

    Front end and Back end databases involved in this are MS ACCESS.

    (the actual data comes from ORACLE though, as its the "true backend" company wide)
  15. Replies
    5
    Views
    686

    Sub Query question

    Hey all,

    So I've been working on an auditing system at work, and am not that familiar with subqueries. So basically I have several append queries in a backend database that get run that pull...
  16. Re: Code to Determine If today is in between to dates

    If Today() > Cell_B2 And Today() < Cell_B4 then
    Yes
    else
    No

    Just off the top of my head, something like that. You just want to make sure your cells are formatted properly for a Date. If time...
  17. Replies
    7
    Views
    1,403

    Re: inner join syntax error

    Thanks.

    Are there any other good resources to read here on the parameter queries.

    I've found a few with great examples.

    http://www.vbforums.com/showthread.php?t=548787
    ...
  18. Replies
    7
    Views
    1,403

    Re: inner join syntax error

    This was the problem.

    mySt variable needs to contain double quotes around it inside the sql string. Code above ends up sending the following in the string:


    WHERE (((CUSTOMER.STATE) = 'GA' ))...
  19. Replies
    7
    Views
    1,403

    Re: inner join syntax error

    Still having the same problem, even if changing the table name for system. e.g. (SYSTEM_ROLE)

    It's odd, since the exact syntax is working fine inside Access itself. Yet from my VB6 program, it is...
  20. Replies
    7
    Views
    1,403

    inner join syntax error

    hey all.

    i've gone over various threads with the error and most end up being placement of brackets, etc.

    I can't seem to figure this out, and i'm sure its really simple.

    First off, this is...
  21. Replies
    8
    Views
    1,388

    Re: vb6 send email help

    If its anything like using the mailto URI; you'd have to use "%OA" to enter a new line in the body text.
  22. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    Unknown worked fine with code MarkT posted above.

    Also resolved the zip code dilemma.

    Forgot about the excel .TEXT property.

    I guess I should have read the help in excel sooner and figured...
  23. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    That did the trick. so that portion is working great.

    Now just to decide on my zip code issue... guess i could sort the zip codes into separate lists base on which state/province is selected or...
  24. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    Only problem with this is the Canadian zip codes now that i think about it.

    that format is more like V2X 8G1 < BC zipcode

    So that would be a problem.



    Also, having some trouble with...
  25. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    Ill test out that code and see if i can adapt it into my project. thanks

    that still beats doing a bubble sort involving 8 listboxes. (speed would be horrible too i think.)

    Another issue I've...
  26. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    Sorry havent posted on this topic in awhile. My hdd on desktop died and my project wasnt saved anywhere else. So just now got the application rebuilt.

    My problem left seems to be the sorting issue...
  27. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    Thanks. The SELECT statements was what I was looking for.

    That version of the haversine formula is similar to what I was using at first, but found this version of the vincenty formula is more...
  28. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    Well... as the previous posts show my Database table consists of the 3 columns.

    Zipcodes | Longitude | Latitude

    I need to search the database for a zipcode that will be provided by the...
  29. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    Per your suggestion Doogle, I successfully loaded the database directly using the xml code from MarkT.

    This was definitely faster than the listboxes too. So i guess I should learn a way to search...
  30. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    Guess I will scrap the list boxes entirely and load the XML directly into the database, as suggested.


    @ Doogle

    This feature of the application is basically a way to Sort a list of companies...
  31. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    I can upload the actual XML file and my project if that would help. Not sure if I'm explaining things well enough or not.


    Also to add to my post above...

    the -32303 list count on my...
  32. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    So I haven't worked with an access DB in years. Was rough working on the syntax for what i have so far. I have my load functions fine for later in my app to load the fields into lists.

    However, my...
  33. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    The XML file is a one time deal, unless i notice that the US Census Bureau updates the zip codes.

    I guess that would be the best method...just extract the information now and place into a...
  34. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    I'll give it a try later and do some timed tests to see. It may speed up some.

    thanks for the idea. :wave:
  35. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    That probably is a good idea. It would still require that 1-time load at start that takes over a minute. Guess the app could start with system start-up in the system tray, would take away that aspect...
  36. Replies
    32
    Views
    3,031

    Re: Parse text file or xml into listboxes

    Thanks for the code sample.

    This method works just fine, it takes 60 seconds on average for it to load the 5mb xml file into the lists though.

    Any ways to optimize that code any for speed, or...
  37. Replies
    32
    Views
    3,031

    Parse text file or xml into listboxes

    Any suggestions the fastest method for pulling a text file or XML file based on the following information. It's preferable that I get the items into list boxes, though i think this may be the part...
  38. Replies
    20
    Views
    5,867

    Re: zip code formula/algorithm question

    Haven't found any downsides to your formula on all that I've tested thus far Milk. It's much simpler than the original above. For my understanding at least ;)

    also before, do not require super...
  39. Replies
    20
    Views
    5,867

    Re: zip code formula/algorithm question

    Ah. gotcha. lol


    Well the javascript code I hadnt tested, just assumed it worked and tested after I re-wrote it in VB. I didn't really want to use other code whether it be javascript,c# etc....
  40. Replies
    20
    Views
    5,867

    Re: zip code formula/algorithm question

    I don't think I understand either of your posts. Care to clarify?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Click Here to Expand Forum to Full Width