Search results

  1. A

    rs showing values as null even though they're in the query output!

    Somehow using DAO instead of adodb fixed the issue.
  2. A

    rs showing values as null even though they're in the query output!

    I tried using .value but it still spits back NULL in vba - shows up just fine in the actual query view when I run it manually in Access
  3. A

    rs showing values as null even though they're in the query output!

    Anyone have any idea? This is a massively annoying problem since I don't want to resort to running messy maketables just because of some Access hiccup.
  4. A

    rs showing values as null even though they're in the query output!

    After opening a recordset in VBA I use this code to cycle through all fields of all records: While Not rs.EOF For i = 0 To rs.Fields.Count - 1 Set fld = rs.Fields(i) Debug.Print fld.Name, rs(fld.Name) Next i rs.MoveNext Wend The problem...
  5. A

    VBA Allowing user to dictate AND vs OR

    Figured it out, nevermind. Basically had my conditional be if (elementa>=bina) and (elementb>=binb) and +... etc
  6. A

    VBA Allowing user to dictate AND vs OR

    Is there a way to do this? Say I have a ton of variables and want to have some logical expression in a conditional, but I want the user to dictate the logic. e.g. a and b or c but maybe the user wants a or b or c or a and b and c Basically I'd have three binary switches: bina, binb...
  7. A

    Declaring multidimensional array

    How can I basically do this: variablename = {("element1a", "element1b"), ("element2a","element2b"), ...}
  8. A

    Check if query exists

    Works beautifully -- thanks!
  9. A

    Check if query exists

    Is there a way to pass in the database path?
  10. A

    Check if query exists

    How do I check if a query exists in a given db in Access VBA?
  11. A

    DBF file larger than 2 GB

    Can SQL Server Express interface with Access? What would be the difficulties involved, if so? Would it work with VBA, etc?
  12. A

    DBF file larger than 2 GB

    I have a DBF file larger than 2 GB -- Access seems to have a limit, here. What is the typical workaround?
  13. A

    More of a higher-level question, but what's a good way to organize total structure?

    This seems like a pretty good idea as well -- although I don't know if this would circumvent any issues pertaining to the actual files themselves (Excel files, PDFs, etc) that may need to be edited but face the risk of having other people using them at the same time.
  14. A

    More of a higher-level question, but what's a good way to organize total structure?

    Thanks for the detailed response. Why Optimistic locking for forms? Why no locking for data review/viewing?
  15. A

    General database arrangement and structure

    By that I mean I have processes that create tables, processes that extract data, others that export files, and so forth. But there are always issues if someone else is using a given database or file (thereby tying up other processes that either need to access said object for whatever...
  16. A

    More of a higher-level question, but what's a good way to organize total structure?

    By that I mean I have processes that create tables, processes that extract data, others that export files, and so forth. But there are always issues if someone else is using a given database or file (thereby tying up other processes that either need to access said object for whatever reason)...
  17. A

    Why does adding MsgBox change my results?

    Is there a way to keep the bookmark pane opened whenever anyone opens the pdf? I can do AVYourDoc.SetViewMode (3) in the code to make it show as I am adding, but how do I get it to stay that way when I actually open the pdf? I am basically trying to do File->Properties->Initial View ->...
  18. A

    Why does adding MsgBox change my results?

    Did not work unfortunately -- I assume the number at the end of the line refers to bookmark order (if I replace it with 0, for instance, it inserts everything in reverse. If I put it as 1, the order seems quite screwed. An increasing counter seems to do the trick)
  19. A

    Why does adding MsgBox change my results?

    That code worked! With some modifications, I changed it to: If AVYourDoc.Open(filepath, title) Then Set PDYourDoc = AVYourDoc.GetPDDoc() Set JSO = PDYourDoc.GetJSObject Set BMR = JSO.BookmarkRoot 'set bookmark title For Each element In OfficeArray...
  20. A

    Why does adding MsgBox change my results?

    Sure, but in this case I am just creating a bunch of Parents, right (each page is self-contained)? Is there something wrong with that?
Back
Top Bottom